OnDemand Users Group

Support Forums => Report Indexing => Topic started by: kader on February 05, 2014, 02:53:42 PM

Title: acif indexer for CSV file
Post by: kader on February 05, 2014, 02:53:42 PM
Hi folks,

I have an issue to index csv file using ACIF indexer. I have constant header that I use as trigger however since the columns has variable lengths I'm not able to figure out how to use kind of counter to pickup the value of column1, column3, column8 for example.
I look also at ACIF user programming exit, but all code is in C language, is it possible to use Perl for instance?

Thanks for input,


Abdel
Title: Re: acif indexer for CSV file
Post by: Justin Derrick on February 05, 2014, 03:46:58 PM
You would be better off writing your own indexer.  If you're familiar with Perl, it will be trivial to create an indexer that reads your specially formatted CSV files, and creates a text file in the Generic Index format that CMOD likes.

-JD.
Title: Re: acif indexer for CSV file
Post by: kader on February 06, 2014, 05:11:03 PM
Thanks Justin. It seems your suggestion is the only option I have.

Kader
Title: Re: acif indexer for CSV file
Post by: Justin Derrick on February 07, 2014, 03:30:39 PM
Yeah, ACIF is really for AFP and line data reports -- its limitations become quickly apparent when trying to do anything else.  :)

Let us know how it turns out.

-JD.