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.....
@Nate E , I didn't have time to follow up last July, but we built a new Test environment and decided we needed to get this done. For a simple Cascading Dataset (just two keytypes), you can use a query like the following to gather the data from one environment to import into another:
/* 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
