How to import the csv file in bulk

Started by honest16888, 31 May 2011, 06:54:34

Previous topic - Next topic
A financial contribution is greatly appreciated as a support, to help us to keep live the project.
If you like this project you can donate some piece of BitCoin to this address: bc1qy5tgq6tvrckac2a57unxvqcnxamrvhduve9sj9

honest16888

I want to import lots of article into joomla by Alexandria Book Library. How to create a right csv file and then import into the joomla database?

Who could help me?

A financial contribution is greatly appreciated as a support, to help us to keep live the project.
If you like this project you can donate some piece of BitCoin to this address: bc1qy5tgq6tvrckac2a57unxvqcnxamrvhduve9sj9

federica

Hi honest16888,
I hope that these are the info you need.

csv file features:
fields terminated by colon ( ; ), fields enclosed by double quotes ( "" ).

csv fields list:
title, subtitle, alias, id editor, price, pag, user id,  user alias, description, image name, file name, year, id location, id library, vote, numvote, hits, published, qty, isbn, approved, userid, url, url label, date insert, catalog, checked_out, checked_out_time, access, metakey, metadesc, catid, authors.

Notice: the "authors" field is an authors list separated by semicolon.
Al mondo ci sono 10 tipi di persone, quelli che hanno capito il codice binario e quelli che non l'hanno capito.
Informatizzati [url="https://informatizzati.org"]https://informatizzati.org[/url]
Stacca la spina [url="https://disconnessi.org"]https://disconnessi.org[/url]