[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4752: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3887)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4754: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3887)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4755: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3887)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4756: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3887)
steevo.fr • Afficher le sujet - Mass import etc.

Mass import etc.

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

par mazzo » Dim 4 Sep 2011 13:36

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é 388 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

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

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 32 invités