Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The purpose of this document is to outline the process for uploading data (specifically Excel and Text files) in WebFOCUS version 8.2.07. In this version, the data within these files is now loaded into a master file (.mas) and a copy of the original file (excel (.xlsx) or text (.txt,.csv)) will also be created in the application folder. 

...

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

  2. 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.

    Image Removedupload dataImage Added
  3. Under LOCAL FILES, select the type of file you wish to upload, in . 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.

  4. local filesImage Modified

    There are three steps required before you click on the Load button to load the data.

    Image Removedsteps before loadingImage Added
    1. In this example, an Excel spreadsheet is getting uploaded.

      Click on the hamburger icon to the right of Adapter

    :
    1. and select the desired adapter. Click on Excel and click on Select on the bottom right of the screen.

    Image RemovedImage Removed
    1. select excelImage Added
    2. Click

    on
    1. Application Folder

    :
    1. and select the desired folder. Click on the folder you wish to upload to and click

    on
    1. Select on the bottom right of the screen.

    Image Removed
    1. application folderImage Added
    2. If you wish to rename the file

    you’re
    1. you are about to upload, click on the name and

    update to the desired name.  Image RemovedClick on Load. If you’re
    1. edit it.  

    2. Check the values for Skipped rows and Header rows to be sure they reflect the data in the file to be uploaded.

      Image Added
  5. Click Load.
    (warning) Note: If you are loading to master that already exists, you will get a warning.

    warningImage Modified
  6. Click OK, Close and close the tab. Upload The upload is complete.

If the uploaded file does not already exist, the screen will look like this.

...

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.  

Filter by label (Content by label)
showLabelsfalse
max10
spacesIKB
showSpacefalse
typepage
cqllabel in ( "webfocus" , "upload_files" , "upload" , "data" ) and type = "page" and space = currentSpace ( )
labelskb-how-to-article

...