Bulk Load of data

  • 21 December 2018
  • 3 replies
  • 26 views

Badge +8

HI All

 

I have created several Smartbox SO which I'm using in my applications

For lots of them such as customer master I need to bulk load hundred of rows of data

 

Does anyone have a simple method to populate these smartobjects with data without having to type each row individually?

 

 

thanks
Paul


3 replies

Hey psturmey,

 

Where is this data coming from? A SQL database somewhere? Depending on what your data source is you can potentially use a Service Instance to automatically pull a list of data into a SmartObject.

 

~ Andrew

Badge +9

Using SmartForms, you could load your source data into a list view then execute Create method for All rows of the list view to create each record in your SmartBox SmartObject.

Badge +8

Hi Nik

 

The issue I have is getting my source data (from excel) into a list view 

I agree that once its in a list view I can then run a create method for all rows to upload the data

 

regards

Paul

Reply