Mass import etc.

Si vous avez une idée pour une future fonctionnalité

par mazzo » Dim 4 Sep 2011 13:36

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.
mazzo
 
Messages: 5
Inscription: Dim 24 Juil 2011 09:30

par steevo » Lun 12 Sep 2011 14:25

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.5 Kio) Téléchargé 163 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 ?
Avatar de l’utilisateur
steevo
Administrateur du site
 
Messages: 330
Inscription: Jeu 17 Déc 2009 22:59

par mazzo » Lun 19 Sep 2011 21:18

Thank you so much steevo.
Now...I give it a try and I hope to understand everything.
Thank you again for your help.
MaZZo.
mazzo
 
Messages: 5
Inscription: Dim 24 Juil 2011 09:30

par texsuisse » Mar 4 Oct 2011 16:33

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
texsuisse
 
Messages: 1
Inscription: Mar 4 Oct 2011 16:25

par miettja » Lun 31 Oct 2016 11:25

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?
miettja
 
Messages: 1
Inscription: Jeu 7 Juil 2016 13:54

par steevo » Mer 2 Nov 2016 16:21

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.
Avatar de l’utilisateur
steevo
Administrateur du site
 
Messages: 330
Inscription: Jeu 17 Déc 2009 22:59

par Theo » Jeu 9 Fév 2017 11:00

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:
Theo
 
Messages: 5
Inscription: Mer 8 Fév 2017 12:29
Localisation: Veghel - NL

par Theo » Jeu 9 Fév 2017 23:44

Mmmm....

I downloaded the file excel.php but it is empty?? !!!
Theo
 
Messages: 5
Inscription: Mer 8 Fév 2017 12:29
Localisation: Veghel - NL

par steevo » Lun 13 Fév 2017 08:42

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 ;-)
Avatar de l’utilisateur
steevo
Administrateur du site
 
Messages: 330
Inscription: Jeu 17 Déc 2009 22:59

par Theo » Lun 13 Fév 2017 12:13

You're a great guy ! :D :D :D
Theo
 
Messages: 5
Inscription: Mer 8 Fév 2017 12:29
Localisation: Veghel - NL

PrécédenteSuivante

Retourner vers Demande de fonctionnalité

cron

Qui est en ligne

Utilisateurs parcourant ce forum: Aucun utilisateur enregistré et 1 invité