× This category is read only

Import Spreadsheet

More
7 years 8 months ago #3953 by joest
Import Spreadsheet was created by joest
Step by step:

Go to your joomlabackend / JooDatabase
Klick "import"
Define name of destinationtable
Choose and upload your spreadsheet file
If csv - set field delimeter and text enclosure
Set radiobutton if you want columnnames in the first line
Klick "go"
Done (with first step)

You ask yourself: why can´t i see a new database at my jood-bbackend after my import?
Simple answer: because your not fineshed yet ...

Klick "new" (joomlabackend / Joodabase)
Define name of your db like "my little" db or what ever
Choose main table in dropdown (yippie, you just found your importet stuff, right?)
Klick "continue"
Depending on what structure (main table) you used for importing your data you´ll find it here ... match spreadsheetdata and template here
Klick "continue"
Read
Done
;-)

read also what Dirk wrote about mysql

Please Log in to join the conversation.