Cant import from CSV or XML or Database

More
9 years 2 months ago #2822 by Kazuo Gomi Filho
I read the manual but i cant import data from SQL file or database...
I have one website and i import some data from SQL file into Joomla DB... i tried import articles (non joomla) but not success
I tried import by CSV or XML files.. neither not sucess...
I really dont know what can i do...

Please Log in to join the conversation.

More
9 years 2 months ago #2823 by Kazuo Gomi Filho
My database have this columns.

- editorial - I want to skip. I wont use these column
- local - I want to skip. I wont use these column
- ID - I want to skip. I wont use these column
- tema - CATEGORY
- titulo - TITLE
- lead - INTRO
- texto - FULL TEXT
- imagem - IMAGE (INTRO AND FULL)
- categoria - I want to skip. I wont use these column
- data - CREATED DATE
- galeria - I want to skip. I wont use these column
- video - I want to skip. I wont use these column
- audio - I want to skip. I wont use these column
- autor - I want to skip. I wont use these column
- sn - I want to skip. I wont use these column
- autorfoto - I want to skip. I wont use these column
- colunista - I want to skip. I wont use these column
- lidas - I want to skip. I wont use these column
- status - PUBLISHED

Please Log in to join the conversation.

More
9 years 2 months ago #2824 by Daniel
Hello,
You can not import data in SQL format. vData supports XML, JSON, CSV and Remote Database connection. Can you please let me know the error message It's throwing when you import using XML or CSV file, You can also check logs for detailed message.

Thanks
Daniel

Please Log in to join the conversation.

More
9 years 2 months ago #2825 by Kazuo Gomi Filho
Ok.. I cant import from SQL format but i tried with CSV, XML and database sources.

From XML and JSON files
1 - select import joomla articles
2 - select XML or JSON from data source
3 - select the file from my computer
4 - click continue
and got this message : Enter File Path
5 - upload the file to the server(root)
6 - select enter path to local server and complete with the name of the file
7 - goes to another page but this configuration i cant find in your documentation to how configure it

From CSV file
1 - select import joomla articles
2 - select CSV from data source
3 - select the file from my computer
4 - click continue
5 - in another page i have import details
6 - when try to select some field i have this options only : all the fileds are together eg."id","title","text"............

From Database
1 - select import joomla articles
2 - select Database from data source
3 - set local because i import my data to Joomla DB
4 - in another page i have several itens to set... i just set the itens wich i want.. catit i cant understand who it works..
5 - after finish and sucessufull message
6 - nothing in articles


I tried create my own profile but not success.. what i miss??

Please Log in to join the conversation.

More
9 years 2 months ago #2827 by Daniel
A reply to your email has been sent, Please check...

Thanks
Daniel

Please Log in to join the conversation.

More
9 years 2 weeks ago #3044 by Koen Pacquets
Hello,


I'm having the same problems importing csv, xml and json files. What am I missing here??

Greetings,

Koen

Please Log in to join the conversation.

Cron Job Starts