ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

How can I mass import blog entries for a product catalog?

December 26, 2007 8:04pm

Subscribe [2]
  • #1 / Dec 26, 2007 8:04pm

    tim594

    21 posts

    Im building a site based on an existing site which has a few hundred products.
    I think using a blog entry per product is the way to go, but EE’s
    control panel web ui is pretty slow for doing that many products.

    Does anyeone know of a tool for importing from text delimited files?
    It would be cool if you could define the custom fields in a tab delim file with
    each row following, being a blog entry.

    If there is no such thing, can anyone build one for me?
    Theres about 12 SQL queries per blog entry, I think you could write one in under 2 hrs.
    I’ll put a bounty on it and pay them. It basically involves posting the info to the correct blog table, and incrementing all the counters.  I dont need a nice UI, just a php file that can be hardcode configured.

    Tim

  • #2 / Dec 26, 2007 8:48pm

    John Fuller

    779 posts

    Use the Moveable Type import tool.  This might take you a few attempts because you have to get the format exactly right.

    Getting the entries into MT format might be a tad tricky depending on your tools.  You could write a script that would output each of your old entries into the MT format.  If you are not good with scripting and regular expressions then you can use a spreadsheet.

    When I get lazy I even put everything in a horizontal MT format in my spreadsheets and then insert HTML breaks where each line break would be.  I then copy the entire spreadsheet and paste it into an HTML file.  I then open the file in Firefox and the vertical format shows up properly because of the HTML breaks.  I then copy the rendered text and paste it into another text file and upload the text file for importing.  This may seem silly but it saves me from having to write scripts.  😉

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases