I downloaded the csv file and tried to import it and I received an error saying there are duplicated entries with same id (unique identifier). Then I changed the ids also to be unique to each others and re-imported it and It worked properly for me.
So can you make the changes to ids and make it unique to see if it works.
Regarding the CSV files, I have attached a screenshot showing how I fixed the Id's, I have removed most of the contents to make it easier to understand.
Sorry - it's still not connecting the posts and the corresponding second language. Now it's doing even worse, because it doesn't seem to import them all, even though I've started over by wiping out all policy entries after trying a failed import.
When I import it also wipes out taxonomy terms, which I spent a bunch of time translating. I'm baffled.
I feel like I have it set up exactly like your CSV. I can't figure out what's different between mine and yours.
Here is my CSV for the first 5 as I've got it. After each time I run and import and it doesn't work, I trash and permanently delete the Policy Records and start over. So it should be always creating new records because the old policy records aren't there.
I've got French and English in the same file. I can't tell for sure, but perhaps it's wiping out the English posts when it adds the French one? I've tried setting the identifier to both {id[i]} and {_wpml_import_translation_group[1]}. Same problems.
Update: I got the first five to translate and connect when I reduced it to just 5 records and did it without the "bundle."
But then the next ones I did were even more messed up. It also wanted to import bar-separated tags as one string and as a new tag.
I think if I understood:
— What's the difference between ID, WPML Translation ID, _wpml_translation group?
———Which of these need to be the same between English and French?
———How can post ID be arbitrary?
And also if I understood:
— Which non-custom-columns fields should (or must) be left out of an export/import for WPML Export and Import? (For instance, I don't see any use for a permalink field if it has the slug.)
Then I'd also have proper understanding and I'd be able to import these successfully and consistently. Thanks!
Which of these need to be the same between English and French?
_wpml_import_translation_group
How can post ID be arbitrary?
The post id are added by the WordPress system so it will be unique itself. It checks for the last id available and create new onces based on it.
Which non-custom-columns fields should (or must) be left out of an export/import for WPML Export and Import? (For instance, I don't see any use for a permalink field if it has the slug.)
I don't have a set of fields list available. but yes you can leave the permalink fields as it will be generated based on the title available of slug.
Further, I suggest doing imports for only few products as a test then save those settings as template and do remaining imports later on.
