Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: goner
  • Order by date
  1. goner

    Need help with GM. After creating a

    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...
  2. goner

    Goldmine Licencegm.bin location

    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...
  3. goner

    Detail tab in contact menu changed to table format

    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...
  4. goner

    Goldmine SQL Query help.

    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
  5. goner

    Goldmine SQL Query help.

    ...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 c1 WHERE nt.accountno=c1.accountno and (NT.USERID = 'goldmine') AND ((dateadd( day, datediff(day, 0, NT.CREATEDDATE), 0) >=...
  6. goner

    Missing zip code in field linked to Word

    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...
  7. goner

    Goldmine SQL Query help.

    ...custom 'custid' field name is under the hood, so I can't really add it to the query example here, but you can get a date range like this: select * from contact1 where lastuser='DOUG' and lastdate between '3/15/2016' and '4/15/2016' Finally, if this continues to be a problem, maybe a quick...
  8. goner

    Goldmine SQL Query help.

    ...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, username, date, etc. as needed. Doug Castell...
  9. goner

    Missing zip code in field linked to Word

    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
  10. goner

    GM Premium Mass e-mails

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

    Looking for the source of LASTUSER value in CONTHIST

    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...
  12. goner

    user access controls

    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...
  13. goner

    user access controls

    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...
  14. goner

    Very frequent ado errors

    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...
  15. goner

    Very frequent ado errors

    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
  16. goner

    Adding multiple contacts to organisation/company

    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
  17. goner

    Strange place to ask, but does anyone have experience of ORCA?

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

    Strange place to ask, but does anyone have experience of ORCA?

    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
  19. goner

    Macros - GM 7.6 and Windows 8

    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
  20. goner

    alert setting or rather un-setting!

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

Part and Inventory Search

Back
Top