I'm using AppGini 5.76 rv.1058
Lookup field SURNAME not showing data on CSV import.
First, all tables have field "ID".
I have a table called "MARRIAGES", with a lookup field called "SURNAME", that a looks to table "ADD_SURNAME", field "SURNAME_LIST".
There are 2,656 "MARRIAGE" records I'm trying to import by way of a CSV, but as field "SURNAME" is a "lookup field" and it automatically gets set to data type (integer) the text wont import and is not looking to "SURNAME_LIST to populate.
I did import the surnames into table "ADD_SURNAMES" field "SURNAME_LIST" successfully, as there were only 16 different spellings of the same surname for the 2,656 "MARRIAGE" records.
Question; how to get data imported for table "MARRIAGES" and look to values in "SURNAME_LIST" to populate table "MARRIAGES" field "SURNAME" and still have it as a lookup field, because new spelling of surname will be added over time, there is over 25 different ways to spell the same surname.
I hope this is possible and thank you for any assistance.
Lookup field not showing data.
Lookup field not showing data.
What we envision, we make happen.
Re: Lookup field not showing data.
Hi,
if I remember correctly, you need to use the integer value of the lookup for your import, not the final value.
Maybe you can try that.
if I remember correctly, you need to use the integer value of the lookup for your import, not the final value.
Maybe you can try that.
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
Re: Lookup field not showing data.
Thanks for replying,
Do you mean use the ID# for the surname spelling in SURNAME_LIST as the value in table MARRIAGES field SURNAME?
Do you mean use the ID# for the surname spelling in SURNAME_LIST as the value in table MARRIAGES field SURNAME?
What we envision, we make happen.
Re: Lookup field not showing data.
Hey pbottcher!
That did it, just need to change surnames to ID# and it worked.
That did it, just need to change surnames to ID# and it worked.
What we envision, we make happen.