CSV Export/Import
Updated: 12/17/2024
Export the names and IDs of all objects such as ArtMeshes, deformers, parts, and parameters of the model as CSV files.
Open the exported file in Excel or a text editor, make edits, and then import the file to apply the changes in a batch.
For example, as shown in the image below, this is useful for modifying the names of models created in Japanese to English in a batch.
How to Export and Import CSV Files
Bulk setting of model objects
- Click [Modeling] menu -> [Bulk setting of model objects] -> [Export], and the following dialog box will appear.
Select the items to be exported and export the CSV file to the desired location.
- Modify the CSV file using a text editor or other means.
Do not edit the GUID and type columns of the CSV file output at this time. - Click [Modeling] menu -> [Bulk setting of model objects] -> [Import] to import the CSV file.
Bulk setting of model parameters
- Click [Modeling] menu -> [Bulk setting of model parameters] -> [Export], and a dialog box will appear recommending the creation of a backup.
Export CSV files to the desired location after making backups as needed. - Modify the CSV file using a text editor or other means.
- Click [Modeling] menu -> [Bulk setting of model parameters] -> [Import], and the following dialog box will appear.
Optionally, all existing parameters can be deleted before execution, but be aware that if you have previously added motions to the model, they will be lost.
If everything is as desired, import the CSV file.
Specifications for Bulk Setting of Model Parameters
The properties of the various objects subject to bulk setting are as follows:
• Parameters: GUID, type, ID, name, group, minimum value, default value, maximum value, repeat, description
• Parameter groups: GUID, type, ID, name, label color
| Description | Designation method | |
|---|---|---|
| GUID | This information is used only by the system. This information is uniquely tied to the model parameters. | If the designation is blank, it will be treated as a new addition. Otherwise, it is treated as a change in the parameter settings that exist in the model to which it is imported. |
| ID | The ID of the parameter. | Specify a string. |
| Name | The name of the parameter. | Specify a string. |
| Group | ID of the parameter group. | Specify a string. |
| Min. value | The minimum value of the parameter | Specify a decimal fraction. (1.5, 0.0, etc.) |
| Default value | The dafault value of the parameter | Specify a decimal fraction. (1.5, 0.0, etc.) |
| Max. value | The maximum value of the parameter | Specify a decimal fraction. (1.5, 0.0, etc.) |
| Repeat | Parameter repeat setting is enabled/disabled. | Specify true if enabled or false if disabled. |
| Description | A description of the parameters that can be set as desired by the user | Specify a string. |
| Label Color | The label color of the parameter group. | Specify the color name and color code. |
The following functions are implemented for the following cases regarding the addition and deletion of parameters.
- When you want to make a change
If you want to change IDs, names, etc. in bulk during modeling. - When you want to make changes and additions at the same time
If you want to add a new parameter or parameter group at the same time as 1 above.
• The GUID column of the line for the parameter or parameter group you want to add should be a blank string. - When parameters are used as templates
If you want to set new parameters or parameter groups in bulk, after creating a new model.
• Check the “Delete all existing parameters before execution” checkbox in the import dialog box.
Note: All parameters set in the model are deleted at the beginning of processing.
About Exported CSV Files
You can select the CSV character encoding from UTF-8 and Shift_JIS.
When editing the exported CSV files with Microsoft Excel or other software, please export them in Shift_JIS.
Also, when importing CSV files, be sure to select the correct character encoding from [Character encoding for CSV].
If you select the wrong character encoding and get garbled text, select the correct character encoding and re-import the file.