OnDemand User Group

Support Forums => Report Indexing => Topic started by: Steve Lance on August 22, 2018, 12:23:22 PM

Title: Load from ARSDOC GET
Post by: Steve Lance on August 22, 2018, 12:23:22 PM

I did an ARSDOC GET and received a document file and an index file.  They seem to be in binary.  What can I do to get them in a readable format?

Also, when I try to load the files, I am receiving an error "" not in Y-m-d format.  I change the format in the application to m/d/Y and receive "2018-08-20" not in m/d/Y format.  Any suggestions on how I can correct the error?

Title: Re: Load from ARSDOC GET
Post by: Stephen McNulty on August 23, 2018, 04:33:07 AM

what is the Data Type for the document that you are Getting?    (check Application definition, view information tab).  In our shop it would normally be AFP, so I would just change the document file extension to .afp and use an AFP viewer.

for the date format question, you need to update the application (change the Application, Load information tab). Change the Format of your date field to %Y-%m-%d  (or when in the field, press help, then choose Date and Time formats, they will all be listed)

Title: Re: Load from ARSDOC GET
Post by: Steve Lance on September 05, 2018, 09:13:27 AM

I found the problem but I don't have a solution.  I have three date/time indexes.  The last index was added a few weeks ago.  So, the documents I am trying to load do not have a date/time for this last index.  That is why I am getting "" could not be converted to a date from the format of %Y-%m-%d %T.  I changed the Application to accept the current date/time but that did not work.  Any suggestions?

Title: Re: Load from ARSDOC GET
Post by: Greg Ira on September 05, 2018, 10:46:42 AM

Did you try setting a default value for that last date/time index?

Title: Re: Load from ARSDOC GET
Post by: Steve Lance on September 05, 2018, 11:06:52 AM

I did default to the current date/time and that did not work.

Title: Re: Load from ARSDOC GET
Post by: Greg Ira on September 05, 2018, 12:26:07 PM

Did you use the 't' in the client or add the default parm to the indexing?
On multiplatform you can do the following to pull in a default date using regular expressions.
FIELD2=UL(0.00,1.82),LR(8.50,2.06),0,(TRIGGER=1,BASE=0,REGEX='[A-Z][a-z]+ [0-9]+, [0-9]{4}',DEFAULT='January 1, 1970')

We try to use something that makes it obvious it's a default value.

Title: Re: Load from ARSDOC GET
Post by: Justin Derrick on September 05, 2018, 12:30:59 PM

There's an article in the CMOD Wiki about Default Values:  https://cmod.wiki/index.php?title=Default_Values_and_the_Generic_Indexer

Let me know if it's useful.

-JD.

Title: Re: Load from ARSDOC GET
Post by: Greg Ira on September 05, 2018, 12:39:03 PM

I recall tricking the indexer into using the default value from the admin client by using another trigger on a constant in the field such as the ':' in the time eg 10:30.
The field was based off of that trigger.  If the trigger can't find the ':' it never checks the field and uses the default.