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
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)