Running into two issues when running a bulk import from (many) xlsx files (on the command line using Maatwebsite Excel) .
I'm porting over a tonne of content from two (very shaky) WordPress websites built by a third party which were essentially duplicates running alongside each other, one in DE and one in EN (not a great architecture). The goal is to combine the two into a consolidated site on Twill. There are thousands of different posts of various types coming over so manually adding them would obviously be a very bad option).
I have one stack of import files for, (eg) blog posts from the english site and one stack from the German site. These aren't translations of each other (although some are to add some extra complexity). Both are then to be imported to Twill into one module, some with DE as the primary language, some with EN as the primary language. I am also trying to preserve the original slugs so they are being populated too, and a custom block is being populated and added for good measure
The first screenshot is the rough and ready generic class I'm using to manage the imports across a bunch of different modules. This works perfectly when used on the EN posts (the state of the class in the screenshot is where I'm trying to import the DE correctly). The posts and slugs populate and the DE version is inactive when imported, which is what I want (screenshot 2).
The problem is, when I import the DE only content the empty EN version is always live too. And the UI looks like the third screenshot (blank titles). I've tried many combinations of active/disabled but ultimately end up with the same result.
Issue 1 (most pressing) is that EN is always live and issue 2 is the UI not showing a title for the DE only posts (which makes sense as the title is a translated field but is something I need to work around)
We're at the point in a massive project where I am very likely to be making basic mistakes that hopefully fresh eyes might spot