Pages:
Actions
  • #1 by londolozi on 20 May 2013
  • I woke to find there was little action last night from my bots with these msgs.

    Checking condition: and  Trigger Expression cell_querymarket_id_P(sel_index*3+1) is equal to 2
    Condition is false.  "Gold Chain": (null); "Spicy Dal": (null); "Beep": (null); "Wilhana": (null); "Rubbamaa": (null); "Aragosta": (null); "Puligny": (null); "Rainbows And Roses": (null); "Simply Elegant": (null); "Little Alice": (null); "Pure Flight": (null); "Cherry Princess": (null); "Chiltern Secret": (null); "Princess Spirit": (null)

    Did anyone have similar to this?
  • #2 by Oxa (WellDoneSoft) on 21 May 2013
  • The Excel cell was empty, hence the (null).
  • #3 by londolozi on 21 May 2013
  • -----------------------------------------
    21/05/2013 03:11:12:   Market Horse Racing - Todays Card / 03:10 Wind 21 May has been refreshed.
    -----------------------------------------

    .........
    Checking condition: and  Trigger Expression cell_querymarket_id_P(sel_index*3+1) is equal to 2
    Condition is false.  "North Star Boy": 0; "Tajneed": 0; "Captain Kendall": 0; "Noverre To Go": 0; "Commanche": 0; "Amethyst Dawn": 0; "Beltaine": 0; "Kings n Dreams": 0; "Rocky Couloir": 0; "Bird Dog": 0

    Now at
    -----------------------------------------
    21/05/2013 03:15:00:   Market Horse Racing - Todays Card / 03:20 Leic 21 May has been refreshed.
    -----------------------------------------

    ...........Checking condition: and  Trigger Expression cell_querymarket_id_P(sel_index*3+1) is equal to 2
    Condition is false.  "Khobaraa": (null); "Pythagorean": (null); "Evangelist": (null); "Double Your Money": (null); "Dance With Dragons": (null); "Benoni": (null); "Roanne": (null); "Imperial Glance": (null); "Winnie Perry": (null); "Santo Prince": (null)
    Remaining conditions in the block will not be checked.

    When I checked things in the morning. The worksheet looked as normal.
    When a horse is not in the list it is reported zero as the first log report shows.

    I've never seen this 'null' before in 4 yrs of MFPro. Seems to be a one off but you are correct it is only MSExcel related.
  • #4 by Oxa (WellDoneSoft) on 22 May 2013
  • (null) is nothing, neither 0, nor any other string or integer value, it is different from a zero. I'm not sure what the contents of the sheet were, but it looks like they could not be imported into MF Pro in a digital format.

    If this reoccurs on a regular basis, please let me know and I'll look into it further, but will need a sample of the sheet you are using.
Pages:
Actions