[RELEASED] Export/Import tool for OpenCart 1.5.5.x

I've been testing this tool, but I may have missed something. Is there a way to only add new products or options without re-importing the entire inventory database? I am approaching 20K products, and it makes for a very memory intensive operation.

The error suggests that since it tripped over mem even at 256M you should try 512M. It is memory intensive (I run it at 512M). It replaces particular tables (you can draw down backups of the checkbox-checked tables before importing).

butte wrote:The error suggests that since it tripped over mem even at 256M you should try 512M. It is memory intensive (I run it at 512M). It replaces particular tables (you can draw down backups of the checkbox-checked tables before importing).

Thanks for your recommendations. I gave up after a while, and did what I had to do the old fashioned way

Edits 5th above, corrected 998/998 typo, added max_execution_time 300.

It runs smoothly with those maxima: execution, memory, post, upload at 300, 256M, 999M, 998M.

[EDIT, ADDED:] Ditto, with 300, 512M, 999M, 998M.

Hi all,

I have installed a fresh version 1.5.6 in a brand new subfolder. I downloaded this mod from http://www.mhccorp.com/export-import-tool and selected the 1.5.6 version

I have vQmod installed but the export/import tool did not show up in admin.
So I amended the files manually as per the readme.txt, however when attempting to edit "file admin/view/template/common/header.tpl" I find the tpl file is empty.

So I deleted it and uploaded it again, having checked that the file in the 1.5.6 uploads folder did have content. Opened it again and it was blank once more....

Not sure what to do or even where I should post this problem?

Thanks in advance

TAC, the only admin template file should be this one, 3 kb:
admin/view/template/tool/export.tpl
There are two files as admin/controller/common/ header.php and admin/language/[english]/common/ header.php
but those are not .tpl and are several kb apiece.
Ditto for 1.5.5.1 (and probably all prior).

The OC admin/view/template/common/header.tpl file is on the order of 12 kb (1.5.5.1, 1.5.6.0). The tool has no such file.

That might relate to some of your other two threads, on upgrade/installation, and if so, then the tool not working is a good thing for leading you to the hollow file. Whatever you did, if there is a hollow admin/view/template/common/header.tpl file and you will want to replace that from your original OC .zip /upload/ tree. You MIGHT have used the wrong ftp mode. Be certain to send either fileset up via ftp in [AUTO MODE IF YOU SEND UP A TREE] -- text mode is for text (readable, when you look inside them), binary is for compiled executable and for imagery binary files (all or partly gibberish, when you look inside them, spreadsheets, word processor files, images, programs, etc.). Without that file, admin won't get far -- there's no horse under your saddle.

Thank you butte

I have looked in FileZilla but cannot see a choice for auto mode or ascii mode - see attached & next post

The reason I am altering the files is the instructions in the export/import readme.txt:

Step 2)
The following OpenCart core files need to be changed:

admin/controller/common/header.php
admin/language/english/common/header.php
admin/view/template/common/header.tpl

There are 3 ways to do that:

a) If the Override Engine is already pre-installed:
(see http://www.opencart.com/index.php?route ... on_id=8588)
Simply upload the folder 'override' with its sub-folders and files
to your remote OpenCart main directory.

b) Else, if you have VQmod pre-installed:
(see http://code.google.com/p/vqmod/)
Simply upload the folder 'vqmod' with its sub-folders and files
to your remote OpenCart main directory.

c) Neither the Override Engine nor VQmod is pre-installed:
You have to manually edit the header files, as follows:

In file admin/controller/common/header.php find:
$this->data['text_backup'] = $this->language->get('text_backup');
Add the following after the found line:
$this->data['text_export'] = $this->language->get('text_export');

In file admin/controller/common/header.php find:
$this->data['backup'] = $this->url->link('tool/backup', 'token=' . $this->session->data['token'], 'SSL');
Add the following after the found line:
$this->data['export'] = $this->url->link('tool/export', 'token=' . $this->session->data['token'], 'SSL');

In file admin/language/english/common/header.php find:
$_['text_backup'] = 'Backup / Restore';
Add the folling after the found line:
$_['text_export'] = 'Export / Import';

In file admin/view/template/common/header.tpl find:
<li><a href="<?php echo $backup; ?>"><?php echo $text_backup; ?></a></li>
Add the following after the found line:
<li><a href="<?php echo $export; ?>"><?php echo $text_export; ?></a></li>

Am I in the right thread for this do you think

Missing attachment for post above

Yup, this is the right thread for the /admin/view/template/common/header.tpl file that does not exist either there or in any other tool directory. I have fresh downloads of all tool versions, and for 1.5.5.1 and 1.5.6.0 there is no such file; anywhere. There is an export.tpl but no index.tpl file. [For good measure I just now brought down a full set of all tool versions, no change, no such file.]

Under Advanced and Transfer Settings as well as in Preferences you'll find auto/ascii/binary, choose auto; you'll find auto/passive/active, choose auto; you'll find max limits, allow ten. If you send up an entire tree you'll want auto so that no binaries wind up wrong.

I am probably being dumb but I can't see the options you mention in FileZilla (see my screen shots to see what I can see).

The admin/view/template/common/header.tpl file exists in my download of OC 1.5.6 and it is full of text but once uploaded it is empty.

The export.tpl file is in its rightful place at least. I was sooo hoping a fresh install would be trouble free

It's worth diddybopping on over right about now to http://www.mhccorp.com/export-import-tool for a FRESH KNOWN GOOD download of the tool versions FOR your own prior, and 1.5.5.1, and 1.5.6.0 OC.

Ditto 1.5.6.0 at its own address.

The headings across the top are clickable, they unfurl menus, UNDER File Manager's tabs General / Advanced / Transfer Settings / Charset. There is a master setting for Preferences over on the left under one of the tabs across the program's top. The settings are in those.

To bring them onto this page: Under Advanced and Transfer Settings as well as in Preferences you'll find auto/ascii/binary, choose auto; you'll find auto/passive/active, choose auto; you'll find max limits, allow ten.

Possible permissions problem, see http://forum.opencart.com/viewtopic.php ... 67#p443867 . . .

I downloaded the 1.5.6 version from http://www.mhccorp.com/export-import-tool today. Could it make a difference if I do it again?

I was looking at the FileZilla window not the menu at the top of the screen - oops

Everything is set to auto and max limit is 10. I deleted the file online and re uploaded the one from 1.5.6 and still get blank but the file is called header 2.tpl is that a clue? See attached

First retry the OC file as you did (see other thread at the moment, may not need to redo the tool).

Since you now have admin/view/template/common/header.tpl from OC, you probably related it, above, to the tool instead while distracted by the post box. You seem to have the proper tool export.tpl, and the proper OC header.tpl in place now.

When I open the admin/view/template/common/header.tpl file in my downloaded version of 1.5.6 looks like this: When I upload I am asked to overwrite it: And when I open the file online I get: So I assume there is nothing wrong with the file I am uploading but something gets lost in translation?

Would it be quicker to try and work out why the vQmod method didn't work?

While this issue is going on I started to change my theme spreadsheet. When I upload it, and ask it to overwrite the existing file, funnily enough it does not alter anything. The original is still in operation.....

Something is wrong in my FileZilla still?

First try to fire it up using that file. The blank could well arise if the ftp client does not know what editor to use.

Both threads, try firing it up, blank file may owe to ftp client not knowing what editor to use, file will appear unchanged after new upload when timestamps are preserved.

Thanks, Jürgen, once more for developing this tool for the 1.5.6.
I could not find a thread on this version, so I post here in the newest, 1.5.5....

The application has worked well, but I ran into a problem yesterday, and I do not know if it's related to the import/export tool or not. Anyway: Here are the symptoms:

Uploaded Excel- file with added products. Products show up at the admin products- panel, but not at the shop. Why?

Try to download the product- list and recieved a file that was unreadable, format incorrect.Why?

I get these Error- messages:

2013-10-05 22:16:53 - PHP Fatal Error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 84 bytes) in /home/54/w189558/rseuroford/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php on line 155
2013-10-05 22:16:53 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/54/w189558/rseuroford/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php:155) in /home/54/w189558/rseuroford/admin/model/tool/export.php on line 49
2013-10-05 22:16:53 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/54/w189558/rseuroford/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php:155) in /home/54/w189558/rseuroford/admin/model/tool/export.php on line 50

I'm now at 1000 products and have 128 kB memory, and this might be part of the reason?

I first thought there was something wrong in the uploaded excel- file, and there still might be, but after changing formats in the cells it was uploaded succesfully. But again, the products are not visible in the shop. If you search the product- names, they are not found. Even if they're in the catalogue/ products on the admin- page....

Any clues?

Thank you....

Hello,

I'm running 1.5.6 & seeing this error when I try to export...

"Class 'PHPExcel_Shared_String' not found"

...I keep staring at it, but after staring at this line for 3.3hrs, I haven't a clue what it means (or more importantly how to solve it), please help because I can't stare at the screen any longer