Question

4
Replies
1317
Views
 Suraj K (SurajK48)
TCS

TCS
IN
SurajK48 Member since 2014 7 posts
TCS
Posted: June 7, 2018
Last activity: July 4, 2018
Posted: 7 Jun 2018 6:02 EDT
Last activity: 4 Jul 2018 1:02 EDT
Closed
Solved

Convert to CSV

Hi,

I am trying to convert a paglist (pxResults) into a csv file.

i am using the ootb activity pxConvertResultsToCSV i am able to get the file if i am running the activity from the rule.

However, When the agent is picking up this activity it is throwing the error "Goal Seek requires missing input property defaultExchangeFormatForExcelPage.pyLocale" on page defaultDateFormatForExcelPage

PFA the snapshot of the tracer.

i also found another piece of java code in another ootb activity writeToCSV where the param is asking for FileHandle - The handle of a PROutputStream. I dunno what that is.

Can anyone please help me with either of this ?

Image removed.

Data Integration Java and Activities
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 3 years ago
Posted: 7 Jun 2018 8:11 EDT
Suraj K (SurajK48)
TCS

TCS
IN

Alright, now for the first one i was able to narrow it down to this code:


 //get default date formats for excel for the requestor locale


PublicAPI tools = null;


PRThread  mThread = (PRThread)ThreadContainer.get();


if (mThread != null) {


tools = mThread.getPublicAPI();


}


      


      String EXCEL_DATE_TIME_DEFAULT_FORMAT = "M/d/yyyy H:mm";


 String EXCEL_DATE_DEFAULT_FORMAT = "M/d/yyyy";


      


      ClipboardPage defaultDateFormatsForExcelClipboardPage = tools.createPage("PegaAccel-DataImport", "defaultDateFormatsForExcelPage");      


   defaultDateFormatsForExcelClipboardPage.putString(".pyLocale", localeCode);


ParameterPage newParamsPage = new ParameterPage();


 The locale code parameter is not getting set when agent is picking up the activity so i tried setting it manually property-set 


param.localecode = OperatorID.pyUseLocale


But the value is not getting set.
Posted: 3 years ago
Posted: 7 Jun 2018 9:05 EDT
Suraj K (SurajK48)
TCS

TCS
IN

Okay, i am closing this. The issue was the the pxRequestor page did not have the pxReqLocale property when agent running, so they were trying to set localCode from that page to another property which was throwing the error


From the above code snippet


ClipboardPage defaultDateFormatsForExcelClipboardPage = tools.createPage("PegaAccel-DataImport", "defaultDateFormatsForExcelPage");


defaultDateFormatsForExcelClipboardPage.putString(".pyLocale", localeCode);


ParameterPage newParamsPage = new ParameterPage();


Although another issue that i have is that the download is not happeing to may local the download stepis getting executed without any error.


Will the file not get downloaded if its being run by an agent? should i use a connect-file instead and store the file another path ?


Please Help !!

Accepted Solution

Posted: 3 years ago
Posted: 11 Jun 2018 8:57 EDT
Santanu Bhattacherjee (Santanu)
PEGA
Senior Manager - Sales Automation
Pegasystems Inc.
IN

Well, when an agent is processing it and trying to download the file to your local system, then it might get blocked by your system OS thinking it as an attack.


Try giving a server location instead. Like you have static content folder similarly create a new folder for this in the server level and try giving the absolute path.