[wp-hackers] wordpress import. does it really work?

Mon Apr 9 16:44:04 UTC 2012

Thank you  Kevinjohn Gallagher.  I ask my questions to understand and learn
from you all. This is where one of the best minds of the planet hang out as
far as WP goes, right? I cannot think of a better venue than this.

At the end, No. I won't be using the import tool at all. But I would be
putting 15000+ records from multiple microsoft SQL tables into WP
programmatically.

The process will include creating the taxonomies, 1000's of terms under
various taxonomies, and associating existing article's content with
term_taxonomy_id's of the programmatically created terms and assigning
anonymous comments to the posts -- all that programmatically.

So, where and why do I need the importer?

Well, while I do this process, I assume that I will be doing lots of trials
and errors.
I need to go back to a fresh slate many times.
I was trying to simplify the steps so that I don't end up logging into
godaddy, drop the database, wait for the database removal pending, then
install the same named mysql database, wait for the pending set up, wait
for the wordpress to wake up and give me famous 5 min install and all that.

On Mon, Apr 9, 2012 at 8:27 AM, Kevinjohn Gallagher <
kevinjohngallagher at hotmail.com> wrote:

>
> This is one of the great disconnects with WP.Links, in its current state,
> are hardly used anywhere as they work in a simple 1-1 format that no other
> CMS uses.
> Haluk, if you think of WP as a purely blogging-focussed tool (and it
> pretty much was when the importer was built), then this all makes sense.
> If you're thinking of using WP as a CMS, in which you're attempting to
> move a "development"/beta environment data to a live release, then WP
> import is absolutely not the way to go. Sadly, with the hardcoding of the
> URL (and multiple dependancies) in multiple places in database and content;
> the "pushing" of content from one WP install to another on a different
> domain is far from easy, but it's not too complex either (just don't think
> you can search/replace either thats a recipe for a disaster).
>
>
> Kevinjohn Gallagher
> +44 (0) 7788 718382
> KevinjohnGallagher at hotmail.com
> http://www.kevinjohngallagher.com
> http://www.linkedin.com/in/kevinjohngallagher
>
>
>
>
> > From: ipstenu at ipstenu.org
> > Date: Mon, 9 Apr 2012 09:13:24 -0500
> > To: wp-hackers at lists.automattic.com
> > Subject: Re: [wp-hackers] wordpress import. does it really work?
> >
> > Links aren't posts, and while I happen to agree with you, you'll note
> they're in their own table. The export tool is pretty clear on saying it
> exports posts, pages, comments, custom fields, categories and tags. It
> never says links. So ... Yeah, I agree it's frustrating, but it's a bit of
> the old RTFM.
> >
> > As for why you don't get the page... I have no idea. Are you SURE you're
> exporting everything and not just posts? There are options for All, Posts,
> Pages, and your CPTs.
> >
> >
> > On Apr 9, 2012, at 8:38 AM, Haluk Karamete <halukkaramete at gmail.com>
> wrote:
> >
> > > Why on earth it's called an import utility and does not the job they
> way it
> > > is expected to do?
> > > To least, I thought it will either not work at all, or it will truly
> bring
> > > the database structure to "exactly" to the state that when .xml
> generated.
> > >
> > > And any idea of where the wp-post's ID 2 go?
> > >
> > > Does mySQL's "TRUNCATE" also has its own weird logic that sometimes
> after
> > > the truncate, you cannot really, truly start from a fresh slate and
> your
> > > previous database structure will somehow haunt again?
> > >
> > >
> > > On Mon, Apr 9, 2012 at 4:16 AM, Mika A Epstein <ipstenu at ipstenu.org>
> wrote:
> > >
> > >> Yes it works, no it doesn't import your links.
> > >>
> > >> http://en.support.wordpress.com/blogroll/import-export-links/
> > >>
> > >> Works the same way on .org installs.
> > >>
> > >> On Apr 8, 2012, at 11:42 PM, Haluk Karamete <halukkaramete at gmail.com>
> > >> wrote:
> > >>
> > >>> Doesn't wordpress importer ( 0.6 )  import the links?
> > >>>
> > >>> I've been trying for the second time, that the exported wordpress
> does
> > >> not
> > >>> contain any of the original 7 links that comes with the frsh install.
> > >>>
> > >>> My test environment is as follows.
> > >>>
> > >>> get a fresh install.
> > >>> make an xml backup ( export ) of it as backup.xml
> > >>>
> > >>> add a few links, posts, tags, taxonomies....
> > >>>
> > >>> then run
> > >>>
> > >>> TRUNCATE TABLE wp_links
> > >>> TRUNCATE TABLE wp_posts
> > >>> TRUNCATE TABLE wp_terms
> > >>> TRUNCATE TABLE wp_term_taxonomy
> > >>> TRUNCATE TABLE wp_term_relationships
> > >>>
> > >>> this literally clears the mentioned 5 tables.
> > >>>
> > >>> then run the wordpress importer plugin and point to backup.xml
> > >>>
> > >>> As a result, I get the hello world, the uncategorized category and
> that's
> > >>> about it,.
> > >>>
> > >>>
> > >>> I check out the wp_terms, wp_term_taxonomy, wp_term_relationships
> tables.
> > >>> NADA. 0 records in there.
> > >>>
> > >>> I check out the wp_posts and I get 3 records in there, with ID's 1,3
> and
> > >> 4.
> > >>>
> > >>
> > > _______________________________________________
> > > wp-hackers mailing list
> > > wp-hackers at lists.automattic.com
> > > http://lists.automattic.com/mailman/listinfo/wp-hackers
> > _______________________________________________
> > wp-hackers mailing list
> > wp-hackers at lists.automattic.com
> > http://lists.automattic.com/mailman/listinfo/wp-hackers
>
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>