Bypassed this temporarily by adding static data for the database fields I want to “Allow null” but don’t get changed. There are no errors returned by XHR, but the data are not inserted in the database, here’s the XHR output:
{,…}
csvImport1: [,…]
0: {product_name: "Product1", stock_quantity: "4", product_price: "242.45", sales_price: "99.99"}
1: {product_name: "Product2", stock_quantity: "10", product_price: "143.56", sales_price: "79.99"}
2: {product_name: "Product3", stock_quantity: "8", product_price: "173.42", sales_price: "69.99"}
3: {product_name: "Product4", stock_quantity: "7", product_price: "23.54", sales_price: "19.99"}
4: {product_name: "Product5", stock_quantity: "5", product_price: "25.86", sales_price: "9.99"}
record_repeat: [{product_insert: {identity: null, affected: 1}}, {product_insert: {identity: null, affected: 1}},…]
0: {product_insert: {identity: null, affected: 1}}
product_insert: {identity: null, affected: 1}
1: {product_insert: {identity: null, affected: 1}}
product_insert: {identity: null, affected: 1}
2: {product_insert: {identity: null, affected: 1}}
product_insert: {identity: null, affected: 1}
3: {product_insert: {identity: null, affected: 1}}
product_insert: {identity: null, affected: 1}
4: {product_insert: {identity: null, affected: 1}}
product_insert: {identity: null, affected: 1}
upload_file: {name: "products.csv", type: "application/vnd.ms-excel", tmp_name: "/tmp/phppgLCKf", error: 0,…}
error: 0
isFile: true
name: "products_15.csv"
path: "/feeds/products_15.csv"
processed: true
size: 346
tmp_name: "/tmp/phppgLCKf"
type: "application/vnd.ms-excel"
url: "/feeds/products_15.csv"
Seems to be successfully imported. Any clue why the database records are not added?