Importing posts via MySql (a csv file) need to be automatically published
Suggestions for what you can try: Try to remove the empty columns, especially post_excerpt. Try another import plugin. Try another delimiter.
Suggestions for what you can try: Try to remove the empty columns, especially post_excerpt. Try another import plugin. Try another delimiter.
I’d dump part of the database and see how the posts/pages/ titles, date and other meta is arranged and compare it to WordPress’s DB structure. See http://codex.wordpress.org/Database_Description and http://codex.wordpress.org/Importing_Content for existing importers. Decide what you really need to import and what needs to be generated that is specific to WP. It’s not going to be … Read more
If you cannot install your own plugins you could set up a separate WordPress installation where you can do that and use the plugin HTML Import 2. From this site you can create a regular export file. You will not get all meta data (tags, categories etc.) though.
When you’re exporting from a localhost installation, the other installation cannot import images because it technically needs to be ‘online’ for the new installation to download the images off the older one. The easiest thing to do would be to migrate the old site to an online installation. You can read about how to move … Read more
If you can guarantee the “uniqueness” of each page’s title, I would first run the entire import, and then loop over the newly inserted pages & set their parents by cross referencing the CSV.
Sounds like a sound approach to me! Not enough rep to comment so I’m posting an answer… Only advice I’d have is to 1. Make sure character encodings are correct so you don’t end up with a bunch of “æÃ” ‘s 2. Make database backups 🙂 As to ACF, I think it’s pretty much the … Read more
In WordPress, user’s Biography is saved in User Meta table with description key.
Nope, the WP is pretty flexible about this and will perfectly handling omitted fields. Including assigning IDs (which is actually best left to it, outside of edge cases when exact IDs must be imported). The only situation that natively won’t let you create post is if neither of title/content/excerpt is provided and post type supports … Read more
The way WordPress works is that the files need to be there, but they also need to be registered in the database to be listed in the Media Library. I don’t know the DownML Plugin, but it seems as this is only for backups, not for migrating data as you are trying. What you apparently … Read more
Your logic and the steps you plan on following look good to me. This is more or less exactly how I would handle the issue. However when you import the XML file from sub.example.com into example.com, you’ll want to check the links to the media files within the newly-imported posts. I believe they are still … Read more