Author Topic: Excel indexer?  (Read 2470 times)

kbsiva

  • Guest
Excel indexer?
« on: April 26, 2012, 01:10:17 PM »
Hello Folks,
   Just like the PDF indexer do we have an indexer for Excel in CMOD? I know we can  use Generic indexing for Excel spread sheets which does not give me burst options. But outside of IBM is there a plugin that allows us to burst and index based on excel data? Do you know if monarch or any of these companies offer stuff like that?

Thanks
kbs

Alessandro Perucchi

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1002
    • View Profile
Re: Excel indexer?
« Reply #1 on: April 27, 2012, 06:35:15 AM »
Well, I don't know such indexer, but surely something like that could be easily be programmed in Perl, python, ruby, java, ... (for example
!) :-) according that there are not too many macros :-D especially if it needs to index a field that is generated with a macro!

sincerely yours,
Alessandro
Alessandro Perucchi

#Install #Migrations #Conversion #Educate #Repair #Upgrade #Migrate #Enhance #Optimize #AIX #Linux #Multiplatforms #DB2 #Windows #Oracle #TSM #Tivoli #Performance #Audits #Customizing #Availability #HA #DR #JavaApi #ContentNavigator #ICN #WEBi #ODWEK #Services #PDF #AFP #XML

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2230
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Excel indexer?
« Reply #2 on: April 28, 2012, 03:10:02 PM »
Perl has modules for reading Excel spreadsheets directly.  I'd highly recommend using them.
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