Question

use Activity/RD to fetch all the operators and mail it to email id

hi ,

I need to fetch all the operators i have in Pega and save it in excel (may be mail to any email id)

i wrote one Report definition which gives all the list of operators but export to excel doesn't work and moreover this excel is needed in email

Any suggestions?

Thanks,

Ritika

Correct Answer
November 23, 2018 - 3:51am

store the value in string(text) at property-set, not with date property because the return value is not valid date format it seems.

try and let me know

Comments

Keep up to date on this post and subscribe to comments

November 22, 2018 - 7:34am

If you want excel with all the operator id and email, try like this

1. Create data table with operator id and email id

2. create test activity and try obj-brows or RD(Data-Admin-Operator-ID) to fetch all the operator records

3.Create new page and set values which you fetch from above(pyAddresses(Email).pyEmailAddress) and do the obj-save

4. Export excel from data table where all the records saved

let me know If my understanding wrong from your expectation

 

November 22, 2018 - 8:14am
Response to SuryaPrakash

hey Surya Prakash, 

 

Thanks! actually i had to browse all the operators of pega and get them in excel sheet but now it is done by an activity.

The only thing is i am getting the date in the format as (20160520T080945.000 GMT) but need to convert it in the format (17-9-2018  9:58:00) 
Any idea how can we achieve it ? 

November 22, 2018 - 10:38am
Response to ritikap3

Try as below it's work for your requirement and make sure to close this as an answerable(If it solve your problem) so that it helps other pega community
I hardcoded the date you can change as per requirement

@FormatDateTime("20160520T080945.000 GMT", "dd-mm-yyyy hh:mm:ss", "GMT-1", "en-US")

November 23, 2018 - 3:23am
Response to SuryaPrakash

Hey Surya Prakash, 

 

i tried and it does covert the date to the required format but in the tracer it is failing. Have attached the screenshots 

November 23, 2018 - 3:51am
Response to ritikap3

store the value in string(text) at property-set, not with date property because the return value is not valid date format it seems.

try and let me know