How to fast load Bulk Data to matrx using sap b1 addon

[narasimha_chary2]

I have 1000 records of data.I am loading the data to matrix it will take 20 min of time.How to reduce the time to load data to matrix in sap business one

[former_member233854]

Do you need just to show the data or you will need to save somewhere?

[ANKIT_CHAUHAN]

Hi,

If it is a matrix on the User Form which is bound to the UDO, you can use something as below:

SAPbouiCOM.Matrix oMatrix = (SAPbouiCOM.Matrix)oForm.Items.Item("mtx_0000").Specific;
oMatrix.Clear();
oForm.DataSources.DBDataSources.Item("@LINETABLENAME").Clear();
SAPbouiCOM.DBDataSource oDB = (SAPbouiCOM.DBDataSource)oForm.DataSources.DBDataSources.Item("@LINETABLENAME");
oForm.DataSources.DBDataSources.Item("@LINETABLENAME").InsertRecord(oDB.Size);
oDB.SetValue("U_LineID", oDB.Size - 1, Convert.ToString(oRecSet.Fields.Item("LineID").Value));
oDB.SetValue("U_Code", oDB.Size - 1, Convert.ToString(oRecSet.Fields.Item("Code").Value));
oDB.SetValue("U_Name", oDB.Size - 1, Convert.ToString(oRecSet.Fields.Item("Name").Value));
oMatrix.LoadFromDataSource();

Hope it helps!

Kind regards,

ANKIT CHAUHAN

SAP SME Support