Contact Us Today! | vcare@wdmtech.com

WDMtech

Topic-icon Import problems - not importing all records

More
1 year 6 months ago #1915

My Pleasure, Please feel free to revert anytime in case of further assistance...


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Bryan Smith
  • Bryan Smith's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
1 year 6 months ago #1914

Success, thank you Danish

Please Log in or Create an account to join the conversation.

  • Bryan Smith
  • Bryan Smith's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
1 year 6 months ago #1913

Hello Danish,

I'm not able to give admin access to the website at this time.

looks like an article id conflict. I'm sure there's a way to create a new id. I'm trying to learn from the docs.

Please Log in or Create an account to join the conversation.

More
1 year 6 months ago #1912

From your previous message I got to know that You are importing the articles with the primary key values i.e. ID column, So skip this column and try to import the Data again. Your imported articles will have different IDs. And if you want to update already existing articles then you need to choose Update for the operation field in Profile settings.

Hope I could reply to your query precisely...


Thanks
Daniel
Last Edit: 1 year 6 months ago by Daniel.

Please Log in or Create an account to join the conversation.

More
1 year 6 months ago #1911

Hello Bryan,
You must have seen reference to option for fields when you add/edit a profile which is used to Map the articles with Category or in such cases where you need mapping because of a different reference id ( catid in your case ). You can choose extension & Category title columns to map the correct catid. But as you said you have already mapped it manually so It's all good. And if it doesn't find any matching category then It inserts 0. And this can be found in the log section so that you can manually assign categories to such articles ( would be limited in numbers ).

But as you said It's importing only a few articles not all, We need to have a look into it. Please share your back end & FTP login credentials via Contact us form.


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Bryan Smith
  • Bryan Smith's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
1 year 6 months ago #1910

Date: 2016-01-26 05:19:18 UTC
#Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT

#Fields: datetime priority clientip category message
2016-01-26T05:19:18+00:00 INFO 63.248.218.100 com_vdata Import Profile title - Import Joomla Articles
2016-01-26T05:19:18+00:00 INFO 63.248.218.100 com_vdata Import Table - #__content
2016-01-26T05:19:18+00:00 INFO 63.248.218.100 com_vdata Import Format - CSV
2016-01-26T05:19:18+00:00 ERROR 63.248.218.100 com_vdata Insert Fail, record already exists with id = 9 .
2016-01-26T05:19:18+00:00 ERROR 63.248.218.100 com_vdata Insert Fail, record already exists with id = 30 .
2016-01-26T05:19:18+00:00 ERROR 63.248.218.100 com_vdata Insert Fail, record already exists with id = 35 .
2016-01-26T05:19:18+00:00 ERROR 63.248.218.100 com_vdata Insert Fail, record already exists with id = 52 .
2016-01-26T05:19:18+00:00 ERROR 63.248.218.100 com_vdata Insert Fail, record already exists with id = 53 .
2016-01-26T05:19:18+00:00 ERROR 63.248.218.100 com_vdata Insert Fail, record already exists with id = 54 .
2016-01-26T05:19:18+00:00 ERROR 63.248.218.100 com_vdata Insert Fail, record already exists with id = 55 .
2016-01-26T05:19:18+00:00 ERROR 63.248.218.100 com_vdata Insert Fail, record already exists with id = 161 .
2016-01-26T05:19:18+00:00 INFO 63.248.218.100 com_vdata Imported Record count - 4

Please Log in or Create an account to join the conversation.

  • Bryan Smith
  • Bryan Smith's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
1 year 6 months ago #1909

attached is my import csv

Attachments:

Please Log in or Create an account to join the conversation.

  • Bryan Smith
  • Bryan Smith's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
1 year 6 months ago #1908

I'm trying to export - import some joomla articles from a single category.

I'm exporting 12 but importing only 4. I've tried csv and json with csv importing 4, json 5. The destination category is empty.

No error codes.

Are there any logs or any way to figure out what is wrong with the import?

I'm also unclear on how articles get mapped to a category on import. Or what if a category doesn't exist or has a different id. I see in my case the category id is different but it did map it correctly from export to import. Articles ended up in "General Info" category event though ID's were different.

Thank You

Please Log in or Create an account to join the conversation.