Mass import etc.

Si vous avez une idée pour une future fonctionnalité
Avatar du membre
steevo
Administrateur du site
Messages : 330
Enregistré le : jeu. 17 déc. 2009 22:59
Contact :

Re: Mass import etc.

Message par steevo »

Hi !

Maybe you can try with beta release.
So your data should be in the first sheet of your excel file.
In collector, you have to create your collection and your fields.
Then in the items tab, there is a new bottom "import an excel file"
Then you upload your file. It will appear in the list. Select it and then a preview of the 10 first rows will appear.
under the preview, fill the first row of your datas ("2" if the row 1 is the title column for example)
And for each field of your collection, fill the letter column of the data in your file (i hope you have less than 26 columns because it doesn't work for more than 26 columns for the moment)
When it's done, click on "submit". A popup opens and click on the other "submit". You will see "import en cours" and the number of imported items that will increase.
At the end you will see "import terminé" and the number of imported items will stop.
By default the items are unpublished. If you want them published by default, modify the file /administrator/components/com_collector/controllers/import.raw.php at the line 364 add '$table->state=1;'

Tell me if it works ;-)
Fichiers joints
com_collector_0.6.4_beta.zip
(1.54 Mio) Téléchargé 3822 fois

Theo
Messages : 5
Enregistré le : mer. 8 févr. 2017 12:29
Localisation : Veghel - NL
Contact :

Re: Mass import etc.

Message par Theo »

So far no questions ... ;)

I'm busy, on this moment, but will spend some time to this beta-version in the days to come.
Thanks in advance!

Theo

Theo
Messages : 5
Enregistré le : mer. 8 févr. 2017 12:29
Localisation : Veghel - NL
Contact :

Re: Mass import etc.

Message par Theo »

I have setup a fresh Joomla 3.6.5 installation, added the Beta 0.6.4. and now.....
Uploading 26.000 lines :)

So far, I/m happy!

http://movements.sgvolkel.nl

Thanks;
Theo

Répondre