Post by TAC » Tue Apr 22, 2014 1:29 am

The categories not showing in the shop seems to be because the Store has not been set in the data tab. I must have missed that column when I added the date to the spreadsheet.

Am hoping the categories will link to the correct pages once this site replaces the old one :-\

User avatar
TAC
Active Member

Posts

Joined
Sun Sep 26, 2010 1:33 am
Location - England

Post by stimacm » Wed Apr 23, 2014 10:25 am

Hi JNeuhouff,
I have OC 1.5.5.1 installed and am getting this error when I run the export. Can you please help? Thank You!

2014-04-23 0:37:48 - PHP Notice: Error: Table 'justtake_opencart13.oc_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 `oc_product` p LEFT JOIN `oc_product_description` pd ON p.product_id=pd.product_id AND pd.language_id=1 LEFT JOIN `oc_product_to_category` pc ON p.product_id=pc.product_id LEFT JOIN `oc_url_alias` ua ON ua.query=CONCAT('product_id=',p.product_id) LEFT JOIN `oc_manufacturer` m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN `oc_weight_class_description` wc ON wc.weight_class_id = p.weight_class_id AND wc.language_id=1 LEFT JOIN `oc_length_class_description` mc ON mc.length_class_id=p.length_class_id AND mc.language_id=1 LEFT JOIN `oc_product_related` pr ON pr.product_id=p.product_id LEFT JOIN `oc_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 /home/justtake/public_html/system/database/mysql.php on line 50
2

Newbie

Posts

Joined
Tue Sep 03, 2013 10:54 am

Post by JNeuhoff » Wed Apr 23, 2014 5:23 pm

stimacm :

You are using the wrong non-matching version of the Export/Import tool.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by TAC » Wed Apr 23, 2014 9:36 pm

Hi again,

Will the categories will link to the correct pages once this site replaces the old one? Or is there something else I need to correct now?

User avatar
TAC
Active Member

Posts

Joined
Sun Sep 26, 2010 1:33 am
Location - England

Post by dragos.m » Thu Apr 24, 2014 3:25 pm

Hello Jneuhoff,

Can you please help me with my problem ? I need this because I can't edit products from admin and export, I can only edit them in the xlsx and it's really annoying.

"Allowed memory size of 1073741824 bytes exhausted (tried to allocate 32 bytes)

I have the same problem when trying to export. Not many modifications in database, only Journal theme if it's somehow related... Import works like a charm, exporting is an issue.

~3300 products here."

Newbie

Posts

Joined
Thu Mar 06, 2014 5:02 pm

Post by rawmeattt » Thu May 01, 2014 12:00 am

I have had no luck with the import /export tools free or purchased, I have a few sites using Pinnacle Cart and I must admit uploading 30,000-60,000 items is just so easy, you add to existing products, you can add and remove everything, and a few more options, exporting is also just a joy to work with. Opencart lacks alot here, making us use excel is not good and I have just started upload and downloading from the database directly in CSV format and I have had no issues what so ever. Things happen in split seconds.

Someone needs to sit down and figure what I consider the most important function that a modern cart needs, besides bulk uploading of Categories and Manufacturers, images separately. Now if there is a solid import export tool I would love to use it. These posts with responses that keep telling users to increase memory setting is just not right in most cases.

my 2 cents in CSV

Newbie

Posts

Joined
Mon Apr 28, 2014 5:21 am

Post by shearmadness » Thu May 01, 2014 1:35 am

Hi There!
We have used your export/import tool on older versions of opencart and LOVE it! However we just had the newest version of OC Installed Version 1.5.6.1 - and we exported just fine, added our products and then imported just fine. Then next time we tried to export we got the message below - except the end was the Supervisor - line 126 - I found this comment several times on the forum so I adusted our php.ini settings to the following:
magic_quotes_gpc = Off;
register_globals = Off;
default_charset = UTF-8;
memory_limit = 512M;
max_execution_time = 36000;
upload_max_filesize = 998M;
safe_mode = Off;
mysql.connect_timeout = 20;
session.use_cookies = On;
session.use_trans_sid = Off;
session.gc_maxlifetime = 12000000;
allow_url_fopen = on;


Then we got this error -

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 20 bytes) in /home/content/62/7811162/html/supplies/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/CacheBase.php on line 110

Could you help me fix this problem?

Newbie

Posts

Joined
Thu May 01, 2014 1:23 am

Post by JNeuhoff » Thu May 01, 2014 4:15 am

Your webhost doesn't alow more than 64MB, despite your meory_limit set top 512M. Get in touch with your webhost, or change webhost if they don't allow it.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by rawmeattt » Thu May 01, 2014 8:56 pm

Hi I suggest you start uploading(import/export) directly through your database - no one is going to give you more than 128mb on a shared server and you don't need it. The import tool is not good - the rest of the cart is wonderful.

This standard answer of asking everyone to increase their memory limits in PHP.ini is not the solution.

Newbie

Posts

Joined
Mon Apr 28, 2014 5:21 am

Post by TAC » Thu May 01, 2014 9:03 pm

I have a new issue now. I got things to work (on a different site) only to discover all my options have been altered.

I exported my products, added some new one and imported the updated spreadsheet.

I use a mod called Product Options Max Length because I can only accept certain length messages on my products. After the import all the values for the options have been reset to 0.

Is this mod conflict known about and is it fixable at all? I have also asked in the thread for the mod Product Options Max Lengthhttp://forum.opencart.com/viewtopic.php ... 0&start=20

User avatar
TAC
Active Member

Posts

Joined
Sun Sep 26, 2010 1:33 am
Location - England

Post by Xciso » Sat May 03, 2014 3:05 pm

Hello.
I cant find topic for 1.5.6x, so I write here.
I am working on a mod of your extension to insert a "Filters" tab after the "Attributes" tab.

I have now get it working, but it is one thing i dont know if you have missed or not.
At the attribute tab, i think it should be a row for sort_order. Or?

Is that something you have missed or why dosnt you have it there?
If people insert attributes from admin, they can set sort order for each attribute and attribute group.

Thanks.

Active Member

Posts

Joined
Fri Jul 15, 2011 5:20 am

Post by TAC » Mon May 05, 2014 12:08 am

And another problem now
Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!
I have OC 1.5.6.1 and E/I 17 and I downloaded a spreadsheet no problem. I even used OpenOffice as suggested. I added some products to the spreadsheet and tried to re-upload. But I got the error. I changed nothing else. I added the products by copy & pasting data from an older version of E/I from my 1.4.9 store.

Also when you save an OpenOffice document .ods you can't save it as an xlsx file so you can't import it again. So using OpenOffice seems pointless?

This is driving me crazy ???

User avatar
TAC
Active Member

Posts

Joined
Sun Sep 26, 2010 1:33 am
Location - England

Post by JNeuhoff » Mon May 05, 2014 5:59 pm

TAC: At the danger of repeating myself (because people simply don't get it): Check the error logs, especially OpenCart's system/logs/error.txt which which tell you exactly what worksheet header is wrong, Also, you can use OpenOffice or LibreOffice and save your file in ODS, the Import supports ODS, XLS and XLSX formats.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by TAC » Mon May 05, 2014 7:56 pm

Thanks JNeuhoff,

If a lot of us aren't getting it then it can't be that simple ;)

I tried .ods with no luck.

Here are my errors from Admin:

Code: Select all

2014-02-07 19:36:25 - PHP Notice:  unserialize(): Error at offset 0 of 23 bytes in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/system/library/cart.php on line 30
2014-02-08 14:01:26 - PHP Notice:  unserialize(): Error at offset 0 of 15 bytes in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/system/library/cart.php on line 30
2014-02-10 16:32:23 - PHP Notice:  unserialize(): Error at offset 0 of 21 bytes in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/system/library/cart.php on line 30
2014-03-26 19:04:55 - PHP Warning:  Unknown: write failed: No space left on device (28) in Unknown on line 0
2014-03-26 19:04:55 - PHP Warning:  Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp) in Unknown on line 0
2014-04-21 16:21:59 - PHP Fatal Error:  Allowed memory size of 67108864 bytes exhausted (tried to allocate 212370713 bytes) in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/system/PHPExcel/Classes/PHPExcel/Reader/Excel2007.php on line 323
2014-04-21 16:28:41 - PHP Notice:  Undefined variable: fileHandle in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/system/PHPExcel/Classes/PHPExcel/Reader/CSV.php on line 147
2014-04-21 16:28:41 - PHP Warning:  rewind() expects parameter 1 to be resource, null given in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/system/PHPExcel/Classes/PHPExcel/Reader/CSV.php on line 147
2014-04-21 16:28:41 - PHP Notice:  iconv(): Detected an illegal character in input string in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/system/PHPExcel/Classes/PHPExcel/Shared/String.php on line 386
2014-04-21 16:28:41 - PHP Notice:  iconv(): Detected an illegal character in input string in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/system/PHPExcel/Classes/PHPExcel/Shared/String.php on line 386
2014-04-21 16:28:41 - PHP Notice:  iconv(): Detected an illegal character in input string in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/system/PHPExcel/Classes/PHPExcel/Shared/String.php on line 386
2014-04-21 16:28:41 - PHP Notice:  iconv(): Detected an illegal character in input string in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/system/PHPExcel/Classes/PHPExcel/Shared/String.php on line 386
2014-04-21 16:28:41 - PHP Notice:  iconv(): Detected an illegal character in input string in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/system/PHPExcel/Classes/PHPExcel/Shared/String.php on line 386
2014-04-21 16:28:48 - Export/Import: Invalid number of worksheets, 8 worksheets expected
2014-04-21 16:35:50 - PHP Fatal Error:  Allowed memory size of 67108864 bytes exhausted (tried to allocate 212370713 bytes) in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/system/PHPExcel/Classes/PHPExcel/Reader/Excel2007.php on line 323
2014-04-21 17:26:31 - PHP Fatal Error:  Allowed memory size of 67108864 bytes exhausted (tried to allocate 212370713 bytes) in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/system/PHPExcel/Classes/PHPExcel/Reader/Excel2007.php on line 323
2014-04-21 17:47:20 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1570
2014-04-21 17:47:20 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1583
2014-04-21 17:47:20 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1609
2014-04-21 17:47:20 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1622
2014-04-21 17:47:20 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1635
2014-04-21 17:47:20 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1648
2014-04-21 17:47:20 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1661
2014-05-04 16:56:04 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1570
2014-05-04 16:56:04 - Export/Import: Invalid header in the Categories worksheet
2014-05-04 17:10:07 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1570
2014-05-04 17:10:07 - Export/Import: Invalid header in the Categories worksheet
2014-05-04 17:11:47 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1570
2014-05-04 17:11:47 - Export/Import: Invalid header in the Categories worksheet
2014-05-04 17:12:28 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1570
2014-05-04 17:12:28 - Export/Import: Invalid header in the Categories worksheet
2014-05-04 18:03:35 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1570
2014-05-04 18:03:35 - Export/Import: Invalid header in the Categories worksheet
2014-05-04 18:20:20 - PHP Fatal Error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 79 bytes) in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/Memory.php on line 55
2014-05-04 18:39:52 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1570
2014-05-04 18:39:52 - Export/Import: Invalid header in the Categories worksheet
2014-05-04 18:42:05 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1570
2014-05-04 18:42:05 - Export/Import: Invalid header in the Categories worksheet
2014-05-04 19:09:19 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1570
2014-05-04 19:09:19 - Export/Import: Invalid header in the Categories worksheet

And these are from error.txt

Code: Select all

2014-02-07 19:36:25 - PHP Notice:  unserialize(): Error at offset 0 of 23 bytes in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/system/library/cart.php on line 30
2014-02-08 14:01:26 - PHP Notice:  unserialize(): Error at offset 0 of 15 bytes in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/system/library/cart.php on line 30
2014-02-10 16:32:23 - PHP Notice:  unserialize(): Error at offset 0 of 21 bytes in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/system/library/cart.php on line 30
2014-03-26 19:04:55 - PHP Warning:  Unknown: write failed: No space left on device (28) in Unknown on line 0
2014-03-26 19:04:55 - PHP Warning:  Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp) in Unknown on line 0
2014-04-21 16:21:59 - PHP Fatal Error:  Allowed memory size of 67108864 bytes exhausted (tried to allocate 212370713 bytes) in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/system/PHPExcel/Classes/PHPExcel/Reader/Excel2007.php on line 323
2014-04-21 16:28:41 - PHP Notice:  Undefined variable: fileHandle in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/system/PHPExcel/Classes/PHPExcel/Reader/CSV.php on line 147
2014-04-21 16:28:41 - PHP Warning:  rewind() expects parameter 1 to be resource, null given in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/system/PHPExcel/Classes/PHPExcel/Reader/CSV.php on line 147
2014-04-21 16:28:41 - PHP Notice:  iconv(): Detected an illegal character in input string in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/system/PHPExcel/Classes/PHPExcel/Shared/String.php on line 386
2014-04-21 16:28:41 - PHP Notice:  iconv(): Detected an illegal character in input string in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/system/PHPExcel/Classes/PHPExcel/Shared/String.php on line 386
2014-04-21 16:28:41 - PHP Notice:  iconv(): Detected an illegal character in input string in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/system/PHPExcel/Classes/PHPExcel/Shared/String.php on line 386
2014-04-21 16:28:41 - PHP Notice:  iconv(): Detected an illegal character in input string in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/system/PHPExcel/Classes/PHPExcel/Shared/String.php on line 386
2014-04-21 16:28:41 - PHP Notice:  iconv(): Detected an illegal character in input string in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/system/PHPExcel/Classes/PHPExcel/Shared/String.php on line 386
2014-04-21 16:28:48 - Export/Import: Invalid number of worksheets, 8 worksheets expected
2014-04-21 16:35:50 - PHP Fatal Error:  Allowed memory size of 67108864 bytes exhausted (tried to allocate 212370713 bytes) in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/system/PHPExcel/Classes/PHPExcel/Reader/Excel2007.php on line 323
2014-04-21 17:26:31 - PHP Fatal Error:  Allowed memory size of 67108864 bytes exhausted (tried to allocate 212370713 bytes) in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/system/PHPExcel/Classes/PHPExcel/Reader/Excel2007.php on line 323
2014-04-21 17:47:20 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1570
2014-04-21 17:47:20 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1583
2014-04-21 17:47:20 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1609
2014-04-21 17:47:20 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1622
2014-04-21 17:47:20 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1635
2014-04-21 17:47:20 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1648
2014-04-21 17:47:20 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1661
2014-05-04 16:56:04 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1570
2014-05-04 16:56:04 - Export/Import: Invalid header in the Categories worksheet
2014-05-04 17:10:07 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1570
2014-05-04 17:10:07 - Export/Import: Invalid header in the Categories worksheet
2014-05-04 17:11:47 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1570
2014-05-04 17:11:47 - Export/Import: Invalid header in the Categories worksheet
2014-05-04 17:12:28 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1570
2014-05-04 17:12:28 - Export/Import: Invalid header in the Categories worksheet
2014-05-04 18:03:35 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1570
2014-05-04 18:03:35 - Export/Import: Invalid header in the Categories worksheet
2014-05-04 18:20:20 - PHP Fatal Error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 79 bytes) in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/Memory.php on line 55
2014-05-04 18:39:52 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1570
2014-05-04 18:39:52 - Export/Import: Invalid header in the Categories worksheet
2014-05-04 18:42:05 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1570
2014-05-04 18:42:05 - Export/Import: Invalid header in the Categories worksheet
2014-05-04 19:09:19 - PHP Unknown:  Only variables should be assigned by reference in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/shop/admin/model/tool/export.php on line 1570
2014-05-04 19:09:19 - Export/Import: Invalid header in the Categories worksheet

I can see "Invalid header in the Categories" and "an illegal character in input string" but how I work out exactly where to find these in the spreadsheet is not something I am seeing :(

I have not changed any headers on the Categories tab either, just downloaded it, added things to the products tab and then had the issues described above.

Unless it is the column Categories in the products tab? Checked that and the Categories header is "categories". Still stumped :(

User avatar
TAC
Active Member

Posts

Joined
Sun Sep 26, 2010 1:33 am
Location - England

Post by JNeuhoff » Mon May 05, 2014 8:42 pm

TAC: 2 things to do:

1) Increase your memory_limit PHP setting, 256M is simply not enough in your case, it clearly says so in the error messages

2) Fix your header line in the 'Categories' worksheet, just copy the header line from a freshly exported spreadsheet file.

MHC Web Design
Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * TrustPilot Reviews * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by TAC » Mon May 05, 2014 9:21 pm

Thanks again,

1) changed this from 64M to 1024M in both the php.ini files
2) Had already done that

Still get "Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!" in the admin. Logs show "Invalid header in the Categories" still

Spreadsheet is called backup_categories_products.ods

I exported another version and this is in the category header
Screen Shot 2014-05-05 at 14.20.02.png

Screen Shot 2014-05-05 at 14.20.02.png (27.16 KiB) Viewed 4594 times

This doesn't look right?

I changed it manually to status enabled and it still didn't work

User avatar
TAC
Active Member

Posts

Joined
Sun Sep 26, 2010 1:33 am
Location - England

Post by Cue4cheap » Tue May 06, 2014 10:37 am

TAC wrote:Thanks again,

1) changed this from 64M to 1024M in both the php.ini files
2) Had already done that

Still get "Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!" in the admin. Logs show "Invalid header in the Categories" still

Spreadsheet is called backup_categories_products.ods

I exported another version and this is in the category header
Screen Shot 2014-05-05 at 14.20.02.png
This doesn't look right?

I changed it manually to status enabled and it still didn't work
TAC,
Your headers do not look right but they do look like the problem I had before! It happens to me when I use openoffice.
If you see my post: http://forum.opencart.com/viewtopic.php ... at#p467493
you'll see that I had the same problem.
Using MS Excel fixed the duplicating headers BUT then I ran into another problem. MSExcel truncates the product description field so my product descriptions get cut off around 255 characters!
To test my theory, do a download, open it in openoffice and see if you have the duplicated headers.
Then if you do, open the same file (unsaved, unedited) with MSExcel and see if they are duplicated. I bet they are not.

IF they are not duplicated then we are the only two I know of who have ran across this issue but I don't have a fix EXCEPT to copy the headers as JNeuhoff indicated, make sure you get them all that are duplicated.

(Since I wrote my posting, that I linked above) I found it wasn't caused by anything except when I used openoffice, not something else as I guessed in that post....)
Mike

cue4cheap not cheap quality


Active Member

Posts

Joined
Fri Sep 20, 2013 4:45 am

Post by TAC » Tue May 06, 2014 3:41 pm

Thanks Mike but I have already tried every combination of OpenOffice and Excel I can think of.

Downloaded in both, edited both, tried to import both.
Downloaded in OO, copied products to Excel version, which appears to have correct headers, tried to import as Excel.
Downloaded in Ex, copied products in from the OO file, tried to import.
And so on, spent hours on it yesterday....

Can export to Excel and OO no problem, neither will import. Checked headers, copy & pasted correct ones onto wrong ones, manually edited wrong ones, still get the error :(

User avatar
TAC
Active Member

Posts

Joined
Sun Sep 26, 2010 1:33 am
Location - England

Post by apd » Tue May 06, 2014 7:00 pm

TAC,

I had same problem you mentioned in post http://forum.opencart.com/viewtopic.php ... 60#p494315

Was able to get around it by using LibreOffice to edit file and saves as type 'Microsoft Excel 97/2000/XP/2003 (.xls)'.

Andrew

apd
Newbie

Posts

Joined
Thu Apr 28, 2011 12:39 pm

Post by apd » Tue May 06, 2014 7:32 pm

Hi,

I've been using the Export/Import tool fine for a while but I've now noticed some odd behaviour with product options.

I have one option that gets duplicated after running an import. The option has 6 possible values. Some products have 4 of those values, a, c, c and d. Others have 2 of those values, e and f.

For some reason, the option gets created twice in the database, once with all 6 options and another with just two of the values.

Has anyone seen this before?

Thanks,

Andrew

apd
Newbie

Posts

Joined
Thu Apr 28, 2011 12:39 pm
Who is online

Users browsing this forum: No registered users and 6 guests