OnDemand Users Group

Support Forums => CMOD for Multiplatforms => Topic started by: rstockton on July 03, 2014, 04:39:53 PM

Title: Using ARSDOC GET with an input file for multiple retrievals
Post by: rstockton on July 03, 2014, 04:39:53 PM
Does anyone have a script or process to use ARSDOC GET with an input file to get mutiple retrievals using index values?  We ocassionally have request for large number of retrievals for particular documents and we are given a list with Index information.

Thanks,

Russell
Title: Re: Using ARSDOC GET with an input file for multiple retrievals
Post by: LWagner on July 16, 2014, 04:01:59 PM
The joy of getting this to work was just not there, so I save you the grief.

command file sample:
arsdoc get -h <instance-name-ip-address>   -u uid -p passwd -F <parameter file> -v  2>>c:\HACLA\LOGS\LOG2.HACLA.PDFZos-611.txt
--------
parameter file sample:
[-f "zHACLApdf"] [-o "(INDEX_2)(INDEX_3)(POSTING_DATE)"] [-n] [-d D:\HACLA\PDFzOS] [-i "WHERE INDEX_2 = 'LAB' AND INDEX_3 = '11322G' AND POSTING_DATE > 13939"]
[-f "zHACLApdf"] [-o "(INDEX_2)(INDEX_3)(POSTING_DATE)"] [-n] [-d D:\HACLA\PDFzOS] [-i "WHERE INDEX_2 = 'RAB' AND INDEX_3 = '498012' AND POSTING_DATE > 13939"]
[-f "zHACLApdf"] [-o "(INDEX_2)(INDEX_3)(POSTING_DATE)"] [-n] [-d D:\HACLA\PDFzOS] [-i "WHERE INDEX_2 = 'GIR' AND INDEX_3 = '481845' AND POSTING_DATE > 13939"]
Title: Re: Using ARSDOC GET with an input file for multiple retrievals
Post by: LWagner on July 16, 2014, 04:06:08 PM
A caution, if the column names are used in the output filename, as an example, a  60 character value with the last 50 as spaces, will have those 50 spaces in the filename for that column value. You will ant to have a method of stripping spaces from filenames.

If you can program the retrieval with API calls, do that so you have full control of your output filenames.
Title: Re: Using ARSDOC GET with an input file for multiple retrievals
Post by: rstockton on July 16, 2014, 08:16:59 PM
Thanks.

What is  2>>c:\HACLA\LOGS\LOG2.HACLA.PDFZos-611.txt?.
Title: Re: Using ARSDOC GET with an input file for multiple retrievals
Post by: Justin Derrick on July 17, 2014, 09:49:39 AM
Quote from: rstockton on July 16, 2014, 08:16:59 PM
Thanks.

What is  2>>c:\HACLA\LOGS\LOG2.HACLA.PDFZos-611.txt?.

Windows path.  :)  2>> is Windows-ese for redirecting error messages into the log file as well.
Title: Re: Using ARSDOC GET with an input file for multiple retrievals
Post by: rstockton on July 18, 2014, 02:09:13 PM
Another question.  It appears that the output file name can be either user defined text or DB field names, is there anyway to combine the two? 

Example :  [-o "TestFile"]  or [-o "(INDEX-1)"] 

Thanks,

Russell
Title: Re: Using ARSDOC GET with an input file for multiple retrievals
Post by: LWagner on July 18, 2014, 02:30:38 PM
My recollection is that you have to choose one or the other.
Title: Re: Using ARSDOC GET with an input file for multiple retrievals
Post by: rstockton on July 18, 2014, 03:07:51 PM
That is what I have found with my testing, but was hoping there was a way around it.

Thanks
Title: Re: Using ARSDOC GET with an input file for multiple retrievals
Post by: LWagner on July 18, 2014, 03:29:56 PM
If you use a program and the JAVA API calls, you of course have total freedom in final naming.