Updated Bulk Export/Import module

[jty]

Hello
Just wondering, is there an "append" version of this module?
Cuz - I'm adding fields and it looks like everytime I import, it cleans out the database and re-inserts the whole spreadsheet
But I don't know how to mod this module to include my new fields so I'm losing my tailor-made data fields

I'm probably asking for too much again 

[Qphoria]

That is what it does. You must first do an export of the existing table, then append to that, and then import the whole thing back.

[jty]

Where? I can't see it.
I added a short description field to the product_description table
I cannot use the Export/Import module for this short description field cos the export/import eats it up
Pre-specified fields are fine but if we add our own fields to the table, it eats it up

[Qphoria]

Oh I see what you are saying. You want it to only delete the fields that it touches. instead of deleting all fields..
Hmm....

I guess if all the deletes were removed, and all the inserts were replaced with

UPDATE SET = REPLACE(, 'old', 'new')

since update replace will either update if exists or insert if not exists.
Not sure if thats the best approach.

Or maybe it should be dynamic and export & imports all tables it finds

Last edited by Qphoria on Fri Oct 17, 2008 6:10 pm, edited 1 time in total.

Qphoria

Administrator

 

Posts: 18212

Joined: Mon Jul 21, 2008 7:02 pm

Top

---

Re: Updated Bulk Export/Import module

by jty » Fri Oct 17, 2008 6:32 pm

Yeah, something like that.
The Franscais Carte appends new rows without touching the current ones but that's about all that's great about it.
I'm thinking about people with 10,000+ products and additional modded fields
If they had other fields not in the import, they would have a nightmare inputting all 10,000+ products x 5 options and import them at once and then go hunting for the data corruption.
If, on the other hand, the import didn't touch the existing rows, they could do them by eg categories. Check it, if it's OK, do the next category.
In my situation, I got lost with the options and matching it to the product ID 

jty

 

Posts: 1163

Joined: Sat Aug 30, 2008 12:19 am

Top

---

Re: Updated Bulk Export/Import module

by bruce » Sat Oct 18, 2008 10:22 am

Update would then not delete any products that you wanted to remove via the spreadsheet.

The product_id is maintained by import/export so perhaps a better way of implementing additional fields would be in a separate table from the core design. You still have to change the sql statements for getting product information into your store to join to the new table but since you are already changing the templates, it is not too much extra effort.

This way, the core import/export works out of the box for everyone and your custom fields are not trashed when you import and the links are preserved.

The only downside (every silver lining has a cloud  ) is that you cannot load the short description using import/export.

bruce

 

Posts: 1094

Joined: Wed Dec 12, 2007 6:26 am

Top

---

Re: Updated Bulk Export/Import module

by jty » Sat Oct 18, 2008 10:52 am

Thanks Bruce. That's a good idea, to stick it in a different table. I didn't think of that.

jty

 

Posts: 1163

Joined: Sat Aug 30, 2008 12:19 am

Top

---

Re: Updated Bulk Export/Import module

by Qphoria » Sat Oct 18, 2008 12:22 pm

every silver lining has a cloud 

LOL I'm pretty sure that's not how the saying goes....

Qphoria

Administrator

 

Posts: 18212

Joined: Mon Jul 21, 2008 7:02 pm

Top

---

Re: Updated Bulk Export/Import module

by red8ii8 » Fri Nov 07, 2008 6:54 pm

My cart and admin were fresh installs and working fine, and as soon as I installed the mod I get a 500 error and can't get back in to admin at all. Any pointers in where to look for trouble? I tried installing the patch referenced earlier but nothing happened. I reeeally need this mod to get all my inventory moved over. Thanks!

red8ii8

 

Posts: 7

Joined: Fri Nov 07, 2008 6:50 pm

Top

---

Re: Updated Bulk Export/Import module

by bruce » Fri Nov 07, 2008 10:52 pm

Try renaming the .htaccess file in your admin folder to (say) htaccess.txt

bruce

 

Posts: 1094

Joined: Wed Dec 12, 2007 6:26 am

Top

---

Re: Updated Bulk Export/Import module

by Tomas_cze » Fri Nov 14, 2008 5:02 pm

Hi, I have problem
If I click on "Export" and download xml file so in file is

Code: Select all

<b>Warning</b>:  tempnam() [<a href='function.tempnam'>function.tempnam</a>]: open_basedir restriction in effect. File() is not within the allowed path(s): (/data/www/www_exit-site_com) in <b>/data/www/www_exit-site_com/shop/admin/OLE/PPS/File.php</b> on line <b>87</b><br />

Please help ... thx

Tomas_cze

 

Posts: 10

Joined: Sun Jan 13, 2008 1:55 am

Top

---

Re: Updated Bulk Export/Import module

by JNeuhoff » Fri Nov 14, 2008 5:52 pm

This appears to be an issue of directory/file access rights of some sort. Who is your webhosting provider? Are your PHP scripts running under your user account, or under a shared Apache account? Is the PHP PEAR library installed on your host?

JNeuhoff

 

Posts: 2115

Joined: Tue Dec 04, 2007 7:38 pm

• Website

Top

---

Re: Updated Bulk Export/Import module

by Tomas_cze » Fri Nov 14, 2008 6:16 pm

My webhosting provider is hosting.blueboard.cz (Czech) - PHP 5.2.6, Apache 2.0 Handler ... I don´t know if I have installed PEAR but I think yes ... Must I create same directory or edit same files?

Tomas_cze

 

Posts: 10

Joined: Sun Jan 13, 2008 1:55 am

Top

---

Re: Updated Bulk Export/Import module

by yl » Tue Dec 23, 2008 4:09 am

After I uploaded it to 0.7.7 and got a 500 internal service error
"  Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8i DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at my store Port 80  "

What's wrong with it and where I suppose to investigate finding the error and fixing it? or is it linking to web hosting?

Appreciated much your help!

yl

 

Posts: 90

Joined: Mon Nov 24, 2008 10:46 pm

Top

---

Re: Updated Bulk Export/Import module

by yl » Tue Dec 23, 2008 5:34 am

After I removed the file .htaccess I got the admin login back. Problem solved!!

yl

 

Posts: 90

Joined: Mon Nov 24, 2008 10:46 pm

Top

---

Re: Updated Bulk Export/Import module

by yl » Tue Dec 23, 2008 6:13 am

Updated!!

This is a great contribution. Data exported to Excel look great. I can see what product is running out of stock. One problem here is the USD $ changed to £. I checked on admin>setting and found nothing wrong, is still USD. What causes this happened??? Appreciated for any help on fixing it!!

yl

 

Posts: 90

Joined: Mon Nov 24, 2008 10:46 pm

Top

---

Re: Updated Bulk Export/Import module

by yl » Tue Dec 23, 2008 6:28 am

Never mind please, I went back and looked thru admin setting nothing wrong. then I saw it on the home page changed to pound sterling. Don't know how it happened??

yl

 

Posts: 90

Joined: Mon Nov 24, 2008 10:46 pm

Top

---

Re: Updated Bulk Export/Import module

by JNeuhoff » Tue Dec 23, 2008 1:50 pm

You can set the default currency in OpenCart's admin panel, at

Admin > Configuration > Setting > Local > Currency

If you have other currencies enabled, then it is still possible for the user to choose one and it should stay that way in the user session.

JNeuhoff

 

Posts: 2115

Joined: Tue Dec 04, 2007 7:38 pm

• Website

Top

---

Re: Updated Bulk Export/Import module

by Qphoria » Tue Dec 23, 2008 4:54 pm

Never mind please, I went back and looked thru admin setting nothing wrong. then I saw it on the home page changed to pound sterling. Don't know how it happened??

Since the default install uses Pounds, it is likely that even tho you changed it in the backend, the frontend still had the original language cookie session. So you'd need to clear that cookie to make it use the new default language, or just change it in the selector to use USD

Qphoria

Administrator

 

Posts: 18212

Joined: Mon Jul 21, 2008 7:02 pm

Top

---

Previous Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending

---

Topic locked

59 posts • Page 3 of 3 • 1, 2, 3

Return to Contributions

Jump to: Select a forum ------------------ General    News & Announcements       Hot Patches    General Discussion    FAQ & Tutorials       Troubleshooting       Install & Upgrades          Install/Upgrade FAQ       General       Configuration       Payment       Themes       Language & Currency       Shipping       Order Total Support    General Support    Bug Reports    Installation, Upgrade, & Config Support    Template Support    Extension Support       Modules       Payments       Shipping       Order Totals       Feeds       Languages Development    Feature Requests    Concepts    Integration    Free Contributions       Modifications       Extensions       Themes       Languages       vQmods    Commercial Contributions       Extensions       Themes       vQmods České forum Deutsches Forum Foro Español Forum français Fórum Português Ελληνικό φόρουμ Türkçe Forum Italian Forum Svenskt forum Nederlands Forum    Installatie & Configuratie    Extensies & Modificaties    Uiterlijk Norsk Forum Magyar fórum Polskie forum Български Форум Forumul Român lietuvių Forumas Русский/украинский форум Suomi Foorumi Srpski forum 日本語形式のフォーラム 한국어 포럼 Diễn Đàn Tiếng Việt 中文論壇 भारत फोरम القسم العربى انجمن فارسی ภาษาไทย Forum Berbahasa Indonesia OpenCart v0.x    Installation & Upgrade Support    General Support    Bug Reports    Template Support    Extension Support    Contributions    Development    FAQs Other    Commercial Support    Live Shops    Website Suggestions    Off-Topic

Who is online

Users browsing this forum: No registered users and 2 guests

• Board index
• The team • Delete all board cookies • All times are UTC

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
Protected by Anti-Spam ACP

Get Social

Follow us on the social media web sites.

Newsletter

Subscribe to our newsletters and be informed of new releases and other OpenCart events.

Contact Us

OpenCart Limited, Unit 16, 26/F, Tuen Mun Central Square, 22 Hoi Wing Road, Tuen Mun, Hong Kong

+852 24990996

Send email via our contact form

Copyright © 2012 OpenCart - All rights reserved

Hosted by Arvixe Web Hosting

[jty]

Yeah, something like that.
The Franscais Carte appends new rows without touching the current ones but that's about all that's great about it.
I'm thinking about people with 10,000+ products and additional modded fields
If they had other fields not in the import, they would have a nightmare inputting all 10,000+ products x 5 options and import them at once and then go hunting for the data corruption.
If, on the other hand, the import didn't touch the existing rows, they could do them by eg categories. Check it, if it's OK, do the next category.
In my situation, I got lost with the options and matching it to the product ID 

[bruce]

Update would then not delete any products that you wanted to remove via the spreadsheet.

The product_id is maintained by import/export so perhaps a better way of implementing additional fields would be in a separate table from the core design. You still have to change the sql statements for getting product information into your store to join to the new table but since you are already changing the templates, it is not too much extra effort.

This way, the core import/export works out of the box for everyone and your custom fields are not trashed when you import and the links are preserved.

The only downside (every silver lining has a cloud  ) is that you cannot load the short description using import/export.

[jty]

Thanks Bruce. That's a good idea, to stick it in a different table. I didn't think of that.

[Qphoria]

every silver lining has a cloud 

LOL I'm pretty sure that's not how the saying goes....

[red8ii8]

My cart and admin were fresh installs and working fine, and as soon as I installed the mod I get a 500 error and can't get back in to admin at all. Any pointers in where to look for trouble? I tried installing the patch referenced earlier but nothing happened. I reeeally need this mod to get all my inventory moved over. Thanks!

[bruce]

Try renaming the .htaccess file in your admin folder to (say) htaccess.txt

[Tomas_cze]

Hi, I have problem
If I click on "Export" and download xml file so in file is

Code: Select all

<b>Warning</b>:  tempnam() [<a href='function.tempnam'>function.tempnam</a>]: open_basedir restriction in effect. File() is not within the allowed path(s): (/data/www/www_exit-site_com) in <b>/data/www/www_exit-site_com/shop/admin/OLE/PPS/File.php</b> on line <b>87</b><br />

Please help ... thx

[JNeuhoff]

This appears to be an issue of directory/file access rights of some sort. Who is your webhosting provider? Are your PHP scripts running under your user account, or under a shared Apache account? Is the PHP PEAR library installed on your host?

[Tomas_cze]

My webhosting provider is hosting.blueboard.cz (Czech) - PHP 5.2.6, Apache 2.0 Handler ... I don´t know if I have installed PEAR but I think yes ... Must I create same directory or edit same files?

[yl]

After I uploaded it to 0.7.7 and got a 500 internal service error
"  Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8i DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at my store Port 80  "

What's wrong with it and where I suppose to investigate finding the error and fixing it? or is it linking to web hosting?

Appreciated much your help!

[yl]

After I removed the file .htaccess I got the admin login back. Problem solved!!

[yl]

Updated!!

This is a great contribution. Data exported to Excel look great. I can see what product is running out of stock. One problem here is the USD $ changed to £. I checked on admin>setting and found nothing wrong, is still USD. What causes this happened??? Appreciated for any help on fixing it!!

[yl]

Never mind please, I went back and looked thru admin setting nothing wrong. then I saw it on the home page changed to pound sterling. Don't know how it happened??

[JNeuhoff]

You can set the default currency in OpenCart's admin panel, at

Admin > Configuration > Setting > Local > Currency

If you have other currencies enabled, then it is still possible for the user to choose one and it should stay that way in the user session.

[Qphoria]

Never mind please, I went back and looked thru admin setting nothing wrong. then I saw it on the home page changed to pound sterling. Don't know how it happened??

Since the default install uses Pounds, it is likely that even tho you changed it in the backend, the frontend still had the original language cookie session. So you'd need to clear that cookie to make it use the new default language, or just change it in the selector to use USD