process-mining
2024.10
true
UiPath logo, featuring letters U and I in white

Process Mining

Automation CloudAutomation Cloud Public SectorAutomation SuiteStandalone
Last updated Dec 18, 2024

Configuration settings for loading input data

Settings.json

Important:
The 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.

If the 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.

Using existing process apps with the new data model settings

Follow these steps to use your existing process apps with the new data model settings.

  1. Download the settings.json.zip and unzip the file.

  2. Export the transformations of your process app. See Editing data transformations in a local environment.

  3. Add the settings.json file (if not already present) to transformations.

  4. Make sure both AddRawTablePostfix and StripSpecialCharacters are set to false.

  5. 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.

  6. 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.

  7. Import transformations and ingest new data.

The transformations will be run again in the platform and the source tables will be changed accordingly.
  • Settings.json
  • Using existing process apps with the new data model settings

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.