Pages:

Plugin for Export to flat file or Excel exist or not ?

beholder

Avatar: beholder

2008-09-06 01:40

I don't know, did you contact me already? because I have a suspicion my e-mails don't come lately from that account so when you contact me, please let me know also in here that you already did.

beholder

Avatar: beholder

2008-09-08 23:49

My suspicion was confirmed, e-mails now arrive after I set it right.

gadmin

Avatar: gadmin

2008-09-17 23:34

Hi beholder!

I am back ...
unfortunately, the relax time is over!!!
...

long story short, I started a project named "gadmin4QC"on sourceforge.net
actually I am writing the README file and trying to create a small pack for uploading.

unfortunately, i faced problems during last testing :-((
more precisely with the image managing!
setting up the possibility of the 8 attachable pictures
(as it is given by default in the php admin)
needs 40 000 rows for 5000 products!!!!!!
which causes "deadly slow" file opening/saving/updating!
in case of max. 4 pictures per product, it is only 20 000 rows and more useful...
(maybe that is the reason why you use your own php solution ???)

I think it is time to think about writing a perl script to fetch data from the .ods file
and for formating and creating the php/csv/txt database files!!
it is a must anyway, if I wanna do the importing stuff from the php/csv/txt files later!
and should be much faster and simple :-)

...so the version 0.1 will be a limited thing for testing purposes only with

2 000 products
50 pages
and no picture managing


.......tbc

Didier31

Avatar: Didier31

2009-08-13 10:16

Hello Beholder,

Do you have a written documentation to perform export/imports for the article file ?
Thanks,

Didier

beholder

Avatar: beholder

2009-08-13 13:19

yes, but it is in SK language. Can easily translate. Some of the instructions I have already sent to your email. There is just a set of several non-complicated rules to follow.

beholder

Avatar: beholder

2009-08-13 13:36

oh BTW, contrary to what I wrote before in this thread, my script has been recently enhanced to work with all QC 3.x versions, Free, EXT, you name it. It now has a nice general usability.

It can also import product features. The script still works by overwriting the previously imported products by newly imported products, so it's very easy to make changes to your shop in Excel/Calc.

Didier31

Avatar: Didier31

2009-09-05 08:18

Just for your information, this feature is included within the EXT version of QC !

beholder

Avatar: beholder

2009-09-05 14:32

Actually not, Didier. My import does import of categories and features (along with products) and will never overwrite the non-imported products.
I have furthermore created an OpenOffice.org macro, that literally allows for import from Calc to QC by push of a single button. This is perfect for those who fix prices and product information like every week or even more often.

Didier31

Avatar: Didier31

2009-09-05 16:36

I was of course taking about the IMPORT feature object of the original post, not about your procedure. Sorry for the confusion.

Pages:
Back to top
about us | contact