Log in Register FAQ Memberlist Search ContactReview Forum Index
A GoldMine Discussion and Support Community

ContactReview Forum Index » GoldBox » Export a detail record Lookup field
Post new topic  Reply to topic View previous topic :: View next topic 
Export a detail record Lookup field
PostPosted: Mon Oct 05, 2009 9:54 pm Points: 0 Reply with quote
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
View user's profile Send private message

PostPosted: Tue Oct 06, 2009 9:02 am Points: 0 Reply with quote
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.
View user's profile Send private message Send e-mail Visit poster's website

Export a detail record Lookup field
  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  

  
  
 Post new topic  Reply to topic  


Brought to you by Castell Computers, Doug Castell, Admin
RSS Feed
Powered by phpBB © 2001-2004 phpBB Group
Theme created by Vjacheslav Trushkin