Home → Suggestions →

export, work on the .csv and then back import

• Edit

Marcel

13 Jan, 2014 10:48 PM

Hello,
what is wrong with this Data.csv? it puts it all to the same 1text. I exported the List and added the two last lines. but then it messed it up?
i have stored the list in Archive-Group-myList-Data.csv
Thank you for responding.

• Data.csv 3.98 KB

1. Support Staff 1 Posted by drewmccormack on 14 Jan, 2014 09:34 AM

   

   Hi Marcel,
   The commas need to be between the facet texts, not in the quotes. Eg.

   " Offenbarung 20:12,""Und ich
   should be

   " Offenbarung 20:12", "Und ich
   Kind regards,
   Drew

   • Edit

2. 2 Posted by Mc Imhof on 15 Jan, 2014 05:01 AM

   

   Hi Drew, i try and let you know soon. Thank you very much.
   kind regards Marcel Imhof

   • Edit

3. drewmccormack closed this discussion on 15 Jan, 2014 08:25 AM.

4. Imhof Marcel re-opened this discussion on 16 Jan, 2014 11:14 PM

5. 3 Posted by Imhof Marcel on 16 Jan, 2014 11:14 PM

   

   Hi Drew,
   first I want to thank you for helping me.
   now i did what you told me, but still it does not distinguish question and answer! see my print screen. is there a possibility to help me?

   kind regards
   Marcel

   • Bildschirmfoto_2014-01-17_um_00.10.13.png 21.1 KB
   • Bildschirmfoto_2014-01-17_um_00.09.58.png 115 KB
   • Data.csv 4.65 KB
   • Edit

6. Support Staff 4 Posted by drewmccormack on 17 Jan, 2014 07:53 AM

   

   Hi Marcel,
   I just tested, and it seems to work for me. I am attaching the studyarch I made with your CSV. I only fixed the first two notes, so ignore the rest.
   See screenshot of what I got.
   It is important that you balance your quotation marks. The quotation marks group together the text. If you add an extra one somewhere, MC will think you want a multiple line note, and it won't work as you expect. If you want an actual quotation mark in your text, use two together.

   Eg.
   "Do it like this", "If you need quotes ("") in your text, use "" "
   "This is line two", "Huh?"
   "This line will be messed up, because I am putting in an extra quote ". See?", "Now it will all be joined together, with the comma ignored."

   It you still have issues, make sure you save you text files in UTF-8 or UTF-16 (unicode) format. That should be an option in your text editor.

   You can find more info by going to Help > Mental Case Help and searching for CSV.

   Kind regards,
   Drew

   • Screen_Shot_2014-01-17_at_08.46.34.png 1.27 MB
   • Archive.studyarch 4.39 KB
   • Edit

7. Support Staff 5 Posted by drewmccormack on 17 Jan, 2014 07:58 AM

   

   By the way, if it is still not working, maybe you can send me the studyarch you are making.

   Drew

   • Edit

8. 6 Posted by Mc Imhof on 18 Jan, 2014 08:25 PM

   

   Thank you very much. I will try and do my best. I will let you know.

    Kind regards
   Marcel Imhof

   • Edit

9. drewmccormack closed this discussion on 18 Jan, 2014 08:47 PM.