Search results for query: *

It pretty much means what it says: Go to c:\program files (x86)\goldmine\, do you see a file called FLAGS.DBF? If not, you'll probably want to restore it from backup. More importantly, you'll want to figure out why it's not there anymore and remedy that as well. Doug Castell Castell...

in the root folder of GoldMine (possibly c:\programdata\goldmine or c:\program files (x86)\goldmine) you'll find a gm.ini file. In there, there's a SYSDIR= line. That will point your workstation to the server's GoldMine folder. If you change it your workstation will probably never work with...

you probably know this already, but GoldMine 5.5 was made in the 1990's and windows 10 was made relatively recently. GoldMine 5.5 was not supported on windows XP (or Vista or 7 or 2008 or 8 or 8.1 or 2012 or 2016 or 10) so at this point, WYSIWYG, basically. Doug Castell Castell Computers...

try this, instead: select company, contact, key5, lastuser, lastdate from contact1 where lastuser='DOUG' and lastdate between '3/15/2016' and '4/15/2016' Doug Castell Castell Computers www.castellcomputers.com

The query GoldMine wrote is based on the notes in the notes tab. I'm not sure this is your intention as you originally were looking at the last-modified date, right? You could add those contact fields, however, this way: SELECT c1.company, c1.contact, c1.key5, NT.* FROM NOTES NT, contact1...

GoldMine is not a free program. It's not a matter of simply downloading the latest version and installing it. You need to purchase license(s) to use it. Licenses run about $695 per user, depending on how many you need. There are bundle deals available at the 3 and 5 user levels that can save...

Yeah, the downside of the SQL query builder is that it writes somewhat overly-complex code -- sort of how Microsoft Word generates ridiculously complicated HTML. It's functional, but... Also, it looks like your wizard=built query is on the NOTES table -- probably not the right choice...

There's a BUILD button/wizard on the SQL query window that might help you get where you're going -- even without SQL knowledge. Otherwise, something like this might be a good start: select * from contact1 where lastuser='JOHN' and lastdate>='3/15/2016' Adjust the selected fields list...

You cannot edit the built-in macros. They're hard-coded. That being said, it sounds like a bug. The current version of GoldMine, 2016.1, returns the appropriate information (zipcode and all) for both of those macros. Doug Castell Castell Computers www.castellcomputers.com

IMAP and POP3 are GoldMine's methods for RECEIVING mail. GoldMine uses SMTP to SEND mail. Doug Castell Castell Computers www.castellcomputers.com

GoldMine doesn't record that information. You could, potentially, make sure each of your users is assigned a unique MSSQL login id and then make that part of the tracking you do in your trigger. Beyond that, if users deleting records is a problem in your install, you could always curtail their...

Ownership of a record with no curtaining will allow the record to be universally visible but not editable. If I understand your requirements, this would be your best bet. I'd say a nightly SQL job that looks for records that haven't been touched in three months and updates their ownership...

While your triggers may accomplish your goal, you'd be better served to utilize GoldMine's own security model with record ownership. Also note that while your triggers will work for most history, record types (CONTHIST.SRECTYPE) of M are unusual in that they link to MAILBOX records...

No problem. As a side note, I think what you're seeing with those errors is relatively innocuous. It's just GoldMine going through its SQL login fall back progression. When a user logs into GoldMine, the SQL login used is in any of a number of places: 1. their user properties 2. the...

Take a look in the user properties, ACCESS tab and see if they have a username/password specified there for SQL. Update/verify it and see if the errors persist. Doug Castell Castell Computers www.castellcomputers.com

Just add them to a group or create a filter that returns them all, activate it, then right-click on the existing organization chart/folder and select to add contacts and follow your nose to the option to add them based on a filter/group. Doug Castell Castell Computers www.castellcomputers.com

...sorry, wrong thread. weird there's no option to delete the reply. Doug Castell Castell Computers www.castellcomputers.com

Just add them to a group or create a filter that returns them all, activate it, then right-click on the existing organization chart/folder and select to add contacts and follow your nose to the option to add them based on a filter/group. Doug Castell Castell Computers www.castellcomputers.com

I use keyboard macros with goldmine 2013 and windows 7 regularly. I can't speak for golmdine 7 in these newer environments. Doug Castell Castell Computers www.castellcomputers.com

No problem! :) Doug Castell Castell Computers www.castellcomputers.com