CSV import failure Address Book
- Started
- Last post
- 4 Responses
- vaxorcist0
also, try this:
open file in a text editor, like notepad++ or textpad
see if fields are seperated by ","
if they are, you are in luck:1. find/change "," to "--"
2. find/change , to . (comma to period)
3. find/change "--" back to ","
4. save file with .csv extension
5. import and see if it works
(also see if program allows you to use mac or unix or pc linebreaks, try 1 version of each... i.e. file-mac.csv file-pc.csv file-unix.csv etc....)assume a file like this may be weird, probably came from a non-technical salesguy and you will have to budget a few hours to clean it up...
- welded0
If the problem is commas within a data field you can often fix the problem by surrounding each item with quotations. There should be an option to do this in Excel, but I can't recall exactly. There may also be line breaks in the middle of a field, just like vaxorcist suggested about commas.
- I've seen the line breaks in the middle of a field... importing into excel makes this clearvaxorcist
- vaxorcist0
so.... did anything you tried actually work?
- vaxorcist0
argh... addresses probably contain extra, randomly placed commas, inconsistently formatted...
for example:
111 main street, apt #44
State & Main, by the mcdonald'sif you can find the original program used to make the file (hopefully Excel) then do a find-change, to change all commas to periods, then re-export and re-import that should work
try opening csv file in excel, you may be able to see where the problems are that way too.. fix them, then re-export...