[solved] problem with the import of csv files

Questions and answers on bugs and upcoming versions of OpenEMM. See also OpenEMM bugtracker at SourceForge: http://sourceforge.net/tracker/?atid=84 ... unc=browse

Moderator: moderator

[solved] problem with the import of csv files

Postby mmenke » Tue Jan 12, 2010 12:44 pm

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

update

Postby mmenke » Wed Jan 20, 2010 11:23 am

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
mmenke
 
Posts: 30
Joined: Fri Jul 24, 2009 12:14 pm
Location: Germany


Return to Bugs, bug fixes & releases

Who is online

Users browsing this forum: No registered users and 2 guests

cron