 | Export a detail record Lookup field |  |
 Posted: Mon Oct 05, 2009 9:54 pm |
Points: 0  |
|
| kiwi |
| n00b |
|
 |
| Joined: 25 Feb 2008 |
| Posts: 9 |
|
|
|
|
|
|
 |
|
GM 7.5
We have a Goldmine detail which has a field with several hundred entries in the associated lookup. I want to export, amend and re-import the information. The second two parts are fine but how do I export the lookup table entries?
Thanks in advance |
|
|
|
|
| | |
| Posted: Tue Oct 06, 2009 9:02 am |
Points: 0 |
|
| BobTaylor |
| GoldBox Guru |
|
|
| Joined: 07 Sep 2007 |
| Posts: 1216 |
| Location: Jacksonville, FL |
|
|
|
|
|
|
|
For any Lookup List, there are two kinds of records in the Lookup table:
Header: for these records, the Fieldname field in the Lookup table has an entry that ends with an "H". Also, the Lookupsupp field will be populated with "Y" and "N" characters. The Entry field value of the Header record will be the Field Name value of the List (ideally would be the name of the Detail, but it depends on how you populated the Field Name field via the Lookup List Setup screen).
List item: The Fieldname field will have the same value as the Header; except that it ends with a "V", replacing the "H". Also, the Lookupsupp field will be empty, and the Entry value will be one of the values in the actual list.
So, first find the list with a filter like this:
| Code: |
| Lookup->Entry = "Your Field Name".AND..NOT.Empty(Lookup->Lookupsupp) |
Then, once you've found the list Header in the Lookup table, copy all the characters of the Header's Fieldnbame field, except the last, Then Export using a filter like this:
| Code: |
| Lookup->Fieldname = "1GDFCAAAAB"+"V" |
All this will be done from the GXBrowser. If GX5, it will be done directly from the GXBroswer menu item. For GXSQL and GX7, you'll query out the Lookup table. In that case, GoldBox will return the query Result Set in a dBase table named THEQUERY.DBF. You would work directly with that, because it will already be in the GXBrowser. Substitute THEQUERY-> for Lookup-> in the filters above. The Export itself is a menu item within the GXBrowser. |
|
_________________
Bob Taylor
Bob Taylor Consulting
(904)646-9861
www.goldboxbob.com
Consulting with GoldBox and GoldMine since 1997. |
|
|
|
ContactReview Forum Index » GoldBox
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
All times are GMT - 7 Hours
Page 1 of 1
|
|
|
|
Brought to you by Castell Computers, Doug Castell, Admin
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin
|
