This discussion is archived
9 Replies Latest reply: Mar 12, 2013 12:04 PM by KenWaters RSS

Checkout predefined list of resources?

KenWaters Newbie
Currently Being Moderated
Hi all,

I have recently been exploring the vast array of utilities documaker has to offer. It got me wondering if there is a method to extract a predefined list of resources. We often use an external database that we had documented to filter groups of forms at a time and checking them out one at a time is extremely tedious.

Thank you

Ken
  • 1. Re: Checkout predefined list of resources?
    AndyLittle Explorer
    Currently Being Moderated
    Hi Ken,

    You want LBYPROC. This tool allows you to perform library operations via a scripted file. Have a look here: http://docs.oracle.com/cd/E16256_01/dtb_book.pdf, page 143. Specifically mentioned: extraction of resources - page 149.

    Enjoy!

    -Andy
  • 2. Re: Checkout predefined list of resources?
    KenWaters Newbie
    Currently Being Moderated
    Thank you Andy. I was actually trying to get this working and seem to be running into an issue. It doesnt seem to do anything leading me to believe my syntax is off or something.

    My .cmd file is as follows:
    C:\FAP\DLL>lbyproc /i=C:\StudioWorkspaces\PD5\Extract\ext3.lsc

    It should be pointing to my library script containing the following:
    <LBYSCRIPT>
    <EXTRACT>
    <LIBRARY VALUE="DEVIDX"/>
    <FILENAME VALUE=""/>
    <NAME VALUE="APPLICATION-AUTO-AL"/>
    <TYPE VALUE="FOR"/>
    <DESC VALUE=""/>
    <VERSION VALUE="all"/>
    <REVISION VALUE="last"/>
    <USERID VALUE=""/>
    <EFFDATE VALUE=""/>
    <MODE VALUE=""/>
    <STATUS VALUE=""/>
    <CLASS VALUE=""/>
    <PROJECT VALUE=""/>
    <ALLLIB VALUE="C:\StudioWorkspaces\PD5\Extract\"/>
    <BDFLIB VALUE=""/>
    <GRPLIB VALUE=""/>
    <FORLIB VALUE=""/>
    <FAPLIB VALUE=""/>
    <DDTLIB VALUE=""/>
    <LOGLIB VALUE=""/>
    <DALLIB VALUE=""/>
    <DEFLIB VALUE=""/>
    <LONGFILENAME VALUE="No"/>
    </EXTRACT>
    </LBYSCRIPT>



    Perhaps you might see where my problem is?

    Thank you!
  • 3. Re: Checkout predefined list of resources?
    AndyLittle Explorer
    Currently Being Moderated
    Ken -

    I'm using 12.1, here's what works for me:
    <DOCUMENT TYPE="RPWIP" VERSION="12.1">
    <LBYSCRIPT>
    <EXTRACT>
    <LIBRARY VALUE="Correspondence"/>
    <FILENAME VALUE=""/>
    <NAME VALUE="AM-LI-845"/>
    <TYPE VALUE="FOR"/>
    <DESC VALUE=""/>
    <VERSION VALUE="last"/>
    <REVISION VALUE="last"/>
    <USERID VALUE=""/>
    <EFFDATE VALUE=""/>
    <MODE VALUE=""/>
    <STATUS VALUE=""/>
    <CLASS VALUE=""/>
    <PROJECT VALUE=""/>
    <ALLLIB VALUE=".\ext\"/>
    <LONGFILENAME VALUE="N"/>
    </EXTRACT>
    </LBYSCRIPT>
    </DOCUMENT>
    Command Line:
    lbyproc /i=test2.lsc /ini=fsiuser.ini /t /x
    Results:
    --- LBYPROC Copyright (C) 1998, 2012, Oracle. All rights reserved.
    --- Documaker library script processor


    PROCESSING EXTRACT
    ------------------

    EXTRACT Successful. Filename<.\ext\AM-LI-845.for> Name<AM-LI-845> Type<FOR> Ver<00001> Rev<00001> Note<File replaced>

    Extract performed. The following number of objects were extracted from the library.

    LIBRARY: Correspondence

    BDFs : 0 Extracted: 0 Not Extracted
    GRPs : 0 Extracted: 0 Not Extracted
    FORs : 1 Extracted: 0 Not Extracted
    FAPs : 0 Extracted: 0 Not Extracted
    DDTs : 0 Extracted: 0 Not Extracted
    LOGs : 0 Extracted: 0 Not Extracted
    DALs : 0 Extracted: 0 Not Extracted
    XDDs : 0 Extracted: 0 Not Extracted
    PARs : 0 Extracted: 0 Not Extracted
    PSLs : 0 Extracted: 0 Not Extracted
    STYs : 0 Extracted: 0 Not Extracted
    TLKs : 0 Extracted: 0 Not Extracted
    TPLs : 0 Extracted: 0 Not Extracted
    ---------------------------------------
    Total: 1 0


    --- LBYPROC Complete ---
    I suspect you were missing the /x parameter on the command line telling the tool to do the extraction. Note: you can also generate these scripts out of Studio using the Filter/Search tab - there's a button to save the filter as an LSC file.
    --Andy

    Edited by: Andy Little on Mar 12, 2013 11:58 AM - added the results of LBYPROC
  • 4. Re: Checkout predefined list of resources?
    KenWaters Newbie
    Currently Being Moderated
    That got me able to execute it. Now I have some errors lol.

    1. Tue Mar 12 12:07:14.943 2013 pid=00005584 * UTLDefErrorExit * ..\C\fapobjct.c
    Nov 12 2011 17:34:58
    12,0,1,15380 <15> <1074921473> Version number is not in sync with core library.

    2. Tue Mar 12 12:07:14.943 2013 pid=00005584 * UTLDefErrorExit * Executable:<C:\FAP\DLL\LBYPROC.EXE>
    version <Mar 18 2012 13:47:08 11,5,4,704>
    <15> <1074876420> Version number is not in sync with core library.

    Proceeding to investigate.

    I think my installation of studio may differ from the files im using. Going to try reinstalling.

    Edited by: Ken Waters on Mar 12, 2013 9:14 AM
  • 5. Re: Checkout predefined list of resources?
    KenWaters Newbie
    Currently Being Moderated
    Now im getting simply the following:

    1. Tue Mar 12 12:37:33.750 2013 pid=00002188 LBYPROC: User entered the following command:
    2. Tue Mar 12 12:37:33.750 2013 pid=00002188 lbyproc /i=ext3.lsc /t /x


    hrm... :-/ not sure what else to try.
  • 6. Re: Checkout predefined list of resources?
    AndyLittle Explorer
    Currently Being Moderated
    Ken Waters wrote:
    Now im getting simply the following:

    1. Tue Mar 12 12:37:33.750 2013 pid=00002188 LBYPROC: User entered the following command:
    2. Tue Mar 12 12:37:33.750 2013 pid=00002188 lbyproc /i=ext3.lsc /t /x


    hrm... :-/ not sure what else to try.
    Make sure you're running from a directory that has the fsiuser.ini file in it - also ensure that your PATH environment variable doesn't include any older versions which might be getting invoked instead of the newer version.

    I tested this with a library created in Studio 12.1, using LBYPROC from 12.1.

    -Andy
  • 7. Re: Checkout predefined list of resources?
    KenWaters Newbie
    Currently Being Moderated
    Great! I am almost there. I managed to extract a single resource. Is there a way to do an entire list of forms? I tried entering a few more <NAME> blocks with my other forms but that didnt fly.
  • 8. Re: Checkout predefined list of resources?
    AndyLittle Explorer
    Currently Being Moderated
    Couple of ways:
    1. Use a classifying element like PROJECT to group those items you want to get, then specify <PROJECT VALUE="MyProject"> in the LSC script.
    2. Use wild cards (<NAME VALUE="MYFO*"> would capture forms name MYFORM and MYFORM1, etc)
    3. Use multiple LSC scripts and create a batch file to run multiple LBYPROCs.
  • 9. Re: Checkout predefined list of resources?
    KenWaters Newbie
    Currently Being Moderated
    Gotcha, I started on a similar approach to option 3. Going to create a little utility to read in a list from a text file and spit out all the forms.
    Thanks a ton Andy! You have been immensely helpful!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points