Archive | Master Rights & Wrongs

About GoldMines’ Google Apps Sync Feature

Posted on 18 April 2014 by Jay Dymond

GoldMine Premium Edition now includes integration with Google Apps. This integration provides bidirectional synchronization between your Google Apps Calendar and your GoldMine Calendar. Standalone Gmail accounts are not supported at this time. Users must have a paid Google Apps account.

GoldMine Mobile must be installed to use the Google Apps integration. GoldMine owners do not need to use/own a license of GoldMine Mobile but the service must be installed in order to sync with your Google Apps account. Once the integration is installed and configured, syncing will occur automatically with no end user action necessary.

Stay Connected From Anywhere

With Google Apps Calendar you’ll have access to your calendar  no matter where you are in the world and what device you're on. For your business, this means every employee and everyone you work with can be productive from anywhere, using any device with an Internet connection. Organize your day with Calendar and get event reminders on your phone or in your inbox. Attach files or docs to your event so you have the right materials when your meeting starts.

If you are interested in setting up the Google Apps Sync feature with GoldMine Premium Edition, please contact our office. The following lists some of the items you will need in order to successfully install/configure the Google Apps Sync feature, please contact us for technical assistance.

Prerequisites for Google Apps Sync Feature:

You need to have the following before you can set up and configure the synchronization:

  •  An authorized login for Google Apps to access the Google Developers and Google Admin consoles.
  • At least one active Project in the Google Developers console so that you can access the APIs and other functionalitynecessary to set up the configuration.
  •  GoldMine Mobile Edition (GMME) installed on an IIS server in order to synchronize the Calendar with Google Apps.
  •  The IP address of the IIS server to access the GoldMine Configuration page if you are installing from another machine, (or use /localhost). Once GMME is installed you can access Google Apps and the GoldMine configuration page from any machine.

We recommend an installation of Chrome for ease of use with Google Apps products.
Set up involves logging in to the following pages:

  • Google Developers Console Page,
  • Google Admin Console
  •  GoldMine Configuration screen in Google Apps.

Once the synchronization is configured and enabled it will run until the GMGoogleSync service is manually stopped or fails. The service starts automatically when the server starts. We recommend performing the connection tests in order to ensure that your set up works.

Comments (0)

GoldMine Premium Edition 2013 HotFixes Released

Posted on 12 February 2014 by Jay Dymond

What's New in GoldMine Premium Edition 2013.1 Hotfix 5 (2013.1.0.298)

Double-clicking a Case on a contact record’s Cases tab will open the selected case in the Service Center in detail view without resetting the Service Center list view. A user can return to the list view by clicking the Service link.

What's Fixed in GoldMine Premium Edition 2013.1 Hotfix 5 (2013.1.0.298)

  • MS Word exe is using a large amount of CPU with the GoldMine word link installed.
  • Double clicking a case in the cases tab will not bring you to the case if not listed in the 500 cases in the Service Center >> The requested case is out of view because of your filter settings, please release the filter or use the search functionality
  • E-mails with base64 encoding not being displayed correctly in GoldMine (when using Exchange or some other mail servers)
  • 8 bit encoded text/HTML emails are coming in to GoldMine with Asian type characters or ?? in the body and header but show correctly in the online inbox view

What's Fixed in GoldMine Premium Edition 2013.1 Hotfix 4 (2013.1.0.287)

  • Whenever an email is replied to if any of the recipient's full name contains an apostrophe, all CC recipients on the reply are stripped.
  • Email received into GoldMine from Call Logix doesn't have a message in the body of the email but has some info from the body of the email in the email headers in GoldMine
  • sporadically: StartIndex cannot be less than zero - when linking specific incoming or outgoing emails via Outlook Integration

What's Fixed in GoldMine Premium Edition 2013.1 Hotfix 3 (2013.1.0.276)

  • “Change” bar still existed after clicked "Send contact data to Outlook" hyperlink
  • Sign in under "LinkedIn" GM+Views do not display login window, and will sign in capability in a new Web Browser outside of GoldMine for login, for Windows 7 there is further no chance even with saving cookies to get into LinkedIn anymore
  • Configuration of this site contains a serial number from a previous version of Goldmine. Please update it by entering a matching current serial number each day when a user logs onto GoldMine when synchronizing with another E-license.
  • Output to >> Excel does not populate Office 365 Excel 2013 with any information, new workbook is never opened
  • Clicking on the Alert column to sort the list of cases in the Service Center produces an error and crashes GoldMine
  • Entering an apostrophe (') in the service center search field crashes Goldmine

What's Fixed in GoldMine Premium Edition 2013.1 Hotfix 2 (2013.1.0.265)

  • Constant Contact integration recognizes UK format on Date Sent field only correctly, when the campaign was sent on or after 13th of month
  • When merging a document through an automated process, it loops repeatedly through the fields on the merge form
  • Contacts with a single quote (apostrophe) in their name cause subsequent contacts not to show in E-Mail address list
  • Adding multiple attachments to an email, will not add the attachments after the apostrophe in the attachment name
  • When merging a document using right-click and print for this contact, loops through fields repeatedly
  • When updating LASTNAME (LAST) field the CONTACT field is updated > for all versions below 2013.1 only the opposite way did work and this is unexpected and not documented
  • When opening an E-mail after being processed (NOT in EDIT mode) >> opening Regarding list for linking to Opportunity or Project -> Sort of Opportunities/Projects is not intuitive (by creation date/time) and confuses when many records are there
  • Failed to execute command: insert into {{owner}}Environment values( 'GMFileLocation', '','','','O',0,'GSPDONW&(<S(W<' to data type smallint when upgrading to GMPE 2013.1
  • GoldMine takes focus when creating new, replying to, or opening emails in Outlook
  • Attachments with apostrophe's are not properly downloaded/displayed in GoldMine
  • Email address with a single quote (apostrophe) causes subsequent email address to not show or become truncated.
  • Attaching emails from a folder with an apostrophe results in the email history object not showing attachments.
  • When putting an apostrophe in an additional contact's name, it truncates the rest of the list of emails when adding a CC to an email.

What's Fixed in GoldMine Premium Edition 2013.1 Hotfix 1 (2013.1.0.249)

  • To prevent performance issues, a maximum of 500 cases can be viewed in the Service Center. You may select an option from the Show dropdown to filter your Cases or use the Service Center Search function to search for a Case. The top 500 cases are loaded based on your sort selection.
  • Customer tries to see "All Cases" - only a random list of 500 Cases are available in the Service Center
  • Required case is out of the view because of current filter settings.
  • GoldMine PE 2013.1 Installer NOT recognizing Office 2013 32-bit installation from Office 365

Do any of these issues apply to you?

- Do you need to renew your GoldMine Maintenance ?
- Would you  like help applying a GoldMine update or other issues ?
- Want to get information on upgrading or purchasing GoldMine Premium ?

Click here to contact First Direct!
Or call us at (800)935-4386

Comments (0)

Backup Your Local Backups and Important Files/Documents with Online Backup Services

Posted on 25 October 2013 by Jay Dymond

The following is a great article that reviews 27 Online Backup Services. There are no excuses for NOT backing up your local backups and other important documents/files.

Online backup services work much like traditional backup software. With an online backup service, however, your important data is transmitted over the Internet and securely stored on a server in a professional data center. The advantage of having your important data backed up off-site, away from your home or office, is that it's safe from theft, fire, and other local disasters.

You might also want to check out this great article that covers Common Questions about Online Backups.

Comments (0)

What does “cloud computing” really mean?

Posted on 25 October 2013 by Jay Dymond

Cloud computing is all the rage. It's become the catch phrase for many people, looking to take advantage of what it has to offer. The problem is that (as with Web 2.0) everyone seems to have a different definition/idea of what cloud computing is.

As a metaphor for the Internet, "the cloud" is a familiar cliché, but when combined with "computing," the meaning gets bigger and fuzzier. Some analysts and vendors define cloud computing narrowly as an updated version of utility computing: basically virtual servers available over the Internet. Others go very broad, arguing anything you consume outside the firewall is "in the cloud," including conventional outsourcing.

Cloud computing comes into focus only when you think about what IT always needs: a way to increase capacity or add capabilities on the fly without investing in new infrastructure, training new personnel, or licensing new software. Cloud computing encompasses any subscription-based or pay-per-use service that, in real time over the Internet, extends IT's existing capabilities.

Cloud computing is at an early stage, with a disparate list of providers large and small delivering a slew of cloud-based services, from full-blown applications to storage services to spam filtering. Yes, utility-style infrastructure providers are part of the mix, but so are SaaS (software as a service) providers such as Salesforce.com, Zoho.com, even Google Apps. Today, for the most part, IT must plug into cloud-based services individually, but cloud computing aggregators and integrators are already emerging.

Here's a rough breakdown of what cloud computing is all about:

1. SaaS (Software as a Service)

This type of cloud computing delivers a single application through the browser to thousands of customers using a multitenant architecture. On the customer side, it means no upfront investment in servers or software licensing; on the provider side, with just one app to maintain, costs are low compared to conventional hosting. Salesforce.com is by far the best-known example among enterprise applications, but SaaS is also common for HR apps and has even worked its way up the food chain to ERP, with players such as Workday. And who could have predicted the sudden rise of SaaS "desktop" applications, such as Google Apps and Zoho Office?

2. Utility computing

The idea is not new, but this form of cloud computing is getting new life from Amazon.com, Sun, IBM, and others who now offer storage and virtual servers that IT can access on demand. Early enterprise adopters mainly use utility computing for supplemental, non-mission-critical needs, but one day, they may replace parts of the datacenter. Other providers offer solutions that help IT create virtual datacenters from commodity servers, such as 3Tera's AppLogic and Cohesive Flexible Technologies' Elastic Server on Demand. Liquid Computing's LiquidQ offers similar capabilities, enabling IT to stitch together memory, I/O, storage, and computational capacity as a virtualized resource pool available over the network.

3. Web services in the cloud

Closely related to SaaS, Web service providers offer APIs that enable developers to exploit functionality over the Internet, rather than delivering full-blown applications. They range from providers offering discrete business services -- such as Strike Iron and Xignite -- to the full range of APIs offered by Google Maps, ADP payroll processing, the U.S. Postal Service, Bloomberg, and even conventional credit card processing services.

4. Platform as a service

Another SaaS variation, this form of cloud computing delivers development environments as a service. You build your own applications that run on the provider's infrastructure and are delivered to your users via the Internet from the provider's servers. Like Legos, these services are constrained by the vendor's design and capabilities, so you don't get complete freedom, but you do get predictability and pre-integration. Prime examples include Salesforce.com's Force.com, Coghead and the new Google App Engine. For extremely lightweight development, cloud-based mashup platforms abound, such as Yahoo Pipes or Dapper.net.

5. MSP (Managed Service Providers)

One of the oldest forms of cloud computing, a managed service is basically an application exposed to IT rather than to end-users, such as a virus scanning service for e-mail or an application monitoring service (which Mercury, among others, provides). Managed security services delivered by SecureWorks, IBM, and Verizon fall into this category, as do such cloud-based anti-spam services as Postini, recently acquired by Google. Other offerings include desktop management services, such as those offered by CenterBeam or Everdream.

6. Service commerce platforms

A hybrid of SaaS and MSP, this cloud computing service offers a service hub that users interact with. They're most common in trading environments, such as expense management systems that allow users to order travel or secretarial services from a common platform that then coordinates the service delivery and pricing within the specifications set by the user. Think of it as an automated service bureau. Well-known examples include Rearden Commerce and Ariba.

7. Internet integration

The integration of cloud-based services is in its early days. OpSource, which mainly concerns itself with serving SaaS providers, recently introduced the OpSource Services Bus, which employs in-the-cloud integration technology from a little startup called Boomi. SaaS provider Workday recently acquired another player in this space, CapeClear, an ESB (enterprise service bus) provider that was edging toward b-to-b integration. Way ahead of its time, Grand Central -- which wanted to be a universal "bus in the cloud" to connect SaaS providers and provide integrated solutions to customers -- flamed out in 2005.

Today, with cloud-based interconnection seldom in evidence, cloud computing might be more accurately described as "sky computing," with many isolated clouds of services which IT customers must plug into individually. On the other hand, as virtualization and SOA permeate the enterprise, the idea of loosely coupled services running on an agile, scalable infrastructure should eventually make every enterprise a node in the cloud. It's a long-running trend with a far-out horizon. But among big metatrends, cloud computing is the hardest one to argue with in the long term.

If your organization is looking to take advantage of cloud computing and are not sure what options are available to you, please contact First Direct Corp, so that we can discuss your needs and advise you on what might work best for you.

Comments (0)

So you want to learn SQL?

Posted on 24 October 2013 by Jay Dymond

SQL is a standard language for accessing databases. These SQL tutorials will teach you how to use SQL to access and manipulate data in: MySQL, SQL Server, Access, Oracle, Sybase, DB2, and many other database systems.

What is SQL?

  • SQL stands for Structured Query Language
  • SQL lets you access and manipulate databases
  • SQL is an ANSI (American National Standards Institute) standard

What Can SQL do?

  • SQL can execute queries against a database
  • SQL can retrieve data from a database
  • SQL can insert records in a database
  • SQL can update records in a database
  • SQL can delete records from a database
  • SQL can create new databases
  • SQL can create new tables in a database
  • SQL can create stored procedures in a database
  • SQL can create views in a database
  • SQL can set permissions on tables, procedures, and views

The following is a great tutorial that covers a lot of material about SQL - http://www.w3schools.com/sql/default.asp

In order to write SQL statements you need to know the database table structure, the following is a link to a website that details the GoldMine database table structure. - http://www.enigmaware.co.uk/goldmine/tabledefs/

Finally, here is a guide you can purchase, that covers writing SQL Queries for GoldMine.

 

Comments (0)

Tags:

Setting up a SQL Server Maintenance Plan to Backup Databases

Posted on 24 October 2013 by Jay Dymond

In this MS SQL Tutorial, we show you how to do SQL Server 2008 R2 database backup using SQL maintenance plans. This is an easy way for you to do Administration things like Backing up a SQL database, Updating statistics and other SQL Server DBA tasks. We show you How to use the Maintenance Plan Wizard, we create new Full database backup on MS SQL 2008. We also show you how to select the backup file location, create output log file with history on the backup process and a daily schedule that is run by the SQL Server Agent. Using the Maintenance Plan Wizard, SQL server Administration tasks are made quite easy and pretty easy to follow. We also go over the events and historical view of an existing SQL Job.

PLEASE NOTE: Your organizations own maintenance plan settings will vary from what is set in this video. For instance, the databases, the amount of weeks worth of data to keep, or how often the backups should run will depend on your organizations needs.  In many cases you will want to run backups every night, and the amount of backups you keep will depend on how much free disk space you have available on your server.

Comments (0)

How To Backup Your GoldMine SQL Database Manually

Posted on 24 October 2013 by Jay Dymond

If you are using GoldMine Corporate or GoldMine Premium Editions, there are times when you will need to backup the GoldMine database manually.  This is done through the MS SQL Server Management Studio wherever SQL Server is installed, and usually where your GoldMine is installed as well. SQL Server, which is GoldMine's database engine, is usually configured with a management job to backup your GoldMine data on a regular nightly basis.  However, if you are about to make some changes to GoldMine and you want to be able to restore to a previous state if things go sideways, you need to be able to make a backup.

Here is a great short video that shows how to perform a manual backup of GoldMine data through the SQL Server MS.  Here it is:

Comments (0)

Five Free Data Recovery Programs

Posted on 23 October 2013 by Jay Dymond

While the best defense against data loss is redundant and real-time backup, we understand that sometimes data loss sneaks right up on you. Whether your important office documents accidentally got deleted from your computer or if your family photos have gone missing, having emergency data recovery tools handy is crucial to getting your data back before it's gone forever.  The following are some of the best data recovery tools available.

TestDisk (Windows/Mac/Linux)

TestDisk is a powerful open-source tool for recovering your data. Not only can TestDisk perform basic file recovery like undeleting accidentally deleted files from FAT, NTFS, and ext2 file systems, but it comes with a host of additional functionality. With TestDisk you can recover your boot sector from a backup, rebuild your boot sector, fix FAT tables, fix your MFT, locate the ext2/ext3 backup SuperBlock, copy deleted files from partitions to recovery media, and find lost partitions in dozens of formats to help you locate your lost data. It's a command line tool, so there's no GUI, but the menus and the documentation in the wiki should get you started without much trouble.

Recuva (Windows)

Recuva is a user-friendly Windows-based tool. When you run Recuva, you can resurrect missing files using either the file-recovery wizard or the application's manual mode. The file-recovery wizard is handy when you're sure your data is gone but you're not quite sure where it went or how to get it back. The wizard lets you narrow your search type to pictures, music, documents, video, or all files, and you can set the search location to everywhere on your computer, removable media only, in My Documents, the Recycle Bin, or a specified location. If you don't need the wizard you can jump right into manual mode and get to work searching where you know the file should be. Recuva uses a green/yellow/red light system to indicate how probable the recovery of your files will be, and when available, it can provide previews image files available for recovery. Recuva also includes a tool to securely wipe files you find, handy if you're attempting a file recovery just to ensure the files are actually dead and gone.

PhotoRec (Windows/Mac/Linux)

PhotoRec is a companion program to TestDisk, also included in this Hive Five. Like TestDisk, this app is also devoid of a GUI, but likewise is quite powerful at file recovery. We're including PhotoRec independently of TestDisk because many users distinctly prefer PhotoRec as a safer alternative when deep disk recovery isn't necessary. This recovery tool won't mess with your partitions or help you rebuild your master boot record; it will, however, dive into your disks in a safe, read-only mode and ignore partitions and file systems in an effort to seek out your missing files. PhotoRec focuses on file types, is operating-system agnostic, and despite its name, isn't relegated to just photos. Overall, PhotoRec is a powerful tool for quickly and safely copying your deleted files to another disk.

Restoration (Windows)

Restoration is a tiny, no-frills, portable recovery tool. You can use it in all versions of Windows and Windows file systems. It lacks some of the advanced functionality of other nominees but does have basic file-name search and the ability to sort by file parameters such as size and filename. Despite its tiny size, it performed just as well as the other nominees when tasked with restoring files from our test disks. Restoration weighs in at a mere 406k and would make a great addition to any Windows-based USB toolkit.

Undelete Plus (Windows)

Undelete Plus used to be commercial software but has gone on a lengthy "limited time offer" freeware run. This file recovery app works on all versions of Windows and incarnations of the FAT and NTFS file systems. Like Recuva, Undelete Plus assigns a recovery probability to files it finds based on how damaged the file is. You can sort files by type, set filters based on time and size to avoid sifting through every deleted file on your disk, and keep folder structures intact when you perform your recovery.

Comments (0)

Pixlr.com: Easy Online Photo Editing

Posted on 22 October 2013 by Jay Dymond

Pixlr is the most widely used free online photo editor on the web and mobile. It transforms any image with a fast, intuitive and robust tool set that is easy to use for the burgeoning photographer with no prior knowledge of photo editing, while also offering fully featured, per-pixel editing complete with layers, adjustment tools and filters for the more advanced user. It is also great for anyone needing to edit/create their own images.

Pixlr Editor

Pixlr Editor is an advanced online service designed for creating, editing, opening and saving images and photos in various formats. In addition to impressive photo editing features such as layers, shapes, airbrushes, scaling, gradients, color adjustments and filters, Pixlr Editor allows users to download and save files to a local computer in several different formats (including Pixlr Editor’s own multi-layer format, .PXD), or send directly to social networking sites and/or photo sharing sites, such as Facebook, Flickr, or Picasa.

Pixlr Express

Pixlr Express is a simple photo editing tool aimed at users seeking quick and easy fixes for their digital images. With this tool, users with little to no experience with desktop photo editors can still do very cool things to their photos. Pixlr Express boasts a clear, intuitive interface and allows anyone with an Internet connection to resize, adjust, and add effects to their photos.

Pixlr-o-matic

Pixlr-o-matic, awarded the 2011 ‘Best App Ever’ award for the Best Photo Editing App on Android by 148apps.com, is a web and mobile (iOS and Android) service that allows users to add fun retro effects to images, transforming photos into unique masterpieces. Editing on Pixlr-o-matic is simple, with more than 2 million possible finishes, including overlays and borders. With more options than any other photo app, users will never run out of new styles. This fun and simple darkroom app makes it easy to add an effect, overlay and border to get that retro, grunge, or clean look –in just three simple steps.

Pixlr Grabber

A browser tool to fetch images and screen grabs from any web page.

Pixlr imm.io

imm.io is a one-click easy image sharer, perfect if you want to upload an image to show your friends or link from other sites.
Platforms: Online service

Comments (0)

“Round Robin” Assigning of New GoldMine Leads

Posted on 18 October 2013 by Jay Dymond

Is your GoldMine connected to your website so that you can capture leads from your web forms and automatically create/update new Contact Records in GoldMine? Would you like to do a “Round Robin” assignment of the "New Leads" to your GoldMine Sales Reps? Well, with GoldMine, you can do that and it’s easy to set up.  It requires creating/using the Lookup.ini file.

Just update your GoldMine lookup.ini file with this code:

[AutoUpdate]
newrecord=Key3

[Key3]
lookup1=&counter(“SalesRepCounter”,1) % 3
0=TOM
1=JIM
2=SARAH
otherwise=N/A
Overwrite=0

Now, one thing to be aware of is that this will not take into consideration any bogus leads that you may receive from your website.
You should ensure that your web forms are setup to prevent SPAM leads from being submitted, otherwise your sales reps may be disappointed with the leads they are receiving  while others are receiving good leads.

If your website is not currently connected to your GoldMine system to create/update records when your web forms are submitted, you can click here to learn more or contact First Direct Corp. to discuss implementing this feature. In addition, if you are interested in learning more about what the Lookup.ini file can do for you, please click here.

Comments (0)

Most Recent Posts

Enter your email address to subscribe to GoldMineSuccess.com and automatically receive email notifications of new posts.