| Need help with a setup | |
Posted: Fri Jan 14, 2011 8:11 am |
Points: 0 |
|
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 |
|
|
|
|
| | |
Posted: Tue Jan 18, 2011 3:55 am |
Points: 0 |
|
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. |
|
|
|
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
|