Page Comparison

The purpose of this document is to outline the process for uploading data (specifically Excel and Text files) in WebFOCUS version 8.2.06. In addition to interface changes in this version, the data within these files is now loaded into a binary file format (.ftm) rather than remaining in the original excel (.xlsx) or text (.txt,.csv) formats. 

Upload Data 

1. Navigate to the Content Folder within which you plan to use your data.

2. Right-click on the

   on the

   folder

   and

   , select Upload, and then click Data. You will be able to choose the location where the data will be stored in a later step.

   Image Removed
3. From

   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.

   Image Removed
   Note

   1. In WebFOCUS 8.206, if you have a .txt file,

   use the

   1. select Delimited

   files selection

   1. Files.
      Image Added

4. Browse through your local PC File Explorer to locate

   the

   the file to upload, select the

   File

   file name, and click Open.
   Image Modified

5. Click the purple arrow

   , from

   in the right ribbon at the top of the view.  

   Image RemovedImage Added

6. From the Load Options dialog box, follow the instructions below, based on the file format you are working with.

   File Format Load Options 

   1. Excel Files (.xlsx)

    

   1. 1. Change Adapter to DATREC

   -

   1. 1. – fast binaryfrom the drop-down

   list

   1. 1. .

      2. Make sure the Synonym Application and Data File Location are the same. The default is myhome

   (similar concept to My Content) but

   1. 1. ; for a published report,

   you will need to
   

   1. 1. change these values to the appropriate folder.

   After entering the recommended options above, select the

   1. 1. Click Proceed to Load

   button

   1. 1. .

    

   Image Removed

   1. Text Files (.txt)

    
   Confirm that

   1. 1. Make sure the Synonym Application and Data File Location are the same.

    

   1. 1. The default is myhome

   (similar concept to My Content) but

   1. 1. ; for a published report,

   you
   will need to

   1. 1. change these values to the appropriate folder.

      2. Confirm the File Delimiter, Header

   row

   1. 1. Row, and Field Enclosure settings are appropriate

   for the text file you
   are uploading.After entering the recommended options above, select the Proceed to Load button. 
   

   Image Removed

   Tip
   If the file already exists in the selected folder, there will be a warning that one already exists and it will give you the option to replace it. Click Ok to replace file or No cancel.

     

   1. 1. .

      2. Click Proceed to Load.

7. From the Query Development page, exit the process by clicking the X 

   from

   at the upper right corner of the window.  
   Image Modified

   Note
   At this point, the upload of the file has been completed (the master file, the .acx file, and the .ftm file have been created).

8. From

   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.  
   Image Modified

9. 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.
   Image Modified

   tip

...

Related Articles

...

...

...

...