Recent content by JohnnyL

Hi, On our SQL-based Goldmine system we have a user-defined field called UFNTURNOVR which is varchar(20) and has been used to store turnover values (pretty much in free text). I've gone through the process of tidying these values into 'numbers' eg replacing '2mil' with '2000000'. To enable us...

Thanks everyone. Problem solved. As always, very helpful.

Hi, I'm trying to have an image displayed in a fixed position, where that image changes depending on which link is being hovered over. For instance, mouse hovers over link-a then image-a is displayed , mouse over link-b then image-b is displayed etc. Any good tutorials or links or other...

hi linney, you're absolutely right. I came across those options yesterday afternoon, and all's well in my Vista-life now! Thanks. john

Hi, Am i missing something here? Under 2000/XP I could schedule tasks to run only on a weekday - great for automatic reports etc. I cant find anywhere in the Vista Task Scheduler that allows me to run a job only on a weekday. I could set 5 weekly jobs (one for Mon, one for Tue etc), or I...

Thank you Richard. I suspected that was the case, but worth a try.

Hi, My users run a crystal report (8.5) from the Goldmine (6.5) Reports Centre. This CR report is then exported from the CR viewer as a PDF or DOC, to be attached to an email message sent to a Goldmine contact. After the outbound email is filed into Goldmine history, you cant see the PDF or...

Thanks mrdenny.

Hi all, I've got some TSQL statements to backup my databases to tape overnight as server jobs. Whereas the Enterprise Manager "Backup Database" option gives you the option to verify after a backup, I cant find the same argument for the T-SQL statement anywhere. The jobs basically run...

Hi All, Is there any way of removing a GM user from the Email Centre? I have some admin users that rarely use GM, and telemarketing users who use it all the time. The telemarketing users often send emails to admin as "goldmine users", rather than other recipients - and admin don't pick them...

Ah, one small snag though. @echo off net use g: /delete net use g: \\axgoldmine\gmsystem /yes /persistent:yes net time \\dellserver /set /y if exist c:\goldnet\gmw6.exe c:\goldnet\gmw6.exe exit The batch file stays open while the goldmine client runs. Is there any way I can get the batch file...

Thanks Karlis, The same thought occurred to me last night. I'll change the script to check that Goldmine Client exists, then run the exe from the script. We're Brilliant! Thanks for your help. John

Thanks Doug, I'm on a pretty steep learning curve with Goldmine, sounds like my next chapter is Automated Processes. John

Hi All, We use groups very extensively on our GM system. Has anyone come across an add-on or done any work themselves on automatically building groups for users? Thanks John

Hi All I'm having a problem with XP Pro on a W2K domain. My users login to the domain, which runs a login script mapping drive g: to our goldmine server. There is also a shortcut in the startup folder of the client to launch the Goldmine client. The problem is that the XP client launches the...