Author Topic: acif indexer for CSV file  (Read 2768 times)

kader

  • Guest
acif indexer for CSV file
« on: February 05, 2014, 07:53:42 AM »
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

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2231
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: acif indexer for CSV file
« Reply #1 on: February 05, 2014, 08:46:58 AM »
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.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

kader

  • Guest
Re: acif indexer for CSV file
« Reply #2 on: February 06, 2014, 10:11:03 AM »
Thanks Justin. It seems your suggestion is the only option I have.

Kader

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2231
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: acif indexer for CSV file
« Reply #3 on: February 07, 2014, 08:30:39 AM »
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.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR