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.

image-1728997242122.png

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

image-1728997777314.png

Purge Database

image-1728997919498.png

Yes

image-1728997953910.png

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

Was this article helpful?
1 out of 1 found this helpful