Hi,
I'm trying to import organisations by using Totara Sync.
After a lot of attempts I get this error:
"Impossible to upload all registers".
These are the rows in org.csv file:
deleted,idnumber,timemodified,fullname,shortname,description,frameworkidnumber,parentidnumber,typeidnumber
0,25,0,savignoni,sav,desc,A001,AM001,DM002
0,26,0,savignoni2,sav2,desc2,A001,AM001,DM002
Please, could you help me?
Thank you very much.
Kind Regards
Umberto
Hi,
in any case could you provide a example of correct file?
Thank you in advance.
Kind Regards
Umberto
Hi Umbreto
The correct csv format is shown under Totara sync > Sources > Organisation
The fields that you choose under Totara sync > Elements > Manage elements are the fields displayed here.
An example of a file format for organisation is "idnumber","fullname","shortname","description","frameworkidnumber","parentidnumber","typeidnumber","timemodified"
The deleted field is not required, this is chosen under Manage element > Remove elements. The frameworkidnumber and typeidnumber needs to be defined - the sync does not create these.
Craig
Hi Umberto,
I've searched the code base and I can't find an example of the error:
"Impossible to upload all registers".
Was that the exact message you received? If not could you paste the exact error in?
Thanks,
Simon
Hi All,
thank you for your support.
I made new tests to clarify this issue.
I tried to upload a file with standard format but I get this error:
"CSV file not valid, missing field "idnumber""
This error depends on first column in the file. If I change the "idnumber" with another first column as "fullname" I get this error:
CSV file not valid, missing field "fullname"
It seems does not able to view the first column in the file.
If I add, on the first column, "deleted" i get this error:
"could not import all records".
To complete this thread I tried these tests using command line :
php -f run_cron.php
If I try by using Run_Sync link I get this other error:
"cannot create directory: /var/www/vhosts/fideuram.epinoia.it/moodledata/sync/csv/store "
This message I think is wrong because the directory already exists and from command line works fine.
I attached file to clarify my issue.
I hope this helps to fix this issue.
Thank you very much indeed.
Kind Regards
Umberto
Hi Joe,
great, this was exactly the error.
I'm wondering why, normally, the correct encoding would be UTF-8 but in this case with ANSI encoding CSV file works fine.
Thank you very much.
Kind Regards
Umberto
I opened that file with a few different text editors. In all it looked OK but some pointed out it has a BOM which is not needed or recommended. One editor suggested the file may be broken. So I'm guessing that Totara or PHP doesn't handle the BOM correctly or it really is corrupted.
The problem really is that some applications don't export UTF-8 very well. So if you're having this problem then try another encoding, as you have done.
Hi Umberto,
Yes, you should remove the BOM mark from the file and it should work - totara_sync uses the standard PHP library functions for importing the CSV file and does support UTF-8 so most likely the BOM is the issue here.
Regarding your issue running totara sync from the command line - it may be that your data directory is owned by the web server user and the user running the command at the command line doesn't have write access but the web server does.
Normally I'd run it with a command like this:
sudo -u www-data php -f run_cron.php
which runs it as the "web server" user.
Simon
