[RELEASED] Export/Import tool for OpenCart 1.5.3.x

JNeuhoff wrote:In the uploadProducts, put the 2 lines

Code: Select all

			$cptitle = $this->getCell($data,$i,$j++);
			$cptitle = htmlentities( $cptitle, ENT_QUOTES, $this->detect_encoding($cptitle) );

immediately after the line

Code: Select all

			$name = $this->getCell($data,$i,$j++);
			$name = htmlentities( $name, ENT_QUOTES, $this->detect_encoding($name) );

The same is true for the uploadCategories.

djura wrote: Where is the file in which to make changes?

jipsa78 wrote:Hi,

First of all: great job on this extension!

I am now trying to get it to work with the Custom Page Titles extension (url: http://www.opencart.com/index.php?route ... on_id=7867), which I want to use for SEO purposes.
The Custom Page Titles extension adds these new fields to the database:

ALTER TABLE art1_category_description ADD column cptitle VARCHAR(255) NOT NULL;
ALTER TABLE art1_information_description ADD column cptitle VARCHAR(255) NOT NULL;
ALTER TABLE art1_product_description ADD column cptitle VARCHAR(255) NOT NULL;

It also contains a vQmod file that adds the custom page title fields to admin.

Because the export/import tool doesn't know these new database fields, any custom page title I make is deleted on import of an xls file. To solve this I've tried to add the new fields to your admin/model/tool/export.php file.
As a result I am now able to export the xls file with the new fields and correct content.
However when I import the xls file again it empties the database and doesn't populate it with new data.

I have tried hard to find the cause of this, but with my limited php knowledge I haven't succeeded.
Could you take a look at the attached php file?
You can find my entries with a search for 'cptitle'.
Would be very much appreciated :-)

I am running OpenCart 1.5.3.1 with opencart-1-5-2-x-export-import-10
Works fine without the custom page titles alteration.

My OpenCart error log shows no errors.

crispylettuce wrote:

jipsa78 wrote:Hi,

First of all: great job on this extension!

I am now trying to get it to work with the Custom Page Titles extension (url: http://www.opencart.com/index.php?route ... on_id=7867), which I want to use for SEO purposes.
The Custom Page Titles extension adds these new fields to the database:

ALTER TABLE art1_category_description ADD column cptitle VARCHAR(255) NOT NULL;
ALTER TABLE art1_information_description ADD column cptitle VARCHAR(255) NOT NULL;
ALTER TABLE art1_product_description ADD column cptitle VARCHAR(255) NOT NULL;

It also contains a vQmod file that adds the custom page title fields to admin.

Because the export/import tool doesn't know these new database fields, any custom page title I make is deleted on import of an xls file. To solve this I've tried to add the new fields to your admin/model/tool/export.php file.
As a result I am now able to export the xls file with the new fields and correct content.
However when I import the xls file again it empties the database and doesn't populate it with new data.

I have tried hard to find the cause of this, but with my limited php knowledge I haven't succeeded.
Could you take a look at the attached php file?
You can find my entries with a search for 'cptitle'.
Would be very much appreciated :-)

I am running OpenCart 1.5.3.1 with opencart-1-5-2-x-export-import-10
Works fine without the custom page titles alteration.

My OpenCart error log shows no errors.

I assume you have this working well, could you possibly upload an example of the modified php, so i can check i have done it correct?

djura wrote:I have a serious problem.

For a long time trying to import items such category and I export a few months ago.

I'll write what I did, so correct me if I'm wrong somewhere.

-I installed OpenCart v1.5.2.1
-I installed the extension "OpenCart-1-5-2-x-export-import-11.zip v1.5.2, v1.5.2.1" exactly according to the instructions in the README file
-exported items and categories
-I got the file "backup_categories_products" in which I copied the data from the old file (what code I export a few months ago)
I have carefully copied the column by column and save in the same file.
-Import the file and got a message that the import completed successfully

I was hoping that after I finished work on the site I got all the categories and items from the imported file in the admin panel, but nothing has changed, everything else is the same as before the import.


website screenshot
http://www.webpagescreenshot.info/img/1 ... 01233750PM

screenshot of the admin panel
page 1
http://www.webpagescreenshot.info/img/9 ... 01233955PM
Page 2
http://www.webpagescreenshot.info/img/2 ... 01234044PM

screenshot Error Log
http://www.webpagescreenshot.info/img/1 ... 01234133PM

chadhp wrote:HI,
I installed the plugin for 1.5.3.1 and it worked perfect, I later upgraded to 1.5.4 and it disappeared from system menu so I installed the 1.5.4 plugin however it was still not in system menu but was ticked in admin user group. I then restored a backup of my site and it was still not in the system menu.

Can you please let me know if you know what could be wrong?

Thank you

remixer wrote:Do you have a blank template that we can use to start. im not sure of the format needed to upload

JNeuhoff wrote:

chadhp wrote:HI,
I installed the plugin for 1.5.3.1 and it worked perfect, I later upgraded to 1.5.4 and it disappeared from system menu so I installed the 1.5.4 plugin however it was still not in system menu but was ticked in admin user group. I then restored a backup of my site and it was still not in the system menu.

Can you please let me know if you know what could be wrong?

Thank you

You also need to install VQmod.

another question.. if im importing products who assigns product ids?