Import CSV Company Directory

[wazman21]

Hi all,

I can't seem to get import CSV happening in Company Directory...  It just seems to hang and not do a thing.  Even if I stop the web page half hour later, not a single entry inserted.  No error messages, just nothing.  I've read the other threads on here about it, and I think I have the CSV formatted correctly.  Is there a set of option which will prevent the browser hang?  Everything latest version.  I really don't want to go one by one, since I'd have to add the entry, then go back in to each one to lookup coordinates so postcode search works.  Any hints or suggestions appreciated.

Formatting of CSV:

#COMPANY=C|company_name|address|telephone|fax|contact_email|website|details|status|latitude|longitude|hierarchy|FIELD:PostCode|FIELD:City
#FIELDDEF=F|name|type|max_length|admin_only|public|dropdown_data
#CATEGORY=T|name
#HIERARCHY=H|long_name

F|PostCode|textbox|4|0|1|
F|City|textbox|255|0|0|


C|Atmosphere Hair & Body Spa|Shop 4 Triniti Business Complex 39 Delhi Rd|02 8086 3207||marian.ruri@atmospherehairbody.com.au||published||||2113|North Ryde

[Peciura]

I guess you missed " for values with spaces.

C|"Atmosphere Hair & Body Spa"|"Shop 4 Triniti Business Complex 39 Delhi Rd"|"02 8086 3207"||"marian.ruri@atmospherehairbody.com.au"||published||||2113|"North Ryde"

OpenOffice is doing better job createing xls or xlsx to csv.

[wazman21]

Hey there, thanks for the reply - I've added the " around values with whitespaces, but now I just get 0 records imported.  Really not happening

[michaywood]

I've had issues importing to CD as well, but what helped me the most was not starting from scratch.

Go ahead and put like 3 companies into CD, then export a csv. Then you can use that CSV as a template. Sometimes I'll even open that CSV in OpenOffice and set the field delimiter to | so it'll break my 3 companies into columns. Then i'll add more data (or copy/paste data from XLS) and re-export out of OpenOffice setting field delimiters to | . Then double check that all your heading info is still correct in the CSV and give importing another shot.


P.S.- Make sure you don't have any duplicates in your list or else you'll run into some annoying snags on import.

Best of luck.

[blackhawk]

i'm running into some issues too.  Is there an on-line guide for importing and exporting with the csv file?  I created a company directory, then exported it to a csv file.  then tried to import it back (WITH NO CHANGES) and I get errors with 0 records imported.  I'm using the latest version of company directory and cmsms 1.8.2.

Code: Select all

# An error occurred at line 6: Dont know how to handle line 6 with the rule identifier Fnumbertextbox25501
# An error occurred at line 7: Dont know how to handle line 7 with the rule identifier Fpositiontextbox25501
# An error occurred at line 8: Dont know how to handle line 8 with the rule identifier Fheighttextbox25501
# An error occurred at line 9: Dont know how to handle line 9 with the rule identifier Fweighttextbox25501
# An error occurred at line 10: Dont know how to handle line 10 with the rule identifier Fclasstextbox25501
# An error occurred at line 11: Dont know how to handle line 11 with the rule identifier Fcitytextbox25501
# An error occurred at line 13: Dont know how to handle line 13 with the rule identifier TPink

has anyone got this feature working with openoffice calc?  If so what settings have you used?

[alexbuckland]

I think your problem is because of formatting within the xls/csv.
I would suggest removing all formatting of any kind before you export to csv. The csv should be plain text only with your correct delimiter, if only for the purpose of ruling it out as a problem with the import.