Hi,how to fill FK in detail when import data from xls?
list not show the import data because FK is NULL, i don’t want to add FK in xls it is possible?Thanks.
You can use the Row_Import server event to set up the foreign key.
i’ve try but not workHere is my tableT_HeaderIDH (PK)
FreeText-T_DetailIDD (PK)
IDH (FK)
Timestamp
Order
MeasureExcel File Header only 3 column without IDH from T_Header
Timestamp | Order | MeasureI try to use Row_Importpublic bool Row_Import(Dictionary<string, object> row, int cnt) {
//Log(cnt); // Import record count
//Log(row); // Import row
//return false; // Return false to skip import
row[“IDH”] = ExecuteScalar(“SELECT IDH FROM T_Header WHERE IDH ='” + AdjustSql(row[“IDH”]) + “'”);
}What i want in T_Detail auto fill IDHIDD | IDH | Timestamp | Order | Measure
row[“IDH”] = ExecuteScalar(“SELECT IDH FROM T_Header WHERE IDH ='” + AdjustSql(row[“IDH”]) + “'”);
The code does not do anything. If row[“IDH”] exists, you are just getting the same value. If it does not exist, you does not get anything.If you need to retrieve the FK, you need to have something in the row data which can relate to the FK.
MichaelG wrote:
row[“IDH”] = ExecuteScalar(“SELECT IDH FROM T_Header WHERE IDH
='” + AdjustSql(row[“IDH”]) + “'”);The code does not do anything. If row[“IDH”] exists, you are just getting
the same value. If it does not exist, you does not get anything.> If you need to retrieve the FK, you need to have something in the row data which can
relate to the FK.
Ok Thank you, i develop another app to modified excel file.is it possible to upload only created table on database?Example :
In excel i have 5 column
Col1 | Col2 | Col3 | Col4 | Col5
In database i have only 3
Col1 | Col4 | Col5
Use the Page_Importing server event to set up the headers and skip the first header record.
MichaelG wrote:
Use the
Page_Importing
server event to set up the headers and skip the first header record.
Thank you for ur help.