The purpose of this document is to outline the process for uploading data (specifically Excel and Text files) in WebFOCUS version 8.2.0607. In addition to interface changes in this version, the data within these files is now loaded into a binary master file format (.ftm) rather than remaining in mas) and a copy of the original file (excel (.xlsx) or text (.txt,.csv) formats) will also be created in the application folder.
Upload Data
Navigate to the Content Folder within which you plan to use your data.
Right-click on the folder, select Upload, and then click Data. You will be able to choose the location where the data will be stored in a later step.
On the Upload screen, either double-click on your selection for the type-up file you are uploading or right-click and select Upload Data.
In WebFOCUS 8.206, if you have a .txt file, select Delimited Files.
Browse through your local PC File Explorer to locate the file to upload, select the file name, and click Open.
Click the purple arrow in the right ribbon at the top of the view.
Make sure the Synonym Application and Data File Location are the same. The default is myhome; for a published report, change these values to the appropriate folder.
Click Proceed to Load.
Text Files (.txt)
Make sure the Synonym Application and Data File Location are the same. The default is myhome; for a published report, change these values to the appropriate folder.
Confirm the File Delimiter, Header Row, and Field Enclosure settings are appropriate.
Click Proceed to Load.
From the Query Development page, exit the process by clicking the X at the upper right corner of the window.
In the pending changes Warning dialog box, click No, as your upload is already complete and we do not want to create a report at this time.
The system will display a list of the files in the application folder. Close your browser and return to the WebFOCUS home page. Your data is now ready to be used in a report.
Under LOCAL FILES select the type of file you wish to upload, in the next window, select the folder and file you wish to upload. You have a choice of selecting local files on your PC or files on a server.
There are three steps required before you click on the Load button to load the data.
In this example an Excel spreadsheet is getting uploaded.
Click on the hamburger icon to the right of Adapter: and select the desired adapter. Click on Excel and click on Select on the bottom right of the screen.
Click on Application Folder: and select the desired folder. Click on the folder you wish to upload to and click on Select on the bottom right of the screen.
If you wish to rename the file you’re about to upload, click on the name and update to the desired name.
Click on Load. If you’re loading to master that already exists, you will get a warning.
Click OK, Close the tab. Upload is complete.
If the uploaded file does not already exist, the screen will look like this.
Close the tab, Upload is complete.
From the Load Options dialog box, follow the instructions below, based on the file format you are working with.
Excel Files (.xlsx)
Change Adapter to DATREC – fast binaryfrom the drop-down.| Info |
|---|
For updates to Excel files: If your spreadsheet has the same name and the same worksheet name, simply reupload the file. |
| Note |
|---|
For general assistance or to report an issue with WebFOCUS, log a ticket directly with the Technology Support Center. |
Related Articles
| Filter by label (Content by label) | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...