info@softstuff-consulting.com (Softstuff) http://www.softstuff-consulting.com/kbase Knowledge Base digest en-us 2007-2008 Softstuff Consulting Tue, 10 Jun 2003 04:00:00 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=118When trying to install the GoldMine Outlook link, just after it asks for the GoldMine username and password, it may pop a dialog box informing you that it cant load the GM7S32.DLL.http://www.softstuff-consulting.com/kbase/showkb.asp?id=118Fri, 15 Jan 2010 15:20:47 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=117Wehn building integration pieces, using the Webservice interface its sometimes useful to be able to page through the logged in users Work in Progress Queue to either process the items in there, or assign them to another Queue.http://www.softstuff-consulting.com/kbase/showkb.asp?id=117Tue, 1 Dec 2009 13:39:12 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=116When writing code to interface with CRM using the WebService interface it is often necessary to find out details about the user that is being used to login to the interface. This simple function will return a structure with some information about the current user, the most important and useful is the Guid representing the UserId.http://www.softstuff-consulting.com/kbase/showkb.asp?id=116Tue, 1 Dec 2009 11:51:54 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=115If you are running QuoteWerks Corporate Edition hosted to SQL, along with http://www.softstuff-consulting.com/kbase/showkb.asp?id=115Wed, 25 Nov 2009 08:42:24 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=114Recently I came across a situation where the customer wanted to go through allhttp://www.softstuff-consulting.com/kbase/showkb.asp?id=114Tue, 24 Nov 2009 14:34:56 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=113This is a really simple one, but when I spoke to a developer recently he had completely overlooked the simplest way to discover if an integer is odd or even, and was performing quite a convoluted formula to get the answer.http://www.softstuff-consulting.com/kbase/showkb.asp?id=113Tue, 24 Nov 2009 11:51:12 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=112If you are using a textbox on a Windows form, and you want the user to enter data in Uppercase, you could simply convert the data afterwards, or add the following line of code to the InitializeComponent(), or the Load() function of the form.http://www.softstuff-consulting.com/kbase/showkb.asp?id=112Mon, 23 Nov 2009 19:50:43 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=111If you plan on storing any kind of persistent information regarding configuration for your current user in a file the best place to store it is in the users Application Data directory. This allow data to be written regardless of the current set of security in place for that user.http://www.softstuff-consulting.com/kbase/showkb.asp?id=111Fri, 20 Nov 2009 12:06:20 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=110A useful function to return the current IP address of the machine it is run on. A possible enhancement here might be to return all the current IP addresses, as it is possible for a machine to be using 2 addresses at the same time. http://www.softstuff-consulting.com/kbase/showkb.asp?id=110Wed, 18 Nov 2009 16:56:06 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=109Sometimes it becomes necessary to manually remove a service from a machine.http://www.softstuff-consulting.com/kbase/showkb.asp?id=109Wed, 26 Aug 2009 09:47:03 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=108Sometimes it becomes necessary to manually remove a service from a machine.http://www.softstuff-consulting.com/kbase/showkb.asp?id=108Wed, 26 Aug 2009 09:44:43 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=107Sometimes it becomes necessary to manually remove a service from a machine.http://www.softstuff-consulting.com/kbase/showkb.asp?id=107Wed, 26 Aug 2009 09:44:20 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=106To convert values in a spreadsheet from hexadecimal to decimal use the following formula.http://www.softstuff-consulting.com/kbase/showkb.asp?id=106Mon, 24 Aug 2009 20:18:11 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=105Use the formula =NOW() to enter the current date and time into a cell.http://www.softstuff-consulting.com/kbase/showkb.asp?id=105Mon, 24 Aug 2009 20:13:00 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=104Use the following formula to count the number of blank cells within a range of cells in a sheet.http://www.softstuff-consulting.com/kbase/showkb.asp?id=104Mon, 24 Aug 2009 20:05:27 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=103To calculate the number of days in a month, use the following formula.http://www.softstuff-consulting.com/kbase/showkb.asp?id=103Mon, 24 Aug 2009 19:58:57 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=102Comments can be added to a spreadsheet, by simply right-clicking on a cell and selecting Add Comment from the pop up menu. The comment has no effect on the value or formula inside the cell.http://www.softstuff-consulting.com/kbase/showkb.asp?id=102Mon, 24 Aug 2009 19:51:50 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=101In Word 2007 to turn the onscreen ruler on and off the following keystrokes can be used.http://www.softstuff-consulting.com/kbase/showkb.asp?id=101Mon, 24 Aug 2009 17:29:19 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=100While running Word it is possible to view all the system information about your PC, like the operating system version, how much memory is available, and even what hardware is connected inside the box.http://www.softstuff-consulting.com/kbase/showkb.asp?id=100Mon, 24 Aug 2009 16:34:37 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=99Some people like to type their documents, in full screen with no menu bars, or button bars visible, and this feature is still available in Word 2007 not from the menu or toolbars, but it is available with a couple of keystrokes.http://www.softstuff-consulting.com/kbase/showkb.asp?id=99Mon, 24 Aug 2009 16:30:48 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=98Every time you start Word, the program is started with a blank document. This is ideal if you are ready to start a new file. Most people, however, will find themselves working with the same files over and over and having to close the default document down each time becomes a nuisance.http://www.softstuff-consulting.com/kbase/showkb.asp?id=98Mon, 24 Aug 2009 15:16:45 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=97When developing screen layouts in GoldMine it can be quite tedious to set the tab order from the new field positions.http://www.softstuff-consulting.com/kbase/showkb.asp?id=97Wed, 12 Aug 2009 19:31:45 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=96Normally QuoteWerks uses the currency symbol that is set on each client, in the regional settings when creating a quote. This can cause problems when either different clients are set to different currencies, or the client PCs are set to one currency (ie. GBP Pounds Sterling) as it is the local currency where they are located, but they have a need to always quote in another currency (i.e. USD US Dollars) becuase that is what their customers expect.http://www.softstuff-consulting.com/kbase/showkb.asp?id=96Wed, 12 Aug 2009 17:46:28 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=95Below is a function that can be used to strip HTML from a string. It works by looping through the string until it meets an opening HTML tag, and ignores everyting until it meets a closing tag.http://www.softstuff-consulting.com/kbase/showkb.asp?id=95Thu, 6 Aug 2009 20:36:09 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=94By default GoldMine stores all notes in history and pending in HTML format. Depending upon your chosen reporting tool, or if you are linking to an external system this feature isnt always desirable. http://www.softstuff-consulting.com/kbase/showkb.asp?id=94Thu, 6 Aug 2009 20:00:43 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=93To get a list of views within the database run the following query.http://www.softstuff-consulting.com/kbase/showkb.asp?id=93Thu, 6 Aug 2009 19:16:36 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=92As a contact database grows one of the big issues is making sure that you keep interacting with your customers. Its very easy to cherry pick your best and most friendly customers and ignore the rest.http://www.softstuff-consulting.com/kbase/showkb.asp?id=92Thu, 6 Aug 2009 19:13:32 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=91It is quite straightforward to create an expression that will display the age of a contact if their date of birth is known.http://www.softstuff-consulting.com/kbase/showkb.asp?id=91Thu, 6 Aug 2009 17:56:47 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=90To find all the records created in the last 14 days a simply SQL query can be used to build a group.http://www.softstuff-consulting.com/kbase/showkb.asp?id=90Thu, 6 Aug 2009 15:04:20 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=89How many times have you entered data within GoldMine only to look at the screen and find that the Caps Lock key was on, or you forgot a capital letter at the beginning?http://www.softstuff-consulting.com/kbase/showkb.asp?id=89Thu, 6 Aug 2009 12:18:03 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=88Often when designing layouts within QuoteWerks you will produce a header page containing perhaps the name of the Quote and the customer name with the item details following on the next pages. Displaying the Page number and date on this page can spoil the template, but it is easy with the following expression to ensure that the page number doesnt display on the first page.http://www.softstuff-consulting.com/kbase/showkb.asp?id=88Thu, 6 Aug 2009 09:52:33 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=87In a GoldMine expression field the following expression can be used to confirm that a date of birth is valid.http://www.softstuff-consulting.com/kbase/showkb.asp?id=87Thu, 6 Aug 2009 09:30:42 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=86To export a list of primary contacts with their primary email addresses, can be acheived either through the export wizard, or by running this simple SQL query.http://www.softstuff-consulting.com/kbase/showkb.asp?id=86Wed, 5 Aug 2009 08:54:42 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=85The following short TSQL will read files from disk into a table.http://www.softstuff-consulting.com/kbase/showkb.asp?id=85Tue, 4 Aug 2009 19:57:58 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=84To check that users are completing or deleting their emails, a simple query can be run in the GoldMine SQL query window.http://www.softstuff-consulting.com/kbase/showkb.asp?id=84Tue, 4 Aug 2009 17:55:40 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=83To return a list of columns and their data types for a table use the following query.http://www.softstuff-consulting.com/kbase/showkb.asp?id=83Tue, 4 Aug 2009 17:30:03 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=82Adding a Page x of y expression to your Quote Layouts can be done with this simple expression.http://www.softstuff-consulting.com/kbase/showkb.asp?id=82Tue, 4 Aug 2009 16:17:37 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=60When adding a USB portable drive, they often come ready formatted as FAT32 drives. After you plug it into your machine it will assign itself a drive letter. In the exaple below the drive is drive Dhttp://www.softstuff-consulting.com/kbase/showkb.asp?id=60Sun, 21 Dec 2008 13:26:36 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=59If you have just got a shiny new netbook running XP home you may be a little disappointed to discover that the options for setting user security is a little limited compared with XP Pro.http://www.softstuff-consulting.com/kbase/showkb.asp?id=59Sat, 6 Dec 2008 18:49:27 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=58Each network card/adaptor has a unique address called a MAC address, if you are using a network that has access control activated you will probably require the MAC address before you will be able to connect.http://www.softstuff-consulting.com/kbase/showkb.asp?id=58Sat, 6 Dec 2008 10:02:25 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=57To cope with the new rate of VAT in the UK from today (December 1st 2008) open QuoteWerks as an Administrator, go to the Tools menu, and select Options.http://www.softstuff-consulting.com/kbase/showkb.asp?id=57Mon, 1 Dec 2008 21:21:47 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=56Imagine a scenario where you have a datafield containing a series of identifiers with diferent prefixes that are alpha characters but are different lengths and you need to remove them to leave only the numbers. I came across the situation when trying to link up two systems, one system contained numeric identifers, and the other had the same numeric identifier but prefixed with a 2 or 3 letter code to denote the company it was attached to.http://www.softstuff-consulting.com/kbase/showkb.asp?id=56Fri, 21 Nov 2008 16:40:25 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=55In a GoldMine expression field the following expression can be used to display the day of the week.http://www.softstuff-consulting.com/kbase/showkb.asp?id=55Wed, 3 Sep 2008 23:54:26 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=54To switch off HTML email creation by default in GoldMine the following setting can be added to the GM.INI file.http://www.softstuff-consulting.com/kbase/showkb.asp?id=54Sun, 31 Aug 2008 20:23:13 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=53Unfortunately this can no longe be used, due to changes in the way GoldMine 7.5 deals with the controlling conversation to MS Word. It is no longer posible to install the new version of the GoldMine+ word link. It cannot be installed manually.http://www.softstuff-consulting.com/kbase/showkb.asp?id=53Sun, 31 Aug 2008 20:19:50 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=52A new feature of GoldMine PE is the list which tracks the last records you have visited.http://www.softstuff-consulting.com/kbase/showkb.asp?id=52Wed, 20 Aug 2008 08:51:46 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=51When scheduling items into the GoldMine calendar, as well as the usual scheduling by time, GoldMine also supports scheduling by priority.http://www.softstuff-consulting.com/kbase/showkb.asp?id=51Wed, 20 Aug 2008 08:24:25 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=50GoldMine has the ability to link to documents, and in the event of a server move the task of discovering where these documents are held can be quite monumental.http://www.softstuff-consulting.com/kbase/showkb.asp?id=50Tue, 19 Aug 2008 09:23:07 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=49One of the advatnages of a GoldMine hosted SQL system is that it no longer needs to be packed and rebuilt on a regular basis. The problem is that the option to perform maintenance still exists and it is possible for users to perform the operation in error.http://www.softstuff-consulting.com/kbase/showkb.asp?id=49Tue, 12 Aug 2008 20:30:27 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=48To ensure scheduled actions dont get lost, it is possible for GoldMine to move previously scheduled uncompleted actions to the current day. This will apply to events scheduled prior to today, and they will appear in the calendar for today.http://www.softstuff-consulting.com/kbase/showkb.asp?id=48Mon, 11 Aug 2008 17:01:24 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=47In GoldMine the calendar can be configured to display your current working day settings, by default it shows the working day as 9-5 Mon-Fri, but this can be changed to suit.http://www.softstuff-consulting.com/kbase/showkb.asp?id=47Mon, 11 Aug 2008 16:55:33 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=46GoldMine regularily polls the Calendar table to ensure that the calendar is always up to date. This polling interval can be increased to lower the amount of network traffic.http://www.softstuff-consulting.com/kbase/showkb.asp?id=46Mon, 11 Aug 2008 16:52:39 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=45If xp_cmdshell is not enabled, and you have sufficient rights it can be enabled with the following script.http://www.softstuff-consulting.com/kbase/showkb.asp?id=45Mon, 11 Aug 2008 14:36:54 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=44For emails retreived through the GoldMine email client, when deleting the email the attachment is not deleted by default.http://www.softstuff-consulting.com/kbase/showkb.asp?id=44Mon, 11 Aug 2008 14:22:36 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=43For upgraders to GoldMine Premium edition the new menu structure can be confusing.http://www.softstuff-consulting.com/kbase/showkb.asp?id=43Mon, 11 Aug 2008 14:17:13 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=42To help weed out incorrect email addresses that do not contain an @ symbol,a simple query can be run in the GoldMine SQL query window.http://www.softstuff-consulting.com/kbase/showkb.asp?id=42Wed, 6 Aug 2008 11:41:29 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=41A quick and easy way to schedule an activity for a contact is to drag them from the contact search list and drop them onto the calendar day view.http://www.softstuff-consulting.com/kbase/showkb.asp?id=41Wed, 6 Aug 2008 11:33:02 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=40To quickly copy the contact details from a GoldMine contact record it isnt necessary to do it field by field.http://www.softstuff-consulting.com/kbase/showkb.asp?id=40Mon, 4 Aug 2008 17:10:29 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=39This applies to SQL hosted systems only.http://www.softstuff-consulting.com/kbase/showkb.asp?id=39Thu, 31 Jul 2008 21:11:25 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=38All the information about each table in the database is held within the database itself, and the following query can be used to investigate, or extract the information if you need to use it to build dynamic SQL queries etc.http://www.softstuff-consulting.com/kbase/showkb.asp?id=38Thu, 31 Jul 2008 21:05:06 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=37The process to remove old log files in GoldMine is manual, and quite slow. It would be simpler to be able to script this to run ever month automatically.http://www.softstuff-consulting.com/kbase/showkb.asp?id=37Thu, 31 Jul 2008 20:35:20 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=36For CTI screen popping many CTI systemsrequire that the nmbers be stored in the database without extra characters like spaces and brackets. This enables the CTI software to search for the incoming telephone number in the contacts database very quickly.http://www.softstuff-consulting.com/kbase/showkb.asp?id=36Sun, 27 Jul 2008 18:04:30 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=35By default GoldMine only allows an email address to be linked to a single contact.http://www.softstuff-consulting.com/kbase/showkb.asp?id=35Fri, 25 Jul 2008 12:31:13 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=34Normal GoldMine business practice is to complete appointments as soon as is possible after the occur, and adding notes as a reminder where appropriate.http://www.softstuff-consulting.com/kbase/showkb.asp?id=34Wed, 23 Jul 2008 17:34:40 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=33To produce a list of contacts with out a primary email address, the following SQL query can be used.http://www.softstuff-consulting.com/kbase/showkb.asp?id=33Tue, 22 Jul 2008 09:58:10 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=32Quite often a GoldMine database contains a field like Account Manager or industry Type. For a quick and easy way to find out how many records are in each category contained in the field do the following.http://www.softstuff-consulting.com/kbase/showkb.asp?id=32Thu, 17 Jul 2008 22:56:43 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=31To find out how much physical disk space a table takes up execute the following stored procedure.http://www.softstuff-consulting.com/kbase/showkb.asp?id=31Thu, 17 Jul 2008 22:44:12 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=30To discover the network name of the server that SQL is physically located on, the extended stored procedure xp_getnetname can be used.http://www.softstuff-consulting.com/kbase/showkb.asp?id=30Thu, 17 Jul 2008 22:21:54 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=29The stored procedure sp_databases will return the list of the databases on the current SQL server.http://www.softstuff-consulting.com/kbase/showkb.asp?id=29Thu, 17 Jul 2008 22:10:44 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=28GoldMine does not have a simple way of counting history records. This can be done by using a simple expression in the SQL query window contained within the product.http://www.softstuff-consulting.com/kbase/showkb.asp?id=28Thu, 17 Jul 2008 21:33:40 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=27Quite often the network login name is different from the GoldMine user name, this results in the user having to retype their login details each time they login.http://www.softstuff-consulting.com/kbase/showkb.asp?id=27Thu, 17 Jul 2008 21:10:05 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=26GoldMine when first installed produces a series of warnings for each user each time they try to use a new feature. These pop-up on a series of actions, eg. Going into the InfoCenter for the first time, or setting up email rules for the first time. Users have an option on the popup to turn them off, but it must be done for each popup for each user.http://www.softstuff-consulting.com/kbase/showkb.asp?id=26Thu, 17 Jul 2008 20:57:51 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=25It is possible to customise GoldMine by adding your own logo to the right-hand corner of the GoldMine login screen.http://www.softstuff-consulting.com/kbase/showkb.asp?id=25Tue, 15 Jul 2008 19:55:56 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=24If you use record alerts, the default delay of 7 seconds might prove to be too long or too short depending upon your individual application of GoldMine.http://www.softstuff-consulting.com/kbase/showkb.asp?id=24Tue, 15 Jul 2008 19:49:11 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=23GoldMine stores notes internally as HTML which allows formatting information to be stored with the text. This allows the use of Bold or Italic characters within the text, or even different font sizes.http://www.softstuff-consulting.com/kbase/showkb.asp?id=23Sun, 13 Jul 2008 14:45:12 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=22If users keep leaving GoldMine logged in at night, or they leave the application open while they are away from their desks for a period of time, it is possible to ensure the application gets logged out in both scenarios.http://www.softstuff-consulting.com/kbase/showkb.asp?id=22Sun, 13 Jul 2008 13:15:53 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=20Occasionally an issue in GoldMine might arise where the number of records in contact2 might not match the number of records in contact1, especially on older versions of GoldMine.http://www.softstuff-consulting.com/kbase/showkb.asp?id=20Mon, 30 Jun 2008 20:48:58 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=19Occasionally the number of contact2 records may not match the number of contact1 records. In some cases this may be down to the fact that the contact1 record has been deleted but the associated contact2 record remains. This is sometimes more obvious on systems that have been upgraded from older versions of GoldMine.http://www.softstuff-consulting.com/kbase/showkb.asp?id=19Mon, 30 Jun 2008 20:47:38 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=18When running sql queries in the GoldMine SQL query window by default it will only show the first 10000 records of the results.http://www.softstuff-consulting.com/kbase/showkb.asp?id=18Mon, 30 Jun 2008 20:46:06 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=17When using date groupings in GoldMine SQL queries goldmine can be a little quirky as to the date formats it will allow within the query.http://www.softstuff-consulting.com/kbase/showkb.asp?id=17Mon, 30 Jun 2008 20:44:10 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=16A quick way of selecting a batch of random records from a SQL table is to include the NEWID() function in the WHERE clause. This function generates Windows GUID values and provides for most purposes a resonably random set of results.http://www.softstuff-consulting.com/kbase/showkb.asp?id=16Mon, 30 Jun 2008 09:03:07 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=15There are two methods to do this either using a TRUNCATE or DELETE command. http://www.softstuff-consulting.com/kbase/showkb.asp?id=15Mon, 30 Jun 2008 08:46:40 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=14Without using export functions or DTS to write text or CSV files directly from a stored procedure, add the following into your database. It uses the FileSystemObject to write directly to disk. You have to supply a filename, and the line of text to add. You will be responsible for fomatting the output exactly as you need it, and if multiple values are included you will have to assemble them before outputting them to disk.http://www.softstuff-consulting.com/kbase/showkb.asp?id=14Fri, 13 Jun 2008 19:09:25 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=13Creating a counter to provide each Goldmine record with a sequential number as it is entered can be acheived through the lookup.ini file. GoldMine contains an internal function to allow a number of seperate counters to be maintained.http://www.softstuff-consulting.com/kbase/showkb.asp?id=13Fri, 13 Jun 2008 18:56:03 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=12If you have installed QuoteWerks on a Terminal Server, and users need admin rights to be able to use the software perform the following, otherwise they experience the following errors.http://www.softstuff-consulting.com/kbase/showkb.asp?id=12Fri, 13 Jun 2008 18:42:47 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=11During a GoldMine server move the linked documents can prove to be difficult to move, as he recommended way isto build a transfer set, and restore it to a new database, but if the GoldMine system has been in use for a while there can be lots of linked documents which can take a huge amount of time to process.http://www.softstuff-consulting.com/kbase/showkb.asp?id=11Fri, 13 Jun 2008 18:30:30 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=10When using a reporting tool like Crystal Reports one of the issues often encountered is when data has been stored in a multi-selection field. The problem here is made worse by the fact that there are possibly multiple values in the same field, but these all need to be translated to more human friendly values from custom_captions before they can be displayed in the report.http://www.softstuff-consulting.com/kbase/showkb.asp?id=10Fri, 13 Jun 2008 18:16:11 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=9When granting access to tables in SQL Server, it is standard practice not tohttp://www.softstuff-consulting.com/kbase/showkb.asp?id=9Wed, 11 Jun 2008 23:59:03 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=8Scenario: you have a group of customers/prospects and you want to send a letter to everyone in the group who doesnt have an email address, and an email to everyone who does.http://www.softstuff-consulting.com/kbase/showkb.asp?id=8Sun, 8 Jun 2008 11:51:56 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=3To truncate transaction logs and free wasted space on a SQL server, the following script will shrink all the user databases on a single server. This has the advantage thatif there is insufficient disk space to backup each database the operation can be performed without the need for additional storage.http://www.softstuff-consulting.com/kbase/showkb.asp?id=3Sat, 7 Jun 2008 12:05:27 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=5Within the HEAT administrator there is currently no facility to change a Detail screen name after it has been created. An example is if the Detail screen is created as Software it must be referred to within Call Logging as Software, but there are instances during the life of the system where the screens and items need to be changed. e.g.: Software to Software Issue http://www.softstuff-consulting.com/kbase/showkb.asp?id=5Sat, 7 Jun 2008 12:02:07 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=4The script below when added to the lookup.ini file will automatically populate the Dear field when a name containing at least two words are entered into the Contact field. http://www.softstuff-consulting.com/kbase/showkb.asp?id=4Sat, 7 Jun 2008 12:00:44 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=2Unfortunately within the GoldMine UI there is no facility for limiting the types of records that can be deleted from the system. The only way to get around this is to install triggers on an SQL system. The following trigger will prevent the deletion of a specific type of detail record, unless the user types xx into the reference field to mark it as ready for deletion. http://www.softstuff-consulting.com/kbase/showkb.asp?id=2Sat, 7 Jun 2008 11:59:51 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=1This script will shrink a SQL database, clear the transaction logs and allow the operating system to reclaim the free space. http://www.softstuff-consulting.com/kbase/showkb.asp?id=1Sat, 7 Jun 2008 11:58:34 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=7Tables created by each user depending upon user rights may not be available to all other users. To change the ownership of a table to make it accessible to all use the following script. http://www.softstuff-consulting.com/kbase/showkb.asp?id=7Sat, 7 Jun 2008 11:57:46 GMT http://www.softstuff-consulting.com/kbase/showkb.asp?id=6Using the following expression within a document template will allow blank lines to be suppressed. http://www.softstuff-consulting.com/kbase/showkb.asp?id=6Sat, 7 Jun 2008 11:52:52 GMT