OnDemand Users Group

Support Forums => Report Indexing => Topic started by: dstrong on August 13, 2013, 12:22:30 PM

Title: Automated process to create generic index for Excel file and load report
Post by: dstrong on August 13, 2013, 12:22:30 PM
Hi all,

We received a request to start loading Excel files into OnDemand, and I've successfully loaded some test reports with a generic indexer. Now I just need to figure out how to automate a process to create the indexer and load the report into OnDemand when the report land in a specific folder on our AIX server. The generic indexer would need to parse the report name for the department ID(ex., pull 2140 from INCOME_STATEMENT_2140.XLSX). Any suggestions or examples on how to set this up? Any help would be appreciated.

Thank you.
Title: Re: Automated process to create generic index for Excel file and load report
Post by: pankaj.puranik on August 20, 2013, 02:18:35 PM
We do similar stuff.
In our case we wrote either a java program or a shell script to generate the IND and calles arsload from the script.
Title: Re: Automated process to create generic index for Excel file and load report
Post by: dstrong on August 21, 2013, 07:27:00 PM
A shell script is the way I was thinking we's want to go. So are you parsing the report name for the index data?
Title: Re: Automated process to create generic index for Excel file and load report
Post by: pankaj.puranik on August 22, 2013, 10:15:10 AM
In our case we receive a separate file with the metadata from the source systems.
But in your case you can easily extract the metadata from the file name using shell script.