FET Forum

FET Development => Report a Bug => Topic started by: THOMAS251276 on March 17, 2009, 02:39:17 PM

Title: Import activities from csv file
Post by: THOMAS251276 on March 17, 2009, 02:39:17 PM
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
Title: Re: Import activities from csv file
Post by: Liviu Lalescu on March 17, 2009, 02:45:03 PM
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
Title: Re: Import activities from csv file
Post by: THOMAS251276 on March 17, 2009, 02:51:43 PM
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.
Title: Re: Import activities from csv file
Post by: Volker Dirr on March 20, 2009, 09:49:04 PM
This is fixed in FET 5.9.2. Thank you for report.
Title: Re: Import activities from csv file
Post by: Fernando A F Lordão on October 07, 2015, 07:32:33 AM
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.
Title: Re: Import activities from csv file
Post by: Volker Dirr on October 07, 2015, 10:08:00 AM
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.
Title: Re: Import activities from csv file
Post by: Fernando A F Lordão on October 07, 2015, 11:53:21 PM
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.