Author Topic: Generic Indexing - MP - GROUP_FILENAME contains spaces  (Read 4032 times)

brianalbin

  • Guest
Generic Indexing - MP - GROUP_FILENAME contains spaces
« on: April 16, 2014, 11:57:38 AM »
Greetings -

I suspect the answer is "no" and have tried a variety of alternatives, but curious to see if anyone in this forum has a solution to share.  Looking to use generic indexer with file names and paths containing blank characters.  These files originated on the windows platform where spaces are allowed in the name.  They fail to index when running generic indexer via ARSLOAD on Linux.  (CMOD version 8.5.4).   Suggestions welcome on how to get around this issue without having to remove the blanks and/or replace them with with a readable character (like '_')

This is the contents of the generic index file 2200_D501.Agreements.2200_D501_PDF.2200_D501.20140415.150000.ind :

CODEPAGE:850
GROUP_FIELD_NAME:DocumentDefinition
GROUP_FIELD_VALUE:Agreements
GROUP_FIELD_NAME:CounterPartyId
GROUP_FIELD_VALUE:ABC Company
GROUP_FIELD_NAME:MimeType
GROUP_FIELD_VALUE:PDF
GROUP_FIELD_NAME:SequenceNumber
GROUP_FIELD_VALUE:140415001
GROUP_FIELD_NAME:DateForRetention
GROUP_FIELD_VALUE:20140415
GROUP_FIELD_NAME:FileName
GROUP_FIELD_VALUE:Fixed Income LLC - ISDA Schedule Para. 13.pdf
GROUP_FIELD_NAME:FilePath
GROUP_FIELD_VALUE:/domain/apps/2200/D501/docs/Fixed Income LLC - ISDA Schedule Para. 13.pdf
GROUP_OFFSET:0
GROUP_LENGTH:0
GROUP_FILENAME:/domain/apps/2200/D501/docs/ABC Company/Fixed Income LLC - ISDA Schedule Para. 13.pdf

This is the ARSLOAD command used:

arsload -h <hostname> -u admin -p XXXXXXXX -g 2200_D501 -a 2200_D501_PDF -fvn -X G 2200_D501.Agreements.2200_D501_PDF.2200_D501.20140415.150000
 

This is the error returned:

Unable to open the file >/domain/apps/2200/D501/docs/ABC Company/Fixed Income LLC - ISDA Schedule Para. 13.pdf<
Loaded 0 rows into the database
arsload: 04/16/14 14:13:11 Loading failed

brianalbin

  • Guest
Re: Generic Indexing - MP - GROUP_FILENAME contains spaces
« Reply #1 on: April 16, 2014, 01:43:48 PM »
Option ?J with a space worked!

arsload -h <hostname> -u admin -p XXXXXXXX -g 2200_D501 -a 2200_D501_PDF ?J   -fvn -X G 2200_D501.Agreements.2200_D501_PDF.2200_D501.20140415.150000

Small issue is it does not seem to obey the ?-fvn? parameter, but I can deal with that (or research further).   

jeffs42885

  • Guest
Re: Generic Indexing - MP - GROUP_FILENAME contains spaces
« Reply #2 on: April 16, 2014, 08:18:41 PM »
Option ?J with a space worked!

arsload -h <hostname> -u admin -p XXXXXXXX -g 2200_D501 -a 2200_D501_PDF ?J   -fvn -X G 2200_D501.Agreements.2200_D501_PDF.2200_D501.20140415.150000

Small issue is it does not seem to obey the ?-fvn? parameter, but I can deal with that (or research further).   


I had a feeling it was something to do with the spaces in your file name.

You mentioned it does not obey -fvn

Does it do any of it?

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2231
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Generic Indexing - MP - GROUP_FILENAME contains spaces
« Reply #3 on: April 17, 2014, 06:18:37 AM »
The good news:  I know this works in UNIX shell scripts:  Either surround the file name in quotes, or prefix the space character with a backslash to 'escape' it.

The bad news:  I have no idea if CMOD will obey these conventions.  :)

-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