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

Runes wrote:

JNeuhoff wrote:Hi Runes,

According to your error message it already fails at around 64M, not the 256M. Ask your webhost to resolve this, as your PHP settings seem to indicate that the memory_limit is 256M, not 64M.

You know what?

After the 4. time I turned to my webhost provider this came up:

Yes 256 M for the front store BUT NOT for the administrator- side. So, another round of changes in some of the files to get 256 and not 64M for administrator-side and whoops- IT WORKS.

As I have seen others getting the same errors as I have, this has to be useful information.
Thanks
RS

Now I hope for some trouble- free time building the store...

JNeuhoff wrote:

christianlebe wrote:...However, I've got the following error message: Table 'clebe_nuvogue.product_tag' doesn't exist

You are using a wrong, non-matching version of the Export/Import tool for your OpenCart 1.5.4.1.

JNeuhoff wrote:

Addgod wrote:...Problems is when I do an export, I get an error inside the xls files, that says the opencart_tags table does not exist.

You are not using the correct matching version of the Export/Import tool for OpenCart 1.5.4.1.

by rlasmar

Hi, I used this module yesterday and it works fine to export and import on OC 1.5.4.1, but today I noted that google base stoped work. I believe the problem was this module export/import. Could you help me to solve? Aparently the .xml is not being generated or the codification is wrong, I don't know.

<description><![CDATA[ Gildan ultracotton t-shirt - This heavyweight tee is our number one seller. It prints great and feels good on the body. Pre-shrunk jersey. Seamless double needle collar, taped neck and shoulders. Double stitched sleeve and waist hem. Quarter-turned body to eliminate centre crease. Ultra tight knit surface excellent for screenprint and embroidery. Size Chest (to fit) S-� 34/36 �M�- 38/40 �L�- 42/44 �XL�- 46/48 �2XL�- 50/52 �3XL*�- 54/56 ,�4XL+�- 58/60 ,�5XL+�- 62/64 * Only available in 3XL + Only available in 4XL and 5XL Fabric 100% cotton Ash - 99% cotton, 1% polyester Dark Heather - 50% cotton, 50% polyester Sport Grey - 90% cotton, 10% polyester Weight White 195 gsm Colour 205 gsm GD002 ]]></description>

SeanHornby wrote:Hi there, I'm having a problem running an export on one of my sites. I'm hosting via an VPS so I can make whatever changes needed.

My store has over 17000 products in it so I am aware that it'll take some time. After about 30 minutes or so, it comes up with a 500 Internal Server Error and the error_log shows:
Script timed out before returning headers: index.php, referer: http://www.xxxxxxx.com/admin/index.php? ... a5fefd08a0$

Our memory_limit is set to 1024M, max_execution_time and max_input_time is 120, post_max_size and upload_max_filesize is 100M. This is reflected when I create a phpinfo.php page on admin too, to double check it's reading the correct values from the server.

My other sites are working as intended, both import and export, so I am stumped. Can anyone shed some light by any chance?

Thanks.

JNeuhoff wrote:I think the max_execution_time and max_input_time are in seconds, and need to be increased considerably to avoid your timeout error.

f.borangic wrote:can we have this wonderfull tool for opencart 1.5.5.1 ? pls?

moneycarlo wrote:hopefully it'll still support MSExcel too.

JNeuhoff wrote:

f.borangic wrote:can we have this wonderfull tool for opencart 1.5.5.1 ? pls?

I am working on a complete rewrite of the Export/Import tool, with an improved error handler, because users keep asking the same questions, like memory_limit issues, blank screens, invalid spreadsheet formats etc. This version will be totally based on PHPExcel, and will use ODS (LibreOffice, OpenOffice) as the default format, rather than the propriatary MS Excel formats, because I can't get Microsoft to fix its MS Excel bugs, they don't have any proper bug tracking sites for reported bugs.

After that, I'll finish the planned Incremental Import and Multi-lingual support, too.