Archive

Archive for the ‘Tips’ Category

Outlook with Goldmine Plugin: Data Error

December 15th, 2010 No comments

If you’re getting the following error message in Outlook, and you have the Goldmine plugin installed, it’s probably the plugin that’s causing it:

Unable to convert ‘System.String’ to ‘System.Int32’

This error occurs when the Goldmine plugin attempts to display invalid data in the Goldnine pane in Outlook. The invalid data could be Null values stored as units or amounts in forecasted sales. You can;

  1. Check for null values for units or amount in forecasted sales: NUMBER1, NUMBER2 fields in CAL table, where RECTYPE = ‘S’
  2. Manually cleanse data by changing the nulls to zeros.

or

  1. Turn off display of Forecasted Sales in Outlook. Go to Setup GoldMine Plus, Options, uncheck Show Forecasted Sales.

Easy.

Share
Categories: Tips Tags: , , , ,

Word file missing pictures; Edit links

December 1st, 2010 3 comments

Received a Word file and all the pictures are missing? Could well be because the images were linked and not embedded in the document. The creator of the file will need to edit the links and save the pictures in the file. It’s easy:

Word 2007:

Click the Office button and select Prepare > Edit Links to Files. Then for each link (you can select them all using the Shift key), check the box ‘Save picture in document’. Do a ‘Save As’ and it’s done.

Word 2010:

Click File. In the Properties section on right of the file menu pop up there should be a button near the bottom that says ‘Edit Links to Files’, click the button. Then for each link (you can select them all using the Shift key), check the box ‘Save picture in document’. Do a ‘Save As’ and it’s done.

Share
Categories: Tips Tags: , , ,

Google Apps – Xerox Scan to Email

August 13th, 2010 3 comments

Switched to Google Apps and now can’t get your Xerox printers to scan to email? It’s because Google’s servers require you to use SSL when sending email and the Xerox’s can’t send by SSL. To get it working, you’ve got two options (#2 is the far easier option):

1. You can use a program called Stunnel to accept the Xerox’s SMTP transfer and transmit it to Google via a secure connection. More info here.

2. Google actually accepts non-SSL SMTP connections on one of their servers, aspmx.l.google.com on port 25. Set the Xerox to send via that and set your username and password to a Google Apps account.

Share
Categories: Tips Tags: , , , ,

Google Apps Outlook Sync – XP 64 bit

August 13th, 2010 4 comments

Trying to install the Google Apps Outlook Sync connector on your XP 64 bit PC?  Getting the following error: “Could not find http.sys.  Please install all patches specified in the system requirements.  For more details, see: http://support.microsoft.com/kb/939786”

Don’t worry, it can be done!

Copy the http.sys file from “C:\WINDOWS\System32\Drivers\” to “C:\WINDOWS\SysWOW64\Drivers\”

Install the connector.

Sorted!

Share
Categories: Tips Tags: , , , , , , , ,

Windows 7: Change network gateway

March 19th, 2010 No comments

Recently started using Windows 7 64bit at work and I wanted to change my network gateway to use a different broadband line. I did the usual thing, went into the properties of my Local Area Connection, Properties of TCP /IPv4, Advanced, Default Gateways, Add. Added the IP address, perfect, has always worked before. Until now. 7 would just not accept it. Tried repairing the connection, restarting the PC. Nothing worked. I was starting to get frustrated!

There is quite a simple solution though. Just set your network card to use a static IP address and gateway and it works fine.

Easy.

Share

Google Apps Directory Sync: AD passwords

March 19th, 2010 No comments

Trying to sync your Active Directory user passwords with Google Apps? Check out http://code.google.com/p/sha1hexfltr/

Works a treat.

Share
Categories: Tips Tags: , , , ,

Set up Goldmine with Google Mail

March 18th, 2010 4 comments

Has your company switched to Google Apps and you’re wondering how to get your emails in Goldmine? It’s actually quite easy. (I say Google Apps, but this will work for personal use Gmail as well as Google Apps Mail).

First you need to enable IMAP on your Google Mail account (if it isn’t already). In Google Mail go to Settings. Then click the Forwarding and POP/IMAP tab> Check the radio button to enable IMAP.

Now set up Goldmine to connect to GMail. In Goldmine go to Tools> User settings> Preferences> Email. In the Getting mail section set the server to IMAP and enter address imap.gmail.com. Username is your email address, password is your password. Check the ‘Use encrypted connection (SSL)’ box.

In the Sending Mail section the SMTP server is smtp.gmail.com, return address is your email address. Again, check the ‘Use encrypted connection (SSL)’ box.

Done

Update 16.08.10:

I think Google have made security on their servers a bit tighter. Follow these extra steps to get things working:

On the Email settings tab, click the Accounts button. Select the account in the list and click Edit.
Change the Getting Mail port to 993.
In the Sending Mail section, enter your email address as the username and enter your password. For authentication, select Auto. Check Use Start TLS. Make sure the port number is 587.
That should work.
Share

Windows Vista/7: Blank screen after logon

January 26th, 2010 No comments

Recently had this problem at work after I had modified the log on script to add a new printer. You may have noticed in Windows Vista & 7 when you add a network printer a message box pops up asking you to confirm to install the printer driver.

Well our log on script is set to run and complete before the desktop loads, so because the desktop hasn’t loaded yet you never see the pop up message asking you to confirm to install the printer driver. So the PC just sits there with a blank screen waiting for you to click yes or no on a pop up box that you can’t see!

The solution? Log onto the PC using a local account or a network account that doesn’t have a log on script (maybe the network administrator), add all the network printers you need. Log back off and log on as normal. Solved!

Share
Categories: Tips Tags: , , , , , ,

Windows Server 2003: Windows update registry settings

December 14th, 2009 No comments

Want to change the Windows Update settings on your Windows Server 2003 but the options are greyed out? You can change them in the registry.

Go to Start> Run> regedit

Go to HKLM> Software> Policies> Microsoft> Windows> WindowsUpdate> AU

To turn off Windows Updates completely, change NoAutoUpdate to 1.

To select one of the other 3 options change AUOptions to either 2, 3 or 4 (Notify=2, Download=3, Automatic=4).

Close and you’re done!

Share

O2: Can’t send text messages

December 9th, 2009 1 comment

Just had your number transfered to O2 and can’t send text messages? Don’t worry, this is normal for the first 24 hours (although it should start working much sooner than this).

Check your using the right message centre number to send messages. You can find these numbers on the O2 support site.

Another thing you could try is getting someone to send you a text message, this might start them working for you.

Share
Categories: Random, Tips Tags: , ,