Page 1 of 1
Import/Export: Export Error
Posted: Wed Nov 10, 2010 12:01 am
by smutnak
Hello, I have problem with export XLS with this tool. When I exported file, no sheets with categories, products, ....
But only one with some unknown characters. No format. Any Idea?
Re: Import/Export: Export Error
Posted: Wed Nov 10, 2010 1:34 am
by JNeuhoff
No more details:
Opencart version? What version of Export/Import? With what products? Any messages in your error_log or opencart's system/logs/error.txt ?
Re: Import/Export: Export Error
Posted: Wed Nov 10, 2010 1:50 am
by WhiteBirch
Yeah versions would be helpful, and make sure you followed the installation instructions correctly.
Re: Import/Export: Export Error
Posted: Wed Nov 10, 2010 4:10 am
by smutnak
Sorry. Opencart version 1.4.9.1 and Import/Export for this verison.
http://www.opencart.com/index.php?route ... sion_id=17
In error log nothing, becasuse export was successful, but unreadable, or the wrong format.
A week ago, the export function. Thanks to this trade filled. Several times he made a new import and export. Since then, the only edited through the administration. Suddenly it is not.
Re: Import/Export: Export Error
Posted: Wed Nov 10, 2010 7:04 pm
by JNeuhoff
smutnak wrote:Sorry. Opencart version 1.4.9.1 and Import/Export for this verison.
http://www.opencart.com/index.php?route ... sion_id=17
In error log nothing, becasuse export was successful, but unreadable, or the wrong format.
A week ago, the export function. Thanks to this trade filled. Several times he made a new import and export. Since then, the only edited through the administration. Suddenly it is not.
Send me a PM with a zipped backup copy of your DB, and I can try it out on my local test server. I need to be able to replicate this error in order to fix it.
Re: Import/Export: Export Error
Posted: Thu Nov 11, 2010 4:20 pm
by smutnak
I have found what is problem. Problem is in settings in /admin/language/english/english.php where is
$_['date_format_short'] = 'd/m/Y';
but i changed to
$_['date_format_short'] = 'd.m.Y';
And after this change export returns incorrect xls file.
The question is what the change in exports did not matter to another date format.
Re: Import/Export: Export Error
Posted: Thu Nov 11, 2010 11:49 pm
by JNeuhoff
The export doesn't use the setting from the admin/english.php file for the date_format_short. It reads it directly from the MySQL database where the field type always is datetime or date, using the format 'yyyy-mm-dd hh:mm:ss' or 'yyyy-mm-dd'. The same format is used in text fields in the exported XLS file.