Frequently Asked Questions

The FAQ will answer the most commonly asked questions as well as help to understand and resolve the errors/warnings displayed after file validation.

• What is the Data Management Portal (DMP)?

  Data Management Portal (DMP) is a software platform designed to aid you in validating the agency file data and provide inputs on what data/info needs your attention.

• How does it work?

  DMP serves two purposes currently. You must create the new Virtuoso Data Footprint file to reflect all your changes related to Client, Booking, Vendor, Commission and Traveler as applicable.

  1. To validate the file and provide the data issues/warnings within few minutes. Please note that you must login to DMP directly and validate the file when you want to perform this operation. The file is not uploaded (only validated).
  2. Login to DMP to view the details of all data issues/warnings for all the files that you have uploaded to Virtuoso under "Upload History". Select the file for which you want to see the validation results and the details will be displayed for ease.
• How do I know that my file uploaded?

  Select the Upload History tab in the top navigation bar of the Data Management Portal and all of your upload history will display. This includes the list of:

  1. Any files that you tried to validate
  2. Any files that you uploaded at http://securesync.virtuoso.com/WebReporting/Public/login.aspx
  3. Any files that you uploaded using automatic Virtuoso Upload Tool (VUT)
  4. Any files that you auto transferred to Virtuoso Secure FTP server
• Does this mean that all my files were successful?

  In the Upload History tab, if the Status is showing "Complete",

  1. "Uploaded By" column is showing "GRASP web portal", then the file was validated and uploaded successfully.
  2. "Uploaded By" column is showing another login, then the file was only validated through DMP.
• How will I know if my data is accurate and complete?

  Go to "Validation Results" page, it will display the latest file's data issues/warnings. If there are no errors/warnings, then it will display the message "Congratulations! Your file has been validated and contains no errors or warnings".

• What do I do if I receive - "A system error has occurred. Please contact support".

  This is a critical error which has prevented your file from uploading. We will need to view the file you are attempting to upload to find the issue. Please contact us through help@virtuoso.com or call 817-870-0300 and ask for the Data Integration Team.

• What do I do if I receive - "Error reading file. Please verify file and re-upload"
  1. It is likely that the file does not have a tab called "ClientData", please update it and retry. (OR)
  2. It is likely that the file has been saved in unsupported formats (instead of .xls or .xlsx). This will cause your file to "Terminate". Please save it in the correct format and retry.
• What do I do if I receive - "Server Error"

  There might be a technical issue that we must address and would need additional details to troubleshoot and address the problem. Please contact Virtuoso Support at 817-870-0300 or help@virtuoso.com and ask for the Data Integration Team.

• What do I do if I receive - "Validation could not start because another import is currently in progress."

  A previously uploaded file is still trying to process. Please contact Virtuoso Support at 817-870-0300 or help@virtuoso.com and ask for the Data Integration Team.

• How can I address the issues identified as "Blank Keys"?

  Please expand "Blank Keys" by clicking on the Down arrow icon (OR) by clicking "Expand all" at the top of the results. It will show the Tab in which there are rows without the key information. The row number and key column is provided for ease. For example, in the below screenshot it is saying that => The key column proid does not have any values in the rows 17 and 20 (in the ClientData tab)

• How can I address the issues identified as "Columns not found in Excel"?

  Expand the error and you will see the Tab and the name of the column(s) that are missing. Depending on the member agency, some of these are not present because they do not have that data or do not want to share that info. Depending on your agency, you can identify if all the missing columns are as per your need and either include these columns with data (OR) discard this error.

• How can I address the issues identified as "Date and money conversion errors"?

  When the data in the column is not in the expected format such as date or currency format, this error will display in your Validation Results.

  To resolve find the Tab and Column in your file and you will be given the Unrecognized Value. Use Ctrl F, enter the unrecognized value and "Find All". When data is corrected, save the file and retry.

• How can I address the issues identified as "Duplicated Keys"?

  More than 1 row in the tab shares the same key (it is not unique). Keys must be unique but in this case, it is not and hence the data would have been discarded for these rows from processing. Please fix the duplicates and retry.

  Expand the Error and you will see the Tab, Column(s) and the key that is duplicated. Use Ctrl F to Find ALL. Replace the duplicate with the correct information.

• How can I address the issues identified as "Orphaned Keys"?

  Some of the key information is not present but is being referenced in another place. Expand the error and you will see the tab in which the missing key is being referenced or used. In the below example, in the booking tab we have bookings with vendorid 312803 and 66819, but there is no vendor in the Vendor tab with VendorID as 312803 and 66819. To correct the error, if these VendorID exist, then update the Vendor tab to include the details for these VendorIDs. If these VendorID are wrong, then update the booking tab to reflect the correct VendorIDs on those bookings.

• How can I address the issues identified as "Truncation Error"?

  A truncation error occurs when you have exceeding the character limitation of a column.

  Expand the Error to see the columns: Tab, Column, Row, Maximum Column Width Allowed, and Cell Data (what you have actually in the row) will be displayed. In the below example, the VendorType column in Vendor tab has the data "as of 8/20/02 Delta Queen Steamboat Company sold" instead of what the vendor type is like Air, Insurance etc. Please fix it and retry.

• How can I address the warning identified as "Excel tab [AAAAAA] not found"?

  Your spreadsheet is missing this entire "tab/worksheet" of data. In the brackets [ ] they will tell you the tab not found. If your agency is not planning to share that data, then it is fine to discard. But if you do want to share that data, then please ensure that the tab is present along with the corresponding data. It could be a tab name misspelling to correct in some cases.

• How can I address the warning identified as "Fields that we cannot interpret and will be discarded"?

  The columns names must be exact as in the Virtuoso Data Footprint template. This warning will list the columns

  1. That Virtuoso used to utilize in the older formats and no longer uses them => You can remove these columns from your files as it is not being used.
  2. That Virtuoso does not understand => Probable spelling mistakes in the column name, please fix and retry.

  In the below example,

  1. ClientData tab has column indtr instead of indtrav – so this column header must be updated.
  2. Booking tab has columns Agent Commission Amount and Destination City => these are old columns that Virtuoso does not use anymore, so these can be deleted from the file.
• What is the summary information?

  The Summary Information section contains a summary of changes made to records. It is a quick overview of how many clients were added or profiles updated for the listed advisor since the last Data Foot Print was uploaded.

• I need help beyond this FAQ can address, what do I do?

  Send an email to help@virtuoso.com or call 817-870-0300 and ask for the Data Integration Team. A member of the team will reach out to you to assist.