| Newhavensoft forum »Newhavensoft.net forums » Odds Wizard » importing data |
| 1. riccja - 07 November, 2007 - 05:21:52 |
| I am importing data from excel but the program is not picking up the schedule of unplayed games. It picks up the games played and the scores. Is there a different procedure for importing games to be played? I leave the scores blank on the spreadsheet. thanks Rick |
| 2. Alex - 07 November, 2007 - 05:39:44 |
| When importing data from Excel file, make sure that the Date field of a spreadsheet contains the date in the 'date' format, not just text. Successfully imported fixtures are visible in Games -> Show all fixtures. To get them visible in the games table, choose Fixtures -> Show new fixtures. To get ALL fixtures visible in the games table, set an option 'Show new fixtures, rounds' to some value greater than the number of expected rounds, and then choose Fixtures -> Show new fixtures. |
| 3. riccja - 07 November, 2007 - 06:48:38 |
| Alex, It is in the date format. When I add todays games with no score. The games do not show up. Show all fixtures is not highlighted so cannot select that. And when I select all games the new games dosnt show up either. If I add them in manually then no problem. If I put 0 for the score of todays games they show up. Then when I erase the 0. then do a save as and update they dont show up. And also the show all fixutres is not available. Any other ideas thanks Rick (Added) I figured it out....for unplayed games score has to be put in as -1 |