SAP Design Studio 1.6 local mode CSV datasource not working

[Former Member]

Hi All,

I was curious about the new csv datasource feature within SAP Design Studio 1.6. So I created a new project within DS 1.6 local mode and added a csv as datasource. So far so good, but when I try to edit the initial view I get an error : ‘Failed to instantiate data source. See error log for details’.

The messages in the Error log :

Cannot load InfoProvider "local/CSV\CSV3.csv" (data provider "DS_1": Exception opgetreden bij creëren)

And some “Unexpected Exceptions”

Based on above I got some questions :

Does the CSV need to be in some sort of special format?

What are the limitation using a CSV as a datasource  in Records and Cells?

Is there something I’m doing wrong?

Thanks a lot!

[Karol-K · Accepted solution]

Hi,

actually the implementation is more for "download" of real data and use it for demo as CSV. Therefore the way of creation of the CSV file is.

1. attach real data source in your app

2. open initial view editor

3. click the (new in 1.6) button "Download as CSV.

then, the CSV will be created with 3 files

* CSV file with data

* metadata file (as Tammy writes, it is required for the system to understand the CSV data)

* xml data with currect initial iew state (optional if existing)

Of course, you can parse the metadata file and find a way to create such for your CSV (should bot be too complex, just try)

Karol

[Former Member · Accepted solution]

Thank you for your answer.

I will have a look at the generated files and see if I can find an easy way to generate the metadata file myself.

Do you know if there is a limit to the rows/cells using a csv datasource ? Will that be the same when using a Universe as a datasource. I believe it has gone up to 20.000 with Design Studio 1.6.

[TammyPowlas · Accepted solution]

File I am using has almost 85K rows - I am not aware of a stated file limit

[Former Member · Accepted solution]

Thank you for your answer, sounds promising

[Mengting · Accepted solution]

HI TEUN,

Have you solved this issue? I faced same problem when opening initial view editor.

I don't quite understanding how to "open initial view editor and click download as csv". I really cannot open initial view editor. It pops up same error message.

Do you have any clue how to solve this problem?

[TammyPowlas · Accepted solution]

Hi - this is a closed thread; if you are stuck in the future please create a new thread

That said, if you have a BEx query as a data source, go to Edit > Initial View and then you should see Extract as CSV as shown below:

[TammyPowlas]

Hi,

You need a metadata repository file to go with the CSV - see