Hello,
First: All PlugIns are active.
I've set up several import plug-ins to test. No rule works for me, all remain ineffective. A very simple rule for adding a string to the value. See here the configuration:
[img ]https://gb.dinotec.de/images/maleben/2018-07-03%2013_36_13-Start.png[/img]
The value in the database has not changed. Here is the corresponding entry from the debug log:
Debug Log:
2018-07-03 11:05:45 1 [DEBUG] Custom field name-1 is not assigned to given category
2018-07-03 11:05:45 1 [QUERY] SELECT `field_id`,`category_id` FROM `j25_fields_categories` WHERE `field_id` = 1 AND `category_id` = 38
2018-07-03 11:05:45 1 [DEBUG] Removed existing custom field values
2018-07-03 11:05:45 1 [QUERY] DELETE FROM `j25_fields_values` WHERE `field_id` = 1 AND `item_id` = 204
2018-07-03 11:05:45 1 [DEBUG] Custom field values added
2018-07-03 11:05:45 1 [QUERY] INSERT INTO `j25_fields_values` (`field_id`,`item_id`,`value`) VALUES (1,204,'EN VoDes BlueWave 30 mit integr. Regelungstechnik')
I'm desperate, where's the trick for this rule to work?
Greetings
Steffen
Accepted Answer
Pending Moderation
Hi Tharuna,
the best first: My tests were successful now.
Yes, the XML file does not have an article ID, that's what it's meant to be AND (@Roland), the Field "name-1" is a Joomla Custoum Field for Content.
It's probably all "Spanish" to you. Let me explain briefly what I intend to do here:
I would like to use CSVimproved to translate my German content into other languages. This goes in the following order:
Case 1: (NEW)
1. Create German content
2. Export German content with all relevant fields into an XML file
3. This XML file is then read into a TMS (TranslationMemorySystem) and goes through a GUI to a translator. When the translator finishes, an analog XML file is checked out with English texts.
4. CSVimproved import with partially adjusted field contents:
a) alias: 0220-100-00_de -> 0220-100-00_en
b) language: DE-GB -> en-GB
c) the article ID is deleted
5. CSVimproved creates a new article for each entry in the XML file (since there is no ID).
Case 2: (Update)
Points 1-5 are repeated in the same way as in case 1. German content has been changed. This one has to be translated again.
For the point 5 applies: in the XML file there is still NO article ID. Nevertheless, just in my test, the English article (which is already there) updated correctly.
I'm not sure why it worked now, but I hope the import has taken the alias (this will ALWAYS be unique within a category) as a WHERE statement. If so, my procedure should work that way.
I have one more question:
Can I limit a Joomla content export to modified_by = today?
Then I can install a cron that exports the data daily. Maybe you have a link for me to read how it works.
Everything understood ....
hmy: :silly: 
Greetings Steffen
the best first: My tests were successful now.
Yes, the XML file does not have an article ID, that's what it's meant to be AND (@Roland), the Field "name-1" is a Joomla Custoum Field for Content.
It's probably all "Spanish" to you. Let me explain briefly what I intend to do here:
I would like to use CSVimproved to translate my German content into other languages. This goes in the following order:
Case 1: (NEW)
1. Create German content
2. Export German content with all relevant fields into an XML file
3. This XML file is then read into a TMS (TranslationMemorySystem) and goes through a GUI to a translator. When the translator finishes, an analog XML file is checked out with English texts.
4. CSVimproved import with partially adjusted field contents:
a) alias: 0220-100-00_de -> 0220-100-00_en
b) language: DE-GB -> en-GB
c) the article ID is deleted
5. CSVimproved creates a new article for each entry in the XML file (since there is no ID).
Case 2: (Update)
Points 1-5 are repeated in the same way as in case 1. German content has been changed. This one has to be translated again.
For the point 5 applies: in the XML file there is still NO article ID. Nevertheless, just in my test, the English article (which is already there) updated correctly.
I'm not sure why it worked now, but I hope the import has taken the alias (this will ALWAYS be unique within a category) as a WHERE statement. If so, my procedure should work that way.
I have one more question:
Can I limit a Joomla content export to modified_by = today?
Then I can install a cron that exports the data daily. Maybe you have a link for me to read how it works.
Everything understood ....
hmy: :silly: Greetings Steffen
Accepted Answer
Pending Moderation
Hello Steffen,
Yes, the XML file does not have an article ID, that's what it's meant to beIn that case you need to remove the id field from your list of fields.
I'm not sure why it worked now, but I hope the import has taken the aliasCorrect, we take the alias as explained in the documentation Joomla content import
Can I limit a Joomla content export to modified_by = today?You cannot without modifying the export. However I find it a feasible request, so will put it on our todo list.
Everything understood ....All clear to me
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
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!