Im getting error while import activities " Field 'Total Duration' doesn't contain an integer value."
I can't find where is the issue. How to solve it?
Quote from: parthasarathy.r on January 24, 2015, 09:02:58 AM
Im getting error while import activities " Field 'Total Duration' doesn't contain an integer value."
I can't find where is the issue. How to solve it?
Hi,
isn't your quote incomplete?
There should be a warning like "Skipped line X: ..."
So you should check line X field "total duration".
Only integer values are allowed, like:
12
But you wrote an non integer value like:
12+
1 2
12.0
12,0
twelve
Error: Skipped line 2: Field 'Total Duration' doesn't contain an integer value.
Line 2 is: Sabarmathi Maths ANR 1
Im giving it as integer value only. Like 5, 4. And i also checked with number without floating digit, text format in cvs.?
Is there any other issue?
Looks like you are using space as field separator.
Please try ',' (CSV mean comma separated value), because it is common and easer to see the fields.
i fear your field 'Total duration' is always empty and you didn't noticed that you tried to add the number into an other field.
the best is:
open a sample file and export a sample file. then check that exported file. you should do it like there.
if that still doesn't help:
please sent me that file or at least line 2.
Please share anybody, if there any document for import activity.
an activities.csv should look like this:
"Students Sets","Subject","Teachers","Activity Tags","Total Duration","Split Duration","Min Days","Weight","Consecutive"
"5a","MA","Tanja","",4,"1+1+1+1",1,100,1
"5b","MA","Tanja","",4,,1,100,1
"5c","MA","Tanja","",,"1+1+1+1",1,100,1
"5d","MA","Tanja","",,"2+1+1",1,100,1
"Students Sets" = Name of the students set. You need to define them before you import. Define them by importing a students.csv or define them with the fet interface.
"Subject" = Name of the Subject
"Teachers" = Name of the teacher. You can add multiple teachers if you separate them with +
"Activity Tags" = Name of the activity tag. You can add multiple activity tags if you separate them with +
"Total Duration" = Interger value of the total number of hours. can be empty if you use "Split Duration"
"Split Duration" = split the "Total Duration". If this value is empty, then it will be splitted automatic
"Min Days" = number (integer) of min days of constraint min days between activities
"Weight" = weight (double) of min days of constraint min days between activities
"Consecutive" = bool of min days of constraint min days between activities. can be 0, 1, true or false.
Thanks, Its works.