Post by thegeekz » Tue May 22, 2012 5:12 pm

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**

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


Active Member

Posts

Joined
Tue Nov 02, 2010 10:24 am

Post by asagar » Thu May 24, 2012 11:43 pm

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.

Newbie

Posts

Joined
Wed May 23, 2012 8:23 pm

Post by asagar » Fri May 25, 2012 2:03 am

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

Newbie

Posts

Joined
Wed May 23, 2012 8:23 pm

Post by hannan » Mon May 28, 2012 9:55 pm

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?

Newbie

Posts

Joined
Thu May 10, 2012 11:08 pm

Post by Turbo Bob » Tue May 29, 2012 4:58 am

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.

Newbie

Posts

Joined
Sat May 26, 2012 4:49 am

Post by sergio.vasko » Tue May 29, 2012 6:43 pm

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

Newbie

Posts

Joined
Tue May 29, 2012 3:35 pm

Post by JNeuhoff » Tue May 29, 2012 7:02 pm

sergio.vasko wrote: Better wait for update from http://www.mhccorp.com/opencart/other/e ... mport-tool
That's right ;D

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

Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster * Survey Plus


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by Bollard » Wed May 30, 2012 4:41 am

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

Newbie

Posts

Joined
Thu Feb 02, 2012 8:42 am

Post by moneycarlo » Thu May 31, 2012 4:08 am

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

Active Member

Posts

Joined
Wed Sep 28, 2011 3:40 am

Post by elaineben » Thu May 31, 2012 5:29 am

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!

Newbie

Posts

Joined
Wed May 11, 2011 8:02 pm

Post by JNeuhoff » Thu May 31, 2012 7:59 pm

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.

Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster * Survey Plus


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by Melon » Thu May 31, 2012 10:41 pm

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

New member

Posts

Joined
Thu Feb 03, 2011 8:02 pm

Post by Melon » Thu May 31, 2012 11:08 pm

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

New member

Posts

Joined
Thu Feb 03, 2011 8:02 pm

Post by scot » Sat Jun 02, 2012 7:48 am

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

Thank You,

Scot


Newbie

Posts

Joined
Sat Jan 21, 2012 4:13 am

Post by arrjaytea » Sun Jun 03, 2012 7:31 am

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

New member

Posts

Joined
Thu May 31, 2012 11:58 pm

Post by Melon » Sun Jun 03, 2012 8:39 pm

It was aimed at JNeuhoff

New member

Posts

Joined
Thu Feb 03, 2011 8:02 pm

Post by arrjaytea » Mon Jun 04, 2012 10:44 am

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.

New member

Posts

Joined
Thu May 31, 2012 11:58 pm

Post by JNeuhoff » Mon Jun 04, 2012 10:53 pm

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.

Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster * Survey Plus


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by JNeuhoff » Tue Jun 05, 2012 4:01 am

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.

Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster * Survey Plus


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by bnvspl » Tue Jun 05, 2012 9:46 pm

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?

Newbie

Posts

Joined
Sun May 20, 2012 8:08 pm
Who is online

Users browsing this forum: No registered users and 2 guests