horse form

[ninelifecat]

hi
how do I get the horses form into Excel using BA? I have the "form" check box selected on the "Log current prices" scren, and when I hover the mouse over each horse in BA i can see this info, but it's not showing in Excel.
Is there any way to make it do this?
thanks
ninelifecat

[GaryRussell]

If that is the only extra column you have ticked then it should appear in column Y of the spreadsheet. I notice you are using ver 1.1.0.62. There is a bug which affects logging to multiple worksheets when you try to log to one sheet with the column ticked and another without it ticked. Could that be your problem?

Try upgrading to the latest Beta and see if you have the same problem.
See http://gruss-software.co.uk/forum/viewtopic.php?t=3922 for download link.

[GaryRussell]

Sorry, I should also have mentioned that the extra columns are only available if you have ticked Enable triggered betting

[ninelifecat]

hi
upgrading to the new version has definately worked - only if triggered betting is enabled
cheers

[ninelifecat]

hi
I'm now having the same problem with BA 1.1.0.63z on Windows 7, ie the trainer and horse form don't show up in Excel despite the boxes being ticked.
The same version of BA works perfectly on my XP laptop...
any help appreciated
thanks

[GaryRussell]

It has to be your settings.

1) Have you got "Enabled triggered betting ticked" when you set up the Excel link?

2) Can you see the jockey colours when you view the grid in Betting Assistant? If you haven't got this column enabled the information will not be available to Excel. In the grid interface preferences tick "Show silks" under "Display columns"

[ninelifecat]

Yes the show silks setting is on... triggered betting is enabled.
but resulting Excel spreadsheet still has a blank for the
form, days since last run = 0, and jockey, trainer, and age/weight are blank too.
I'm in the process of setting up a virtual xp machine, I don't think I'll be able to reproduce the problem there but I'll let you know.

[GaryRussell]

Strange. You could try upgrading to the latest Beta. See http://www.gruss-software.co.uk/forum/v ... php?t=3922

[ninelifecat]

I'll do that tomorrow.
Is there an easy way to port the BA config from my laptop (which has BA working perfectly) to another machine?
I'm OK with exporting registry keys etc if thats what it takes.
cheers

[GaryRussell]

There isn't a way at all unless you upgrade your laptop to the latest Beta version 1.1.0.66a. You can then copy the settings folder from your laptop's documents folder. See http://gruss-software.co.uk/forum/viewtopic.php?t=4610