Question
CPFB
SG
Last activity: 6 Sep 2017 1:19 EDT
How to update the data instances to existing data tables using file listeners
Hello Team,
I have one query with respect to importing a file for data table values updations. Is it possible to update the existing values or including a new data values into the data tables? If so, could you please explain me to proceed further?
Thanks in advance.
***Updated by moderator: Lochan to add Categories***
Accepted Solution
Pegasystems Inc.
IN
Randstad Technologies US
US
Yes you can do that .its after all a data instance and you can open the record by using obj-open or obj-open by handle to open it and update as required and persist again.
if its is new record just set values to some temp page and persist it.
Pegasystems Inc.
IN
Please let me know what kind of file it is? ( is it excel ).
I am supposing your file will contain list of Data Table entries to be process.
You can update the existing entries by aquiring lock of existing entries and then set required properties to update and save the instance.
New entries can be added by creating new pages of your data table class and saving those page instance.
All these can be done in an Activity.
Regards,
Ashish
CPFB
SG
Hi Ashish,
thanks for your reply. It is a excel file which holds the 4 cloumn of values.
JPMorgan Chase & Company
US
CPFB
SG
yes, it has a unique column.
Accepted Solution
Pegasystems Inc.
IN
Create an activity to parse excel file, details of the process can be found at below link
http://vamshikassety.blogspot.nl/2015/08/parse-excel-file.html
once its done modify ur activity to add/update data table entries using obj-browse,obj-open and obj-save methods.
Hope this will help
Regards,
Ashish
Hi SanthoshkumarD
Create an activity to parse excel file, details of the process can be found at below link
http://vamshikassety.blogspot.nl/2015/08/parse-excel-file.html
once its done modify ur activity to add/update data table entries using obj-browse,obj-open and obj-save methods.
Hope this will help
Regards,
Ashish