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**
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**
No more using Apsona, as they are not updated.
- Every upgrade -- rem. 2 reinstall vqmod & mindful of modules w/ VQmod -- E.g Import / Export Tool by MHC
Guys, anybody found solution for the above? Have been searching a solution whole day today with no success.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
hannan wrote:Yes, also tried OpenOffice.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?
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.
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
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
That's rightsergio.vasko wrote: Better wait for update from http://www.mhccorp.com/opencart/other/e ... mport-tool
There is no point in reporting issues for 1.5.3 when it hasn't even been released yet for that version!
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Extension works great!
Wondering if anyone has been able to create a cron job from this extension?
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!
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 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.i have a newly installed cart, v1/5.3.1 and newly installed export/import extension (latest version also).
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Thank you for your offer. I have now released a 1.5.3.x version, with some other improvements and bugfixes.Melon wrote:I have edited the file to work with 1.5.3.1.. you want this?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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?
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?
Who is online
Users browsing this forum: No registered users and 151 guests