Trying to understand how to import mass pre-populated data from Excel to an IDO(in my case SLJobRoutes) considering IDOs are collection of multiple tables and ... .
Thank you!
Let me rephrase that, is there any way i can disable filtering the result(maybe event handlers?) in current operations based on item number and show all the item numbers ?
Do you have access to the database directly via SQL?
No, using V10 cloud version
with API's
I do things like this using the following steps:1 - create a new ido with unbound properties - one for each property you want to import2 - create a detail view only form using ido created in step 1 as source3 - add grid to form and add column for each property outlined in the ido you created4 - add button to the form and create event to call a form script5 - write form script to use LoadCollectionRequest and LoadCollectionResponse to write data to the IDOs you want to import data intoYou should be able to paste-rows-append data from the excel sheet into the form you create, and the form script will import the records from the form into another ido.
I will try this, thank you so much!
I wish i had more resources about using API, do you have any resources ?
We use a product from Decision Resources call decision Excelerator. We are in the implementation stage, V10 Cloud, and that is what we use to import data. Very powerful. DecisionExcelerator - Decision Resources, Inc.
Thank you so much!