Tagged: ,

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #32075
    DJobin
    Participant

    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.

    #32082
    DJobin
    Participant

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

    #32108
    MSchappler
    Moderator

    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 2 weeks, 5 days ago by MSchappler.
Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.