While the jobs are published to a section whose id is passed in the configuration, it is necessary to create a XML file that maps the Gemstone Classifications to their corresponding “section ids” in VirtualCMS. This is a manual process, helped by the XSLT files in the “util” sub-folder of the installation package.

1.Download the list of sections from VirtualCom. This is done by navigating to: http://XXXX/GNWebDo.jsp?cmd=getsections&format=xml (where XXXX is the website’s URL) and by saving the results to a XML file (call it VCSections.xml)

2.Obtain from Gemstone the list of classifications via this SQL query on the Gemstone database:

select 

short_name, long_name 

from 

classification 

where 

discontinue_date is null 

for xml raw ('classification'), ROOT

Save the results as GemstoneClassifications.xml

3.Apply to the GemstoneClassifications.xml the XSLT MergeGemstoneVirtualCMS.xsl with an XSL processor, and save the resulting file as LineageMappingTable.xml. Note that the XSLT loads the file VCSections.xml: make sure they are all in the same folder (or hard-code the path)

4.Copy this file in the workflow (wf_createVCAds.xml) assigning it to the variable:

Dim ClassificationMap As XElement

5.Re-import the workflow.