[UPDATED] Export/Import tool for OpenCart 1.4.9

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'n Prop CF061')' at line 1
Error No: 1064
INSERT INTO `product_image` (`product_image_id`, product_id, `image`) VALUES (493,492,'Pop'n Prop CF061');

In method storeProductsIntoDatabase of the file admin/model/tool/export.php, change the line

$imageName = $product[7];

to using

$imageName = $database->escape($product[7]);

Hello JNeuhoff, i changed line but error is still there.

I'm trying to use your tool with 1.4.9.4 opencart. Downloaded latest version from MHC download section. It works, but I get only numbers in exported XLS. No text, like it drops strings. Even Columns titles are blank, I have only numbers. I have cyrillic text, using UTF-8 encoding.

Hello

I successfully installed your new updated module for 1.4.9.5. It export and imports without errors. But it only show up products and categories in front end. And all categories and products are empty in back end. What is wrong????

Sorry. It had to do with language settings. I had different language set up for admin.

Module works perfect (at least on local machine, for the moment). Thanks.

Hi!

I'm experiencing this error, how could I solve it?

yiyinlah wrote:Hi!

I'm experiencing this error, how could I solve it?

Code: Select all

Fatal Error: Class 'ZipArchive' not found in /home/blahblah/public_html/system/PHPExcel/Classes/PHPExcel/Shared/File.php on line 53

I am unable to reproduce your error.

JNeuhoff wrote:

yiyinlah wrote:Hi!

I'm experiencing this error, how could I solve it?

Code: Select all

Fatal Error: Class 'ZipArchive' not found in /home/blahblah/public_html/system/PHPExcel/Classes/PHPExcel/Shared/File.php on line 53

I am unable to reproduce your error.

Perhaps I'll share with you what I was doing.

I used to use Excel 2003, thus format is 97-2003, xls format.
But as I need to use more than 7 levels of nested formulas, I downloaded Excel 2010.

But in 2010, compatibility mode was used for my file, so in order to remove this mode, I changed the file format to 2010 format. & when I tried to upload a pure 2010 excel workbook, this error happens.

Initially I use Excel 2003 to import, so even when I try to export from admin now, before downloading/save as/open, the window also read it as a 2003 file format.

I could only import 2003 versions of excel files now and so, even after downloading excel 2010, I have to keep using compatibility mode.

Do you know what's happening?

I don't use any Microsoft software so I am unable to reproduce it.

According to wikipedia:

Microsoft Excel up until 2007 version used a proprietary binary file format called Binary Interchange File Format (BIFF) as its primary format.[49] Excel 2007 uses Office Open XML as its primary file format, an XML-based format that followed after a previous XML-based format called "XML Spreadsheet" ("XMLSS"), first introduced in Excel 2002.[50]

It appears to me you are not using the BIFF format. If Excel 2010 isn't backward compatiblewith the BIFF you could always use OpenOffice.

JNeuhoff wrote:I don't use any Microsoft software so I am unable to reproduce it.

According to wikipedia:

Microsoft Excel up until 2007 version used a proprietary binary file format called Binary Interchange File Format (BIFF) as its primary format.[49] Excel 2007 uses Office Open XML as its primary file format, an XML-based format that followed after a previous XML-based format called "XML Spreadsheet" ("XMLSS"), first introduced in Excel 2002.[50]

It appears to me you are not using the BIFF format. If Excel 2010 isn't backward compatiblewith the BIFF you could always use OpenOffice.

What is OpenOffice?

It would take you only one or two seconds to Google it:

http://www.openoffice.org/

JNeuhoff wrote:It would take you only one or two seconds to Google it:

http://www.openoffice.org/

Sorry!

But could it take in Excel formulas?

But could it take in Excel formulas?

Yes. But this is not relevant here, because the Export/Import tool won't support any formulas!

JNeuhoff wrote:

But could it take in Excel formulas?

Yes. But this is not relevant here, because the Export/Import tool won't support any formulas!

Oops! I didn't know.
But it's just to calculate numbers, could it not accept too? ;/

Hi All,

First post here as a newbie to OpenCart.

Does anyone have this extension running in 1.5 yet?

The instructions don't seem to apply/work to the latest version.

Any/All help appreciated.

Thanks

Still working on a 1.5.0 version, hope to have it released soon.

raoulpop wrote:I'd really appreciate some usage instructions for this plugin. I've installed it according to your instructions (vQMod is pre-installed), and I see no Import or Export option anywhere in the Admin pages. (Yes, I've enabled it on the user group page.) I don't know where else to look. Please help.

I have the same issue.

I was using Apsona before this, but suddenly, the function went missing.. without me doing anything..

Then I tried to install this tool from MHC, but...... sad news is it does not appear as well after installing and getting the Admin rights checked... in System -- User Group...



Think this has happened to me twice... to both Apsona and MHC's export & import tool...

Has any one imported products and options from 1.4.9.4 to 1.5.0 with this tool?

grgolf wrote:Has any one imported products and options from 1.4.9.4 to 1.5.0 with this tool?

Not yet, but I checked the two XLS files to determine what the differences are. I've seen quite some differences so I think I need to copy/paste per column.

I was able to import the products and options from 1.4.9.4 to 1.5. I just need to modify the spreadsheet a little. I was able to get the customers imported too, but now I'm having problems getting orders imported in. Any help would be appreciated.