05-07-2018 12:58 PM
Is there a way to move a Cascading Data Set from UAT to Production? If not how would I format the CSV file to be able to import the parents and children if this is possible?
07-06-2021 03:04 PM
Article #000001474 (hyland.com) implies you cannot really export datasets. I am not sure about the CSV layout for an import. We created a new Test environment and the Cascading datasets did not copy over, so I need to figure out how to export the data from Prod to import into Test.....
/* MS SQL Query - select "parent" and "child" from Cascading Dataset number ###.
Use the pipe (|) or other delimiter to separate values.
Save as a text file and import that into your other environment */
select rtrim(p.keyvaluechar) + '|' + rtrim(c.keyvaluechar)
from hsi.multidataset### p
join hsi.multidataset### c on c.parentnum = p.multikeysetnum
order by p.keyvaluechar, c.keyvaluechar
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.