Downloading a file from a Generic Inquiry side menu

Question

I have a generic inquiry for displaying a side panel on an ‘Export Shipments’ page. This side panel lists all the Files on the page (this page has the option to create a document and attach it to the page, populating the default ‘Files’ popup).

I would like to update this side panel so when a user clicks the file name it will download the file instead of navigating to the ‘File Maintenance’ page.

I noticed the File Maintenance page has the ‘External Link’ field that is a part of the ‘UploadFileWithIDSelector’ -

I was originally using the ‘UploadFile’ data class for displaying the Name, CreatedDate, and a few other properties belonging to ‘UploadFile’ on the side panel but this data class doesn’t have access to the ‘External Link’ field so I updated the generic inquiry to use the ‘UploadFileWithIDSelector’ data class and attempted to add the ‘External Link’ field in the Results Grid -

With this setup the page only displays the Name and CreatedDate with the External Link value being empty (also tried the Source URI and that is empty as well) -

Some extra information that may be useful, I had to add a view records in the ‘Relations’ section to make sure the correct files are being retrieved for this particular ‘Export Shipment’ record as well as linking the NoteDoc table with the UploadFileWithIDSelector table based on the fileID -

I’ve attached the exported generic inquiry as well. I feel like there is some other connection between tables that needs to be added (probably in the ‘Relations’ section) to allow the External Link to appear on the side panel so the user can click that link to download the file. Any help/suggestions are more than welcome!

icon

Best answer by mbarrett 3 April 2024, 02:38

View original

mbarrett · Accepted Answer

@rcambierI was able to get your inquiry into my local demo instance and was able to successfully get my uploaded files to be directly downloaded when clicking on the hyperlink on each recordfrom the Results. Below are the steps you need to take in order to replicate this.First identify what your file download URL is for your Acumatica instance:This can be done by navigating to any file on the File Maintenace screen and selecting the “GET LATEST VERSION” button.This will prompt the selected file to be downloaded to your local system through your browser. Then navigate to the Downloads page of your browser and copy the File path that was used to download the file.Paste this information in some text editor program such as notepad and modify the URL by removing the “fileID=” and “revision=”information and replace each valuewith this exact text:((FileID))((RevisionID))From this: http://localhost/Acumatica2023/(W(10696))/Frames/GetFile.ashx?fileID=1a4f0b3b-b852-43fb-8c06-17fa114c301c&revision=1&fdwnld=1To this: http://localhost/Acumatica2023/(W(10696))/Frames/GetFile.ashx?fileID=((FileID))&revision=((FileRevID))&fdwnld=1Now back in the Acumatica Generic Inquiry screen go to the Navigation tab and paste the modified URL into the Navigation Targets Link field and select New Tab for the Window Mode.Once pasted you can move over to the Navigation Parameters section to the right and fill out the 2 Parameters we created in the URL to inject the value from the datafields.Field = ((FileID)) Parameter = UploadFileRevision.FileIDField = ((FileRevID))Parameter = UploadFileRevision.FileRevisionIDNow Save the Inquiry and apply this new navigation parameter to the data field you want the hyperlink on from the Results Grid Tab of the Generic Inquiry.Uncheck the Default Navigation check box and then select the URL in the Navigate To Column.After all of these steps it should do exactly what you described in your original post open up your inquiry and test it out. Let me know if you run into any issues and Good Luck!