Page 1 of 1

[solved] problem with the import of csv files

Posted: Tue Jan 12, 2010 12:44 pm
by mmenke
Hi,

I have a problem with importing csv-files. Version in use is 6.0.1

The import works flawlessly up to the point where OpenEMM shows the preview of the data that is going to be imported. This step works as well (that data shown is looking perfect) but when I click on forward/next (I don't know how the button is named in the english version, I am forced to work with the german version) I get a blank, white page with no HTML-output at all. Aka: the script dies.

I did check the import_log_tbl, but there are no entries.

I tried different charsets and also tried to import a csv-file that has been exported with OpenEMM. That did not work as well :(

Any ideas how I could debug this?

Thanks,

Marco

update

Posted: Wed Jan 20, 2010 11:23 am
by mmenke
Doing

tail -f /home/openemm/webapps/core/log/openemm_stdout.log

I found out that there was a problem when OpenEMM wanted to create a temporary table for the import with the database user "agnitas".
I just fixed the user's rights and everything works just fine now :)

I don't know why the rights were wrong, but it would have been one of the last places to look for me, because everything else was working fine.

Marco