This feature is available only in Inforiver Writeback Matrix.
Inforiver Writeback Matrix provides the flexibility to input values in Excel and seamlessly import them into the visual.
Using the import utility is as simple as selecting the Data Input measure to input values for -> downloading the Excel template -> entering values directly in Excel -> importing the template back into the Inforiver Matrix visual.
Data import utility
Let's look at the steps involved and the options Inforiver Matrix provides to import data from Excel.
STEP 1: In the Data import utility pop-up window, use the Choose Measure dropdown to select the data input measure for which we are importing data. We can import data for one measure at a time.
Select the measure
STEP 2: If you've already entered values in the data input field, you can choose the 'Template with existing values' option to capture the existing values in the template file. Choose 'Blank template' if you do not need the existing values in the template file.
Click Download.
Selecting the template type
STEP 3: Enter values in the downloaded file. In this case, the values already entered in the report have been captured in the template file. Let's add values for the Central and East regions. Data Import Utility feature updates new values while retaining the original values where no updates are needed.
Entering data in the template file
STEP 4: Click the Next button after entering data in the downloaded template file.
Click Next
STEP 5: Click the Browse button. Select the template file that contains the new data input values to be imported into the visual.
Select the template file to import values from
STEP 6: Select the Ignore null or blank values in the CSV checkbox if you do not want to import null values from the template file.
Click Apply.
Ignore null values in template file
You'll see that the values we entered for the Central and East regions have been imported into the visual.
