ContactReview :: View topic - Global Replace finding one record at a time??

ClareLondon · Obsessive GoldMiner

Hello all

This is a very bizarre one I think.

I've had a global replace set up which has worked impeccably. Until an hour ago, when it suddenly stopped finding any records at all. After a series of deleting and setting up brand new search & replace, now I have an interesting, in the Chinese sense, situation, where the filter works, but only finds ONE record at a time.

This is GoldBox 5 Premium

I've done repeated pack & reindex of GoldMine system files. I've also cleared T logs in GoldMine and done pack &rebuild. A lot.

BTW this is a GoldBox replace set up as a filter within GoldBox. I have no tagged records highlighted or filters activated within GoldMine which might be confusing the issue. In fact, I took GoldMine out of the picture altogether by running the replace with GM shut.

There's a corruption somewhere, is there?

Any help gratefully received.

ClareLondon · Obsessive GoldMiner

GM 6.7
build 70226
GoldBox 5 premium
XP

Just to be clear, it finds and replaces exactly as set up to do but only one record at a time. i.e. the filter 'works' and the fields are correct.

GoldBoxGodfather · Experienced Miner

Go to the Global Replace Setup screen, click the Life Ring icon, send the TXT file to the below email address.

ClareLondon · Obsessive GoldMiner

Just to report feedback: Dave had a look at the text file. He reported back that there were no known bugs with the prog and he could see nothing wrong with the lifering.

Neverytheless, the problem persists. It's odd. I am using the exact same filters I did for an entire day. But suddenly they stopped producing any more records than one at a time. And the problem remains today.

ClareLondon · Obsessive GoldMiner

After extensive testing, I can report the following:-

1. I've run global replace using other detail tabs (all expanded tabs)
Resuilt
they all work

2. I've tried putting the original detail information on a different tab
Resuilt
they all work

3. I've run the original search and replace on the original tab
Resuilt
DOESN'T work

4. I've set up a brand new global replace, new filter expression, new field replacements, but on the original tab
Resuilt
DOESN'T work

5. I tried (4) above but using a different tab
Resuilt
[b] works

CONCLUSION
even though the tab appears to work fine, search and replace will not work.

Humph. But at least I now know what Dave's 'environmental' means. It means something in GoldMine. And that something appears to be a corrupted expanded tab (at least in terms of Global Replace). Otherwise there is nothing that doesn't work on that tab.

Just to be clear. what I mean by expanded tab is, not the original details tab, but a tab set up from the details tab, with a label "Info". You know, the ones you create.

Any brainboxes out there to tell mewhat to do? (Delete the tab and start over, I guess.)

But - strange huh?

BobTaylor · GoldBox Guru

When you want to replace fields in existing records, there are always 2 ways you can go, if you have GoldBox: 1) Global Replace; 2) Import/Update. Two different ways to accomplish the same thing. Dave suggested you try option 2), and so do I. In fact, I almost never use Global Replace, because it has to be run over the entire database, and that may take longer than I want it to. A Q-file running an Export and an Import/Update will be faster.

If you need help implementing 2), ask questions about it. And if your Export only gives you one record, then you need to have another look at your filter. Remember, you sent Dave that LifeRing, but the rest of us haven't seen it (and Dave's on vacation for a few days, now).

ClareLondon · Obsessive GoldMiner

BobTaylor · GoldBox Guru

In GoldBox,

1. Setup | Export

2. Create a New Setup

3. Supplemental radio button | Next

4. Add LaunchID and Description to create a new Setup

5. Click Record Type button and select P-Details/...

6. Add filter...whatever you've been using, I guess (still haven't seen it).

7. No need to change anything else on this screen, unless you want to change the export file name/type or location (don't do that for this test). Click the MAP Fields for Export button.

8. To get every field in the Detail record, check every box in the leftmost column, down to (but not including) C1_ACCT.

9. Click Exit to close the MAP screen. Press the thunderbolt button to run the Export.

When complete, you can use File | Open Any dBase Table to see what you've exported to GMEXDATA.dbf. This will become the Source file for your Import/Update.

Let me know when you get that far; let's get the Export done before going on to the Import/Update.

ClareLondon · Obsessive GoldMiner

Bob, much gratitude at this end. Thank you for this exemplary, lucid, absolutely clear explanation.

Will do it all and get back shortly.

Now you need a well-deserved English cuppa tea. (Am throwing one over the ocean to you.)

BobTaylor · GoldBox Guru

Damn thing picked up some seaweed along the way, but thanks!

ClareLondon · Obsessive GoldMiner

That was easily done Bob! Thank you.

It appears to have produced the exact number of records I would have expected. I am now officially ready to import.

Laughing

ClareLondon · Obsessive GoldMiner

I may be doing it.

Give me 5!

x

ClareLondon · Obsessive GoldMiner

Hmm.

Got quite a way. One thing is that the words that Dave used in his email don't match precisely with what appears on screen. I think I got it more or less right, but then one field populated another field, like when I put the recid in it also filled in another field. Prob it's because I'm on GX5 and Dave was referring to a different version, maybe.

Then I got stuck. Very.

Anyway. Further instructions would be very much appreciated. I am slightly on the verge of rampant e-excitement here. This looks like being very very useful.

Razz

BobTaylor · GoldBox Guru

Can you post the LifeRing for the Import that you have so far?

ClareLondon · Obsessive GoldMiner

WINDOWS System: Windows NT version 5.01
FREE DiskSpace: 1,431.060 Megabytes
B D E Version: 5.1.1.1
Folder: g:\goldmine\setup\bdeshare\idapi32.cfg
GOLDMINE Versn: 6
Exe: g:\goldmine
GMbase: g:\goldmine\gmbase
User: =
Sync: ON
GOLDBOX-5 Vers: 2009-K
Folder: g:\goldmine\goldbox5
Serial #: 5G751911
Licensee: THE RED HEDGEHOG

OPERATION: IMPORT / UPDATE
Category: DETAIL/NU
Description: workshops
Launch ID: IGWO3.DBF

SOURCE TABLE: g:\goldmine\goldbox5\gmexdata.dbf
SOURCE FILTER:
START AT RECD: 1
QTY TO IMPORT: ALL
PARK AND STOP: NO
ACCUM. UPDATE: NO
TARGET TABLE: g:\goldmine\common\contsupp.dbf
DDE or TABDel: NO
INDEXED MATCH:
CUSTOM MATCH:
INCLUDE FILTER:
ADD NO-MATCHES: NO
MULT MATCH UPD: NO
BYPASS MATCHES: NO
LOG FLD CHANGE: NO
TAB PLUGIN OFF: NO
PARENT TABLE: g:\goldmine\common\contact1.dbf
INDEXED MATCH: CN1RECID
CUSTOM MATCH: RECID
SOURCE EXPRN:

SOURCE Table: GMEXDATA.DBF Fields: 27 Records: 11
1 ACCOUNTNO C 20 0
2 RECTYPE C 1 0
3 CONTACT C 30 0
4 TITLE C 35 0
5 CONTSUPREF C 35 0
6 DEAR C 20 0
7 PHONE C 20 0
8 EXT C 6 0
9 FAX C 20 0
10 LINKACCT C 20 0
11 NOTES M 10 0
12 ADDRESS1 C 40 0
13 ADDRESS2 C 40 0
14 ADDRESS3 C 40 0
15 CITY C 30 0
16 STATE C 20 0
17 ZIP C 10 0
18 COUNTRY C 20 0
19 MERGECODES C 20 0
20 ADDL_EMAIL C 75 0
21 STATUS C 4 0
22 LINKEDDOC M 10 0
23 LASTUSER C 8 0
24 LASTDATE D 8 0
25 LASTTIME C 5 0
26 GM_EMAIL C 75 0
27 RECID C 15 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: "ATS"

STATUS C 4 Ref to Lkup Dflt=NO e
PARK EXPN: 'NO'

ACCOUNTNO C 20 Account Number e Shd RQ
PARK EXPN: Contact1->Accountno

(END OF LISTING) Created 03/07/2009 02:28:59