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

Quote

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
817
Joined
Sun Sep 26, 2010 1:33 am
Location - England
Top

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

Quote

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.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig

User avatar
JNeuhoff
Guru Member
Online
Posts
6748
Joined
Wed Dec 05, 2007 3:38 am
Top

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

Quote

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
817
Joined
Sun Sep 26, 2010 1:33 am
Location - England
Top

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

Quote

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.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig

User avatar
JNeuhoff
Guru Member
Online
Posts
6748
Joined
Wed Dec 05, 2007 3:38 am
Top

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

Quote

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 5804 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
817
Joined
Sun Sep 26, 2010 1:33 am
Location - England
Top

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

Quote

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

Cue4cheap
Expert Member
Posts
2028
Joined
Fri Sep 20, 2013 4:45 am
Top

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

Quote

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
817
Joined
Sun Sep 26, 2010 1:33 am
Location - England
Top

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

Quote

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
3
Joined
Thu Apr 28, 2011 12:39 pm
Top

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

Quote

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
3
Joined
Thu Apr 28, 2011 12:39 pm
Top

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

Quote

Post by munaim1 » Wed May 07, 2014 8:00 am

Hi,

This extension is working perfectly on our store, an absolute god send :) Just one question, do you know if the import export tool will work with this extension: http://www.opencart.com/index.php?route ... rch=remote

Thanks for your time.
munaim1
Active Member
Posts
111
Joined
Tue Dec 10, 2013 2:05 am
Top

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

Quote

Post by JNeuhoff » Wed May 07, 2014 5:44 pm

munaim1 wrote:Just one question, do you know if the import export tool will work with this extension:
Depends on whether there are underlying changes (e.g. new fields) done to the database.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig

User avatar
JNeuhoff
Guru Member
Online
Posts
6748
Joined
Wed Dec 05, 2007 3:38 am
Top

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

Quote

Post by TAC » Wed May 07, 2014 10:23 pm

@Mike I also emptied my vqmod cache and still get the double header titles.

I read the stuff about messing with the db but I don't want to start doing with that. I need a mod without such complications :)
User avatar
TAC
Active Member
Posts
817
Joined
Sun Sep 26, 2010 1:33 am
Location - England
Top

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

Quote

Post by rawmeattt » Thu May 08, 2014 12:33 am

Guys - do your importing and exporting - directly from your phpmyadmin - just did a 34,000 sku upload not one error.

For get using extra memory setting - upto a 1gb ??? c'mon - really !


Use cvs files looking into phpmyadmin download the sample info that is there when you do a fresh install and you will get to see how the headers are set up and how the info needs to be entered.

The excel files are overloading the system and are just full of bugs. The database uses CSV why use excel files.
rawmeattt
Newbie
Posts
13
Joined
Mon Apr 28, 2014 5:21 am
Top

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

Quote

Post by munaim1 » Thu May 08, 2014 3:10 am

JNeuhoff wrote:
munaim1 wrote:Just one question, do you know if the import export tool will work with this extension:
Depends on whether there are underlying changes (e.g. new fields) done to the database.
Image

Well looking at the screenshot of the extension it does create a URL field, not sure if your import export tool will capture that in the xl file. ???
munaim1
Active Member
Posts
111
Joined
Tue Dec 10, 2013 2:05 am
Top

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

Quote

Post by TAC » Thu May 08, 2014 4:06 am

@rawmeattt I thought that sounded like a good idea so I downloaded my db as a csv file but found the layout probably too confusing to replicate for new products :(

Others may not find it complicated of course :)
User avatar
TAC
Active Member
Posts
817
Joined
Sun Sep 26, 2010 1:33 am
Location - England
Top

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

Quote

Post by rawmeattt » Thu May 08, 2014 6:08 am

hi, the product section in the db is 13 files - not all are used. so if you download everything for the products then you will end-up with these 13 files on just one file. In that file you will end-up with 13 sections in length divided by headers.

So you make a master file (with all the headers in just one line) of this in excel as a csv file and then you place all your info there. You can then use your downloaded file just for a reference. Then you cut and paste the columns and save as files for each section.Then you upload 13 separate files, it takes just split seconds or less.

If there is an error and it tells you straight, error in line 50 or error in headers because you may have one extra or missing column. You don't have to email anyone because its easy.

Same thing for manufacturers and categories. I understand that it looks intimidating and it did to me at first as well.

You have to look at the phpmyadmin as the ultimate extension - then you will see its very basic and simplistic- you can erase and update fix things at will . Don't be scared to make a mess of it -you can just reload the startup database and start from something fresh.

trying to to upload everything - products,categories,manufacturers(not there), additional images, options, attributes,specials and discounts and reward -All in one file and then wonder what is wrong with the upload .NOT GOOD

Back to this import export thing - ever since my first battles with these very bad import/export tools I start using the database directly - its actually inexcusable and I am being polite. Anyone defending these extensions is laughing at all us users, anyone that keeps telling us to increase php memory to a 1gb is laughing at us. Trying to learn to deal with each extension free or purchased and all those bugs is an insult to the cart industry. I have never used excel files to upload to a database. I am not a coder, I am a user and I think these coders should go out and use the import and export features from other cart and copy the logic -yes copy the logic. I will again mention Pinnacle cart because there are no issues on their boards about importing or exporting - because it works and is a non issue. If they did not go to the pay by month type of sale, I would have kept buying more licenses.As for Opencart this cart is great in itself and almost all extensions I purchased I am totally pleased with but not the import export extensions - these functions should be part of the basic cart and not offered as an extension. Not doing this will turn off users and cost more in lost extension sales in the future.

ah now I feel better...
rawmeattt
Newbie
Posts
13
Joined
Mon Apr 28, 2014 5:21 am
Top

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

Quote

Post by Malaiac » Sun May 11, 2014 10:57 pm

@JNeuhoff : a way of bypassing upload limits on shared hosts would be to allow direct upload (via FTP) and to allow the extension to work from a local file. Memory limits would still be annoying.
Malaiac
New member
Posts
45
Joined
Thu Jan 07, 2010 12:06 am
Top

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

Quote

Post by jeepstone » Fri May 16, 2014 5:15 pm

I've just tried to do a Product Filter import and my filter items have appeared as attributes. Does the filter import work?

They appear correctly when I export the spreadsheet, but if I update them and try to reimport, they appear as attributes. Is this a bug?

Pete Jones
http://www.petersencreative.com

User avatar
jeepstone
Newbie
Posts
11
Joined
Tue May 21, 2013 12:18 am
Location - Cheltenham, United Kingdom
Top

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

Quote

Post by JNeuhoff » Fri May 16, 2014 9:49 pm

jeepstone wrote:I've just tried to do a Product Filter import and my filter items have appeared as attributes. Does the filter import work?

They appear correctly when I export the spreadsheet, but if I update them and try to reimport, they appear as attributes. Is this a bug?
Our free Export/Import does not support product filters, so you wouldn't even be able to import them, nor export them.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig

User avatar
JNeuhoff
Guru Member
Online
Posts
6748
Joined
Wed Dec 05, 2007 3:38 am
Top

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

Quote

Post by jeepstone » Fri May 16, 2014 9:54 pm

Does that mean that there's a paid for version that does? The filters definitely export.

Pete Jones
http://www.petersencreative.com

User avatar
jeepstone
Newbie
Posts
11
Joined
Tue May 21, 2013 12:18 am
Location - Cheltenham, United Kingdom
Top
Post Reply
Return to “Extensions”
Who is online

Users browsing this forum: No registered users and 68 guests