Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Data Table Import not working as expected



A data table is configured such that one of the keys is the Effective Date (property type is Date).
On entering the value for the EffectiveDate field in the Excel sheet in date format, the update is not performed.

Error Messages

Not Applicable

Steps to Reproduce

  1. Create a data table with two keys. One of the keys must have a data type.
  2. Add some records.
  3. Import data through an Excel sheet

    a. Add or Update.
    b. Update if target is blank or if source is not blank.
When the EffectiveDate in the Excel is not Text and if imported, then rows are updated disregarding the types.

Root Cause

The key column is selected as Date type. Hence, when importing a few CSV records, the results are incorrect. 
For a BLOB, getExistingRecords is used to determine if each record of CSV is available in the database. In this case, the value in the database is saved in the yyyyMMdd format. Hence, in the getExistingRecords method, a check is performed to determine if the value is available with the CSV value (that is, with m/d/yyyy format) due to which the existing record returns false. 
After updating the database, the value is converted to database format (that is, m/d/yyyy format is converted to the yyyymmdd format). The update does not occur when the type is 'Update if target is blank'.


Apply HFix-43853.

Suggest Edit

Published September 20, 2018 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us