Import Successful, but where is the data?

More
13 May 2016 06:57 #2548 by Daniel
Replied by Daniel on topic Import Successful, but where is the data?
Hello John,
Please share your FTP & Backend login credentials along with the Article ID where you are having the issue via Contact us form, We'll look into it.

Thanks
Daniel

Please Log in to join the conversation.

  • John Paquette
  • Topic Author
  • Offline
  • New Member
  • New Member
More
12 May 2016 20:14 #2542 by John Paquette
Replied by John Paquette on topic Import Successful, but where is the data?
Is there a way to set the export character type to UTF8, ASCII, etc? Looks like underscores, dashes and trademark emblems are getting converting into crazy characters.

Please Log in to join the conversation.

  • John Paquette
  • Topic Author
  • Offline
  • New Member
  • New Member
More
12 May 2016 18:32 #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.

  • John Paquette
  • Topic Author
  • Offline
  • New Member
  • New Member
More
12 May 2016 16:26 - 12 May 2016 16:27 #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: 12 May 2016 16:27 by John Paquette.

Please Log in to join the conversation.

  • John Paquette
  • Topic Author
  • Offline
  • New Member
  • New Member
More
12 May 2016 15:49 #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
  • New Member
More
12 May 2016 15:48 #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?

Please Log in to join the conversation.

More
12 May 2016 15:32 #2534 by 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.

Thanks
Daniel

Please Log in to join the conversation.

  • John Paquette
  • Topic Author
  • Offline
  • New Member
  • New Member
More
12 May 2016 13:55 #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

Please Log in to join the conversation.

Cron Job Starts