Registration | Remind password |



Collection Studio 4.76

[ release date: May 31, 2024 ]







This community protected: neighbourhood watch

Problem importing



tegwin
Registered user
6 messages
decoration
September 23, 2010 07:01
Quote    Reply
decoration
decoration  
Hello,

I am trying to do an import from excel into this software. I made a test entry in the software and then exported it to excel so that I could see how it needed to be laid out. I have then copied my entries under the relevant fields and saved the excel file as a CSV file. When I do an import it comes up with an error saying items failed 100 items imported 0.

It seems to do this no matter whether I import as CSV or Excel etc.

What Do I need to do ?

 
  decoration +0 -0 decoration
tegwin
Registered user
6 messages
decoration
September 25, 2010 14:23
Quote    Reply
decoration
decoration  
Anyone have any ideas on this, I would like to get this working this weekend.
 
  decoration +0 -0 decoration
developers
Developers group
130 messages
developers profile
decoration
September 25, 2010 14:29
Quote    Reply
decoration
decoration  
Did you perform all steps, described in the help article "import"?

(another ability: you can send us your csv file, and we will check why it cannot be imported...)

 
  decoration +0 -0 decoration
tegwin
Registered user
6 messages
decoration
September 25, 2010 15:41
Quote    Reply
decoration
decoration  
I have gone through that now and it works.. But there is stil a problme. It seems to add some rouge fields to the import even though I have select the options. It seems like there may be some comma's in the text fields and this causes it to create new record.. If I send you the file can you do the import for me .. Do youhave a private email I can send the file to
 
  decoration +0 -0 decoration
developers
Developers group
130 messages
developers profile
decoration
September 26, 2010 10:09
Quote    Reply
decoration
decoration  
info@collectionstudio.com should be used.
 
  decoration +0 -0 decoration
developers
Developers group
130 messages
developers profile
decoration
September 28, 2010 08:44
Quote    Reply
decoration
decoration  
Thank you for your sample collection send to us via e-mail.

We can import these data into CollectionStudio using CSV data format using "tabulator" symbol as delimiter. Excel supports this saving format. This will resolve the first problem - tabulator is unique symbol for your collections data (it was never used in the data fields inside text). But we have another problem in your xls file - it is you have "line feeds" in "comments" column. Excel places these line feeds as line feeds, so we detect a new record on each line feed. It can be resolved with manual editing of the exported file, taken from first step: "xsl -> csv(tabs)". Than you can import your data into CollectionStudio!

 
  decoration +0 -0 decoration

forums rss 0.91 forums rss 2.0 forums rss atom 0.3 ?

Add Message Add Message
chart bar 67756 views; Messages: Last message 6.