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 ?
Accepted Solution
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.
TCS
IN
Alright, now for the first one i was able to narrow it down to this code:
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.
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.
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
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.