I've submitted to your query to subject matter expert(s) in the hope we can get you an answer soon. Someone will check back on this post in the next 24-48 hours to see if the SME has responded. Thank you for your patience.
PDN and Pega Academy Self-study Forums Support Team
FSFFileName : Name and Location of the uploaded excel file.
If you are not sure about this, please follow below steps.
Click on Pega -> Application--> Distribution --> Import
From the import wizard, select the XSLX file and click on next. You will see an error message "File extension must contain .jar or .zip". Ignore the error message and open your clipboard. From Clipboard, check the property value PxRequestor . pyFileUpload. (example: file:\\\webstatic\....)You can directly use this value as input for FSFFileName.
Basically this is the location where you need to upload your excel files. Unless you have any other staging location on the server.
TemplateRFB: Name of the uploaded binary file, it should follow <Directory name>!<Rule Name>!<extension>
Here directory name is the first key part when you create Rule-File-Biunary, it could be webwb, app or any thin else you have provided.
There is a requirement to insert data to database from an excel sheet( having multiple rows of data).the data also needs to be shown in an window before inserting it to database.can anyone help me.The excel sheet format is predefined. usr will only fiil up the required data set in excel sheet.click on attach and browse button to browse to the path where excel sheet is kept and then to show whole excel data in an window and then click on submit button to insert data into database.and while doing so it will check whether same data exist in the data base or not.suppose the excel contain 7 rows of data.while inserting it shows Duplicate=1,data Inserted=6
File parsing was working correctly , i used similar approach used binary file and used MSOParseExcel activity , it was working with parameter pxRequestor.pyFileUpload .today it was not working and i try to change it to value of this property path also from clipboard still getting The uploaded file template could not be recognized. Please upload a valid file. Refer to template for details.
Im getting below error in log:
Error in parsing Excel file file://web:/StaticContent/global/ServiceExport/null