Business User Edition Technical Library > Working With Data > Uploading, Appending, and Merging Spreadsheets

Uploading, Appending, and Merging Spreadsheets

How to:

You can upload, append, or merge Excel spreadsheets or CSV files using the Upload wizard. Before uploading a new file, you should review Preparing Data for Upload, to ensure that your upload runs successfully.

After you upload a new file, you can append a file by adding new data to an existing synonym, without changing the structure. This option is useful when you are working with a complex or heavily edited synonym, by allowing you to retain all previous edits and data transformations. You can also merge a file with your data and enhance the existing structure.

The procedures in this section provide step-by-step instructions for uploading, appending, and merging files using the default settings in the Upload wizard.

Procedure: How to Upload Excel Spreadsheets

  1. Launch the Upload wizard in one of the following ways:
    • On the Home page, on the actions bar, click Upload Data .
    • In the Open dialog box, in InfoAssist+, click Upload Data.
  2. Drag the file that you want to upload into the Upload pane or click Select File, and navigate to the location of the file on your machine.

    The next screen of the Upload wizard opens, as shown in the image below. You can use the options on this screen to preview and change spreadsheets and delimited data files before you upload them to the target environment. This screen shows you the default breakdown of your data as measures, dimensions, and hierarchies.

    Upload wizard Metadata screen

    For more information about the options that are available in this screen, see Wizard Metadata Screen Reference.

  3. On the ribbon, click Load and Next.

    The Target Load Options dialog box opens.

    Note: In Business User Edition, the default target for the Upload Wizard is Hyperstage, which is configured with a bulk load feature. If you change your target environment from the default, and do not have a bulk load program that supports this environment, you may need to clear the Bulk Load check box. For example, if you are using Microsoft SQL Server, you can use a Bulk Copy Program (BCP). If you are unsure about whether you have a bulk load program installed, contact your system administrator.

  4. Click Proceed to Load.

    If the load is successful, a window opens, and provides options to automatically generate content from your data, create content using the new Master File, or close the Upload wizard, as shown in the following image.

    Callout page in the Upload wizard

    Note: If there are informational messages or if your upload is unsuccessful, the Status screen opens.

  5. Select what you want to do next.

Related Information:

Procedure: How to Append New Data to an Existing Synonym

  1. Launch the Upload wizard.
  2. Drag the file containing the data that you want to append into the Upload pane or click Select File, and navigate to the location of the file on your machine.

    The next screen in the Upload wizard opens.

  3. On the ribbon, in the Load group, click Load Options.

    The Target Load Options dialog box opens.

    Note: In Business User Edition the default target for the Upload Wizard is Hyperstage, which is configured with a bulk load feature. If you change your target environment from the default, and do not have a bulk load program that supports this environment, you may need to clear the Bulk Load check box. For example, if you are using Microsoft SQL Server, you may use a Bulk Copy Program (BCP). If you are unsure about whether you have a bulk load program installed, contact your system administrator.

  4. From the Load Option drop-down list, click Append to Existing.

    In the Select Target Synonym dialog box, select the synonym to which you want to append data.

  5. Click OK.

    The Target Load Options dialog box opens.

  6. Click OK.

    The Merge Editor dialog box opens.

  7. Click OK.
  8. On the ribbon, click Load and Next.

    If the load is successful, a window opens, and provides options to automatically generate content from your data, create content using the new Master File, or close the Upload wizard.

    Note: If there are informational messages or if your upload is unsuccessful, the Status screen opens.

  9. Select what you want to do next.

Related Information:

Procedure: How to Merge New Data With an Existing Synonym

  1. Launch the Upload wizard.
  2. Drag the file containing the data that you want to merge into the Upload pane or click Select File, and navigate to the location of the file on your machine.

    The next screen in the Upload wizard opens.

  3. On the ribbon, in the Load group, click Load Options.

    The Target Load Options dialog box opens.

  4. From the Load Option drop-down list, click Merge into Existing.

    In the Select Target Synonym dialog box, select the synonym to which you want to merge your data.

  5. From the If the record exists drop-down list, click the action you want to occur when a record in the new spreadsheet matches a record in the existing data. You can choose to reject the matching record, update the existing record, or delete the existing record. By default, Update the existing record is selected.
  6. From the If the record does not exist drop-down list, click the action you want to occur when a record in the new spreadsheet does not match the record in the existing data. You can choose to include or reject the record that does not match the existing record.

    Note: In Business User Edition the default target for the Upload Wizard is Hyperstage, which is configured with a bulk load feature. If you change your target environment from the default, and do not have a bulk load program that supports this environment, you may need to clear the Bulk Load check box. For example, if you are using Microsoft SQL Server, you can use a Bulk Copy Program (BCP). If you are unsure about whether you have a bulk load program installed, contact your system administrator.

  7. Click OK.
  8. In the Merge Editor dialog box, you can make additional changes to how your data is merged, for each column in the spreadsheet.

    You must create at least one matching expression before you load your data.

  9. Click OK.
  10. On the ribbon, click Load and Next.

    If the load is successful, a window opens, and provides options to automatically generate content from your data, create content using the new Master File, or close the Upload wizard.

    Note: If there are informational messages or if your upload is unsuccessful, the Status screen opens.

  11. Select what you want to do next.

Related Information:

WebFOCUS

Feedback