Page 2 sur 3

Re: Mass import etc.

Posté : dim. 4 sept. 2011 13:36
par mazzo
steevo a écrit :Hi.
For the moment, i am on holidays. I will give you the script with explaination after August the 15th.
Any news?

Cheers,
MaZZo.

Re: Mass import etc.

Posté : lun. 12 sept. 2011 14:25
par steevo
Hi and sorry for the late answer.

You need an excel file with your data in the first sheet.
the first row for identify columns and each row is an item.
each column is a field of your collection.

So you have to download phpexcel here: http://phpexcel.codeplex.com/
Extract the files in a directory for example phpexcel.
And in the same directory you have to put the file joined (extract first).
excel.zip
(1.51 Kio) Téléchargé 6496 fois
in this file, you have to put your database parameters at the beginning.
line 16, fill with your collection id (in backend the list of collections)

after in the SWITCH instruction, create a case for each column (first column is 0) and in the case you call a function to insert data. The functions are declared after line 100.

if the field is text, image, file or number, you have to declare function like "traiter_ref" and change the field id with your own value.

if the field is defined field, declare a function like "traiter_fabricant" and change the field id with your own value.

Am I clear ?

Re: Mass import etc.

Posté : lun. 19 sept. 2011 21:18
par mazzo
Thank you so much steevo.
Now...I give it a try and I hope to understand everything.
Thank you again for your help.
MaZZo.

Re: Mass import etc.

Posté : mar. 4 oct. 2011 16:33
par texsuisse
Hi, Steevo,

I am putting this component to good use! I I also need to load items from a spreadsheet, so I'm really happy that you made this script available. Thanks!

Regards,

TexSuisse

Re: Mass import etc.

Posté : lun. 31 oct. 2016 11:25
par miettja
Hi,

I would also like to use this mass import script, but I'm not able to download this zip files. Is there something else I should do?

Re: Mass import etc.

Posté : mer. 2 nov. 2016 16:21
par steevo
miettja a écrit :Hi,

I would also like to use this mass import script, but I'm not able to download this zip files. Is there something else I should do?
Hi,

What is the problem ? normally you are allowed to download the zip file.
I'm working on the version 0.7 that will include in the admin panel this mass import functionnality.

Re: Mass import etc.

Posté : jeu. 9 févr. 2017 11:00
par Theo
steevo a écrit : I'm working on the version 0.7 that will include in the admin panel this mass import functionnality.
I Can't wait to use it, as I have an Excel file containing 28.000 items.... :shock:

Re: Mass import etc.

Posté : jeu. 9 févr. 2017 23:44
par Theo
Mmmm....

I downloaded the file excel.php but it is empty?? !!!

Re: Mass import etc.

Posté : lun. 13 févr. 2017 08:42
par steevo
Hi,
I will give you a beta version in few days.
You first have to create your collection with your fields.
And in your Excel file, all rows should be in the first page, one field by column.
Just few days to wait ;-)

Re: Mass import etc.

Posté : lun. 13 févr. 2017 12:13
par Theo
You're a great guy ! :D :D :D