Lenora Barnes Posted March 23, 2022 Share Posted March 23, 2022 Im developing a report for a user and want the user to be able to upload a list of employee numbers from an Excel spreadsheet. This list of employee numbers will be used in the filter of report. I want the user to run the report and be prompted with a year and then be allowed to upload their spreadsheet. Im not looking for the user to be able to open the report in the text editor or InfoAssist. Is there a way as a developer to make this happen using the InfoAssist GUI Thank you so much! WebFocus 8.2.06 InfoAssist Developer Link to comment Share on other sites More sharing options...
Debra Waybright Posted March 24, 2022 Share Posted March 24, 2022 I am not aware of a way to use InfoAssist to be able to upload a spreadsheet. The web client does have the Get Data function which allows permitted users to upload spreadsheets. That process generates a master file for the spreadsheet which you can join to in order to do filtering in a report. Link to comment Share on other sites More sharing options...
Lenora Barnes Posted March 24, 2022 Author Share Posted March 24, 2022 Thank you. I will look into that. The user Im developing the report for will have a different set of ids they will regularly need to upload and then run the report to gather their data points. Im unsure how to accomplish this. Link to comment Share on other sites More sharing options...
Debra Waybright Posted March 24, 2022 Share Posted March 24, 2022 Heres a thought. Upload the initial spreadsheet of ids to establish the .acx and .mas files then maybe find a way to just replace the xlsx file on the reporting server when needed. That is likely a solution outside of WebFocus (an SSIS package for example). Link to comment Share on other sites More sharing options...
Trudy Last Name Posted March 24, 2022 Share Posted March 24, 2022 I do this currently for my users. We have a shared drive with the initial file in it and the user has access to update that file. We created metadata from that original file. We mount the shared drive located locally to our cloud installation of WF and as long as the new file the user overwrites has the same name, tabname, fields and format as the initial file this is working seamlessly for us. Link to comment Share on other sites More sharing options...
Lenora Barnes Posted March 25, 2022 Author Share Posted March 25, 2022 Debra and Trudy, Thank you! Im going to look into these options. I appreciate your time and knowledge! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now