I make data CSV by excel, but its trouble when i import to FET. How i solve this problem?
This my excel data.
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?)
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?
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.
Ok.
Thanks for your advice. i will try its.