Clarity Database Export Errors
Prior to running a Revit Database Export, there is no defined data for the parameters. Once the first model is run, it sets those values, so all other models with the same parameter name, must have the same types of data set in the parameter or you will get errors.
What that means is, if I look at the first example below BoxSize is expecting an integer, but in the model that it is running on now, it is formatted as a text parameter. The data type must be the same in all models.
Error Examples
- An error occurred during export processing: ArgumentException: Input string was not in a correct format.Couldn't store <18x8.5x80> in BoxSize Column. Expected type is Int32.
- An error occurred during export processing: ArgumentException: Input string was not in a correct format.Couldn't store <87.2cm - 34.3inch> in Width Column. Expected type is Double.
Resolution
To resolve this issue, you will need to edit your models or families to get the custom parameters consistent in all the models, then purge the database.
Following the database purge, parameters don’t have their data type set yet and we start fresh again, but the same rule still applies.
Process
In each model replace the parameter with the correct parameter so the data type is the same as all other models.
Once that is done in all models you can try rerunning the exports, but it is likely you will need to purge the database and rerun the exports.
How to Purge the Database
From the Project Home page, select the Pencil/Checkbox in the upper right and Edit Project
Purge Database
Yes
Rerun the exports.
Alternate Option Skip Tables in the Database
If you want to skip certain tables to get around the issue, please refer to the following blog.
https://imaginit.helprace.com/i692-revit-database-export-config-to-skip-tables