Page 1 of 1

[SOLVED] Company Directory - import not working

Posted: Thu Aug 01, 2013 1:52 pm
by michaywood
Updated to the latest version of CMSMS yesterday (1.11.7) and updated CD to 1.19.2 and all CG dependencies are updated as well. However, when I go to import a CSV file, it gives me some errors, but only imports 1 record. Go back to view it in CD and it isn't showing up. But if I check the SQL database, I can see and delete the record from sg_module_compdir_companies in the database.

Also, before deleting the imported record from the SQL database, I would go back to CD and click on Export CSV , and even though I only see 1 company in CD, the export would have 2 companies (including the first one on the list of the CSV I attempted to import).

Any ideas? I would hate to have to delete and reinstall the module as there are a number of templates in the module I'm using. Thanks!

Re: Company Directory - import not working

Posted: Thu Aug 01, 2013 2:28 pm
by calguy1000
Make sure you have not set a filter to exclude displaying the imported entry.

If there are 2 rows in the database, but the admin is only showing 1 I would suspect that you had configured the filter in the admin interface somehow so that the new record gets excluded.

Re: Company Directory - import not working

Posted: Thu Aug 01, 2013 4:42 pm
by michaywood
there was some saved name as "test" in the filter from a while ago. it now shows, thanks!

now I just have to figure out how only 1 record was imported. I took an export file, left the first 5 rows the same, then just put my companies in there in the same format:

Code: Select all

C|"company name" |"their fully address"|phone number||email addy|full website|Published|||||"My Customer"
All 6 companies in my test import CSV file are that exact format but only the first imported (gave errors saying line 2 already exists, line 3 already exists, etc...)

Also, the one that imported, the Status is set to:

Code: Select all

-- Missing Languagestring - module:CompanyDirectory string:--
so it isn't showing up in my company searches unless I go into it and change it to published and hit save.

any ideas?

Re: Company Directory - import not working

Posted: Thu Aug 01, 2013 8:10 pm
by michaywood
solved. phone number needs to be in " "

Re: [SOLVED] Company Directory - import not working

Posted: Sat Aug 03, 2013 5:18 pm
by Dr.CSS
I would have thought if any had " " they would all need it....