Question Re: CAP: SQLite deploy error about csv location in Technology Q&A

CAP: SQLite deploy error about csv location

alicegavanelli — Fri, 16 Jul 2021 08:47:01 GMT

Dear Experts,

reading CAP documentation about deploy providing-initial-data I noticed that csv files, could be located in three different folders: db/csv, db/data/, or db/src/csv

I have tryed with all of these, under the results:

db/csv -> OK

db/data -> OK

db/data/other_folder -> KO

db/src/csv -> KO

In documentation if I read db/data/ with symbol "/" I understand that I could add other underfolder. But it is not true. Is it an error?

Folder db/src/csv doesn't work despite documenation.

Below my release:

@sap/cds: 5.0.6
@sap/cds-compiler: 2.4.4
@sap/cds-dk: 4.0.7
@sap/cds-foss: 2.3.1
@sap/cds-runtime: 3.0.9
Node.js: v14.16.0<br>

Thank you in advance.

Best

Alice

Re: CAP: SQLite deploy error about csv location

former_member643578 — Mon, 19 Jul 2021 03:59:36 GMT

what error you are getting? Can you share your folder structure of csv file?

Re: CAP: SQLite deploy error about csv location

chgeo — Mon, 19 Jul 2021 08:53:02 GMT

CSV files from subfolders of `db/data` or `db/csv` are not deployed by intention.

Please provide the link to the documentation where you think this would be stated differently.

Re: CAP: SQLite deploy error about csv location

alicegavanelli — Wed, 21 Jul 2021 08:20:54 GMT

Dear Christian,

as you can read in my post, link is already provided.

However I put it again Link to CAP documentation

CSV files from subfolders of `db/data` are documented in the link above; the '/' could be a documenation misunderstanding.

CSV files from subfolders of `db/csv` are not documented and It is not my request.

I ask about 'db/src/csv' that actually in documentation as you can see below.

Thank

Alice

Re: CAP: SQLite deploy error about csv location

chgeo — Wed, 21 Jul 2021 10:30:44 GMT

I see, you are confused by the trailing / in the documentation. However, trailing slashes do usually not indicated sub folders (recursively even). Normally, this would be indicated by ** globs or so.

But yes, we will remove the /

Re: CAP: SQLite deploy error about csv location

alicegavanelli — Wed, 21 Jul 2021 10:56:06 GMT

What about 'db/src/csv'?

Thank

Alice

Re: CAP: SQLite deploy error about csv location

alicegavanelli — Wed, 28 Jul 2021 08:57:50 GMT

Dear Christian,

What about 'db/src/csv'?

Thank

Alice

Re: CAP: SQLite deploy error about csv location

Ren — Mon, 02 Aug 2021 15:57:05 GMT

Hi Alice,

valid question. I think our documentation is not clear enough at that end. The csv files are only picked up for models located in the parent folder. And in the db/src/csv case it's a little bit special, because usually only native database artifacts are located there. Most probably SAP HANA artifacts. So from the db/src/csv folder, no initial data is fetched for .cds files located in the db folder.

Hope that helps. And I'll trigger an update to our documentation.

All the best,

René