[DJobin]

I get an error when trying to import records.

Content of the file with data to import:
@ACCTLEDG(ASCII):JOURNAL,ACCT,DATE(-1),REF,DESC,AMT,XACCT,XDESC,KEY
“JG.VISATONY”,”AP.VISA.TONY”,23072021,”4050204″,”Esso”,69.58,”5130″,”Esso”,4050204
“JG.VISATONY”,”AP.VISA.TONY”,23072021,”4050204″,”Esso”,3.48,”AR.TPS.CHA”,”Esso”,4050204
“JG.VISATONY”,”AP.VISA.TONY”,23072021,”4050204″,”Esso”,6.94,”AR.TVQ.CHA”,”Esso”,4050204
“JG.VISATONY”,”AP.VISA.TONY”,23072021,”4050204″,”Esso”,5.21,”5130″,”Esso – 50% TPS et TVQ”,4050204
“JG.VISATONY”,”AP.VISA.TONY”,23072021,”4050204″,”Esso”,-1.74,”AR.TPS.CHA”,”Esso – 50% TPS”,4050204
“JG.VISATONY”,”AP.VISA.TONY”,23072021,”4050204″,”Esso”,-3.47,”AR.TVQ.CHA”,”Esso – 50% TVQ”,4050204

Import log file:
2021-08-02 03:34:46 PM Expected a valid date but encountered “07232120”.
2021-08-02 03:34:46 PM Expected a year in the range 1903 to 2037 but encountered 467.
“JG.VISATONY”,”AP.VISA.TONY”,23072021,”4050204″,”Esso”,69.58,”5130″,”Esso”,4050204
2021-08-02 03:34:46 PM format @ACCTLEDG(ASCII):JOURNAL,ACCT,DATE(-1),REF,DESC,AMT,XACCT,XDESC,KEY

It has to be noted that I have been doing that kind of import regularly for many years, a great number of times.
This is the first time I attempt it since the last update.

[DJobin]

Since I got no reply or comment, I am going to have to enter transactions the regular way into NewViews.

[MSchappler]

The upcoming service 2.34.11 will alert you that there was a problem instead of closing down.

From the error you have provided, the transaction is in the year 2120. Change it to 07232020 and you can import the file.

Regards to All,

Martin

• This reply was modified 3 years, 2 months ago by MSchappler.

[Author]

Posts