Custom - Bear 100 Mile Race
This is a custom help file for the Bear 100 mile running race.

Login Directions
To get to the main login page for the data team, go to:
https://data0.adilas.biz/top_secret/index.cfm?corpKeyId=bear100

Login Reset Directions
If for some reason, you get locked out of the system (more than three failed login attempts), type the following address into your browser. Make sure that the reset address is entered on the computer that got locked out. After you type the address, make sure to submit the page by hitting your enter key.
https://data0.adilas.biz/top_secret/login_reset.cfm

Runner Portal - Public View Site
There is a runner's portal site that allows for basic live data tracking of the race. It is a small web page that pulls data directly from the main Adilas.biz website and backend database. The runner portal site is meant to be a spot where the runners, their crew members, and/or interested persons can virtually watch the race take place and unfold. The runner portal also has options to search by runner name, bib number, aid station, etc. The runners and/or family members may also post social type data such as comments, mini-blog, updates, photos, and images.

The web address for the runner portal is:
https://data0.adilas.biz/bear100/

Add A New Runner
If you need to add a new runner at the last minute, use these directions to do that. Most of the runners should already be imported into the system. For this process, I would recommend two browser windows. One for looking up the required format and the other for adding the new record.

First, in one of the browser windows, find a valid runner's record and go all the way into it until you see a button that says "edit main". Click that button. This will show you values that are stored for the runner. Key points are the title or caption. It needs to be something like: Bib[x] - Runner Name, where x is the bib number (no spaces between the word Bib and the actual bib number). An example might be Bib307 - John Smith. The other two important fields are the priority, set that to 1000 (one thousand), and then try to copy the general notes. By way of a note, the notes have some special HTML (web code) built in. You need all of it. Do a copy of the data to keep the format correct.

For the new record, use the other browser window. At the very top of the page, by the logo is a thing called the quick search. Select time from the drop-down and then type in the word "new" (without the quotes). Click Go. This will take you to a page to add the new runner. Fill in the title caption with the correct format (remember no space between the word Bib and the actual bib number). Set the priority to 1000 and then fill in the general notes section (paste what you have copied and then modify it). If anything is unknown, just put the value of unknown. Once satisfied, click the add button. The runner will now be in the system, just as if it was originally imported. As a reminder, you still need to start them just like normal (use the bulk start), but they should be good to go.

Tips And General Help For The Secure Site
Once you login, you will most likely land on a page called the Bear 100 - Radio Interface. This is a special dashboard page for the Ham Radio folks and data team that populate the data. The page is broken up into a number of different sections to help with race and data tasks.

The top portion has a number of special buttons including - manual single entry, manual bulk entry, manual single update, and a reset page button. The first couple manual buttons are special features built just for the Bear 100 race crew. They allow you to add and edit data in a quick and easy way. All three of the manual buttons go to the same page, just with a different look and what is available. That page has some general help options listed at the bottom. Very fast and easy tools, specific for the data team. The reset button just does a browser refresh, clears any notifications, and reshows the page. Nothing special.

The next portion is a CSV (comma separated values) file upload option. This is where the data team uploads the collected data from the different aid stations. The system is setup to help with the uploads and will convert the CSV data into live database transactions. If an error occurs, the data is dumped into a file called "Bad Runner Data". This main form is the live upload section.

As of race year 2023 we also added a link to go to a page called "test csv". This is a separate page that allows you to upload a CSV file as many times as you wish. No database actions are performed from this test page. It is setup to just do the parsing, filtering, and logic. When the test page is finished, it will dump the data, both good and bad for you to see. This is not required, but technically, you could run a CSV file in test to make sure that everything will pass and then run it live. Just an option. Once again, the test page allows for you to run any file as many times as you wish.

The next section is a quick search option for either bib number or a first/last name (runner) search. The results will show up on a different page.

The next block is a number of quick link buttons. These are thing such as: bulk start, full race, finish, DNS (did not start), bad runner data, DNF (did not finish), advanced search, stats, and export to CSV. Each of those pages has a special function and is a custom report that relates to the task at hand.

The bottom portion is a color coded list of all of the aid stations. Use the buttons provided to get data and information on the different aid stations. The results will show up on a different page.

If you need more options and/or want to visit other sections within the site, look for the chooser links in the header and footer. Those links will allow you to view 30+ other homepages and/or navigational dashboards.

The top header also has a thing called the quick search. Most of the data for the Bear 100 Race is held in what are called elements of time (events and scheduling). So, if you need to search for something in elements of time, you would select "Time" and then enter whatever search options you want. A couple of key words are: "home" (go to the time homepage) or "adv" (go to the advanced time search page). If you would like more key words and options, click here to see the help file for the Adilas quick search. Once again, checkout the section for elements of time.

Within the data, there are three main key words that help the system. They are DNF (did not finish), DNS (did not start), and "Manual Override". All of these key words are used in a section called sub dates and times (basically the records for the runners and their legs and aid station times). These key words, along with other notes, are held in the sub date and time notes fields.