Import Successful, but where is the data?
- John Paquette
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 14
- Thank you received: 0
9 years 4 months ago #2533
by John Paquette
Import Successful, but where is the data? was created by John Paquette
Hello,
I imported a csv file with 2650 records and according to the log the import was successful, but I do not see the data in the Joomla Articles?
oceannews.cloudaccess.host/logs/com_vdat...5-12-2016_0121pm.txt
John
I imported a csv file with 2650 records and according to the log the import was successful, but I do not see the data in the Joomla Articles?
oceannews.cloudaccess.host/logs/com_vdat...5-12-2016_0121pm.txt
John
Please Log in to join the conversation.
9 years 4 months ago #2534
by Daniel
Thanks
Daniel
Replied by Daniel on topic Import Successful, but where is the data?
Hello,
Are you using Primary Key ( Article IDs ) to import the Data?
Are you using "Insert" or "update" operation?
Article IDs are used to update already existing records. If the IDs do not exist and you try to import the records, It doesn't import anything.
Are you using Primary Key ( Article IDs ) to import the Data?
Are you using "Insert" or "update" operation?
Article IDs are used to update already existing records. If the IDs do not exist and you try to import the records, It doesn't import anything.
Thanks
Daniel
Please Log in to join the conversation.
- John Paquette
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 14
- Thank you received: 0
9 years 4 months ago #2535
by John Paquette
Replied by John Paquette on topic Import Successful, but where is the data?
That's probably it, I created my own ID numbers. I assumed I needed the id number to import.
I'm seeing all the data in the assets table but the data is not showing up in the article tables.
So, should I skip the ID field?
I'm seeing all the data in the assets table but the data is not showing up in the article tables.
So, should I skip the ID field?
Please Log in to join the conversation.
- John Paquette
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 14
- Thank you received: 0
9 years 4 months ago #2536
by John Paquette
Replied by John Paquette on topic Import Successful, but where is the data?
It was set to insert.
Please Log in to join the conversation.
- John Paquette
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 14
- Thank you received: 0
9 years 4 months ago - 9 years 4 months ago #2537
by John Paquette
Replied by John Paquette on topic Import Successful, but where is the data?
Ok, I kinda got it working. Only issue is it's not importing all the HTML that's in the fulltext and introtext fields and the date is formatted incorrectly.
Last edit: 9 years 4 months ago by John Paquette.
Please Log in to join the conversation.
- John Paquette
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 14
- Thank you received: 0
9 years 4 months ago #2538
by John Paquette
Replied by John Paquette on topic Import Successful, but where is the data?
I'm seeing weird characters throughout the fulltext and introtext of the CSV file. Example: — -- How can I get the import to ignore those, anything that shows up after those characters does not get imported.
Please Log in to join the conversation.