Hi
I would like to import a number of articles with certain IDs from a 3.10.12 version into a migrated page (version 5.3). New IDS should be assigned and the customfields should also be imported. What is the best way to do this?
Kind regards
Christoph
- galbur
- RO CSVI
- Tuesday, 29 April 2025
- Subscribe via email
0
Accepted Answer
Pending Moderation
Hello Christoph,
You can use id field in import file to have specific IDs and in Joomla content import template on Options tab set Keep content ID to Yes. This will import articles with IDs set in import file. Custom fields will be created to the ID article is assigned to.
You can use id field in import file to have specific IDs and in Joomla content import template on Options tab set Keep content ID to Yes. This will import articles with IDs set in import file. Custom fields will be created to the ID article is assigned to.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hello Tharuna
Many thanks for the quick reply! But the articles should be imported with new IDs. That means, if I set Keep content ID to No in the Options tab, then new ID'S will be created?
Kind regards
Christoph
Many thanks for the quick reply! But the articles should be imported with new IDs. That means, if I set Keep content ID to No in the Options tab, then new ID'S will be created?
Kind regards
Christoph
Accepted Answer
Pending Moderation
Hello Christoph,
Yes with Keep content ID set to No new IDs will be created. Also skip id column from import file if you have it.
Yes with Keep content ID set to No new IDs will be created. Also skip id column from import file if you have it.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hello Tharuna
I use the joomla Content Import Example. I established a connection to the DB. But now, where exactly do i have to set the row of ids (for Example 2884,2886,2887,2891,2892,2895,2896,2897,2898,2899,2900,2901,2902,2903,2904,2905,2906,2907,2909,2910,2911)?
kind regards
Christoph
I use the joomla Content Import Example. I established a connection to the DB. But now, where exactly do i have to set the row of ids (for Example 2884,2886,2887,2891,2892,2895,2896,2897,2898,2899,2900,2901,2902,2903,2904,2905,2906,2907,2909,2910,2911)?
kind regards
Christoph
Accepted Answer
Pending Moderation
Hello Christoph,
Now I am confused
By new IDs you mean that articles should be created with the IDs you have?
Now I am confused

By new IDs you mean that articles should be created with the IDs you have?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hi Thamura
Thanks again. Sorry for confusing you. Ich have certain Articles in the old system. With some ID's: (2884,2886,2887,2891,2892,2895,2896,2897,2898,2899,2900,2901,2902,2903,2904,2905,2906,2907,2909,2910,2911) In the meantime, in the new parallel-System, some new Articles have the same id but other content. So i want to import all these specific Articles (and only these) to the new system. And all these articles are to receive new IDs.
I hope my request is clear now ;-)
Kind regards
Christoph
Thanks again. Sorry for confusing you. Ich have certain Articles in the old system. With some ID's: (2884,2886,2887,2891,2892,2895,2896,2897,2898,2899,2900,2901,2902,2903,2904,2905,2906,2907,2909,2910,2911) In the meantime, in the new parallel-System, some new Articles have the same id but other content. So i want to import all these specific Articles (and only these) to the new system. And all these articles are to receive new IDs.
I hope my request is clear now ;-)
Kind regards
Christoph
Accepted Answer
Pending Moderation
Hello Christoph,
Yes I understand now. You are having conflict with IDs in old and new Joomla installation.
The articles you want new IDs you can import them without id field and set Keep content ID to No. RO CSVI will use cat_id or category_path and title or alias fields from import file and check if article already exists if they don't exists then it will create articles with new IDs. This new ID will be auto increment number in database. If matching article already exists then it will update existing article. Will that work for you?
I hope my request is clear now ;-)
Yes I understand now. You are having conflict with IDs in old and new Joomla installation.
So i want to import all these specific Articles (and only these) to the new system. And all these articles are to receive new IDs.
The articles you want new IDs you can import them without id field and set Keep content ID to No. RO CSVI will use cat_id or category_path and title or alias fields from import file and check if article already exists if they don't exists then it will create articles with new IDs. This new ID will be auto increment number in database. If matching article already exists then it will update existing article. Will that work for you?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hello Tharuna
Thanks again for Helping.
What I still don't understand ... I only want to import certain items with certain IDs. Where exactly can I define these IDs? Or where is there a field where I can enter all the required IDs?
Kind regards
Christoph
Thanks again for Helping.
What I still don't understand ... I only want to import certain items with certain IDs. Where exactly can I define these IDs? Or where is there a field where I can enter all the required IDs?
Kind regards
Christoph
Accepted Answer
Pending Moderation
Hello Christoph,
You can use RO CSVI Skip rule to set the IDs you want to skip on import. Rest of the records will be imported. Apply this rule on ID field and run the import.
I only want to import certain items with certain IDs. Where exactly can I define these IDs?
You can use RO CSVI Skip rule to set the IDs you want to skip on import. Rest of the records will be imported. Apply this rule on ID field and run the import.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hi Tharuna
Thank you. So i have to skip hundreds of articles to import 40 articles?
Kind regards
Christoph
Thank you. So i have to skip hundreds of articles to import 40 articles?
Kind regards
Christoph
Accepted Answer
Pending Moderation
Hello Christoph,
You can use regular expression with 40 article ID so only they are imported and the rest of hundreds of articles are skipped on import. You can use the below regex in RO CSVI Skip rule. IDs should be separated by |. See attached screenshot. Try it and let me know if that works.
You can use regular expression with 40 article ID so only they are imported and the rest of hundreds of articles are skipped on import. You can use the below regex in RO CSVI Skip rule. IDs should be separated by |. See attached screenshot. Try it and let me know if that works.
/^(?!2886|2891|2884)/
Attachments (1)
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »