topic Question on using the Batch Export Tool to export (Folder Objects) (DI Studio/Management Console) in SAS Data Management

Question on using the Batch Export Tool to export (Folder Objects) (DI Studio/Management Console)

r_d — Tue, 05 Dec 2017 12:07:10 GMT

Hello,

I have googled far and wide to no avail. I am using the Batch Export Tool (http://documentation.sas.com/?docsetId=bisag&docsetTarget=n008xsxs34mvcwn1qrgcmugpzu6i.htm&docsetVersion=9.4&locale=en#n01c236lnwpclgn1g39ppo1tc19u).

I can successfully use the tool no problem. But I am having an issue in getting 'Folder Objects'.

Using the export wizard in DI Studio or Management console, I can right click at the highest folder level and create an export package. If I then select a job, then it will be exported along with all the above folder objects.

Using the Batch Export Tool, I cannot find that I can do the same thing. I can select jobs and export them, but it doesn't include the above folder objects. I can select the folder the job is in, and just choose to export jobs (-types Job), but it exports every job in the folder (not what I need, some folders are massive). Lastly, I have tried to export the job, and then separately export the folder, but the option '-types Folder' is not valid.

In the end I am trying to achieve a package that can be imported, using the import tool, to a target folder, and within that target folder it keeps the same folder path down to the job (this can be achieved using the manual wizards).

Thanks in advance!

Re: Question on using the Batch Export Tool to export (Folder Objects) (DI Studio/Management Console

r_d — Tue, 05 Dec 2017 13:59:05 GMT

As usual... I've answered this myself immediately after asking

The solution is.... List the folder path first, e.g. -objects "/Top Folder/My Folder/Daily/" "/Top Folder/My Folder/Daily/Job_Name(Job)" -subprop -types Job

This seems to have the effect that, you select the 'Folder Object', you then say exactly which jobs in the folder you want. I'd tried it the wrong way round

Re: Question on using the Batch Export Tool to export (Folder Objects) (DI Studio/Management Console

BrunoMueller — Tue, 05 Dec 2017 14:03:35 GMT

Please provide the commands you have tried. The ExportPackage has an option to specify a name pattern you may also explicitly specify the object your interested in.

Here is an example using the -name option

ExportPackage.exe -profile <yourProfile> -package "c:\temp\test.spk" -objects "/shared data/stp_samples"  -includeEmptyFolders -name display -nameMatchType STARTSWITH