How to import activities CSV files

Luke Lin · July 21, 2009, 09:25:24 AM

We occur problems while trying to import activities csv file into FET. FET reports warnings. Could you provides us a sample of activity csv file? How the format of the activity csv files are? :-? :-?

Volker Dirr · July 21, 2009, 09:29:02 AM

to get an example just open a sample file and export to csv.

Liviu Lalescu · July 21, 2009, 09:35:15 AM

QuoteWe occur problems while trying to import activities csv file into FET. FET reports warnings. Could you provides us a sample of activity csv file? How the format of the activity csv files are? :-? :-?

Volker could answer to this better than me. But you can open a sample file and export it, in different ways, with different textquotes or separators, and see what you get.

Luke Lin · July 21, 2009, 09:41:56 AM

I have tried to export the activity from .FET file to .csv, but I cannot import the .csv file back to FET without any modification... Why is it?

Volker Dirr · July 21, 2009, 10:02:44 AM

I guess you modified with an office software.
some office softwares (like open office calc or excel) didn't check on all operationg systems the correct fileformat (BOM).

you can see/check that if you open the csv with an editor. (notepad++, kate or windows-editor.)
if your office software do a incorrect BOM, then you can see that normaly in the editor, because the first fild of the first line is incorrect.

just open an exported sample and copy that first line (the head) and replace xour incorrect first line.

Maybe i shouldn't write such a hard check at the beginning? but that might do problems to guys that use their own csv structure.

Liviu Lalescu · July 21, 2009, 10:34:02 AM

The imported files must be in UTF-8 format (or UTF-16 might work also).

mbarsan · July 21, 2009, 12:00:12 PM

In my limited experience, I got the same error.

I solved considering that beside and before the cvs file related to activities (where you need to respect the known syntax), FET needs to know the students structure you are going to use.

So, first of all import the students structure. If you prefer, you may also manually put years, groups and subgroups.
After that, you can try to import activities involving those students sets without warnings.

Let me know.