[SOLVED] Export/Import tool for 1.4.9.2 data missing

Quote

Post by TAC » 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

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


and this is the error I get
Screen Shot 2014-02-18 at 20.48.28.png

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

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

Thank you :)
Last edited by TAC on Sun Apr 20, 2014 4:31 am, edited 1 time in total.
User avatar
TAC
Active Member
Posts
816
Joined
Sun Sep 26, 2010 1:33 am
Location - England
Top

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

Quote

Post by butte » 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.
butte
Guru Member
Posts
7059
Joined
Wed Mar 20, 2013 6:58 am
Top

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

Quote

Post by TAC » 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.
User avatar
TAC
Active Member
Posts
816
Joined
Sun Sep 26, 2010 1:33 am
Location - England
Top

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

Quote

Post by butte » 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.]
butte
Guru Member
Posts
7059
Joined
Wed Mar 20, 2013 6:58 am
Top

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

Quote

Post by TAC » 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 :)
User avatar
TAC
Active Member
Posts
816
Joined
Sun Sep 26, 2010 1:33 am
Location - England
Top

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

Quote

Post by JNeuhoff » 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

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
7463
Joined
Wed Dec 05, 2007 3:38 am
Top

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

Quote

Post by butte » 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.
butte
Guru Member
Posts
7059
Joined
Wed Mar 20, 2013 6:58 am
Top

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

Quote

Post by TAC » 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 :choke:

@butte 1.5.6.2 is obviously a complete figment of my imagination :wolf:
User avatar
TAC
Active Member
Posts
816
Joined
Sun Sep 26, 2010 1:33 am
Location - England
Top

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

Quote

Post by TAC » 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 :D
User avatar
TAC
Active Member
Posts
816
Joined
Sun Sep 26, 2010 1:33 am
Location - England
Top
Post Reply
Return to “Modules”
Who is online

Users browsing this forum: No registered users and 6 guests