---
sourceDocument: Yokohama Data and Automation
sourceDocumentLink: https://www.servicenow.com/docs/r/yokohama/integrate-applications

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama Data and Automation

ft:clusterId :

    - crint

bundleId :

    - crint

workflow :

    - Creator


---

# Import sets properties

# Import sets properties {#ariaid-title1}

* Release version: Yokohama
* 
* Updated January 30, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 8 minutes to read

Summarize  
![AI sparkle icon](https://servicenow.com/docs/portal-asset/ai-sparkle-icon) Summarized using AI  
This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.  

## Summary of Import sets properties

Import sets properties in ServiceNow control the behavior and performance of data imports from various sources such as Excel files, CSV files, JDBC connections, web services, and scheduled imports.
These properties allow administrators to customize how data is processed, validated, logged, and stored during the import process.
Show full answer Show less  

## Key Features

* **Data Handling and Preservation:** Properties like `glide.importset.preserve.leading.spaces` control preservation of leading spaces in Excel data, while `glide.impex.transformer.emptyvaluenil` governs handling of empty string values during transformation.
* **Dynamic Field Management:** The `glide.importsetrow.dynamicallyaddfields` property allows or prevents import sets from dynamically adding new columns to staging tables, helping avoid performance issues or outages.
* **Field Sizing:** `com.glide.loader.verifytargetfieldsize` enables dynamic resizing of import set fields based on source data length, preventing data truncation.
* **Import Source Support:** Properties such as `glide.ds.file.http.variablereplacement` support system property expansion in HTTP/HTTPS file data sources, enhancing flexibility.
* **Error Handling and Control:** Using `glide.scheduledimport.stoponerror`, imports can halt on errors, useful when imports depend on each other.
* **Concurrency and Performance:** Several properties manage concurrent import limits and locking behavior, such as `glide.scheduledimport.max.concurrent.importsets` and `com.glide.concurrentimportsetinsertmutexexpiration`, ensuring efficient processing.
* **Web Service Import Set Behavior:** Properties like `com.glide.wsimportset.columnresize` control dynamic resizing of staging tables during web service imports.
* **CSV and Excel Import Configuration:** Properties including `com.glide.csv.loader.ignorenonparseablelines`, `glide.import.csv.charset`, and memory settings like `glide.xlsx.multiplier` allow customization of import tolerance, character encoding, and resource allocation for file imports.
* **Logging and Debugging:** Logging levels and debug flags such as `com.glide.importset.importloglevel` and `glide.import.debug` enable tailored logging for import troubleshooting and environment-specific needs.
* **JDBC Connection Retry:** Properties control retry behaviors for JDBC data source processing, improving reliability.

## Practical Benefits for ServiceNow Customers

* These properties provide granular control over import processes, enabling you to optimize performance, prevent downtime, and handle data quality issues effectively.
* Customizing memory and field sizing settings ensures large or complex data imports are processed efficiently without data loss.
* Proper use of error handling and concurrency properties helps maintain stable and reliable imports even in complex or high-volume environments.
* Logging and debug options support faster diagnosis and resolution of import issues in both development and production environments.
* Control over CSV and Excel import behavior allows handling of common challenges such as malformed data rows, character encoding issues, and memory limits.

## Implementation and Configuration

All these properties are configured as system properties accessible via the system properties interface. Adjusting them requires administrative access and should be done considering your instance's import workload, data sources, and performance requirements. Some properties have default values optimized for general use but can be tuned for specific scenarios to improve import reliability and efficiency.  
Multiple properties control import set behavior.

## Import sets properties {#r_ImportSetsProperties__section_d4y_pcf_1jb}

glide.import_set.preserve.leading.spaces
:   Specifies whether the import process preserves leading spaces in Excel data cells.
    When false, the import process removes non-breaking leading spaces from Excel data
    cells. When true, the import process preserves non-breaking leading spaces.  
    Note:  
    The import process always removes trailing spaces from Excel data cells.

    * Type: true \| false
    * Default value: false
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    {#r_ImportSetsProperties__ul_olk_ps1_kr}

glide.import_set_row.dynamically_add_fields
:   Specifies whether an import set can add new columns to the staging table (true) or not
    (false). Instances that contain large numbers of import sets can sometimes become
    unresponsive when an import adds a column because the instance must alter every row in
    the staging table. In some cases, the database alter table action causes an outage.
    Setting this property to false prevents an import set from adding columns to the staging
    table and produces a log message. As a workaround, administrators can manually add a
    column to the staging table by creating a new dictionary entry and then reimporting the
    import set.

    * Type: true \| false
    * Default value: true
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    {#r_ImportSetsProperties__ul_chh_xcf_1jb}

com.glide.loader.verify_target_field_size
:   Enables dynamic resizing of import set fields. With the default setting of
    false, up to 20 records of the source data are sampled to
    determine the import set field length. If the field is empty in all the sampled records,
    the default length of 40 is used. Any data loaded that exceeds the import set table
    field length is truncated. Set this property to true to allow any
    import set field to increase the column size by 100 to match the length of the data. For
    example, if the incoming source data has a length of 60, the system sets the length of
    the column to 160. This is relevant to data source only.

    * Type: true \| false
    * Default value: false
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    {#r_ImportSetsProperties__ul_ahj_22l_xw}

glide.ds.file.http.variable_replacement
:   Enables system property expansion for File-type data sources that are retrieved using
    HTTP or HTTPS.

    * Type: true \| false
    * Default value: true
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    * More information: [Data source fields](https://www.servicenow.com/docs/MtphPrmFOEGr2FpzEQEjmg "In addition to common fields, other fields appear on the data source form, depending on the value of the Type field.")
    {#r_ImportSetsProperties__ul_gxh_nl4_kx}

glide.scheduled_import.stop_on_error
:   Set to true to stop the import process when the parent scheduled
    import generates an error. This behavior can be useful when one import set depends on
    the results of another import set.

    * Type: true \| false
    * Default value: false
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    {#r_ImportSetsProperties__ul_hjs_4sq_3y}

glide.impex.transformer.empty_value_nil
:   Controls how empty string values are handled during transformation from an import set
    staging table. Set this property to true to preserve empty strings. Set
    this property to false to convert empty strings to the string
    NULL.  
    Note:  
    An empty string is always stored as a null value in the database, regardless of this property value.
    You can use this
    property when you run an onBefore script during transformation. Setting this property to
    true allows you to check for null values using
    hasValue() or nil() functions.

    * Type: true \| false
    * Default value: false
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    {#r_ImportSetsProperties__ul_um3_g5c_gz}

com.glide.loader.max_scan_rows
:   Controls how many rows of source data are sampled to automatically generate staging
    table fields when you import data. This property applies to JDBC, XLS, CSV, and XML
    imports but not to JSON and XSLX imports.

    * Type: integer
    * Default value: 20
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    {#r_ImportSetsProperties__ul_tyy_s3x_d1b}

## Concurrent import sets properties {#r_ImportSetsProperties__section_fjp_ldf_1jb}

glide.scheduled_import.max.concurrent.import_sets
:   Maximum number of import sets for one concurrent import.

    * Type: Integer
    * Default value: 10
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    {#r_ImportSetsProperties__ul_qf4_ydd_vfb}

com.glide.concurrent_import_set_insert_mutex_spin_wait
:   Wait time mutex spends if the lock is acquired (in milliseconds).

    * Type: Integer
    * Default value: 1000
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    {#r_ImportSetsProperties__ul_rmw_xdd_vfb}

com.glide.concurrent_import_set_insert_mutex_expiration
:   Mutex expiration time (in milliseconds).

    * Type: Integer
    * Default value: 300000
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    {#r_ImportSetsProperties__ul_kz1_xdd_vfb}

com.glide.concurrent_import_set_mutex_fast_lock
:   Specifies whether to use fast lock (true) or SQL-based slow lock (false).

    * Type: true \| false
    * Default value: false
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    {#r_ImportSetsProperties__ul_jdm_vdd_vfb}

## Web service import sets properties {#r_ImportSetsProperties__section_hrk_5df_1jb}

com.glide.ws_import_set.column_resize
:   When true, enables dynamic column resizing on import staging tables for web service
    import sets.

    * Type: true \| false
    * Default value: false
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    {#r_ImportSetsProperties__ul_k34_qqq_zv}

com.glide.ws_import_set.column_resize.max_row_count

:   The maximum number of rows an import staging table can have for dynamic column resizing with web service import sets. Import staging tables with more than this
    number of rows will not use dynamic resizing with web service import sets, even if
    com.glide.ws_import_set.column_resize is true.

    This property has a maximum value of 500,000.

    * Type: Integer
    * Default value: 100,000
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    {#r_ImportSetsProperties__ul_ibq_qqq_zv}

## CSV properties {#r_ImportSetsProperties__section_cck_c2f_1jb}

com.glide.csv.loader.ignore_non_parseable_lines
:   Allows an instance to ignore one or more lines (rows) that contain bad data in a CSV
    import, such as a row that is missing a column of data. By default, imports cannot
    ignore bad data in CSV files and fail on the first error.

    * Type: true \| false
    * Default value: false
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    {#r_ImportSetsProperties__ul_imp_5w1_kr}

com.glide.csv.loader.max_errors_allowed
:   Specifies the maximum number of lines (rows) that an import can ignore before failing.
    If the import succeeds, the import lists the number of rows the import ignored due to
    errors.

    * Type: integer
    * Default value: 100
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    {#r_ImportSetsProperties__ul_wky_dw1_kr}

glide.import.csv.charset
:   The charset of the CSV file to import. Valid values are UTF-8 and WINDOWS-1252. You
    may need to use UTF-8 formatting when importing special characters.

    * Type: String
    * Default value: WINDOWS-1252
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    {#r_ImportSetsProperties__ul_dmr_wlt_15}

## Excel import properties {#r_ImportSetsProperties__section_mbc_42f_1jb}

glide.excel.multiplier

:   The maximum amount of instance memory to allocate to an Excel import. This property applies when importing .XLS files only. The value of this property is multiplied by
    the file size of the Excel file to determine the total memory allocation. The memory
    used cannot exceed the limit specified by the
    glide.excel.max_memory_percent property.

    For example,
    with the default value 8 and a 10MB Excel file, the instance will use up to 80MB of
    memory for the import.

    * Type: integer
    * Default value: 8
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    {#r_ImportSetsProperties__ul_rpr_stl_h5}

glide.xlsx.multiplier

:   The maximum amount of instance memory to allocate to an Excel import. This property applies when importing .XLSX files only. The value of this property is multiplied by
    the file size of the Excel file to determine the total memory allocation. The memory
    used cannot exceed the limit specified by the
    glide.excel.max_memory_percent property.

    For example,
    with the default value 10 and a 10MB Excel file, the instance will use up to 100MB of
    memory for the import.  
    Note:  
    Do not modify the value of this property. The default value was selected for optimal performance.

    * Type: integer
    * Default value: 10
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    {#r_ImportSetsProperties__ul_fyw_byf_45}

glide.excel.max_memory_percent
:   The maximum amount of memory allowed for Excel imports, as a percentage of the total
    instance memory.

    * Type: integer
    * Default value: 10
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    {#r_ImportSetsProperties__ul_azm_45l_h5}

glide.excel.use_disk_backed_strings_table
:   Controls whether the instance uses disk storage to maintain large file data during
    XLSX import. Set this property to false to store XLSX file data only in memory. Setting
    this property to false increases the memory used during XLSX import.

    * Type: true \| false
    * Default value: true
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    {#r_ImportSetsProperties__ul_ukx_5nf_45}

glide.excel.in_memory_strings_table_size_mb
:   The maximum amount of memory, in megabytes, available to store XLSX file data before
    writing to disk storage when glide.excel.use_disk_backed_strings_table is true. Setting
    a lower value for this property will use less memory during XLSX import but may result
    in slower imports.

    * Type: integer
    * Default value: 5
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    {#r_ImportSetsProperties__ul_bdd_vnf_45}

glide.xlsx.import.debug
:   Enables debug logging for XLSX imports.

    * Type: true \| false
    * Default value: false
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    {#r_ImportSetsProperties__ul_lqw_xd1_p5}

glide.import.excel.enhanced_number_conversions
:   When true, numeric values greater than 10 million are preserved in import staging
    tables. When false, imported values greater than 10 million are converted to scientific
    notation that may not match the original imported value. This property should be set to
    true for importing most kinds of data.

    * Type: true \| false
    * Default value: true
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    {#r_ImportSetsProperties__ul_xjj_k5b_3y}

glide.transform.boolean.casesensitive
:   When true, upper case boolean values of (TRUE/FALSE) always transform to false. When
    false, upper case boolean values (TRUE/FALSE) are transformed correctly.

    * Type: true \| false
    * Default value: true
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    {#r_ImportSetsProperties__ul_asd_2kr_prb}

## JDBC connection properties {#r_ImportSetsProperties__section_j4g_bff_1jb}

glide.jdbcprobeloader.retry
:   The number of times a JDBC probe loader attempts to process data returning from a JDBC
    data source. Sleeps on the value defined in
    glide.jdbcprobeloader.retry_millis between retries.

    * Type: integer
    * Default value: 60
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    {#r_ImportSetsProperties__ul_u14_brq_dq}

glide.jdbcprobeloader.retry_millis
:   How many milliseconds a JDBC probe loader waits in between retry attempts to process
    data from a JDBC data source.

    * Type: integer
    * Default value: 5000
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    {#r_ImportSetsProperties__ul_y2v_2rq_dq}

## Logging and debug properties {#r_ImportSetsProperties__section_bpv_3ff_1jb}

com.glide.import_set.importlog_level
:   Specifies how much information import sets add to the log. Possible values are INFO,
    WARNING, and ERROR. You can set this to INFO in the dev environment and change it to
    WARNING or ERROR in production to reduce amount of logging noise traffic to the
    database.  
    Note:  
    This property does not impact logging related to the cleanup of staging tables.

    * Type: string
    * Default value: INFO
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    {#r_ImportSetsProperties__ul_ptl_3pf_f5}

glide.import.debug
:   Enables debug logging for all import processes.

    * Type: true \| false
    * Default value: false
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)Add to the System Property \[sys_properties\] table
    {#r_ImportSetsProperties__ul_qpv_ljg_y5}

glide.importlog.log_to_table
:   Specifies whether to write information-level log messages into the import_log table.
    When true, the information-level log messages are written.  
    Note:  
    The information-level logs for [IntegrationHub ETL](https://www.servicenow.com/docs/access?context=integrationhub-etl&version=yokohama&pubname=yokohama-servicenow-platform&ft:locale=en-US) are written to the importlog.log table regardless of this property setting. To have additional exceptions added, contact Now Support.

    * Type: true \| false
    * Default value: false
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    {#r_ImportSetsProperties__ul_uqd_3st_lrb}

glide.import.sftp.debug
:   Enables additional debug logging for SFTP imports. Enabling this property will cause
    the instance to log all outgoing and incoming messages during the SSH session.

    * Type: true \| false
    * Default value: false
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    {#r_ImportSetsProperties__ul_b3l_5jg_y5}

glide.import.scp.debug
:   Enables additional debug logging for SCP imports. Enabling this property will cause
    the instance to log all outgoing and incoming messages during the SSH session.

    * Type: true \| false
    * Default value: false
    * Location: [Add a system property](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US)
    {#r_ImportSetsProperties__ul_wvf_vjg_y5}