BUG ?

Please see attached trigger compilation.
There is one called Equipace 3
I want to change the sub block to an OR condition.
That is
AND
AND
AND
AND
AND-> OR

Everytime I change is and Save conditions it reverts to AND
Tried in outside the trigger in the Editor and same result.

It will not save the OR condition in the sub block???

Can some try and make the change as required. I ma using the lastest version.
 

hi londolozi
i have tried and there is no problems.
for a sub block to be OR, there has to be 2 sub blocks not 1, you cannot have OR, if there is only 1 sub block, it is not logical.
you can have the 2 conditions in the sub block set to OR
if you want to have your first 4 conditions OR the second 2 conditions, then put the first 4 conditions in a block of there own.
so you would have 1 block with your 4 conditions and 1 block with the 2 conditions and the blocks set to OR.
i have altered the trigger for you to see.


mcbee

download the trigger below

Thanks mcbee.
Not a condition I have used much.

But does that mean either the 4 conditions are OR the 2 conditions are met?

Actually I think this is what I wanted

The trigger image is in the previous msg.
here is the Excel and trigger log images.
Why won't this work?

hi
why are you showing sheet1, when the trigger is calling for sheet querymarket_id
are they the same figures.


mcbee

Here's the cell_query sheet. It seems obvious why it failed. It appear MFPro has not transferred the data in the imported from sheet 1 on to the querymarket sheet. 29 should have gone to cell P16 and 0.0085 P17. As you can deduce from the other runners? I have not touched the sheet.

I tested another race and the same thing happened, see image?

MFPro is not transferring to place market sheets correctly.

hi
can you add a screenshot or/and list of your excel formulas from mfp


mcbee

This may be something for Oxa. I think I have found the issue.
I tested another race this time with the horse 'The Danehill Rose' which had the prior Excel data 6,9 in cols B & C

I changed this (B,C) to 29 & 0.0085. Pls see attached image what happened when the market started refreshing.

Prior to the last update I highlighted to Oxa how when you tick clear previous cells.
In the last update "5.   The setting “Clear previously imported cells” has changed its behaviour. It will now make the program delete all custom cells assigned to all selections in all markets before importing new ones from Excel. Moreover, the old imported cells will also be cleared from the corresponding market “queryxxxx” sheets."
http://community.welldonesoft.com/announcements-1/version-7-1-0-6/msg23438/#msg23438

Data seems to have  kept the 9 (orig Col C) and added the new data 29 and 0.0085 but in the wrong positions.

The import data work correctly and my data is Sheet1, A1:C500, Col: P

The error seems to only occur when I overwrite previous cells. 

hi
i have emailed support about this problem.

mcbee

Hi londolozi,

Sorry for the delay, been abroad for several days.

I'm trying to tune in to this problem and doing some tests, but obviously I'm missing some particulars.

Please read what I do below and tell me whether it is the same thin that you're doing, or if there is anything else.

1. Click "Launch Excel", wait till a market appears in the sheet.
2. Rename one of the spare sheets from Sheet1 to MySheet.
3. Fill A1:A2 with the names of horses in the market. Fill B1:C2 with some random data, numeric and textual.
4. Open Settings, switch to Excel. Press "Import Selection Cells". Sheet name: MySheet, Range: A1:C2, Output starting column: P. "Clear previously imported cells" is ON.
5. Program says it's imported data for 2 horses, ok. Checking that the new values appeared in the market sheet after the first refresh.
6. Getting back to MySheet and changing the values in B1:C2.
7. Doing steps 4-5. In both cases the new values appear in the first two cells of each selection in column P.

Can you tell me which steps go wrong in your case?

1. same
2. almost the same (I don't rename, I just import sheet1)
3. same
4. same
5. same
6. same
7. same

Up until step 5 it all works as expected.
When you change the data on a horse and import new data that when things go wrong. I have established the same happens in the win market as the place market. See the attached images.

I'll test another race .
Albany AUS race 6

Original imported data.
TO MY EYE , 3 , 0.85%
SENTOKI , 29 , 0.50%

Here is the second data
TO MY EYE , 29 , 0.40%
SENTOKI , 2 , 0.70%

See image 1 (win market after first import)
There appears to already be a bug with Sentoki however it may be the No.29
Disregard other horses as I was using a race I imported early this day but you will note all other imports are ok expect where I have used 29)

Image 2 is the place market with teh same result. Error with Sentoki.

Now I change the import data.
Image 3 Sentoki is ok. Now To My Eye has the error with 29 and 0.004

Image 4 same as above.

Image 5 was the imported data

I have used number up to 25 before with no apparent errors. When I have started using 29 things have gone wrong. There may be other numbers. Good luck. I hope you find it quickly. In the mean time I will use another number.