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

JNeuhoff wrote:

TriumphDesign wrote:Trying really hard here, I actually deleted all the oc_product_ tables and replaced them with tables from another database where the tool does work. (even that did not do the trick)

Could you, maybe, give me a list of all the affected tables the tool exports from, my bet is, if I empty them all, my problems might be solved, I already made a fresh opencart install with the template imusing + your tool and the export works on that copy. But I really can't be arsed (excuse my french) to redo the whole website css / php / etc wise.

What happens if you use the default web theme?

Nothing, I still get an export that's corrupted :\

Maybe it's because I deleted the english language completely ?

While I was trying to fix this I also found time to translate the language file to dutch, if you ever wanna use it, see the attachment.

TriumphDesign wrote:While I was trying to fix this I also found time to translate the language file to dutch, if you ever wanna use it, see the attachment.

Thanks. I think it always is a good idea to keep the english language in there for a language fallback in case something is missing.

Hi Jurgen,

Perhaps you should consider replacing the admin menu link then with a language file dependent link. When one switches languages currently the link isnt translated.

Youc an easily fix that by editing the vqmod -> xml file

The installation doesn't work if you have changed the name of your admin directory.

So, for the next release, please do not hardcode 'admin' directory into the export.php and instead use the system constant.

TriumphDesign wrote:Youc an easily fix that by editing the vqmod -> xml file

Beside the point.

Hey JNeuhoff,

I fixed the problem I had by installing a fresh install of opencart plus your tool, shame we couldn't find the real problem. But I wanted to thank you again for your time.

Thank you for your effort in developing this extension and making it available for free.

I followed your instructions to install the extension. Everything went as planned. However, I don't see an option to export/import anywhere in the interface after installing the extension.

Did I miss a step? I expected to find an option to export/import under the System menu, but it is not there.

I am seeing this error message repeated in the error logs:

2013-06-28 5:26:29 - PHP Notice: Undefined variable: export in /home/stoutn/public_html/admin/view/template/common/header.tpl on line 158
2013-06-28 5:26:29 - PHP Notice: Undefined variable: text_export in /home/stoutn/public_html/admin/view/template/common/header.tpl on line 158

Any help you can offer would be appreciated.

Ignore my post. I added comments to the files I modified during the setup and my editor removed my line breaks... so the necessary changes were mistakenly commented out also. Once I fixed the line breaks, everything works as expected.

Thank you again for this module!

Is this the tool being discussed in this thread: http://www.opencart.com/index.php?route ... e=JNeuhoff? I noticed "Compatibility" only goes up to "v1.5.3, v1.5.3.1", and we need something for our 1.5.5.1 store, but I couldn't find another, more updated extension from the same developer.

WebDev22 wrote:Is this the tool being discussed in this thread: http://www.opencart.com/index.php?route ... e=JNeuhoff? I noticed "Compatibility" only goes up to "v1.5.3, v1.5.3.1", and we need something for our 1.5.5.1 store, but I couldn't find another, more updated extension from the same developer.

All versions up to 1.5.5.1 are supported by this tool, just download the one for the correct version.

Okay. Thanks. I'm currently trying to figure out why it's not working for our 1.5.5.1 store. I first tried importing, but got the pink bar error message that reads, "Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!" I then tried exporting, but the XLSX file contains this error:

<b>Notice</b>: Error: Table 'dtb3_opencartstore.dtb3_product_tag' doesn't exist<br />Error No: 1146<br />SELECT p.product_id, pd.name, GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR "," ) AS categories, p.sku, p.upc, p.location, p.quantity, p.model, m.name AS manufacturer, p.image AS image_name, p.shipping, p.price, p.points, p.date_added, p.date_modified, p.date_available, p.weight, wc.unit, p.length, p.width, p.height, p.status, p.tax_class_id, p.viewed, p.sort_order, pd.language_id, ua.keyword, pd.description, pd.meta_description, pd.meta_keyword, p.stock_status_id, mc.unit AS length_unit, p.subtract, p.minimum, GROUP_CONCAT( DISTINCT CAST(pr.related_id AS CHAR(11)) SEPARATOR "," ) AS related, GROUP_CONCAT( DISTINCT pt.tag SEPARATOR "," ) AS tags FROM `dtb3_product` p LEFT JOIN `dtb3_product_description` pd ON p.product_id=pd.product_id AND pd.language_id=1 LEFT JOIN `dtb3_product_to_category` pc ON p.product_id=pc.product_id LEFT JOIN `dtb3_url_alias` ua ON ua.query=CONCAT('product_id=',p.product_id) LEFT JOIN `dtb3_manufacturer` m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN `dtb3_weight_class_description` wc ON wc.weight_class_id = p.weight_class_id AND wc.language_id=1 LEFT JOIN `dtb3_length_class_description` mc ON mc.length_class_id=p.length_class_id AND mc.language_id=1 LEFT JOIN `dtb3_product_related` pr ON pr.product_id=p.product_id LEFT JOIN `dtb3_product_tag` pt ON pt.product_id=p.product_id AND pt.language_id=1 GROUP BY p.product_id ORDER BY p.product_id, pc.category_id; in <b>/home/dtb3/public_html/system/database/mysql.php</b> on line <b>50</b>

For the error above, I was wondering if the config.php file needed one edit. All the other OpenCart sites we have don't have anything defined for DB_PREFIX, but this site has 'dtb3_' listed as the prefix. So I made the change but that took down the entire admin, so I added it back.

WebDev22 wrote:For the error above, I was wondering if the config.php file needed one edit. All the other OpenCart sites we have don't have anything defined for DB_PREFIX, but this site has 'dtb3_' listed as the prefix. So I made the change but that took down the entire admin, so I added it back.

I am certain you are using the wrong version of the Export/Import tool, because there is no 'product_tag' table in Opencart 1.5.5.1.

JNeuhoff wrote:I am certain you are using the wrong version of the Export/Import tool, because there is no 'product_tag' table in Opencart 1.5.5.1.

You know what? I downloaded the download file that was listed at the very top thinking it was the most recent. That's what happens when you try to make updates while juggling honey-do items for the wife at the same time.

I exported the db from our 1.4.9 store and was hoping to be able to import it into the new 1.5.5.1 store, but it's not working. Is there an easy way to migrate data from 1.4.9 to 1.5.5.1?

I downloaded the spreadsheet from the demo OpenCart site, manually keyed in a new product, and was able to do a test import. However, when I copy and paste that same one product beneath the existing products in the spreadsheet, with the exact same data, I get the pink bar error. I checked all the fields and made sure they were formatted the same. Any ideas what I'm missing?

I figured it out. I had selected entire rows, instead of just columns A through AP when copying and pasting.