Problems migrating BCM data into CRM SB edition
I am having a problem migrating data from Business Contacts Manager (BCM)
into CRM 3.0 Small Business edition.
I have downloaded the BCM data migration pack and have followed the data
migration documentation to the letter.
I even cleaned up the BCM database prior to copying the files, checking them
for errors using the Manage Database option in the Business Tools menu.
It gets so far through the migration process and then bombs out.
Here is the final few entries from the log file:
28/10/2006 12:18:53------>Transitioning to next screen. From:
ConfigurationSummary screen. To: ...Problems with creating a newsletter
I chose the form "Newsletter - email".
I have created a 3 page newsletter. Now, I have NO IDEA how to send it out
as an email. I do not want to send it as an attachment. I cannot figure out
which "save as" format or what I need to do so that i can email this
newsletter. Is there a website that goes through how to do this?
Am I correct when I say that it has to be html in order for me to send it as
email? That is not one of the options.
Any help you give me would be greatly appreciated.
...CSV File Problem
Can any one explain why the following problem occurs please?
A colleague has a small list of data which is a csv file exported from SQL.
Column One is a serial number from 1 to 29.
Column 2 is a number of transactions which have occurred.(it should look
like example A below in Excel)
1 475 1,475
2 1732 21,732
3 1670 31,670
4 2176 42,176
5 608 5,608
6 1579 61,579
7 43101 743,101
8 54512 854,512
9 51258 951,258
10 61050 1,061,050
If I double click on the csv file, it opens in Excel but c...Customize Current View: Filter Problem
Using Outlook 2002, I have created a category called "Hidden" i
outlook. In my calendar, I put all the appointments I don't want t
appear in this calendar (i.e. daily reminders).
I then filter out all these "Hidden" items by selecting --
Customize Current View-->
Hidden (the category I created)-->
Edit these criteria directly-->
And then I change:
("DAV:isfolder" = false AND "DAV:ishidden" = false) AN
I trying to retrieve values from a table to calculate the 14days average
value of a stock closing price. However, i encounter some problem as stated
beside the code as follows:
'Calculate the average value of a given value.
Dim db As DAO.Database
Dim rst As DAO.Recordset
Dim varBookmark As Variant
Dim numAve, numDaysAvg As Double
Dim intA, intB, lngCount As Integer
Set db = CurrentDb
Set rst = db.OpenRecordset("SGX Individual Historical", dbOpenTable)
Do While Not rst.EOF
intA = 1
intB = 0
varBookmark = rst.Bookmark
I have some code where I calculate this month minus 2 month. This goes fine
until I get to august. When I use DateSerial to deduct 2 month I get to July,
and this makes no sence. I made the following testcode.
Dim MyDate As Date
MyDate = #8/31/2010#
MsgBox DatePart("m", DateSerial(Year(MyDate), _
Month(MyDate) - 1, Day(MyDate))) ' MsgBox = 7
MsgBox DatePart("m", DateSerial(Year(MyDate), _
Month(MyDate) - 2, Day(MyDate))) ' MsgBox = 7
MsgBox DatePart(&qu...Rounding Problem
I am using the following formula:
Where BH24 = 15:21, BG24 = 15:00 (times based on a 24 hour clock)
The answer returned is 0.3, but it should be 0.4. If you round out to 2
places the answer is 0.35. Unless I am missing something 0.35 should round
to 0.4. If I use Roundup, it rounds everything up. What am I missing?
this is due to Excel's representation of numbers (see:
In your case the formula
=(BH24-BG24)*24 does not return 0.35 but
(Just test it and format the resulting cell with enough decima...Access 2007 and Vista code problem
I am developing a database on a XP SP2 machine. On a form I have created
some buttons with event procedures that run 2 queries and open a form. I
sent the db to someone running Access 2007 on a Vista machine and nothing
happens when she clicks the buttons and there are no messages.
I know nothing about Vista so thanks in advance for any help.
Might be a reference problem, have them open the open a code window and
click tools references. See what says missing and tell them what should be
there, Add it and it should work. Duff
"Tim Reid" <TimReid@discussions.micr...Resolving Email Address to existing contact problem
Has anyone else come across this issue in MSCRM3.0? - when you attempt to
resolve an email address to an existing contact in CRM (that does not
currently have an email address stored in their details) the contact resolves
OK but does not update the email address in the contacts details.
Is this by design, or have I found a bug?
...Offline folder problems #2
Basically I installed Outlook 97 on my office PC which is
connect to microsoft exchange server.
For some reason all of my messages were copied into
offline folders, this causes a problem, whenever I open up
outlook I get this message.
Upload of offline changes could not be completed you do
not have sufficient permission to perform this operation
on this object. See the folder contact or see your system
I do not administrator access on my user profile, every
time I open outlook it resets everything I have changed
(view etc) and gives that error message. How ...Outlook Hangs Reading Messages
I am running Windows XP Pro & Outlook 2003 via POP3 & Symantec AV
I had to reinstall everything on my pc and now find when I double click
an email outlook hangs for roughly a minute and then it finally opens,
I have tried a data compact, reinstalling outlook and creating a new
pst then importing but it still happens
Does anyone have any ideas? It's driving me mad
Try deleting and recreating the profile as one of your steps in
Thoughts lead on to purposes; purposes go forth in action; ...Outlook rule to move read message from Blackberry
I have Outlook configured with a Blackberry server and want to set up a
rule to mange messages marked as read: For example.
1. I'm away from the office, Outlook is closed.
2. I read an email on my Blackberry, which marks the message "read"
3. When I return to the office and open Outlook I want to:
a. Apply a rule to my inbox that states: If message is marked as read,
move to folder "read messages"
b. All unread messages will remain in the inbox.
I'm a heavy user of rules but I can't find a way to identify
Outlook is behaving strangly with the "through the selected account"
Each time I restart Outlook the rule fails. When I go in to check on the
rules I get told that the rule is "invalid". and the "SELECTED" account
is no longer selected.
Each time the criteria the account needs to be selected by changes.
For example with the following data
Account Name Email Account
One time I go in and it's asking me to select the account ...outlook 2k2 problem
I am using Outlook 2002 with SP3, and i have not had any problems up
until a week ago. My password does not seem to save even though i have typed
it in correctly in the e-mail acct settings ,and have checked "save
password. It saves it as long as i have Outlook open, but as soon as i close
it, and then later open it again, my password is gone and Outlook asks me
for my e-mail password. So, i re-type and i check "save password". But if i
decide to close Outlook (say for the evening, and shut down my computer or
something), my password disappears the next time i open Outlo...Office 2003 Service Pack 3--subsequent problems opening Publisher
I run Publisher 2003 on Windows XP. On June 13, I updated my system with
Office 2003 Service Pack 3 so that I could open Word documents with the file
ext docx. Subsequent to the Service Pack 3 installation, whenever I open a
Publisher file (which I created), I get the following message: "Publisher has
detected a problem in the file you are trying to open. If you are certain
that this file came from a trusted source and does not contain harmful
information, click OK." What is causing this and is there a way to stop this
Error message when you...IsOutLookClient() returns wrong value
IsOutLookClient() returns wrong value when both web client of crm and outlook
client are running on the same workstation
It looks like the same cookie(used for determining what client is running)
is used by the sessions of each client.
Look for "LightClient" in IsOutlookWorkstationClient() in global.js
Oeps...I seem to have made a wrong assumption...
Between the to clients IsOutlookClient() seems to work ok...
But in outlook client the IsOutlookClient() function gives false for
me...after I have opened a page from the Microsoft Crm folder structure...
On another workstation it...changing values of one field based on another
How can I best change the values of one field in a table based on
values of another field of the same table. We have an existing table
of thousands of entries and I would like to use the following logic to
populate a new boolean field.
If field1 = "Done" Then BooleanFieldCompleted = True
I have some Excel VBA experience but limited Access. I dont want to
do this manually! Any assistance appreciated.
In general, you'd use an Update query. However, in this case I don't see why
you'd need such a field.
Why not just create a query with a computed field that returns True...Mother of a sumproduct (ish) problem!
At least it is to me - now I humbly beseech your magic :)
A1 to A10 contain 10 unique letters, e.g. A,Q,E...
B1 to B10 contain 10 unique letters, e.g. Z,B,A...
C1 to C100 contain nonunique letters, e.g. E,E,F,E,Q,Q...
D1 to D100 contain nonunique letters, e.g. A,T,F,A,X,B...
E1 to E100 contain values, e.g. 9,1,3,5,7,2...
In pseudo logic, for x = 1 to 10 I want to find each Ax:Bx pairing in
Cy:Dy and sum E when matched. So I want to sum Ey for the rows where [Cy
is "A" and Dy is "Z"], plus each Ey where [Cy="Q" and Dy="B"], etc. for
the sample...Hyperlink problem #3
I've got two workbooks on a shared drive with hyperlinks
linking the two. When a user clicks on the hyperlink on
the first workbook, it takes him to the second workbook.
Fine. However, when the user clicks on the hyperlink in
the second workbook to go back to the first, the error
message says that that workbook is already open and it
cannot open two files with the same name. Help is
I just tried a small test in xl2002 and it worked ok for me. I use
Insert|Hyperlink to create the links.
Are you sure that the hyperlinks point at the file you want--same folder and
e...CRM 3.0 Login Problems
Some specific users are constantly getting prompted for CRM login in Outlook.
We are using desktop client (online) online. This happens randomly. We have
CRM 3.0 with rollup update 2 and IE7. We have also applied this fix
http://support.microsoft.com/default.aspx/kb/934243/en-us. Also added the crm
site to local intranet zone.
set the authentication in IE
check rollup update 2
MS CRM Certified Professional
Chat with me on MSN / Gmail / Skype : ID Is :.. email@example.com
>...Spam is a big big problem
Spam is a big big problem
...Problem with Database Wizard
I'm trying to generate a diagram based on the contents of
an Access database, using the database to provide x,y
coords for instances of a Master shape. It seems I need
to run the wizard twice, first to link a master, then to
generate the drawing. The first bit appears to work OK,
but when I do the second bit, Visio says that there is no
master in the stencil that it can use. But I know the
master is connected, because if I modify the database,
then refresh the shapes, they change accordingly.
Does anyone have any idea why this isn't working for
me ? I'm using Visio 20...How to add a button to restore all altered cells original values?
I want to add a reset button to an excel spreadsheet that will restore the
values of all changed cells to the original saved ones.
Any help would be appreciated.
this would require quite some VBA code as you somehow have to store the
original values for example on a separate hidden sheet
"Dawnybros" <Dawnybros@discussions.microsoft.com> schrieb im
> I want to add a reset button to an excel spreadsheet that will
> values of all ...Strange problem
We have been rolling out new Windows 7 workstations (all new computers) at
work over the last few months and a strange problem has developed. Prior to
Windows 7 we were using Windows XP with Office 2007.
The problem is, we have a workbook which uses a UserForm for filling in all
required information. Prior to rolling out the new Windows 7 workstations,
the workbook and UserForm were working flawlessly (for over a year) and they
still work flawlessly on the first 3 Windows 7 workstations but on the last
2 workstations we rolled out if you open the UserForm and leave it open for
...HELP! Outlook POP3 problem(s)
Hello. I am so lost. I have a few e-mail accounts set up on my computer
which retrieves my mail from a couple of different providers and deposits the
mail into my Outlook Inbox. Up until yesterday, my mail always has worked
fine. For some strange reason, my Outlook is now (Again) retrieving my
messages from all of my accounts I had set up, which are all duplicates of my
messages. There is now nearly 4,000 duplicate messages in my folders. I
can't seem to stop the download of these already retrieved messages. To top
things off, a couple of my email account login windows keep p...