Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 04, 2017 at 12:31 PM

    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

    Add comment
    10|10000 characters needed characters exceeded