Thread

I have a potential client that wants to overhaul their site and is very interested in ExpressionEngine, possibly EE 2.0. Their current site was built in ‘99 with Classic ASP and has an enormous amount of content that I guess is coming from either an Excel or SQL Server database. My question is, does anyone know of a way to import all of this data into EE weblogs/channels? I can’t possibly see manually importing into new EE weblogs. I’ve seen the CSVGrab plugin, but I’m not sure if that actually imports the data into weblogs or just displays it from a template. I also can’t find any plugins that will at least convert a CSV file into MovableType format, so I can use EE’s built-in MovableType importer.

Thank you

I’ve seen the CSVGrab plugin, but I’m not sure if that actually imports the data into weblogs or just displays it from a template.

I haven’t used CSVGrab but I have used XMLGrab from the same author and it has worked very well for me. It’s an interesting Add-on because it requires you to load a template to run the conversion which is odd to me. Regardless, it takes your data and loads it into the EE database. I’ve used it on about 3 or 4 sites so far importing from other systems (wordpress, proprietary stuff, etc) and after a few tests I had it down just fine. After the import I can edit my data just fine in the EE control panel and access it with {exp} tags like you would expect. Have you run any small scale tests with it? Perhaps trying to import a few entries just to get everything mapped our correctly

Great, thanks Erik! I’m definitely going to check XMLGrab out since it seems that’ll get the data into the weblogs. I appreciate the reply.

-Ira