Importing external data - HELP! Options
shadow
Posted: Wednesday, March 14, 2007 11:07:55 PM
Rank: Enthusiast

Joined: 3/14/2007
Posts: 20
Hi

This is my first post and hopefully not my last

I have a site going live with Umbraco this week and need to import some external data.

The data has been collected over the last 3 months into an ms-access database so exporting it into a number of formats isn't an issue. But how do I import into Umbraco? The data follows a datatype I've already created.

Any help here would be hugely apperciated (otherwise I've got to enter 800 records this weekend )

Thanks in advance

Andy

PS sorry for second post - I missed the subject both on my first post!!
desmo
Posted: Thursday, March 15, 2007 2:38:22 AM

Rank: Aficionado

Joined: 7/19/2006
Posts: 174
Location: NYC
There are 2 popular ways to do this:

You can write your own library like this:

http://blockquote.be/2006/08/09/extending-umbraco-with-a-library/

OR (this may be easier) use a .aspx page to get your XML and then parse it with
xslt like this:

http://kasperb.dk/2006/6/26/display_your_flickr_images_on_your_umbraco_driven_website.aspx

With the 2nd method, you can do whatever database queries you want, dump out the data in XML format, and you're ready to go.

- Mark
Users browsing this topic
Guest


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.