OpenCart Community

Hi, I know I said I managed to solve the same issue earlier.. however after trying the installation of the Tool in another OC setup..

The Export Import Tool just doesn't appear under System...

....

EDIT: It appears that it has something to do with VQMOD's Vqcache folder permissions! Remember to set it to 777 if 755 doesn't work. I've solved it now..! **cold sweat**

joshivinay wrote:I did a clean install for Opencart 1.5.1.3 and installed the plugin. On trying to export, an Excel file was created, but it had only numbers in it. No Strings (names, descriptions, etc.) at all in any of the sheets. I remember having used the plugin in 1.4.x and it worked well at the time. I saw a post from another member in May 2011 with an identical issue, but there was no response.
Can you tell me what the issue is. I have followed all your instructions to the hilt

Regards
Vinay

Guys, anybody found solution for the above? Have been searching a solution whole day today with no success.

Everything seems to be working fine on windows+wamp+openoffice but does not show text in the exported xls (shows only numbers) on mac osx+mamp+excel/openoffice/neooffice

hannan wrote:

JNeuhoff wrote:
No idea, I am unable to reproduce your error. Have you checked your PHP settings? And done a file compare ofthe one that was fine on your other hosting and the one which is broken? Have you tried opening the file in OpenOffice?

Yes, also tried OpenOffice.

These are the URLs to check PHP settings. Can you please check it in your way?

http://bit.ly/JVs4gI (Good)
http://bit.ly/LfjMmF (Bad)

Thank You.

Could it be that the problem is Suhosin extension installed on (Bad) hosting?

Opencart 1.5.3.1
E/I Tool : opencart-1-5-2-x-export-import-6.zip
VQMOD : vqmod-2.1.6-opencart

When exporting, the xls says:

"Notice: Error: Unknown column 'cg.name' in 'field list'
Error No: 1054"

When importing it sends me to new page displaying this:

"Notice: Undefined index: name in /home/username/public_html/admin/model/tool/export.php on line 1110Notice: Undefined index: name in /home/username/public_html/admin/model/tool/export.php on line 1208Notice: Undefined index: name in /home/username/public_html/admin/model/tool/export.php on line 1310Notice: Error: Unknown column 'name' in 'field list'
Error No: 1054
INSERT INTO `customer_group` (`customer_group_id`, `name`) VALUES (2, 'Default'); in /home/username/public_html/system/database/mysql.php on line 49"



It imports the items, categories anyway and they work.

Opencart 1.5.3
quick fix: editing file admin\model\tool\export.php
1. When exporting --- "Notice: Error: Unknown column 'cg.name' in 'field list' Error No: 1054" --> in methods:
function populateRewardsWorksheet(), function populateSpecialsWorksheet(), function populateDiscountsWorksheet()
comment block of code // The actual product discounts data.
2. When importing --- in method:
function storeSpecialsIntoDatabase() comment block of code // find existing customer groups from the database.

Now it works, but its not right solve. Better wait for update from http://www.mhccorp.com/opencart/other/e ... mport-tool

sergio.vasko wrote: Better wait for update from http://www.mhccorp.com/opencart/other/e ... mport-tool

That's right

There is no point in reporting issues for 1.5.3 when it hasn't even been released yet for that version!

I really love this extension!

Is there any update for 1.5.3.x coming? I cant update without it!

Thanks for all the work

Extension works great!
Wondering if anyone has been able to create a cron job from this extension?

i have a newly installed cart, v1/5.3.1 and newly installed export/import extension (latest version also). i followed the instructions but when i opened the export/import page it was blank. i checked the system error log and this is what i got:

2012-05-30 15:44:32 - PHP Notice: Error: Could not load language tool/export! in /home/detoxcen/public_html/ocart/vqmod/vqcache/vq2-system_library_language.php on line 41
2012-05-30 16:00:30 - PHP Notice: Error: Could not load language tool/export! in /home/detoxcen/public_html/ocart/system/library/language.php on line 39
2012-05-30 16:17:24 - PHP Notice: Error: Could not load language tool/export! in /home/detoxcen/public_html/ocart/system/library/language.php on line 39

i opened the ocart/vqmod/vqcache/vq2-system_library_language.php on line 41
and ths is what i found as error (it was colored ...line 41)

$file = DIR_LANGUAGE . $this->default . '/' . $filename . '.php';

if (file_exists($file)) {
$_ = array();

global $vqmod;
require($vqmod->modCheck($file));

$this->data = array_merge($this->data, $_);

return $this->data;
} else {
trigger_error('Error: Could not load language ' . $filename . '!'); exit();
}
}
}
?>

as for the other one:
ocart/system/library/language.php on line 39 (the line was colored)

$file = DIR_LANGUAGE . $this->default . '/' . $filename . '.php';

if (file_exists($file)) {
$_ = array();

require($file);

$this->data = array_merge($this->data, $_);

return $this->data;
} else {
trigger_error('Error: Could not load language ' . $filename . '!'); exit();
}
}
}
?>

how could i solve this, please help.

thanks!

i have a newly installed cart, v1/5.3.1 and newly installed export/import extension (latest version also).

I won't even bother to answer any of your questions because we haven't yet released a version for 1.5.3.1. We are in the process of creating one for OpenCart 1.5.3.1, but it may take a few days.

Great piece of software, I can see your working on 1.5.3.1 will await for its arrival, keep up the good work.

I have edited the file to work with 1.5.3.1.. you want this?

"I have edited the file to work with 1.5.3.1.. you want this?"

I do please. Thank you.

Melon wrote:I have edited the file to work with 1.5.3.1.. you want this?

... me too

It was aimed at JNeuhoff

Melon wrote:It was aimed at JNeuhoff

Yes, clearly. That doesn't mean I wouldn't take it.

Regardless, Sergio's hack works just fine for me.

I am currently testing a new Export/Import tool release for 1.5.3.1, hope to have it released within the next few hours.

Melon wrote:I have edited the file to work with 1.5.3.1.. you want this?

Thank you for your offer. I have now released a 1.5.3.x version, with some other improvements and bugfixes.

Hi, I'm using OC 1.5.2.1

I can export and open the excel file BUT I have issues importing the file back.

However, after clicking on the "Import" button; (trying to import the same excel file back)..This is what happen:-

1) It automatically logged me out of the OpenCart Administration and
2) immediately linked to my Store Front (http://...../admin/index.php?route=tool/export&token=...) with the message "The page you requested cannot be found!"

Can anyone please help with this problem?