Excel Data Import Utility (VDIU_)

Owned by Tanpreet Singh (Unlicensed)
Last updated: Jun 13, 2024 by Yogita Rani
3 min read

Version

Date

Included

Version

Date

Included

2.0.6.0

Jun 12, 2024

Bugs Fixes:

  1. Removed the 'Address' column from the default mapping Excel file, in the previous version, it was hidden 

  2. Handled multiple identifiers: update and create records based on the combined values of all identifier columns in case of default mapping (e.g., identifier1_identifier2 are the identifiers on parent table, based on these identifiers records will be inserted/updated)

  3. Support for LOV (list of values), having characters more than 256

2.0.4.0

May 9, 2024

Enhancements:

  1. Support culture   

  2. Provided support for "Save As" feature for "Default Mapping"  

  3. Inserted instruction row for Default Mapping     

For more information see details in Enhancements (Excel Data Import Utility) 

    

Bugs Fixes:

  1. Bug fixed for records not importing if data is not available for child tab in previous row 

  2. Bug fixed to import location if address control is used in the window 

  3. Bug fixed of Description ( text ) UI on the import screen 

2.0.3.0

Feb 28, 2024

1. Introduced Default Mapping and Download Excel File feature.

(a) For all screens by default there will be a default mapping in the mapping dropdown, so whenever user opens any screen "Default Mapping" record will display in the dropdown.

(b) Added "Download Excel File" button, from where user can download excel file with all the fields of the screen with all tabs by selecting "Default Mapping" as a mapping in the dropdown.

(c) "Download Excel File" can also download custom mapping which is saved by user with all columns mapped earlier which were saved by user at the time of mapping. 

(d) </EOR> to indicate End Of Row, so that the Excel Import tool will not check the rows after this keyword. 

(e) Upon uploading the downloaded excel file with the "Default Mapping", all the columns will be mapped automatically for all tabs of the screen from where user opened Excel import Page.

For more information see details in Enhacements (Excel Data Import Utiilty)

1. Fixed Design issue

2. Fixed bug to display correct row number in case of any error

2.0.2.0

Jul 11, 2023

1. Fixed bug of setting default value of system date in date type fields if not mapped. 

2. Fixed bug for busy indicator keep on loading in case of exception 

2.0.1.0 

Oct 11, 2022

1. Rebuild the module with updated NuGet Packages to make compatible with Vienna Advantage Framework version 5.0 and above.

Note:- This version and all future versions of this module will be compatible with Vienna Advantage Framework version 5.0 and above. If you are using Vienna Advantage Framework 4.X.X.X then, do not install this version.

Module Dependency 

Vienna Advantage Standard (VAS_) <1.0.1.0> 

Note:- This version and all future versions of this module will be compatible with Vienna Advantage Framework version 5.0 and above. If you are using Vienna Advantage Framework 4.X.X.X then, do not install this version.  

1.1.1.0 

Aug 30, 2022

1. Fixed bug for Image type column marked as identifier during importing data on any screen, as images are not provided on the excel but Image column marked as identifier to display in grid mode (new feature) 

1.1.0.0 

May 3, 2022

1.0.12.0 

Nov 18, 2021

1.0.11.0 

Sep 2, 2021

1.0.9.0 

Aug 19, 2020

1.0.8.0 

Sep 20, 2019

1.0.7.0 

Feb 1, 2019

1.0.6.0 

Jan 31, 2019