Messages

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?...

332

Report Indexing / Re: Ingesting an EXCEL spreadsheet into ERR

« on: June 20, 2012, 07:13:42 AM »

Correct...We tested that and both of those files get removed...The issue is we are loading .XLS files, and the actual data file (ie test.test.xls) file ISN'T being removed from the ARSLOAD directory after it's ingested....Currently, with our PDF's, they send one file (ex test.test.pdf) and once it's ingested, it's removed....Guessing systems needs to define something in ARSLOAD to automatically remove .xls files after ingestion.

333

Report Indexing / Re: Ingesting an EXCEL spreadsheet into ERR

« on: June 20, 2012, 04:36:37 AM »

Alessandro,  thank you (and Russell) for all the information...I finally was able to get things to work...I didn't realize at first the trigger file was simply a blank file...Once I realized that I created it, along with the index file (.ind)...My index file simply contains just the Codepage, Group offset, Group length and Group file name information.  Currently our systems group have files ending with .pdf configured to automatically ingest with ARSLOAD...So here's what configured:

TEST.TEST.PDF  < Empty file
TEST.TEST.PDF.IND < within this file I have the complete path and data file name (TEST.XLS)
TEST.XLS < Actual data file

I copy the TEST.XLS to one of our ARSLOAD directories on our server first
I then copy both the TEST.TEST.PDF and TEST.TEST.PDF.IND to the same directory as the TEST.XLS file.
ARSLOAD then automatically ingests the file.  After ingestion is complete, the TEST.TEST.PDF and TEST.TEST.PDF.IND files are deleted.
We just need to work with our systems group to configure ARSLOAD to also delete the TEST.XLS file after ingestion

We loaded not only XLS but also TXT and CSV file types configuring the view information on the Application setup with the file extension it should be opened with in CMOD.

Again, thanks to everyone for all the valuable information you provided. 

Take care.

Dave

334

Report Indexing / Re: Ingesting an EXCEL spreadsheet into ERR

« on: June 18, 2012, 06:53:19 AM »

Russell,  what fields need to be defined in the .ind file?...As indicated, this is an excel spreadsheet with NO indexing...I'm basically attempting to ingest it into Content Manager OnDemand8.4 as is...Does the .ind file need to contain all the fields defined under the application group?...It appears from your example you are specifying values for these fields...The 'fields' I have defined in the application group are:
POSTING_DATE
REPORT_NAME  <  Report name defined
DESCRIPTION  <  Description of the report
LOAD_DATE
PAGE_COUNT

For the POSTING_DATE and LOAD_DATE we set the Default Value with a lower case 't' on Load Information tab on the Application definition.

I just don't know what I have to have specified on this .ind file...

Also, when you define it, do you simple use notepad and then save it in the name format needed, (ie ApplicationGroup.Application.ARD.IND).?

335

Report Indexing / Re: Ingesting an EXCEL spreadsheet into ERR

« on: June 18, 2012, 03:16:46 AM »

Thanks Russell.....What I'm attempting to do for now is just ingest a sample Excel spreadsheet with NO indexing...So on my Application Group the only fields I have defined are POSTING DATE, REPORT NAME, REPORT DESCRIPTION, LOAD DATE and PAGE COUNT.  These are all FILTERS.  For our normal text files the .ARD is the actual data file. From what you indicated, the .OUT is the actual spreadsheet data file... Forgive my ignorance, but not familiar with a trigger file..with never having used a separate index file (.IND), just not sure how/where it's defined.  And once i get past that point, will it have to be supplied to the end user who is actually sending the spreadsheet data to our server to be ingested by ARSLOAD?....

336

Report Indexing / Re: Ingesting an EXCEL spreadsheet into ERR

« on: June 14, 2012, 09:50:45 AM »

Russell, do you have any examples?..Currently we have users sending PDF files right to our PROD ERR server (to an ARSLOAD) directory...They format their files as ApplicationName.ApplicationGroupName.pdf...Once the file gets to the ARSLOAD directory, it is automatically ingested...We obviously define the ApplicationName and ApplicationGroupName...The difference being with it being a PDF, the application contains the indexing information which we obtain by running the data through the report wizard on the ADMIN client..We would like to accomplish the same thing with an XLS file..(ex ApplicationName.ApplicationGroupName) minus the indexing......I'm just not sure how you incorporate all these files...Especially the .IND file that contains the indexing...I've not been able to find a true example of this kind of file and how it would get incorporated in the process...Specifically where it's defined and stored...

337

Report Indexing / Re: Ingesting an EXCEL spreadsheet into ERR

« on: June 14, 2012, 04:34:08 AM »

Alessandro, here is a copy of the 88 message I receive with just having the application defined with "user defined" and the generic indexer...It seems to point back to the indexer file but as my previous post indicated, not sure how to define that piece...

arsload: 06/06/12 09:18:36 -- Indexing started, 432128 bytes to process
arsload: Unknown Indexer ><
arsload: Output/Indexer file was not created
arsload: 06/06/12 09:18:36 Indexing failed

338

Report Indexing / Re: Ingesting an EXCEL spreadsheet into ERR

« on: June 14, 2012, 04:27:42 AM »

Alessandro,  I had attempted previously to do what you suggested..I defined the application with the view information as 'user defined' and xls as the application...I also set the indexer as Generic..I've read in other posts when the generic indexer is used, a separate index file must be created...I'm just not sure how it is to be formatted or where it is stored...Currently we have applications who send pdf files directly to our OnDemand server under an ARSLOAD library which then automatically gets ingested into Content Manager OnDemand by ARSLOAD...A majority of the data going to OnDemand currently is coming from the mainframe and the files all end in .ARD...I believe out systems area had to update something in ARSLOAD to allow the automatic ingestion of PDF's...The format of the files are Application.ApplicationGroup.pdf..I'm assuming with the XLS files, something will need to be updated in ARSLOAD to accept a file formatted as Application.ApplicationGroup.xls...But again, the question I have is regarding how to provide this minimum index file needed, its format and where it's stored.

339

Report Indexing / Re: Ingesting an EXCEL spreadsheet into ERR

« on: June 13, 2012, 09:54:02 AM »

That I'm not sure....The question was just raised if we could ingest a true EXCEL spreadsheet...my guess is they don't want to do anything on there end other than providing us the spreadsheet itself.

340

Report Indexing / Ingesting an EXCEL spreadsheet into ERR

« on: June 13, 2012, 09:47:42 AM »

Can anyone provide the procedure for ingesting a NON indexed EXCEL spreadsheet into OnDemand8.4?....Basically all we're trying to do is 'dump' a spreadsheet into CMOD...No indexing....Currently we are using ARSLOAD to ingest both text, AFP and PDF documents...We had an inquiry from a user to load an excel (XLS) spreadsheet...any help or specific direction would be appreciated.

341

Report Indexing / Re: Ingesting an XML document into OnDemand

« on: March 16, 2012, 08:13:04 AM »

Thanks again for the responses...These believe will be true XML documents....I have defined the application group and application to OnDemand...Forgive me for my ignoranance, but where would the files you mention in line, "The index file name should be filename.ind, the file with content should have filename.out and there should be trigger file name named as filename"...From what I understand the filename.out would be the actual XML document???...We are hoping the application can send these XML documents directly to our OnDemand server...They are currently doing that with their PDF documents...We have them name them Application.ApplicationGroup.pdf...They send them to a specific arsload directory on the server and they get ingested automatically....I'm not sure how this same process would work with what you describe...This is all new to us and we haven't found an examples to go from as far as what needs to be defined...Currently all of our line data files come from mainframe jobs...Do these XML files have to be sent first to the mainframe prior to ingestion into OnDemand?...

342

Report Indexing / Re: Ingesting an XML document into OnDemand

« on: March 16, 2012, 05:47:21 AM »

Thanks for the info....From what I've read, this would require me to use the GENERIC INDEXER...Attempting to run it via the wizard the only options are LINE, AFP and PDF..When choosing LINE and using my excel spreadsheet as my sample, the data isn't rendered readable....I had reviewed the info from IBM's site on the generic indexer and just not sure how to define the parameter file, and once defined, where this file should be stored....Is it on the OnDemand server?...I was hoping there was someone out there that has already loaded an EXCEL document to OnDemand but may not....

343

Report Indexing / Ingesting an XML document into OnDemand

« on: March 15, 2012, 07:01:00 AM »

Hi, We have some users who want to load XML documents into OnDemand...We've successfully been able to load PDF, AFP and text documents...I've read from various posts that in order to import other formats into you use the GENERIC indexer....When doing so we get the following msg, "arsload: Generic Indexer requires the data to have already been indexed.  Index the data or verify your input file and resubmit the job"..I've read that an index file must be created...I'm just not sure how to create this and where it is stored...We are looking for the users to send their XML documents directly to our OnDemand Server and be collected by ARSLOAD...This is how we are currently doing our PDF's....Any help would be appreciated...Thanks!