ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Problem Reports - Sporadic >> Erroneous contact information
http://www.istechforum.com/YaBB.pl?num=1428593159

Message started by dashdown on 04/09/15 at 08:25:59

Title: Erroneous contact information
Post by dashdown on 04/09/15 at 08:25:59

We're still having problems with our customer contacts. Evo is pulling contacts from one company and plugging them into a different one. I can't see a pattern this time. Last time it was pulling from a customer and plugging it into the one that appears next in the file. This time it appears to be random. Any help on this would be appreciated.

Title: Re: Erroneous contact information
Post by BurrKing_Mfg on 04/20/15 at 06:05:54

We have fought the same fight. Erroneous contact information. WE are now currently on the latest release and things seem to be working much better.

Of course as soon as I say the problem is fixed we will start seeing it again, but right now, I think its fixed.

I have some garbage that has been created over the years in the old contact manager that still is showing up in grids that I need to clean up.

Title: Re: Erroneous contact information
Post by Kelloggs on 04/20/15 at 11:31:44

BurrKing_Mfg wrote:

.....
I have some garbage that has been created over the years in the old contact manager that still is showing up in grids that I need to clean up.

Same situation here. This is what we used to clean up our contacts.

'No Customer Code
DELETE FROM BKCMACCN WHERE ASCII(LTRIM(RTRIM(BKCM_ACCN_CODE))) = 0;

'It is not a Primary Record, No Contact, and No Email
DELETE FROM BKCMACCN WHERE ASCII(LTRIM(RTRIM(BKCM_ACCN_PRIM))) = 0 AND ASCII(LTRIM(RTRIM(BKCM_ACCN_EMAIL_1))) = 0 AND ASCII(LTRIM(RTRIM(BKCM_ACCN_CON))) = 0;

'Delete some weird records
DELETE FROM BKCMACCN WHERE BKCM_ACCN_EMAIL_1 = '.F.';"

If you change the "DELETE " to "SELECT * ", you can see what records will be delete.

Good Luck

:)

Kelloggs

Title: Re: Erroneous contact information
Post by BurrKing_Mfg on 04/20/15 at 11:40:49

Thanks Kelloggs !

Where do you run the scripts from?

IS that TAS-R (SQL editor)

Title: Re: Erroneous contact information
Post by Kelloggs on 04/20/15 at 11:44:38

Yes!! you can use DBA's own Sql Editor or Pervasive's Control Panel

"C:\Program Files (x86)\Pervasive Software\PSQL\bin\pcc.exe

Please make sure to "View" what records will be delete first (SELECT *........)

8-)

Kelloggs

Title: Re: Erroneous contact information
Post by BurrKing_Mfg on 04/20/15 at 11:45:06

Thanks

Title: Re: Erroneous contact information
Post by DawnS on 04/21/15 at 07:05:56

'No Customer Code
DELETE FROM BKCMACCN WHERE ASCII(LTRIM(RTRIM(BKCM_ACCN_CODE))) = 0;

Just a note to watch for the number of rows affected ..... running the select statement on this one - in our table there were two rows with nothing in any field - when I did the select it 'appeared' that nothing was returned (even through two rows are returned) due to the lack of data in any field.