importing to contacts from excel

[carol]

i have successfully imported some fields from excel but
not others. it appears that all my various phone number
fields are not importing. i changed the format in excel
on these fields to text hoping that would resolve my
problem, but no luck. can you help me out!?! thx.

 

[Karl Timmermans]

Your phone numbers are being translated as numeric fields by the Outlook
import translator on your system. Suggest you try saving the file as a .CSV
file and import that file to see if it resolves the problem. This is an
issue with the standard import engine we saw on some systems but not others
when the ContactGenie products were being developed.

What the Excel import translator is doing is scanning your first 20 or so
rows for that column from what we can determine and decides on whether a
field is numeric or text from that. You may also want to try putting a text
character in front of the phone number in the first row or so and see if
that will force "text" recognition for the rest of the rows you are
importing.

What version of Outlook (and Excel) are you using?

Karl
--
__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://contactgenie.claxton.com

 

[carol]

will try. using excel 97 and outlook 98. thx.

-----Original Message-----
Your phone numbers are being translated as numeric fields by the Outlook
import translator on your system. Suggest you try saving the file as a .CSV
file and import that file to see if it resolves the problem. This is an
issue with the standard import engine we saw on some systems but not others
when the ContactGenie products were being developed.

What the Excel import translator is doing is scanning your first 20 or so
rows for that column from what we can determine and decides on whether a
field is numeric or text from that. You may also want to try putting a text
character in front of the phone number in the first row or so and see if
that will force "text" recognition for the rest of the rows you are
importing.

What version of Outlook (and Excel) are you using?

Karl
--
__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://contactgenie.claxton.com





.

 

[carol]

alpha character in front of phone no. didn't resolve
problem. thx.

 

[carol]

tried cvs with no luck either. searched thru all outlook
fields just to see if it was throwing phone numbers (as
numbers, text, or junk) into any field but nothing. need
help with this project. whatever you can suggest will be
appreciated. thx.

 

[Karl Timmermans]

I'd have offered you a (free) solution to your problem but unfortunately we
don't support Outlook '98 and the problem may well be an issue related to
the age of your programs which no longer exists in current releases. To be
honest, I have no idea anymore what Outlook '98 or Excel '97 supports
anymore in the way of import/export drivers but if either supports MS Access
2.0 we could possibly convert your data to that format just for you to test.

However, having said that - just to make sure I understand correctly - are
you saying that your phone numbers are not importing "at all" - i.e. as in
blank or are importing as strange numbers?

If you wish to contact me directly outside of this forum and send me a
sample of your data - will be happy to take a look in case we can find
something that stands out (this is not intended as a general invitation for
everyone who is having a
problem ). - Please make sure you reference this newsgroup should you
decide to follow-up. In terms of the data - we operate under an automatic
general non-disclosure agreement which is published on our website in case
confidentiality is an issue related to your data.

My bet is on the way your import drivers are scanning the data - a quick way
to prove that is to create a worksheet with only one contact and put any
non-numeric character in front of your phone number - then import that
single contact both via Excel and after saving it as a CSV file.

Karl

--
__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://contactgenie.claxton.com