- Release notes
- Before you begin
- Getting started
- Integrations
- Working with process apps
- Working with dashboards and charts
- Working with process graphs
- Working with Discover process models and Import BPMN models
- Showing or hiding the menu
- Context information
- Export
- Filters
- Sending automation ideas to UiPath® Automation Hub
- Tags
- Due dates
- Compare
- Conformance checking
- Root cause analysis
- Simulating automation potential
- Triggering an automation from a process app
- Viewing Process data
- Creating apps
- Loading data
- Customizing process apps
- App templates
- Additional resources
- Editing data transformations in a local environment
- Setting up a local test environment
- Custom throughput time metrics
- SQL differences between Snowflake and SQL Server
- Configuration settings for loading input data
- Designing an event log
- Extending the SAP Ariba extraction tool
- Performance characteristics
- Basic troubleshooting guide
Configuration settings for loading input data
AddRawTablePostfix and StripSpecialCharacters settings in the settings.json file are no longer supported and cannot be used anymore to switch existing process apps to the data loading behavior that
was introduced in March 2023.
When uploading data, always make sure that the input data is in the required format for the app template that you use to create the process app. See App Templates.
settings.json file of your process app still contains these settings, you can safely remove them since they are not used anymore.
|
Setting |
Format |
Description |
| AddRawTablePostfix |
boolean | For adding a _raw suffix to your source tables when using file uploads through the Upload data option. For example, if the file you upload is named Event_log.csv it changes to Event_log_raw.csv if this setting is set to true. |
| StripSpecialCharacters |
boolean | For removing special characters and replacing spaces with underscores in table names and/or field names. For example, a field called Event+end changes to Eventend. |
Follow these steps to use your existing process apps with the new data model settings.
-
Download the settings.json.zip and unzip the file.
-
Export the transformations of your process app. See Editing data transformations in a local environment.
-
Add the settings.json file (if not already present) to transformations.
-
Make sure both AddRawTablePostfix and StripSpecialCharacters are set to false.
-
Change your input files, or transformations, such that the file names match exactly. For example, if your input transformations expect event_log_raw then your csv file should also be called event_log_raw.csv.
-
If you are using special characters in table names or field names (for example ' ', '(' or '?'), then make sure the input transformations use the same name. For example, a field Activity category should be referred to as Activity category in your queries and not Activity_category.
-
Import transformations and ingest new data.
