Archive

Posts Tagged ‘Tips’

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: , , , , , , , ,

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

OWA: Change password error

November 24th, 2009 No comments

Trying to change your password with OWA and getting error: object required? You need to register a dll on the server, follow the instructions found in this Microsoft support article.

If after you’ve done this you’re now getting error number 5, you need to check Integrated Windows authentication in the IIS virtual directory. To do this go to IIS manager> right click on the IISADPWD virtual directory and select properties> select the Directory Security tab> under Authentication and access control click Edit> check the box Integrated Windows authentication.

Done!

Share
Categories: Tips Tags: , , ,

Disable AutoRun in XP

November 13th, 2009 No comments

AutoRun/AutoPlay is a well known security risk. Pop an infected USB stick into your PC and up pops the autorun/autoplay menu. Viruses can replicate items on that list, so you think you’re just opening it up in Explorer but actually you’re infecting your PC as well.

It makes sense then to disable it. It can be done easily in Group Policy, but if you’re a home user then that won’t be any use to you. Here’s how to do it XP by modifying the registry.

  1. Start> Run
  2. Type regedit
  3. Click OK
  4. Go to: HKEY_CURRENT_USER\ SOFTWARE\ Microsoft\ Windows\ CurrentVersion\ Policies\ Explorer\ NoDriveTypeAutorun
  5. Right-click NoDriveTypeAutoRun, and then click Modify.
  6. In the Value data box, type 0xFF to disable all types of drives.
  7. Click OK. Exit Registry Editor
  8. Restart your PC
  9. Done!
Share
Categories: Tips Tags: , , ,

Exchange 2003: Reduce database size

November 13th, 2009 No comments

Deleted some accounts or cleared a load of emails from your Exchange server and wondering why the database size hasn’t reduced?

Well, after you’ve deleted Exchange accounts, you need to run the Cleanup Agent for them to actually be removed (and then only after the waiting period, typically 30 days, has passed).

To change the deleted mailboxes waiting period: In Exchange System Manager go to the First Storage Group, right click on your Mailbox Store and click Properties. On the Limits tab, at the bottom, change the number of ‘Keep deleted mailboxes for (days)’.

To run the Cleanup Agent: In Exchange System Manager, go to your Mailbox Store, right click on the Mailboxes folder and click Run Cleanup Agent.

The space you’ve cleared will only be available after the next online defrag has completed (typically overnight). However, the Exchange database files won’t actually be any smaller. Exchange keeps the space in it’s databases ready to use for new emails. You can see how much free space your Exchange server is holding by viewing your Exchange servers Application Event Log (in Event Viewer). Look for the Event ID 1221 that has your Mailbox Store name in it (not the Public Store). The Event description will tell you the megabytes of free space.

To actually make the Exchange database files smaller you need to run an offline defrag. This can only be done during downtime and really isn’t recommened unless you have a lot of free space in your database to release. To run you need to detach your Mailbox Store and run the Eseutil utitlity. More info can be found here.

Share
Categories: Tips Tags: , ,

Update Group Policy

November 13th, 2009 No comments

Ever wondered how to do an immediate Group Policy update without restarting your PC or anything? It’s dead easy:

Open Command Prompt (search for CMD)

Type “gpupdate/force” (without the quotes)

Hit Enter

Done!

Share
Categories: Tips Tags: , ,