Friday, January 4, 2013

If a Tree Fell in the Woods, Would It Lose Its Metadata?


An under-emphasized feature in Content Server metadata is the use of a path analogy to hold meaningful data. 

Most implementations use Contribution Folders to provide a file system-like path to an item, when a path is needed.  What happens if a document really needs to exist on multiple paths?  Yes, you could create multiple copies of the document, and put a copy in in each folder, but that makes maintaining the content difficult.

To address this shortcoming, many implementations add additional metadata fields to hold data to emulate other paths.  Dependent choice lists (“DCLs”) are a popular way to sort and categorize this extra data, but even DCLs have a problem when a document needs multiple sets of data applied to it.  Eventually, a lot of extra metadata elements get introduced in the metadata model, often nearly identical to existing fields, resulting in confusion (“Which set of DCLs do I need to fill out to get the new HR policy to show up for both Minneapolis and San Francisco?”)
Content Server metadata fields can be configured to use “trees” to store various different path analogies.  This makes storing multiple paths very easy, with fewer overall fields than traditional DCLs
Let’s take a walk through the forest.
In this example, I’m using states and cities, although I can easily use other DCL/relational data.


·         Create a schema table called “tblStates” with two columns, “stateID” and “stateName”.  “stateID” will hold the two character state abbreviation, and “stateName” will hold the full name of the state (shown later).   Create a view in Configuration Manager that exposes all columns in the table as shown.  On the “Options” tab in the view, select the “Is Sorted on Database” option, and sort the view on the stateName column. 









·         Create a schema table called “tblCities” with three columns, “cityID”, “stateID” and “cityName”. “cityID” in this case holds the airport code for the city, “stateID” will hold the two character state abbreviation where the city is located, and “cityName” will hold the full name of the city.  Create a view in Configuration Manager that exposes all columns in the table as shown.  On the “Options” tab in the view, select the “Is Sorted on Database” option, and sort the view on the “cityName” column.







·         Create a relationship in Configuration Manager that ties the states table and the cities table on the “stateID” column in each table.



·         Now create a new “memo” metadata field in Configuration Manager, called “xStateCity”.  Make this field an option list.  When configuring the source of the option list, select “Use Tree”, then select the view of the state table,




then the relationship connecting the state and city views,





and finally, select the view with the city data, if it’s not already filled in by selecting the relationship.


·         
Check the two options at the bottom of the dialog that says “Show complete selection path” and “Store complete selection path”.  Use “/” as the path separator.


·        Now when viewing the checkin page, a “Select” button is displayed instead of a typical input field for the field xCityState.


·         Clicking the select button shows a popup as shown.


·         
Expanding each state shows the cities underneath.  Clicking the city adds the city as the selected option as shown.


·         Clicking OK populates the checkin page with the selected value.


·         If the field is configured as a multi-select option list, multiple cities can be selected as shown below.




·         The actual values are stored in a path analogy, i.e. “San Francisco” is stored as “CA/SFO”, so the entire value is actually stored as “CA/SFO, MN/MSP”, but San Francisco and Minneapolis are displayed. 
·         Any option displayed in the tree is a valid choice.  For example, to add a STATE, simply click on the state name, instead of the city.  This is very powerful in being able create flexible path analogies.
Hopefully, this example will let you see the forest of possibilities BECAUSE of the trees.

39 comments:

  1. Apple iPad Mini 5 has the foldable function. The iPad Mini 5 comes after an extensive gap; let’s follow our site for know more about the upcoming version of Apple iPad is iPad Mini 5.

    ReplyDelete
  2. If you check out here you will find some awesome tips that may be really helpful to you next time you gonna need to write an essay about American dream. Good luck

    ReplyDelete
  3. I am glad to see this brilliant post, all the details are very helpful and useful for us, keep up to good work. driving directions

    ReplyDelete
  4. Thanks for Nice and Informative Post. This article is really contains lot more information about This Topic
    gmail sign up

    ReplyDelete
  5. The effects from Js Famous Kush provide a euphoric burst that is surprisingly uplifting for a strain dominated by indica genetics. Lemon Thai adds its own touch of citrus flavors and uplifting effects. The resulting hybrid provides an intense and fast-hitting high coupled with dreamy euphoria https://nobullshitseeds.com & https://lizavetacbd.com

    ReplyDelete


  6. If You are looking for something different, then I am ready. Escorts Service in Aerocity I am well educated, have an open mind and have the girlish charm that Is fun and easy to be found. You will always find me smart, clean and fresh as I am very conscientious about my hygiene and I expect all my clients to reciprocate in the same manner. Check our other Services...
    Escorts Service in Aerocity
    Escorts Service in Aerocity
    Escorts Service in Aerocity
    Escorts Service in Aerocity
    Escorts Service in Aerocity

    ReplyDelete
  7. Yes! South Africans can play Mega Millions and other US lotteries online and win jackpots with records of over $1.5 BILLION https://lottoalotto.co.za

    ReplyDelete
  8. If you check out Newixfrancia
    you will find some awesome tips that may be really helpful to you next time you gonna need to write an essay about American dream. Good luck

    ReplyDelete
  9. Thanks for Nice and Informative Post. Newixfrancia This article is really contains lot more information about This Topic

    ReplyDelete
  10. thanks for sharing this! really interesting and helpful post. Aviabiletebi

    ReplyDelete
  11. Thank you so much for this excellent Post and all the best for your future. windousis gadayenebaI hope you and we will be sharing more thoughts and keep writing more like this one.

    ReplyDelete
  12. Thank you so much for this excellent Post Tortebi and all the best for your future. I hope you and we will be sharing more thoughts and keep writing more like this one.

    ReplyDelete
  13. hope you and down or not we will be sharing more thoughts and keep writing more like this one.

    ReplyDelete
  14. Quality articles is the secret to attract
    the visitors to go to see the site, that’s what this website is providing.

    온라인카지노
    카지노

    ReplyDelete
  15. Keep up the wonderful piece of work, I read few content on this site and I conceive that your blog is very interesting and holds bands
    of good information.

    토토
    먹튀검증

    ReplyDelete
  16. Just ɑ smiling visitor һere to share the love (:, btw outstanding design.

    Loօk at my web-site;

    카지노사이트
    바카라사이트

    ReplyDelete
  17. Thanks for sharing the information it will helps others to gain information...

    gmail

    ReplyDelete
  18. That's a really impressive new idea! 메이저토토사이트추천 It touched me a lot. I would love to hear your opinion on my site. Please come to the site I run once and leave a comment. Thank you.

    ReplyDelete
  19. What a post I've been looking for! I'm very happy to finally read this post. 안전놀이터 Thank you very much. Can I refer to your post on my website? Your post touched me a lot and helped me a lot. If you have any questions, please visit my site and read what kind of posts I am posting. I am sure it will be interesting.

    ReplyDelete
  20. Aw, this was a very good post. Taking the time and actual effort to create a good article… but what can I say… I put things off a whole lot and never seem to get nearly anything done Feel free to visit my website; 먹튀검증

    ReplyDelete
  21. I am a fan of reading to add insight to information. Thank you for this great blog. this is here, the few months I am visiting and following you. What I really like about you is that your writing style. Feel free to visit my website; 바카라사이트

    ReplyDelete
  22. You make so many great points here that I read your article a couple of times. Your views are in accordance with my own for the most part. This is great content for your readers. Feel free to visit my website; 바카라사이트

    ReplyDelete
  23. I was very pleased to find this page. I wanted to thank you for your time due to this wonderful read!! I definitely loved every part of it and I have you bookmarked to check out new information on your blog. Feel free to visit my website; 토토사이트

    ReplyDelete
  24. Very informative and useful post thanks for sharing. kisscartoon

    ReplyDelete
  25. Such an informative information thanks for sharing it out...
    bank of america

    ReplyDelete
  26. Thanks for sharing it out man I am now very clear about metadata thanks for sharing it out hope to see more informative and useful information by you...
    www.hotmail.com

    ReplyDelete
  27. I was recommended this web site by my cousin. I’m
    not sure whether this post is written by him as nobody else
    know such detailed about my difficulty. You’re wonderful! Thanks!


    https://www.safetotosite.pro

    ReplyDelete
  28. I accidentally searched and visited your site. I still saw several posts during my visit, but the text was neat and readable. I will quote this post and post it on my blog. Would you like to visit my blog later? keonha cai


    ReplyDelete
  29. Thanks for sharing excellent informations. Your web-site is very cool. I’m impressed by the details that you have on this site. It reveals how nicely you understand this subject. Bookmarked this web page, will come back for more articles. 온라인카지노사이트
    You, my pal, ROCK! I found simply the information I already searched all over the place and simply couldn’t come across. What a great web-site.

    ReplyDelete
  30. Incredible post I should state and much obliged for the data. Instruction is unquestionably a sticky subject. Be that as it may, is still among the main themes of our opportunity. 카지노사이트홈
    I value your post and anticipate more.

    ReplyDelete
  31. I just came right here via a different page relating to kik messenger free and imagined I might as well read this. I really like what I see therefore now I”m following you. Getting excited about looking over your blog yet again. 토토365프로


    ReplyDelete
  32. 안전놀이터 I feel this is among the most vital info for me. And i am happy reading your article. But want to remark on few general things, The web site taste is perfect, the articles is in point of fact great : D. Excellent task, cheers

    ReplyDelete
  33. That's a really impressive new idea! casino api It touched me a lot. I would love to hear your opinion on my site. Please come to the site I run once and leave a comment. Thank you.


    ReplyDelete