Pages:
Actions
  • #1 by londolozi on 23 Nov 2013
  • 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.
     
  • #2 by mcbee on 23 Nov 2013
  • 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
  • #3 by londolozi on 23 Nov 2013
  • Thanks mcbee.
    Not a condition I have used much.
  • #4 by londolozi on 23 Nov 2013
  • But does that mean either the 4 conditions are OR the 2 conditions are met?
  • #5 by londolozi on 23 Nov 2013
  • Actually I think this is what I wanted
  • #6 by londolozi on 24 Nov 2013
  • The trigger image is in the previous msg.
    here is the Excel and trigger log images.
    Why won't this work?
  • #7 by mcbee on 24 Nov 2013
  • hi
    why are you showing sheet1, when the trigger is calling for sheet querymarket_id
    are they the same figures.


    mcbee
  • #8 by londolozi on 24 Nov 2013
  • 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.
  • #9 by londolozi on 24 Nov 2013
  • I tested another race and the same thing happened, see image?

    MFPro is not transferring to place market sheets correctly.
  • #10 by mcbee on 24 Nov 2013
  • hi
    can you add a screenshot or/and list of your excel formulas from mfp


    mcbee
  • #11 by londolozi on 24 Nov 2013
  • 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. 
  • #12 by mcbee on 24 Nov 2013
  • hi
    i have emailed support about this problem.

    mcbee
  • #13 by Oxa (WellDoneSoft) on 27 Nov 2013
  • 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?
  • #14 by londolozi on 28 Nov 2013
  • 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.
  • #15 by londolozi on 28 Nov 2013
  • 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.
     
     
Pages:
Actions