Recent posts

#71
CMOD for i / Re: Resources or help with the...
Last post by tomondemand - November 12, 2024, 12:08:22 PM
Thank you. I have a on demand application that appears to be setup correctly, comparing the setup to another functioning one. It will not go to on demand though. The system log does not show anything other than the log on and log off. Is there a file somewhere that I can query that shows more detail? Or is there somewhere that explains  the purpose of the files? Thank you.
#72
CMOD for i / Re: Resources or help with the...
Last post by Darrell Bryant - November 11, 2024, 05:42:56 PM
My apologies for the typo.
You use the Print Text (PRTTXTOND) command to determine how the spooled file appears to the 400 indexer. 
If you use the graphical indexer in the OnDemand Administrator client to view a spooled file and create / modify indexer parameters, Print Text is run in the background to create the sample data file which is then automatically downloaded to the PC.  Retrieving sample data from the Administrator client requires having IBM i Access Client Solutions and the accompanying Windows Application Package installed.  If you don't have those installed or have trouble with them, you can use the Print Text command with the Stream file (STMF) parameter to send the output to a stream file on your IBM i system.  That steam file can then be downloaded to the PC and used as input to the graphical indexer.

The quarterly OnDemand Newsletter has lots of great information about OnDemand on all platforms.  You can find all previous newsletters at:
https://www.ibm.com/support/pages/node/628001

The 3rd quarter 2016 newsletter, on page 5, has a tip entitled 'Creating sample data for a complete spooled file' which contains a good explanation of using the Print Text command and manually downloading the output to the PC.

If you would like to receive the newsletters as they come out, send me a note. darrell.bryant@unicomsi.com
#73
CMOD for i / Re: Resources or help with the...
Last post by tomondemand - November 08, 2024, 06:36:14 PM


It does and thank you for taking the time to do that. Searching through the manuals, I discovered some of that. Trigger 2 makes sense, it is looking for fiscal year. But Trigger3 (you accidently called it 2), is searching for a period, and this is in an address. It always stops on the CSZ line and uses that instead of the name. Even if there is a period in the name and first address. Here is a good example,
Innovative Ag Services Co.

2010 S Main St.

Monticello         ,IA 52310

It indexes the City State and zip. In this example there is a period. But in others, no period exists and it still shows city state zip.
I have tried moving the record range around, but end up with blanks then. Also searching for a blank, and it went way down to the bottom and picked up an amount.

QUESTION: Do you use the spool file entry to determine the lines in the Recordrange?
#74
CMOD for i / Re: Resources or help with the...
Last post by Darrell Bryant - November 08, 2024, 05:24:48 PM
Looking only at the relevant indexing information:

TRIGGER1=*,1,X'F1',(TYPE=GROUP)                          /* 1      */
TRIGGER2=*,*,X'61F2F0',(TYPE=GROUP,RECORDRANGE=(1,4))    /* /20    */
TRIGGER3=*,23,X'4B',(TYPE=GROUP,RECORDRANGE=(2,6))       /* .      */
FIELD2=0,-4,9,(TRIGGER=2,BASE=TRIGGER)
FIELD3=4,-12,35,(TRIGGER=3,BASE=TRIGGER)
INDEX2=X'A8858199',FIELD2,(TYPE=GROUP,BREAK=YES)         /* year   */
INDEX3=X'8595A389A3A8',FIELD3,(TYPE=GROUP,BREAK=YES)     /* entity */

Trigger 1 is carriage control (hex F1) for start of new page. Once that is found by the indexer the other triggers will be searched for.  (Hex F1 is at the top of every page, it is not the ideal trigger 1, but that is a topic for another day)

Trigger 2 is the string '/20' (w/o quotes).  It is searched for in any row and column (that is the meaning of *,*) in a range of records from 1 to 4 rows below trigger 1.  Once it is found searching stops (i.e. if it exists more than once in those rows, only the first one is used)

Trigger 2 is the period character.  It is searched for in column 23 in a range of records from 2 to 6 rows below trigger 1.  Once it is found searching stops (i.e. if it exists more than once in those rows, only the first one is used)

Field 2 is located using trigger 2.  It is located relative to trigger 2 (that is the meaning of BASE=TRIGGER).  It is located on the same row as trigger 2, and 4 columns before the start of trigger 2.  (That is the 0,-4 on the parameter). The length of the field is 9 characters.

Field 3 is located using trigger 3.  It is located relative to trigger 3.  It is located 4 rows below trigger 3, and 12 columns before the start of trigger 3.  (That is the 4,-12 on the parameter). The length of the field is 35 characters.

Index 2 is composed of the contents of field 2.  The field name is year.  The break equal YES means that if this value changes a new document is started.

Index 3 is composed of the contents of field 3.  The field name is entity.  The break equal YES means that if this value changes a new document is started.

If the report layout was changed and the location of the field(s) moved on the page, the indexer parameter must be updated to capture the data at its new location.

I hope this quick overview helps.
#75
CMOD for Multiplatforms / Re: How to generate index file...
Last post by Justin Derrick - November 08, 2024, 02:10:32 PM
I'm not familiar with IBM RPA, so I don't know if it could be integrated into your OCR system.  That sounds like a question for IBM.

-JD.
#76
CMOD for Multiplatforms / Re: ARSLSYNC Question
Last post by Justin Derrick - November 08, 2024, 02:07:27 PM
Please use our enhancements forum instead, so we can present the item to IBM as part of the next Enhancements Discussion with IBM.
#77
CMOD for Multiplatforms / Re: ARSLSYNC Question
Last post by mayank81089 - November 08, 2024, 11:42:55 AM
Quote from: PostWagon70-1 on November 08, 2024, 11:25:30 AMHi ,  we are also implementing ARSLSYNC and have the same issue.  We would like to have more information from the user in the ldap into the CMOD user administration.  The company is using a unique id for every employee and uses that f.e. in audit logging (custom made for CMOD via an exit).  Currently we are thinking about writing an extra script to  get that unique id and put it into the cmod usertable but it would far better solution if we can do it in one go with ARSLSYNC.  It would be nice if we could map at leasted 5 attributes from ldap to CMOD user administration.

How can we make this wish known to  IBM? How can we make an enhancement to IBM to request for this?

Lets post your query at below IBM portal for them to consider and it has the facility for people to vote for this idea

https://ibm-data-and-ai.ideas.ibm.com/
#78
CMOD for Multiplatforms / Re: How to generate index file...
Last post by mayank81089 - November 08, 2024, 11:30:25 AM
Thanks Justin ,yes we have the OCR solution that we use for physical documents and it is done through a scanning application.

The IBM RPA bot process was used to reading through all 30K doc files to produce metadata for documents in Generic Index Format before loading happens.

Our thought process is if we can leverage the IBM RPA bot with OCR capability to process scanned images to generate generic index format before loading happens.

Mayank

#79
CMOD for Multiplatforms / Re: ARSLSYNC Question
Last post by PostWagon70-1 - November 08, 2024, 11:25:30 AM
Hi ,  we are also implementing ARSLSYNC and have the same issue.  We would like to have more information from the user in the ldap into the CMOD user administration.  The company is using a unique id for every employee and uses that f.e. in audit logging (custom made for CMOD via an exit).  Currently we are thinking about writing an extra script to  get that unique id and put it into the cmod usertable but it would far better solution if we can do it in one go with ARSLSYNC.  It would be nice if we could map at leasted 5 attributes from ldap to CMOD user administration.

How can we make this wish known to  IBM? How can we make an enhancement to IBM to request for this? 
#80
CMOD for i / Re: Resources or help with the...
Last post by tomondemand - November 07, 2024, 09:21:52 PM
Thank you. Still struggling with how stuff gets indexed. I am sure a one sentence answer from a former employee who did this could clear it up for me.