Cant import from CSV or XML or Database
- Kazuo Gomi Filho
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 4
- Thank you received: 0
9 years 2 months ago #2822
by Kazuo Gomi Filho
Cant import from CSV or XML or Database was created 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...
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.
- Kazuo Gomi Filho
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 4
- Thank you received: 0
9 years 2 months ago #2823
by Kazuo Gomi Filho
Replied by Kazuo Gomi Filho on topic Cant import from CSV or XML or Database
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
- 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.
9 years 2 months ago #2824
by Daniel
Thanks
Daniel
Replied by Daniel on topic Cant import from CSV or XML or Database
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.
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.
- Kazuo Gomi Filho
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 4
- Thank you received: 0
9 years 2 months ago #2825
by Kazuo Gomi Filho
Replied by Kazuo Gomi Filho on topic Cant import from CSV or XML or Database
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??
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.
9 years 2 months ago #2827
by Daniel
Thanks
Daniel
Replied by Daniel on topic Cant import from CSV or XML or Database
A reply to your email has been sent, Please check...
Thanks
Daniel
Please Log in to join the conversation.
- Koen Pacquets
- Offline
- New Member
-
Less
More
- Posts: 2
- Thank you received: 0
9 years 2 weeks ago #3044
by Koen Pacquets
Replied by Koen Pacquets on topic Cant import from CSV or XML or Database
Hello,
I'm having the same problems importing csv, xml and json files. What am I missing here??
Greetings,
Koen
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.