OpenCart Community

Posted: **Wed Feb 19, 2014 4:51 am**

Hi,

I've done some searching in the forums and couldn't work out where to ask this question for the best. I have a store in 1.4.9.2 and I am building its replacement in 1.5.6.2.

I realise that I cannot export from the old version to the new version. So I thought I could export the products from the old store and then take the parts I need and manually add them to a new export/import spreadsheet for the new store.

This may not be the best way to do it but, whether it is or not, I have run into a problem. The spreadsheet I export from the 1.4.9.2 store loses any text data and only shows numbers.

Screen Shot 2014-02-18 at 20.15.17.png (69.42 KiB) Viewed 2383 times

and this is the error I get

Screen Shot 2014-02-18 at 20.48.28.png (37.7 KiB) Viewed 2383 times

Is this anything to do with the fact I am using Office for Mac or is the file corrupting?

Thank you

Posted: **Wed Feb 19, 2014 9:20 am**

Put in a few dummy products in the new one. Export that. Open it. Transplant into that what you want -- if need be make new columns, but when you copy/paste EXCLUDE the format (just paste the content). Save it. Import it. Then you'll be using the "real" spreadsheet file. You may have a problem with spreadsheet CELL formats.

In a quick Search, the sole references forum-wide to 1.5.6.2 seem to be your own OP above and the last line in your own http://forum.opencart.com/viewtopic.php ... 26#p475437 ten days ago.

Posted: **Fri Feb 21, 2014 4:50 am**

Thanks butte,

My intention is to do as you say with a new spreadsheet from the 1.5.6.2 version of the shop. But I still don't know how to get the file from the 1.4.9.2 shop to export correctly.

I was looking for a thread called something like '[RELEASED] Export/Import tool for OpenCart 1.4.9' but all I could find were 1.5 related threads and a 1.4.8 one.

Posted: **Fri Feb 21, 2014 10:24 am**

Doesn't he have all versions available in at once, in the store and in his website)?

You just posted the fourth instance of 1.5.6.2 . . . where did that come from?

[Okay, upon Submit we have a new one, "Your message contains too few characters." Uh, huh. Retrying.]

Posted: **Sat Feb 22, 2014 11:45 am**

Yes he does but on his Mod page it says to ask support questions in the forum. But I couldn't work out which was the best place to put it when I couldn't find a thread specific to 1.4.9

Perhaps I should tag my question onto the end of his most recent thread

Posted: **Sun Feb 23, 2014 5:51 am**

Try OpenOffice, or LibreOffice. Don't understand why people still use MS Excel.

Also, check your server's error_log AND OpenCart's system/logs/error.txt

Posted: **Sun Feb 23, 2014 1:39 pm**

TAC, where is the 1.5.6 point-TWO coming from?

If you're using excel (which doesn't), then you'll need to be using a compatible version, and apparently "2007" does the trick consistently.

You can find the server error log(s) either in your control panel or in directories where scripts actually fire. Those will read differently than error.txt (relating to OC alone) does.

Posted: **Wed Apr 09, 2014 1:37 am**

Just come back to this issue so thank you for your responses.

It seems you are saying the version of Excel I am trying to use is not compatible with the 1.4.9.2 version of OC & the mod?

I have looked at the error.txt and it is choc full of stuff. From 2014 there are hundreds & hundreds of these:

Code: Select all

2014-01-03 11:14:00 - PHP Notice:  Undefined index: reqd in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/catalog/view/theme/PE/template/product/product.tpl on line 79

One of these:

Code: Select all

2014-01-03 18:43:57 - PHP Notice:  Undefined variable: text_image_manager in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/admin/view/template/module/mymodule.tpl on line 116

Quite a few of these:

Code: Select all

2014-01-05 5:20:02 - PHP Warning:  file_get_contents(/var/www/vhosts/personalisedemporium.co.uk/httpdocs/system/cache/cache.category.69.1.0.1388902802): failed to open stream: No such file or directory in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/system/library/cache.php on line 25

A few of these:

Code: Select all

2014-01-07 4:08:25 - PHP Notice:  Undefined variable: text_error in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/catalog/view/theme/default/template/product/category.tpl on line 22

Quite a few of these:

Code: Select all

2014-02-22 5:08:43 - PHP Warning:  unlink(/var/www/vhosts/personalisedemporium.co.uk/httpdocs/system/cache/cache.category.48.1.0.1393049323): No such file or directory in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/system/library/cache.php on line 48

Some of these:

Code: Select all

2014-03-25 18:26:44 - PHP Notice:  Undefined variable: text_image_manager in /var/www/vhosts/personalisedemporium.co.uk/httpdocs/admin/view/template/module/mymodule.tpl on line 116

Quite a lot of these:

Code: Select all

2014-03-26 17:38:15 - 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

All of which mean nothing to me

@ JNeuhoff if I gave you access would you be able to download the export file & send it to me at all? It's not the format that bothers me, just that I get the product data so I don't have to enter it all again for the new version of the shop

@butte 1.5.6.2 is obviously a complete figment of my imagination

Posted: **Sun Apr 20, 2014 4:33 am**

In the end I installed OpenOffice temporarily and got the data back that way.

Thanks for the help

OpenCart Community

[SOLVED] Export/Import tool for 1.4.9.2 data missing

[SOLVED] Export/Import tool for 1.4.9.2 data missing

Re: Export/Import tool for 1.4.9.2 has lots of data missing

Re: Export/Import tool for 1.4.9.2 has lots of data missing

Re: Export/Import tool for 1.4.9.2 has lots of data missing

Re: Export/Import tool for 1.4.9.2 has lots of data missing

Re: Export/Import tool for 1.4.9.2 has lots of data missing

Re: Export/Import tool for 1.4.9.2 has lots of data missing

Re: Export/Import tool for 1.4.9.2 has lots of data missing

Re: [SOLVED] Export/Import tool for 1.4.9.2 data missing