Troble when import CSV saved by MS Excel

Started by M.zais, November 25, 2013, 09:23:48 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

M.zais

I make data CSV by excel, but its trouble when i import to FET. How i solve this problem?
This my excel data.

Volker Dirr

#1
you must export it as a csv file.
i exported with Libre Office.
Sadly i can't test it, because i also need your students structure (students.csv) to test it. But i manualy checked it and it look ok. (except the teacher names. you are sure you also want to have "x. Ust" stuff?)

M.zais

This my data of  class structures and activities after I export to CSV with LibreOffice, but I still can not import into the FET. Can you tell me what was wrong with my data?

Volker Dirr

the data isn't "incorrect". it is just not saved "perfect".
it is possible to import that data. (see answer b))

there are 2 solutions:
a) if you export as a csv file, then you should also export with textquotes ("). (Just check the checkbox "export textquotes" in libre office.) then fet can import correct.

or
b) import the current csv file. because of missing textquotes fet don't understand your fileformat. you must select the filedseperator (,) and no textquotes. then you manualy need to select the correct column for each value.

M.zais