Post by TAC » Fri Dec 17, 2010 2:42 am

Hi again,
I worked out how to move the code from one file to the other in WinMerge and now it seems both GMO and Export/Import are working.
Thank you very much! :laugh:

User avatar
TAC
Active Member

Posts

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

User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by Mitch » Thu Dec 30, 2010 7:09 am

I love this tool. It saves me countless hours... Things have been working fine until just now.. am getting this error

Code: Select all

Error: FUNCTION fcamera_cart.Saturation does not exist
Error No: 1305
INSERT INTO `shop99_product_to_category` (`product_id`,`category_id`) VALUES (2689,Saturation(colordepth));
Let me know. I thought it was because I had one my cell's highlighted, so I fixed that saved and tried again.. same error.

Newbie

Posts

Joined
Wed Dec 29, 2010 4:43 am

Post by JNeuhoff » Thu Dec 30, 2010 7:50 am

You should only use integer values for the category_id, not something
like 'Saturation(colordepth)', in your spreadsheet!

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


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by mudstar » Tue Jan 11, 2011 3:51 pm

Hello

I'm using the import export tool for opencart 1.48 and its working fine but found a different issue not an error

My store is related to car parts and by the way is in Spanish and have lot of items

Today I tried to import the XML sheet with 7483 items in 397 categories the file size is 8608 kb

When proceed to load the file it did not give me any errors but neither said Successful it just blinked and nothing happened

When ahead to check but the new items are not showing only items showing are the ones already loaded before this upload.

My question is is there a limit for items or is there a way to change settings to be able to load many many items as 20.000








I know is not the import export Tool but maybe someone have an idea

Please let me know

In advance thanks for any help

Regards

Mauricio
Last edited by mudstar on Mon Jan 17, 2011 5:10 pm, edited 1 time in total.

Newbie

Posts

Joined
Mon Oct 04, 2010 3:21 am

Post by TAC » Wed Jan 12, 2011 10:53 am

Hi, I have recently moved my store from a sub-domain to the domain. I've had some issues so in the end I did a fresh download and install of OC but I seem to be getting there. Before I go any further I thought I must do an export of my products etc.

So I used the export/import tool but I cannot get a spreadsheet that is not corrupted. I've tried a few times but each time it says some data is lost and it turns out most of it is lost and only some random numbers are in there. Thinking about it it's as if all the text is gone and only numbers remain ???

Any ideas what I might have done wrong? I also have GMO installed and I have had to merge the header files. I am using the latest version of OC v14.9.2.

Thanks in advance :)

User avatar
TAC
Active Member

Posts

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

Post by TAC » Sat Jan 15, 2011 3:16 am

Hi again,

I have just downloaded the latest Export/Import mod version and uploaded it to my site. I have had to alter the code a little to make GMO work as well. I haven't removed any E/I code.

But I am still having the same problem as before i.e. getting a corrupted spreadsheet. I'm ready to add lots of products to my new site and I want to back them up so am keen to find out what the problem might be.

Thanks :)

User avatar
TAC
Active Member

Posts

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

Post by JNeuhoff » Sat Jan 15, 2011 7:02 am

Send me a PM with your Opencart and FTP login details, and I can a look at it. I am unable to reproduce the error on my own test server.

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


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by TAC » Sun Jan 16, 2011 12:37 am

I've sent a PM - says it's sent but not showing in 'sent' box so let me know if you don't get it.
Thanks :)

User avatar
TAC
Active Member

Posts

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

Post by mudstar » Mon Jan 17, 2011 5:14 pm

Hello

I had edited the php.ini
Tried to upload the .xml file but still no success

Finally went to goddady.com to read and read and keep reading until found this

NOTE: The location of your php.ini file can vary, depending on your operating system/control panel combination. If you are using Fedora 4 with Parallels Plesk Panel, for example, this file is in the following location: /etc/php.ini

If you are using a different operating system and/or control panel, you can find the location of your php.ini file by running the following from your command line:
php -i | grep php.ini
There are two variables within your php.ini file that are responsible for managing user file uploads.
• post_max_size This variable determines the maximum amount of data that PHP will accept in a single form submission using the POST method. Its default value is 8 MB, as shown below:
post_max_size = 8M
• upload_max_filesize This variable limits the size of an individual file uploaded to your site. Its default value is 2 MB, as shown below:
upload_max_filesize = 2M
An increase in the value of these variables expands user file upload limits.
NOTE: After making changes to php.ini, you must perform an httpd restart for them to take effect. This is accomplished by running the following from your command line:
/etc/init.d/httpd restart


I just sent them a email and wating for them to do the restar

I will let you guys now if this fixes my issue

Newbie

Posts

Joined
Mon Oct 04, 2010 3:21 am

Post by TAC » Wed Jan 26, 2011 6:47 pm

Still desperate for help..... :(

User avatar
TAC
Active Member

Posts

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

Post by JNeuhoff » Thu Jan 27, 2011 3:50 am

TAC wrote:Hi again,

I have just downloaded the latest Export/Import mod version and uploaded it to my site. I have had to alter the code a little to make GMO work as well. I haven't removed any E/I code.

But I am still having the same problem as before i.e. getting a corrupted spreadsheet. I'm ready to add lots of products to my new site and I want to back them up so am keen to find out what the problem might be.

Thanks :)
Sorry for the delay. was quite busy. Just tested the Export on your server, and the downloaded spreadsheet opens up just fine. So I am unable to reproduce your error.

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


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by JNeuhoff » Thu Jan 27, 2011 3:59 am

mudstar wrote:Hello

I had edited the php.ini
Tried to upload the .xml file but still no success

Finally went to goddady.com to read and read and keep reading until found this
Assuming yours is a commonly shared web host, with a Plesk or cPanel, you should create and/or edit the admin/php.ini found in your OpenCart's root directory.

If you are using a personal stand-alone Fedora Core Linux server, then chances are that Apache runs the PHP scripts under its own account, e.g. 'apache' or 'nobody', and the php.ini is then located at etc/php.ini.

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


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by TAC » Sun Jan 30, 2011 4:55 am

Hi,
Thanks for the reply. Are you able to email me the spreadsheet? At least then I'll have a backup copy before I start tinkering with the store to see if I can get it to work on mine....

Thanks again :)

User avatar
TAC
Active Member

Posts

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

Post by Tobievr » Tue Feb 08, 2011 4:35 am

Hi
I have found your export/import extremely helpful, but I have run into something very strange and I cant figure it out all, so I urgently need your help please.

I first uploaded my pictures via FTP onto the server into a specific folder.

I then imported 3 pics from within the shop, as to help setup the excel spreadsheet and its format.

I exported the spreadsheet. Added the data exactly the same as the lines of a specific category (if that makes sense) with the names of the photos uploaded onto the ftp server.

I then imported the spreadsheet back into the shop. Looked in the product section, the photos are there, but once viewed on the website, it doesn't show up with the original 3 photos I uploaded manually.

Please could you help me, as this is almost the last part of the development and now I am stuck.

Thanks again

Tobie

Newbie

Posts

Joined
Wed Oct 27, 2010 4:40 am

Post by Tobievr » Tue Feb 08, 2011 4:55 am

Hey guys

Sorry, after carefully studying the spreadsheet, I noticed that the store was not selected. Once again, really thanks for a great product that has saved my backside on this one.

Newbie

Posts

Joined
Wed Oct 27, 2010 4:40 am

Post by merchboer » Tue Feb 08, 2011 6:13 pm

AWEsome plugin, I'm really thankful for creating it!

There's one function I'd really like, and I'll send you a PM about it as well (I'm willing to pay for it of course); in the options tab it would be very helpful for me if I can put multiple product id's for the same option, as I'm planning to use this on a branded promotional clothing store, where many products are available in the same sizes, and even the same colors.

If you need more clarification I'm of course happy to send an example XLS by e-mail/attach it here.

Thanks in advance for getting back to me!

I likez teh beerz & foodz.


User avatar
Active Member

Posts

Joined
Fri Jan 14, 2011 4:27 pm
Location - Netherlands

Post by kjp » Fri Feb 25, 2011 3:08 am

Hello all,

I just installed the Export/Import tool and followed the instructions in the "read me" txt file, but, while the menu item for Export/Import now exists in the admin, my only options on that page are backup & restore where an .sql file seems to be my only option for download. Is there something wrong with my config? I am on 1.4.9.

Please help. Thanks.

kjp
Newbie

Posts

Joined
Fri Feb 25, 2011 3:02 am

Post by Tobievr » Fri Feb 25, 2011 3:15 am

As far as I can tell, you didn't follow the exact steps, but maybe this will help.

I the admin panel go to SYSTEM > USER GROUPS
In Top Administrator click on EDIT
I selected All and then SAVE
Now you should be able to see the IMPORT/EXPORT Function in the SYSTEM Drop down menu.

I hope this helps.

Newbie

Posts

Joined
Wed Oct 27, 2010 4:40 am

Post by kjp » Fri Feb 25, 2011 5:38 am

Thanks for the quick response -

the IMPORT/EXPORT Function is already displaying in the SYSTEM Drop down menu. The problem seems to be that when I click on this function it takes me to a page that does not contain any import or export buttons. The page looks exactly like the back-up restore page, and the "back-up" button only offers the .sql download. So, I am guessing maybe something is weird with my config, but everything looks to be in place so I'm not sure what's missing.

Thanks for your help.

kjp
Newbie

Posts

Joined
Fri Feb 25, 2011 3:02 am
Who is online

Users browsing this forum: No registered users and 3 guests