Announcement

Collapse
No announcement yet.

CSV File Upload Error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • CSV File Upload Error

    Hi All, we are working on service provider capacity management. We are able to get committed and usage values updated, whereas Finalize is not getting updated, even after the shipment is accepted and invoice is raised.

    We were trying to update some data through CSV file to the table, 'COMMIT_USAGE' that updates the finalized commitment value.

    We are unable to upload the data in CSV file.

    Following error is displayed:
    ORA-01861: literal does not match format string
    or
    ORA-01843: not a valid month

    Note: We were having issues in date earlier

    CSV file is attached for reference.

  • #2
    Re: CSV File Upload Error

    If you are updating a date field, make sure the 3rd line of the CSV file contains the date format as follows:

    EXEC SQL ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/YYYY'

    Line 1 must contain the table name
    Line 2 must contain the column names, separated by a comma. Make sure there are no additinoal commas after the last column.

    Always edit CSV files in a Text editor. Excel plays havoc with CSV files. Particullary with AGENT_ACTION_DETAILS and SAVED QUERY records where certain fields may contain a large amount of data.

    I use the following SQL Script to extract AGENT_ACTION_DETAILS from the DB:

    SELECT AD.AGENT_GID, AGENT_ACTION_GID, ACTION_FLOW, ACTION_SEQUENCE,'"'||replace(replace(replace(ACTIO N_PARAMETERS, chr(9), ' '), chr(10), ' '), chr(13), ' ')||'"' ACTION_PARAMETERS,DOMAIN_NAME, DATA_TYPE_ASSOCIATION_GID FROM AGENT_ACTION_DETAILS AD WHERE agent_gid in(
    :agent_gid)

    It removes all tabs and line returns.

    I cannot see the file, so I hope this helps with your issue. If not, attache the file (or at least the first 4-5 lines), and I will have a look into this for you.

    Cheers,
    James Foran
    Toll Global Information Services
    http://www.tollgroup.com

    Comment


    • #3
      Re: CSV File Upload Error

      Hi James,
      Thanks for the response. We tried that... seems there is some other problem as well. Attaching the CSV file for reference.

      Thanks in advance.
      Attached Files

      Comment


      • #4
        Re: CSV File Upload Error

        Hi,

        This file contains a Date time value, but not translation.

        Also, you cannot include null as a value. This should just be blank.

        EG
        Correct Line
        test,,
        incorrect line
        test,null,

        Dont forget to add line 3 data format
        James Foran
        Toll Global Information Services
        http://www.tollgroup.com

        Comment

        Working...
        X