Question Re: CAP: incorrect DB insert of boolean values in string fields from CSV in Technology Q&A

CAP: incorrect DB insert of boolean values in string fields from CSV

alicegavanelli — Wed, 03 Mar 2021 11:40:14 GMT

Dear Experts,

I have an entity with a string field called "defaultValue".

entity PropertiesTest : cuid { 
    defaultValue : String(1000); 
}

If in this field I put string "true" or "false", the value is interpreted as boolean and is converted to "1" and "0".

Data are inserted by csv file. I have tried also with quotation marks.

ID;defaultValue
bc1c3c82-6ade-11eb-9439-0242ac130002;true
773a6a34-6adf-11eb-9439-0242ac130002;false
7b96940e-6adf-11eb-9439-0242ac130002;alice test
7b96940e-6adf-11eb-9439-0242ac130005;'false'
7b96940e-6adf-11eb-9439-0242ac130006;"false"

If I try by OData, the string is correctly inserted.

HTTP/1.1 200 OK
{
  "d": {
    "ID": "773a6a34-6adf-11eb-9439-0242ac130002",
    "defaultValue": "false",
    "__metadata": {
      "type": "WTest.PropertiesTest",
    }
  }
}

We have solved using a workaround but maybe it should be fixed.

Best.

Re: CAP: incorrect DB insert of boolean values in string fields from CSV

gregorw — Wed, 03 Mar 2021 15:48:46 GMT

Please file that also as an Issue via the SAP Service Marketplace.

Re: CAP: incorrect DB insert of boolean values in string fields from CSV

alicegavanelli — Wed, 03 Mar 2021 16:43:00 GMT

Thank you Gregor,

I've opened the incidente:

161611 / 2021 CAP: incorrect DB insert of boolean values in string fields from CSV

Best

Alice

Re: CAP: incorrect DB insert of boolean values in string fields from CSV

chgeo — Thu, 04 Mar 2021 08:25:08 GMT

Thanks for reporting. We will track progress in the incident now. Please understand that we cannot keep this community issue up to date as well.

Re: CAP: incorrect DB insert of boolean values in string fields from CSV

gregorw — Thu, 04 Mar 2021 15:27:33 GMT

So Alice please give us an update when you've got a solution from SAP.

Re: CAP: incorrect DB insert of boolean values in string fields from CSV

alicegavanelli — Thu, 15 Jul 2021 07:31:44 GMT

SAP hasn't given me any answer yet.

Re: CAP: incorrect DB insert of boolean values in string fields from CSV

gregorw — Wed, 20 Oct 2021 10:11:54 GMT

Any updates?

Re: CAP: incorrect DB insert of boolean values in string fields from CSV

alicegavanelli — Wed, 20 Oct 2021 10:35:25 GMT

Unfortunately not yet.

The incident is still in "In process by SAP".

I had asked for a feed-back in April but no one answered me.

It will certainly be my care to update you as soon as SAP will answer me.

Re: CAP: incorrect DB insert of boolean values in string fields from CSV

gregorw — Wed, 20 Oct 2021 13:49:51 GMT

I would suggest to reach out to the SAP Support Hotline and ask for a speedup.

Re: CAP: incorrect DB insert of boolean values in string fields from CSV

gregorw — Fri, 22 Oct 2021 06:12:39 GMT

I've now also filed an issue: 757245 / 2021

Re: CAP: incorrect DB insert of boolean values in string fields from CSV

alicegavanelli — Wed, 22 Dec 2021 14:41:15 GMT

Has SAP answered to you?

Re: CAP: incorrect DB insert of boolean values in string fields from CSV

gregorw — Wed, 22 Dec 2021 16:03:37 GMT

No. Status "in processing" and that since 17th November 2021.

Re: CAP: incorrect DB insert of boolean values in string fields from CSV

steffenwaldmann — Tue, 29 Mar 2022 14:56:32 GMT

Hi Alice,

Good news, we shipped a fix for this issue in the most recent @sap/cds release (5.9.0). The SQLite CSV importer will now interpret quoted "true" and "false" as strings instead of Booleans.

Best regards,

Steffen