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

ContactReview Forum Index » GoldBox » Need help with a setup
Post new topic  Reply to topic View previous topic :: View next topic 
Need help with a setup
PostPosted: Fri Jan 14, 2011 8:11 am Points: 0 Reply with quote
lisaharris
Experienced Miner
Joined: 07 Sep 2007
Posts: 77
Location: Mt. Laurel, NJ




Not sure where I've gone wrong here... I have a dbf file that i created containing Accountno, Recid, Email Address, and a merge code. I want to find the existing record (using recid as the match field) and update the merge code in contsupp with the mergecode in my dbf file. Lifering is below. Help please!!

WINDOWS System: Windows NT version 5.02
FREE DiskSpace: 195,968.946 Megabytes
B D E Version: 5.2.0.2
Folder: d:\Program Files\Borland\Common Files\BDE\IDAPI32.CFG
GOLDMINE Exe: i:
DATABASE Main: VENDOR
Premium Edit'n: YES
GoldMine v 8.5: YES
User: MASTER
Sync: ON
GX7 Version: 2010-B
Folder: d:\goldbox7
Serial #: G7xxxxxxx
Licensee: MARLIN LEASING CORP.

OPERATION: IMPORT / UPDATE
Category: EMAIL/NU
Description: bbk additions
Launch ID: IGBBK.DBF

SQL CONVERT:
TEXT CONVERT:
SOURCE FILTER:
SOURCE TABLE: d:\goldbox7\reporte.dbf
START AT RECD: 1
QTY TO IMPORT: ALL
PARK AND STOP: NO
TARGET TABLE: ENDUSER
INDEXED MATCH: RECID
CUSTOM MATCH: RECID
INCLUDE FILTER:
ADD NO-MATCHES: NO
GX-VU/QUIK-DEL: NO
MULT MATCH UPD: NO
BYPASS MATCHES: NO
DIRECT DELETE: NO
LOG FLD CHANGE: NO
TAB PLUGIN OFF: NO
DETAIL NAME: E-mail Address
DETL SRCH FLD: CONTSUPREF
PARENT INDEX: RECID
PARENT CUSTOM: RECID
SOURCE EXPRN: Reporte->Recid

SOURCE Table: REPORTE.DBF Fields: 4 Records: 7781
1 EMAIL_ADDR C 254 0
2 ACCOUNTNO C 254 0
3 RECID C 20 0
4 MERGE_CODE C 254 0

FIELD-NAME T LEN D DESCRIPTION FIELD-1 FIELD-2 SHD Case WB RQ
---------- - --- - -------------------- ---------- ---------- --- ---- -- --
CONTACT C 30 Detail Type e Shd RQ
PARK EXPN: 'E-mail Address'

CONTSUPREF C 35 E-MAIL ADDRESS EMAIL_ADDR RQ

ADDRESS1 C 40 + 35 Overflow e
PARK EXPN: SubStr(Reporte->Email_addr, 36)

MERGECODES C 20 Merge Codes MERGE_CODE

ADDRESS2 C 40 Contact Name e
PARK EXPN: vMainConName

ACCOUNTNO C 20 Account Number e Shd RQ
PARK EXPN: vMainConAcct


(END OF LISTING) Created 01/14/2011 10:04:00 AM
View user's profile Send private message

PostPosted: Tue Jan 18, 2011 3:55 am Points: 0 Reply with quote
BobTaylor
GoldBox Guru
Joined: 07 Sep 2007
Posts: 1216
Location: Jacksonville, FL




The one thing I can point to as wrong is the Parent matching. That should be Accountno, not Recid. Granted, it shouldn't even be necessary, when you have a Recid match on the Detail itself, but that's another story.

_________________
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

Need help with a setup
  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