A new Flexera Community experience is coming on November 18th, click here for more information.
Hi,
We are running a spreadsheet import and getting validation errors - All fields have data in which are the same as previously imported (earlier version of FNMS - 2017 R3 - now on 2020 R1)
A ConsolidatedInstallerEvidence record and records for other object types were not created from this row of data.
Invalid object. | Evidence | CopyInstallerEvidenceFromExcelCSV | ConsolidatedInstallerEvidence | 22/03/2021 | Missing mandatory value. Object: ConsolidatedInstallerEvidence Column name: DisplayName Row number: 1 A ConsolidatedInstallerEvidence record and records for other object types were not created from this row of data. |
Has anyone seen this ?
‎Mar 22, 2021 10:19 AM
In the Installer Evidence template, the column "Display Name" is a mandatory, required field. This means that you have some rows of data in your InstallerEvidence template file where the Display Name column has a blank value, and therefore cannot be imported into FlexNet Manager.
‎Mar 22, 2021 10:29 AM
Hi,
We have no blanks in our spreadsheet - is there a required format for this column?
Thanks
Stephen
‎Mar 22, 2021 10:34 AM
Can you provide a screenshot of the first several rows of your InstallerEvidence spreadsheet?
‎Mar 22, 2021 11:15 AM
Just tried to load data as per your screen shot snippet which worked for me:
Please feel free to ping me personally if you want to receive a copy of the CSV files I used to import the one-off upload.
Thanks,
‎Mar 25, 2021 06:57 AM
@Smitty987 - You likely have some blank rows of data at the end of your spreadsheet. Open it in Excel and then press CTRL-END. This will navigate to the last cell in the last row of your spreadsheet. This will show if you have blank rows at the end that need to be deleted.
You can also enable filtering in your spreadsheet. In the menu, navigate to Data-->Filter. Each column header will now have a drop-down arrow. Click on the arrow for your DIsplay Name column, which will show all of the unique values in the spreadsheet. If you scroll to the bottom of this list, look for a selection of "(blanks)". If you select this, it will show the rows in your spreadsheet where the Display Name is blank.
‎Mar 25, 2021 07:07 AM
User | Count |
---|---|
8 | |
6 | |
3 | |
3 |