AnsweredAssumed Answered

Account/Entitlement Collection from a fixed width csv file?

Question asked by Vinodhini Selvaraj on Aug 8, 2016
Latest reply on Aug 10, 2016 by Vinodhini Selvaraj
  • Comment • 2

Hello Everyone,

 

We are trying to collect a fixed width file into Via L&G Version 7.0 through account and entitlement collectors but haven't had any success yet. Also we are not sure, if that's possible, as the collectors guide in the knowledge base does not give information on if the account/entitlement collectors support collecting fixed width file in Via L& G.

 

Also if you were able to achieve this with any workaround in your experience, please share with us and that will be more helpful.

 

Thanks,

Vino

Daniel Cinnamon
Daniel Cinnamon Employee Aug 8, 2016 12:26 PM
Correct Answer

What you have to do is- use the odbcSchemaFile property of the CSV JDBC driver.  You need to create a text file in the same directory as the csv file, and use the specification in the reference below.  In there you define which columns are in the file, as well as how long each column is.

 

Schema.ini File (Text File Driver)

See the reply in context
No one else had this question

Outcomes