openTextReader

OL Connect Professional DataMapper
1

I have an xml file. I need to change a field name to a “Y” or a “N” based on a external loan list that is saved in a text file.

I decide to use the pre-processor but I am getting an error on Wrapped java.io.FileNotFoundException:

var LoanList =openTextReader(“file:///C:/PlanetPressResources/billing/inserts/loanlist.txt”,“”);

var loan;

while ((loan = LoanList.readLine()) != null) {
//do something

}

The file exists but I am not sure why it says that it doesn’t. My encoding is UTF-8.

Has anyone done this and was there a solution for it? I should add that the loan list lookup is over 1 million records.

2

Use either

var LoanList =openTextReader("C:/PlanetPressResources/billing/inserts/loanlist.txt","");

or

var LoanList =openTextReader("C:\\PlanetPressResources\\billing\\inserts\\loanlist.txt","");