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 4054 posts 12927 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

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies