Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Invalid characters error message wne loading csv or excel file

Received Response
181
Views
1
Comments
Geoff Fredericksen
Geoff Fredericksen Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

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

 

error_message.JPG

Answers

  • Geoff Fredericksen
    Geoff Fredericksen Rank 1 - Community Starter

    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.