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
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).
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).
Last edited by butte on Mon Jan 13, 2014 7:08 am, edited 1 time in total.
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!
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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
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
Koeltechnische deurrubbers eenvoudig online op maat bestellen.
Alle niet stekplichtige onderdelen zoals scharnieren, sloten, randverwarming en verlichting voor alle typen koelingen en vriezers.
https://koelcel-onderdelen.com
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!) ?
What's in your system/logs/error.txt ?
What's in your server's error_log (ask web host for it!) ?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Absolutly nothing, otherwise it would have given me a clue where to look.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!) ?
if you are interested you can take a look no problem.
Koeltechnische deurrubbers eenvoudig online op maat bestellen.
Alle niet stekplichtige onderdelen zoals scharnieren, sloten, randverwarming en verlichting voor alle typen koelingen en vriezers.
https://koelcel-onderdelen.com
Send me a PM with FTP and Opencart login details, and I'll take a look at it.victorj wrote:Absolutly nothing, otherwise it would have given me a clue where to look.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!) ?
if you are interested you can take a look no problem.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Actually, there was a message in your system/logs/error.txt when I looked at it!Absolutly nothing, otherwise it would have given me a clue where to look.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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).
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
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
Koeltechnische deurrubbers eenvoudig online op maat bestellen.
Alle niet stekplichtige onderdelen zoals scharnieren, sloten, randverwarming en verlichting voor alle typen koelingen en vriezers.
https://koelcel-onderdelen.com
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
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.
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.
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.
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.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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 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.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 ?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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
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
Who is online
Users browsing this forum: No registered users and 7 guests
