Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

Welcome to the CollectiveAccess support forum! Here the developers and community answer questions related to use of the software. Please include the following information in every new issue posted here:

  1. Version of the software that is used, along with browser and version

  2. If the issue pertains to Providence, Pawtucket or both

  3. What steps you’ve taken to try to resolve the issue

  4. Screenshots demonstrating the issue

  5. The relevant sections of your installation profile or configuration including the codes and settings defined for your local elements.


If your question pertains to data import or export, please also include:

  1. Data sample

  2. Your mapping


Answers may be delayed for posts that do not include sufficient information.

Importing Parks Canada Taxonomy

edited June 2013 in Installation
I would like to import a hierarchical taxonomy (Parks Canada) into a CA list, via a script. Tab delimited data looks like this except there are 6500 records:

Nomenclature Code Category English Category French Category Code Class English Class French Class Code English Term French Term French Grammatical Gender
01-00001 STRUCTURES CONSTRUCTION ET ÉLÉMENTS DISTINCTIFS 1 BUILDING BÂTIMENT A020 TENT TENTE f

Resulting in a hierarchical list like this:

Category1 (Facet)
-Class1 (Guide term)
--Subject Term1 (Concept)
--Subject Term2 (Concept)
-Class2 (Guide term)
--Subject Term3 (Concept)
--Subject Term4 (Concept)
Category2 (Facet)
-Class3 (Guide term)
--Subject Term5 (Concept)
--Subject Term6 (Concept)
-Class4 (Guide term)
--Subject Term7 (Concept)
--Subject Term8 (Concept)
Etc.

Anyone have a script that does this or something close? Thanks!

Jon

Comments

  • Can you give us the data to look at?
  • We ended up linking to the CA tables using MS Access and wrote some Access SQL "Insert" queries to populate the CA list tables from the backend. Seemed to work fine. Thanks.
Sign In or Register to comment.