Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Chris Knowles 141 posts 222 karma points
    Apr 11, 2012 @ 15:02
    Chris Knowles
    0

    Import data to overwrite specific nodes

    Hi,

    i have the following structure in my umbraco site:

    Home
    Continents
    Africa
    Kenya
    Airport
    South Africa
    Airport 1
    Airport 2
    Europe
    United Kingdom
    Heathrow
    Stanstead

    This structure holds info for all airports around the world, each airport item has a value associated with it and i need to find a way of uploading a spreadsheet and for it to update the values.

    What is the best way of doing this and how would i structure the spreadsheet to do this best?

    Thanks
    Chris

    Copy Link
  • Richard Soeteman 4046 posts 12899 karma points MVP 2x
    Apr 11, 2012 @ 15:31
    Richard Soeteman
    0

    Hi Chris, 

    Have you checked out the video on www.cmsimport.com ? I'm using products there but it will be the same for your needs, Basically you need a spreadsheet containing the following worksheets

    • Continent
    • Country (Make sure to include a key to the continent)
    • Airport (Make sure to include a key to the country)
    I assume all data is new and being imported using CMSImport then it will handle updates just fine as long as you specify a key. If you need to update existing data please let me know because that will take some programming of events.
    Cheers,
    Richard
    Copy Link
  • Chris Knowles 141 posts 222 karma points
    Apr 11, 2012 @ 16:15
    Chris Knowles
    0

    Richard,

    I have had a quick look at the video and it is ind of what i want although i have set up all these airports already and i need a quick way of updating them. I guess it should create new ones if they are not there.

    Thanks for your help.

    Chris

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft