General OBIEE

Get Involved. Join the Conversation.

Topic

    Geoff Fredericksen
    Invalid characters error message wne loading csv or excel...Answered
    Topic posted October 26, 2015 by Geoff FredericksenRed Ribbon: 250+ Points 
    82 Views, 1 Comment
    Title:
    Invalid characters error message wne loading csv or excel file
    Summary:
    Can't load csv or excel file into BI data model
    Content:

    Hi,

    When I try and load either csv file with comma separator or pipe or excel .xls file I get invalid character error message.

    I am trying to create a BI Publisher v 11.1.1.7.27 data model using both excel and csv option.

    I have tried loading 1 row with 2 columns

    200134,3

    where col1 is text and col 2 number, with no header row and still get message (see attached image)

    Any ideas?

    Thanks

     

    Image:

    Best Comment

    Geoff Fredericksen

    For those of you who ever experience this, the problem was when selecting a csv file from your local directory it does not like the characters in the path to the file as in //. You'd think this might have been addressed by Oracle at some stage.

    You have to copy the file to your desktop and load it from there.

    Comment

     

    • Geoff Fredericksen

      For those of you who ever experience this, the problem was when selecting a csv file from your local directory it does not like the characters in the path to the file as in //. You'd think this might have been addressed by Oracle at some stage.

      You have to copy the file to your desktop and load it from there.