Welcome, Guest. Please Login.
03/28/24 at 01:17:35
News:
Home Help Search Login


Pages: 1
Send Topic Print
Erroneous contact information (Read 2209 times)
dashdown
Full Member
***


Be alert.  The
world needs more
lerts.

Posts: 189
Gender: male
Erroneous contact information
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.
Back to top
 
 
Email   IP Logged
BurrKing_Mfg
Member
**


Computer repair can
not be done with a
hammer!

Posts: 66
Gender: male
Re: Erroneous contact information
Reply #1 - 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.
 
 
 
Back to top
 
 

12 User Evo-ERP
Pervasive 11
2012r2 Server (needs upgrades)
Evo is fully patched and ready to go
Email WWW   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: Erroneous contact information
Reply #2 - 04/20/15 at 11:31:44
 
Quote from BurrKing_Mfg on 04/20/15 at 06:05:54:
.....
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
 
Smiley
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
BurrKing_Mfg
Member
**


Computer repair can
not be done with a
hammer!

Posts: 66
Gender: male
Re: Erroneous contact information
Reply #3 - 04/20/15 at 11:40:49
 
Thanks Kelloggs !
 
Where do you run the scripts from?
 
IS that TAS-R (SQL editor)
 
Back to top
 
 

12 User Evo-ERP
Pervasive 11
2012r2 Server (needs upgrades)
Evo is fully patched and ready to go
Email WWW   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: Erroneous contact information
Reply #4 - 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 *........)
 
 Cool
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
BurrKing_Mfg
Member
**


Computer repair can
not be done with a
hammer!

Posts: 66
Gender: male
Re: Erroneous contact information
Reply #5 - 04/20/15 at 11:45:06
 
Thanks
Back to top
 
 

12 User Evo-ERP
Pervasive 11
2012r2 Server (needs upgrades)
Evo is fully patched and ready to go
Email WWW   IP Logged
DawnS
Browser
*


I Love EvoERP!

Posts: 14
Re: Erroneous contact information
Reply #6 - 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.  
Back to top
 
 
  IP Logged
Pages: 1
Send Topic Print