Hello Moqui Community,
I’m currently working on importing data from a CSV file into an entity using the EntityDataLoader
in Moqui. However, I’m encountering an issue when a double quote ("
) appears somewhere in the middle of the data values.
Sample data that throws an error while importing
co.example.bi.fact.OrderItemFulfillmentFact
orderId,orderItemSeqId,externalId,orderName,orderTypeId,productStoreId,salesChannelEnumId,entryDate,orderDate,shippingCharges,productId,itemDescription,
FAO10117,101,5669763023132,"#1010101240",SALES_ORDER,STORE,POS_SALES_CHANNEL,1705232954323,1705232896000,,10016,"\"And\" Pride Tank in Grey Mix",
The value \"And\" Pride Tank in Grey Mix
, contains the quote("
) that causes an issue. And if the value is like "And" Pride Tank in Grey Mix
also causes an issue.
Error text:
{'message':'IOException reading next record: java.io.IOException: (line 3) invalid char between encapsulated token and delimiter (line 3) invalid char between encapsulated token and delimiter','errorName':'Internal Server Error','error':500,'path':'/apps/tools/Entity/DataImport/load'}