331
Report Indexing / Re: Ingesting an EXCEL spreadsheet into ERR
« on: June 25, 2012, 04:06:11 AM »
Alessandro, I believe we finally have everything in place we need...There a basically 3 file types we are loading (CSV, XLS and TXT)...All 3 need to be opened in OnDemand using Excel...So I've defined the Application as User Defined with the XLS extension....I'm then using 3 files for the ARSLOAD funtion:
Example:
TEST.TEST.ARD (Blank "Trigger" file)
TEST.TEST.ARD.IND (Index File)
TEST.TEST.ARD.OUT (Actual data file)
These naming conventions allow the ARSLOAD process to automatically run and delete all 3 files after successful ingestion...
I do have an off the wall question...This hasn't come up yet, but if the Application would want "breaks" inserted on the data when viewing the spreadsheets in OnDemand, is that something that is possible?...We enable the "Page Break" function on the Application Group for Line data which utilizes Carriage Control (1 in column 1 at the top of every page)...Obviously an Excel spreadsheet or txt files don't have that...So right now we are just loading the entire spreadsheet without and breaks...Just curious if we could the application would request we break after so many lines on the spreadsheet, if that default could be defined/set somewhere?...
Example:
TEST.TEST.ARD (Blank "Trigger" file)
TEST.TEST.ARD.IND (Index File)
TEST.TEST.ARD.OUT (Actual data file)
These naming conventions allow the ARSLOAD process to automatically run and delete all 3 files after successful ingestion...
I do have an off the wall question...This hasn't come up yet, but if the Application would want "breaks" inserted on the data when viewing the spreadsheets in OnDemand, is that something that is possible?...We enable the "Page Break" function on the Application Group for Line data which utilizes Carriage Control (1 in column 1 at the top of every page)...Obviously an Excel spreadsheet or txt files don't have that...So right now we are just loading the entire spreadsheet without and breaks...Just curious if we could the application would request we break after so many lines on the spreadsheet, if that default could be defined/set somewhere?...