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

ContactReview Forum Index » GoldMine 8 - 2019 (Premium Edition) » Single quotes in accountno
Post new topic  Reply to topic View previous topic :: View next topic 
Single quotes in accountno
PostPosted: Fri Oct 02, 2015 2:44 pm Points: 0 Reply with quote
Paul Laufer
GoldBox Guru
Joined: 27 Oct 2008
Posts: 125




Have a client asking about this. I always assumed that FR would add an INI setting to prevent single quotes in accountno, but have never seen one come along.

My questions

1) Anyone know of a way to prevent it yet?
2) Anyone have a tool other than the GoldBox accountno regenerator to fix it?

_________________
Paul Laufer
Telesage Solutions
www.tsage.com
View user's profile Send private message Visit poster's website

PostPosted: Wed Nov 04, 2015 7:35 am Points: 0 Reply with quote
DJ
GoldMine Guru
Joined: 29 Jun 2006
Posts: 2055
Location: Fitchburg, MA, USA




What version & build of GoldMine are you talking about Paul?

It is my understanding that the current versions of GoldMine will not generate an AccountNo that contains single quotes.

_________________
DJ Hunt

Phone: (978)342-3333
Email: DJ@DJHunt.US

GoldMine Premium - The Defintive Guide
One-on-One GoldMine Technical Support ( Fee Based )
www.DJHunt.US
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

PostPosted: Tue Nov 24, 2015 6:49 am Points: 0 Reply with quote
Paul Laufer
GoldBox Guru
Joined: 27 Oct 2008
Posts: 125




Every build.

Just created this accountno using 2015.1

B5112420816(*)G;CD'J

Easy enough to test. Create a new contact named "D'Jay Smith"

_________________
Paul Laufer
Telesage Solutions
www.tsage.com
View user's profile Send private message Visit poster's website

PostPosted: Tue Nov 24, 2015 9:37 am Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1639
Location: Los Angeles, CA




I've had a customer tell me that they use my castellrecnogen tool to run a nightly job that makes and assigns a new accountno for such problematic records... Wink

_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

PostPosted: Wed Nov 25, 2015 4:44 pm Points: 0 Reply with quote
Paul Laufer
GoldBox Guru
Joined: 27 Oct 2008
Posts: 125




Interesting. I know that Albert has a copy of that somewhere. Is the documentation online or with the package?

_________________
Paul Laufer
Telesage Solutions
www.tsage.com
View user's profile Send private message Visit poster's website

PostPosted: Wed Nov 25, 2015 6:32 pm Points: 0 Reply with quote
DougCastell
GoldMine Guru
Joined: 15 Jun 2006
Posts: 1639
Location: Los Angeles, CA




There are example scripts included with the package, but that's about it. The main parts are three functions called like this:


_________________
Doug Castell

GoldMine Sales and Support:
http://www.castellcomputers.com/
office: (310)601-4738
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number

PostPosted: Sat Jan 09, 2016 9:42 am Points: 0 Reply with quote
dexterb
GoldMine Journeyman
Joined: 09 Apr 2007
Posts: 47
Location: http://www.dbxforgoldmine.com




I don't think there is a need to create a new accountno. All that needs to be done is to replace the single quote (or double quote) with another character and you do this for all tables with an accountno column. This way, all accounts are still in sync between related tables.

Update contact1 set Accountno = replace(accountno,'''','1') where accountno like '%''%'
Update conthist set Accountno = replace(accountno,'''','1') where accountno like '%''%'
Update contsupp set Accountno = replace(accountno,'''','1') where accountno like '%''%'
Update mailbox set Accountno = replace(accountno,'''','1') where accountno like '%''%'

...and add more update queries for other tables

this is not sync aware of course.....but if you want it to sync, simply insert tlog records for each accountno that was replaced and they could be using the same syncstamp which you can also generate either castellgen or by simply creating a new record and use the same syncstamp generated by that new record.

the method above is actually used by the DBX tool plus it makes it sync aware by adding the appropriate tlogs

-dexterb
View user's profile Send private message Visit poster's website

Single quotes in accountno
  ContactReview Forum Index » GoldMine 8 - 2019 (Premium Edition)
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