Nick Gardener
Forum Replies Created
-
Posts
-
This reply has been marked as private.
Yeah we tried that before — it turned out to be fiendishly complicated and lots of trouble. Lots of cells are involved, it seems.
Is there a way in which we can directly import part of the data into one sql table, and have it update the rest from import?
Perhaps including a re-export to get the fresh ID?
Hopefully Stiofan can give us some good ideas!
I saw a few notes about more effective template overrides in the latest, but FYI this hasn’t fixed it for this issue.
I tried a work around, which possibly highlights a bug.
Experiment theory: if I import id, title, type directly into wp_posts in sql, and THEN run an import with Update by ID, then it will import the full data.
Practise:
– even though Update by ID was selected, it just created 3 new rows.Oh that’s interesting. Right. So.. hmm.
So here’s my situation: I’m importing linked data from a custom app. The relationships exist as IDs in columns, so it’s relationally structured. But I need to work out how to bring that data across.
An automatic solution is necessary, alas: there are some 35000 records across 4 different CPTs.
Any cunning ideas?
oops.. or not 🙂
Thanks for this — I’ve just tried importing a a different CPT (not places) and whilst it says that 55/55 rows imported successfully, they’re neither on the site nor in the db… :/
<3
This reply has been marked as private.I’m guessing it’s going to be a few extra columns in the import CSV, would that be correct? Can I proceed in preparing my data on that assumption?
This reply has been marked as private.This reply has been marked as private.nudge? (sorry but … well you are about to renew my membership!)
Is there a shortcode to display these components separately?
