Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Errors when deploying csv to sqlite

flachlaender
Explorer
0 Likes
600

I'm trying to load data from a .csv, but keep getting an error:

Definition of the entity

entity QuestionLists : managed {
    key questionListID   : ty.QuestionListID;
        hierarchyProfile : ty.hierarchyProfileID;
        status           : ty.Status;
        title            : ty.Title;
        descr            : ty.Descr;
        note             : ty.Note;
        valuation        : ty.ValuationStr;
        questions        : Association to many Questions; 
}

types:

type QuestionID : Integer;
type QuestionListID : Integer;

type Status : String(4);
//
type Title : localized String(111);
type Descr : localized String(1111);
type Note : localized String(1111);

CSV File

questionListID ;  hierarchyProfile ; status ; title ; descr ; note 
1 ; 1 ; 1; QuestionList 1 ; Description of QL 1 ; n1 
2 ; 1 ; 1; QuestionList 2 ; Description of QL 2 ; n2 
3 ; 1 ; 1; QuestionList 4 ; Description of QL 3 ; n3 
4 ; 1 ; 1; QuestionList 4 ; Description of QL 4 ; n4 

Error:

[ERROR] SQLITE_MISMATCH: datatype mismatch
{ INSERT: { into: 'auditq.QuestionLists',
  columns:
   [ 'questionListID',
     'hierarchyProfile',
     'status',
     'title',
     'descr',
     'note' ],
  rows:
   [ [ '1',
       '1',
       '1',
       'QuestionList 1',
       'Description of QL 1',
       'n1',
       '2021-03-04T17:01:05.200Z',
       'anonymous',
       '2021-03-04T17:01:05.200Z',
       'anonymous' ],
     [ '2',
       '1',
       '1',
       'QuestionList 2',
       'Description of QL 2',
       'n2',
       '2021-03-04T17:01:05.200Z',
       'anonymous',
       '2021-03-04T17:01:05.200Z',
       'anonymous' ],
     [ '3',
       '1',
       '1',
       'QuestionList 4',
       'Description of QL 3',
       'n3',
       '2021-03-04T17:01:05.200Z',
       'anonymous',
       '2021-03-04T17:01:05.200Z',
       'anonymous' ],
     [ '4',
       '1',
       '1',
       'QuestionList 4',
       'Description of QL 4',
       'n4',
       '2021-03-04T17:01:05.200Z',
       'anonymous',
       '2021-03-04T17:01:05.200Z',
       'anonymous' ],
     [ '',
       '2021-03-04T17:01:05.200Z',
       'anonymous',
       '2021-03-04T17:01:05.200Z',
       'anonymous' ] ] }}
    at init_from_ (/home/michael/Developments/SAP/.../node_modules/@sap/cds/lib/db/deploy.js:182:35)

The columns for createAT/BY and modifiedAT/BY are apearently generated from the "managed" aspect, but should not be here on the database upload.

0 REPLIES 0