Data360 Analyze

 View Only
  • 1.  CSV import error - Reserved character (:)

    Posted 03-15-2023 10:53

    Hi there, I am importing a .csv file and getting the following error.  Is there a work around to this without opening the .csv file every time to do a find/replace.  In the excel import node there is a 'SubstitudeInvalidCharacters' options which handles this perfect, but it's not in the .txt/.csv import node.

    Error occurred while attempting to open output (0) : "output cause: Reserved character (:) on metadata field (12), name: Ultimate Parent Account: Account Name, type: class com.lavastorm.lang.UnicodeString. "

    Thanks in advance,



    ------------------------------
    Jamie Johnny
    Dun & Bradstreet Canada Ltd
    Mississauga ON
    ------------------------------


  • 2.  RE: CSV import error - Reserved character (:)

    Employee
    Posted 03-15-2023 12:34

    Hi,

    Recent versions of the product were updated to provide the 'SubstitudeInvalidCharacters' property on the CSV/Delimited Input node.

    Regards,

    Adrian



    ------------------------------
    Adrian Williams
    Precisely Software Inc.
    ------------------------------



  • 3.  RE: CSV import error - Reserved character (:)

    Posted 03-15-2023 14:17

    Thanks Adrian!

     

    Jamie Johnny
    Principal Data Advisor
    Strategic Accounts
    Direct 905.812.5934
    Cell
    647.338.9943

     

     

    Restricted Confidential






  • 4.  RE: CSV import error - Reserved character (:)

    Employee
    Posted 03-16-2023 06:21

    Just returning to your original question about a work around. If the fields in the CSV file are well known and will not change then you could use the following approach:

    Given the following example data

    Set the 'FieldNames' property to the required valid output field names, e.g.

    Sepal.Length,Sepal.Width,Petal.Length,Petal.Width,Species

    and set the 'SkipHeaderRows' property 1 to ignore the first line in the file.

    However, we recommend that you upgrade to a recent version of the product to ensure it is covered by the support policy.



    ------------------------------
    Adrian Williams
    Precisely Software Inc.
    ------------------------------



  • 5.  RE: CSV import error - Reserved character (:)

    Posted 03-17-2023 10:54

    Thanks Adrien,

     

    I'll be getting a new machine which will allow me to run an upgrade.

     

    Thanks,

     

    Jamie Johnny
    Principal Data Advisor
    Strategic Accounts
    Direct 905.812.5934
    Cell
    647.338.9943

     

     

    Restricted Confidential