Skip to main content

Import Issue Universal GUI


Forum|alt.badge.img+4

Hi all,

I am trying to import data using a excel sheet in Universal GUI, but am running into a problem where the existing records won’t update. Context: importing data in a detail screen.

Steps taken:

  1. export data using option “Export immediately”
  2. changing some fields in excel > save excel sheet
  3. import using the “Import (update existing rows)” option. 

Also noticed that it doesn’t update but rather add the rows again.
Please help! Thanks

This topic has been closed for comments

Mark Jongeling
Administrator
Forum|alt.badge.img+23

Hi,

According to the Release notes for Universal GUI version 2022.1.11, there should be an option to Update existing rows: 

https://community.thinkwisesoftware.com/product-updates/release-notes-universal-gui-2022-1-11-2758#Update+Existing+rows

Which GUI version are you using at this moment?


Forum|alt.badge.img+4

I am currently using GUI version 2022.1.13


Mark Jongeling
Administrator
Forum|alt.badge.img+23

Are you importing in a Main screen of a Detail screen? From a colleague I have understood that there is/was a bug when importing data into a Detail screen.

I do recommend checking using both the latest Indicium and Universal GUI versions. Our Indicium team did solve an issue surrounding the import functionality.

The changes you made in the export file, did you change any of the Primary key columns; or does the subject you want to Import not have an unique Primary key? -This can occur when using views for example.

Hope this helps!


Mark Jongeling
Administrator
Forum|alt.badge.img+23

Hi @kensonlatchmansing,

Has this been resolved or do you need more help?


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings