[SOLVED] Import .csv file for Users to Upload data
Hello
I am looking for some help with allowing a user to upload a .csv file to an html page from their local machine. Then we would need to store that csv file in a location where WebFocus can read it and update/append an oracle database table or Webfocus Table file. This would be sort of an ETL Tool or Application within WebFocus.This message has been edited. Last edited by: FP Mod Chuck,
WebFOCUS 8203
Windows, All Outputs
April 23, 2018, 03:05 PM
BabakNYC
There's an Upload function that does exactly that from the Portal home page or Workbench.
WebFOCUS 8206, Unix, Windows
April 24, 2018, 10:05 AM
DMoses
quote:
Portal home page
Is this for webfocus 8202? Once the csv file is uploaded where is it stored?
WebFOCUS 8203
Windows, All Outputs
April 24, 2018, 10:29 AM
FP Mod Chuck
Dmoses
This is been available in version 8.0 and above. The csv file is saved on the WebFOCUS Reporting server under the application folder selected during the process.
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
April 24, 2018, 02:37 PM
BabakNYC
If you have configured other read/write adapters, you can also allow the user to load the data into one of those DBMS's.
WebFOCUS 8206, Unix, Windows
April 25, 2018, 10:04 AM
DMoses
Would it be possible to have this feature available in the report itself? The user would open a report/dashboard and upload data from there.
WebFOCUS 8203
Windows, All Outputs
April 25, 2018, 10:23 AM
BabakNYC
This is a feature of the Portal. You'd have to do a lot of coding to expose the feature inside a report. However, in the JOIN dialogue there is an UPLOAD button which allows users to blend uploaded data from inside a report. All of this is covered in the doc under Upload. https://webfocusinfocenter.inf...e/working_data37.htm