Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2014

    Unanswered: Error uploading csv to API database

    Hi There,

    We are currently doing testing on our new API staging database which has an upload function for a templated csv datafiles downloaded directly from financial providers websites. The csv shows information about superannuation funds and the legislated format is a basic csv that should be standard across the industry.

    Of the ~200 funds we have two issues with ~25 of them.

    1) The datafile from the financial providers website is in xls format. I have converted the files through excel as well as free online file converters but our database still does not recognise the converted files.

    2) The datafile downloaded from the website is already in csv format but will not upload as it fails to recognise the file. The following error message occurs.

    "The parser failed to recognise the disclosure file. This probably means that the file is malformed - possibly with incorrect line endings or field delimiters."

    Does anyone have an idea of the cause of these issues or an easy fix to our problem?

    Thank you for your help in advance!

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    The odds are good that one or more fields in the CITY files have commas inside the field. Most CSV imports fail in that case.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts