OpenCart Community

Thank you for the quick reminder! I'd overlooked that from habit of looking at the prior instances. That actually opens an avenue to solution for a special problem.

Thanks guys. Got around it by using Microsoft compatibility addon which opened the xlsx file ok as well as saving in that format, so all worked fine.

This seems to be the right place to ask. I've just completed building an ecommerce site with OpenCart 1.5.6 and entered all my products, etc the hard way. The Import/Export tool seemed to be a much better way of updating the categories and products, so I downloaded it and installed. After making the changes to the files I do have the Import/Export listed under System heading in Admin. Life seemed to be good at that point, but when I export it pretends to do so, but nothing is actually exported. The error log says:

2014-01-12 2:25:42 - PHP Notice: Error: Table 'copes1_items.oc_product_tag' doesn't exist<br />Error No: 1146<br />SELECT p.product_id, pd.name, GROUP_CONCAT( DISTINCT CAST... and it goes on forever...

Does anyone have any idea what is wrong? I don't know enough about PHP or MySQL to understand what it is telling me. It appears it can't find my database, but have no idea how to fix that.

Thanks for any help!
Copes can't cope

copes1, what is the OC version [okay, you did say 1.5.6] and is the tool version the correct one?

It sees the database, but the table copes1_items,oc_product_tag is missing, and then it cannot concatenate (that means adding end to end, as in the old days of copy A.txt + B.txt + C.txt > D.txt).

The Export/Import tool for Opencart 1.5.6.x doesn't use the table 'product_tag' anywhere. I think you must have ionstalled the wrong version of the Export/Import tool!

JNewhoff, you are of course correct. I inadvertently downloaded and installed the incorrect version. Please forgive me for bothering you with my foolish mistake. I downloaded and installed the correct version and life is good once again thanks to you. Thank you very much for all your work in creating this handy tool, and doubly thanks for taking the time to assist foolish users like me.

I have a problem as well.
oc 1.5.5.1 exel 2007

used it on 1.5.4.1 without any problems

just upgrade, installed correct version

exporting no problem, doing a import works like a charm
opening file in exel, and save it straight away and import will give a blank screen.
same after editing, saving and importing.

clearly doing something wrong, but no cleu what im doing wrong

My questions as always:

What's in your system/logs/error.txt ?
What's in your server's error_log (ask web host for it!) ?

JNeuhoff wrote:My questions as always:

What's in your system/logs/error.txt ?
What's in your server's error_log (ask web host for it!) ?

Absolutly nothing, otherwise it would have given me a clue where to look.

if you are interested you can take a look no problem.

victorj wrote:

JNeuhoff wrote:My questions as always:

What's in your system/logs/error.txt ?
What's in your server's error_log (ask web host for it!) ?

Absolutly nothing, otherwise it would have given me a clue where to look.

if you are interested you can take a look no problem.

Send me a PM with FTP and Opencart login details, and I'll take a look at it.

Absolutly nothing, otherwise it would have given me a clue where to look.

Actually, there was a message in your system/logs/error.txt when I looked at it!

I'll hazard to guess that it didn't say Hi. It may have been obscure enough not to seem related to the problem -- I don't believe he misses much under the hood.

victorj, if you skipped past them, two above (prior page), http://forum.opencart.com/viewtopic.php ... 60#p455924 and http://forum.opencart.com/viewtopic.php ... 60#p458942, may help as simple reminders to look at worksheet tabs' cell formats inside Excel, before Saving changes. If General prevails, that may upset format purity (particularly but not exclusively in ID cells).

just before jneuhoff checked site, increased memory and it started to produce a error.

the problem was not the import export it is working great,

in the names of the images where spaces and ' imbedded into the names and that is something wich will not work, after changing al names to generic import is as smooth as always.
as i already mentioned all fault was on my side

all credit for solving this is for JNeuhoff

great service

Hello
i not writing eng

this is google/tran


My problem is export/import modul.

i downloading my database. But unfortunately, he does not take all the rows in particular would need to take the lead in new lines for the names of tire size and other rows

evarE, your eng/g/tran works well enough. Which OC version do you have? Are there any errors logged in system/log/errors.txt?

See http://forum.opencart.com/viewtopic.php ... 86#p350982 -- install correct version, back up database, then export .xlsx, open that in Excel 2007 or compatible, edit, save, then import .xlsx to server.

My OC version v1.5.2.1 because the design template is also to v1.5.2.1. But my problem is downloading XLSX fail.

I opening fail exel then there is a all rows ok but not rows tyre_search data.

$this->data['entry_tyre_type'] = $this->language->get('entry_tyre_type');
$this->data['entry_tyre_width'] = $this->language->get('entry_tyre_width');
$this->data['entry_tyre_profile'] = $this->language->get('entry_tyre_profile');
$this->data['entry_tyre_diameter'] = $this->language->get('entry_tyre_diameter');
$this->data['entry_tyre_speed'] = $this->language->get('entry_tyre_speed');

i need this data exporting fail xlsx

I hope that is understandable.

butte wrote:evarE, your eng/g/tran works well enough. Which OC version do you have? Are there any errors logged in system/log/errors.txt?

See http://forum.opencart.com/viewtopic.php ... 86#p350982 -- install correct version, back up database, then export .xlsx, open that in Excel 2007 or compatible, edit, save, then import .xlsx to server.

Your additional fields such as tyre_type etc are not part of a standard OpenCart.

You have 2 choices:

1) Add support for these additional fields youself in file admin/model/tool/export.php

2) Or I can do it for you for a small charge, send me a PM if interested, with details.

Having a slight issue i can't seem to resolve:

I installed the Export/Import extension as per the instructions - Upload the Admin and System folders, then the VQmod folder, then tick them in the top administrator account.

i can access the import/export tool from the system menu, now I have found a problem that I can't seem to resolve:
Whenever i try to export I get the following error:
Parse error: syntax error, unexpected $end, expecting T_STRING in /home/handmark/public_html/system/PHPExcel/Classes/PHPExcel/Shared/String.php on line 434

Any suggestions ?

kukaraditya wrote:Having a slight issue i can't seem to resolve:

I installed the Export/Import extension as per the instructions - Upload the Admin and System folders, then the VQmod folder, then tick them in the top administrator account.

i can access the import/export tool from the system menu, now I have found a problem that I can't seem to resolve:
Whenever i try to export I get the following error:
Parse error: syntax error, unexpected $end, expecting T_STRING in /home/handmark/public_html/system/PHPExcel/Classes/PHPExcel/Shared/String.php on line 434

Any suggestions ?

I am unable to reproduce your error.

Hello,

I just upgraded my opencart store from 1.5.5.1 to 1.5.6.1 this morning. I had been using the import/export
tool for 1.5.5.1 for a long time and it worked great. Once I upgraded it no longer showed up, so I downloaded to current version for 1.5.6.1 and uploaded it via Filezilla (uploaded admin & system then vqmod as directed). I then checked the permissions boxes and saved everything. after refreshing the screen the import/export tool still does not show up.

Thanks