[solved] problem with the import of csv files

Use this forum to report bugs and to check for bugfixes and new releases of OpenEMM

Moderator: moderator

mmenke
Posts: 30
Joined: Fri Jul 24, 2009 12:14 pm
Location: Germany
Contact:

[solved] problem with the import of csv files

Post 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
Last edited by mmenke on Wed Jan 20, 2010 11:24 am, edited 1 time in total.
mmenke
Posts: 30
Joined: Fri Jul 24, 2009 12:14 pm
Location: Germany
Contact:

update

Post 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
Post Reply