Skip to main content
A
ankits7238
September 19, 2024
Question

Issue while using import csv to DB

  • September 19, 2024
  • 2 replies
  • 0 views

i am trying to use import csv to db, with using these columns, but only 3 columns value is going to save and other columns save with null values. give me quick solution for it

="Region,

Country,

ItemType,

SalesChannel,

OrderPriority,

OrderDate,

OrderID,

ShipDate,

UnitsSold,

UnitPrice,

UnitCost,

TotalRevenue,T

otalCost,

TotalProfit"

2 replies

vinaykumarp8308
vinaykumarp8308
Participating Frequently
September 19, 2024

[mention:d79b8279413e474ab882b532e6edacc1:e9ed411860ed4f2ba0265705b8793d05] 

Can you check the header names in your excel matches the field names or provided them in Csv Header Names input?

kumara0180
kumara0180
September 19, 2024

Ya agree with [mention:d79b8279413e474ab882b532e6edacc1:e9ed411860ed4f2ba0265705b8793d05] . Also if you look at it there are only 5 fields mandatory. Just configure them once. Check the output after that as well. 

You are on right track just try with configuring other parameters as well. Check the error if you get any and try again. 

Terms & ConditionsAccessibility statement