Import activities from csv file

Started by THOMAS251276, March 17, 2009, 02:39:17 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

THOMAS251276

Hello,
When I try to import activities from csv file
The error message is in the file attached.
Does anybody knows why i meet with this error ?
Thank you very much

Liviu Lalescu

#1
Thank you for this bug report!

Please give us your csv file, so we can analyze the error (attach it here or, if it is private, send it by e-mail).

Edited to add: Please also send us the students and maybe all the csv files

THOMAS251276

#2
Can I have an e-mail because I can't attach a file in the forum mailbox.
my e-mail is schtoma at gmail dot com
Thank you very much

Edited to add: Admin edited the address to protect the author from automatic spam bots.

Volker Dirr

This is fixed in FET 5.9.2. Thank you for report.

Fernando A F Lordão

When importing activities from .csv text file FET 5.28.0 shows the message "Skipped line X: Fields 'Split Duration' and 'Total Duration' haven't the same value." which means that the system waits the same value in both fields and, consequently, avoids activities as the followings:

* ACTIVITY ONE
Teacher: Tony
Students: Elementary_A1
Subject: Introduction
Total duration: 2
Split duration: 1
(2 hours/day, 1 day/week)

* ACTIVITY TWO
Teacher: Tony
Students: Elementary_A1
Subject: Introduction
Total duration: 4
Split duration: 2
(2 hours/day, 2 days/week)

So, I think FET has to change this validation to the following:
1. Total duration >= Split Duration

Additionally, FET would use the following values to fill Duration in each splited day:
* If day count <= (Total Duration MOD Split Duration), then day duration will be  ((Total duration DIV Split Duration) + 1)
* If day count > (Total Duration MOD Split Duration), then day duration will be  (Total duration DIV Split Duration)

The attached file contains:
* .fet file to create an environment test
* .csv file to reproduce the importing error
* .png images containing some snapshots from importing steps to show how the screen fields were filled out.

Volker Dirr

you are missunderstanding how to enter the data. the correct values are:

* ACTIVITY ONE
split duration=2

* ACTIVITY TWO
split duration=2+2


By the way: you only need to enter split duration OR total duration. if you use total duration only, then it will be splitted in 1 hour per day activities.

Fernando A F Lordão

Oh, my god!!! How long time it could save me if I have known before. :-\
Next time, maybe :D
Thanks a lot for helping me.