Author Topic: Field doesn't contain an integer value.  (Read 1072 times)

0 Members and 1 Guest are viewing this topic.

parthasarathy.r

  • Level 1
  • *
  • Posts: 4
    • View Profile
Field doesn't contain an integer value.
« on: January 24, 2015, 03: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?

Volker Dirr

  • Forum Administrator
  • Level 5
  • *****
  • Posts: 1906
    • View Profile
Re: Field doesn't contain an integer value.
« Reply #1 on: January 24, 2015, 06:17:37 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

parthasarathy.r

  • Level 1
  • *
  • Posts: 4
    • View Profile
Re: Field doesn't contain an integer value.
« Reply #2 on: January 24, 2015, 06:35:08 AM »
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? 
« Last Edit: January 24, 2015, 06:40:53 AM by parthasarathy.r »

Volker Dirr

  • Forum Administrator
  • Level 5
  • *****
  • Posts: 1906
    • View Profile
Re: Field doesn't contain an integer value.
« Reply #3 on: January 24, 2015, 07:13:50 AM »
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.

parthasarathy.r

  • Level 1
  • *
  • Posts: 4
    • View Profile
Re: Field doesn't contain an integer value.
« Reply #4 on: January 24, 2015, 11:19:49 AM »
Please share anybody, if there any document for import activity.

Volker Dirr

  • Forum Administrator
  • Level 5
  • *****
  • Posts: 1906
    • View Profile
Re: Field doesn't contain an integer value.
« Reply #5 on: January 24, 2015, 12:33:55 PM »
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.
« Last Edit: January 24, 2015, 12:38:20 PM by Volker Dirr »

parthasarathy.r

  • Level 1
  • *
  • Posts: 4
    • View Profile
Re: Field doesn't contain an integer value.
« Reply #6 on: January 25, 2015, 01:25:29 AM »
Thanks, Its works.
« Last Edit: January 25, 2015, 02:58:13 AM by parthasarathy.r »