IBA Certifications - Updated Listing?

Rony6ble

Premier Member
#21
Short answer: No.

Longer answer: If you take a look at the list, you will see that it's a very big text file. The columns are not of a fixed width, the field separators are a combination of spaces and tabs, and it has a variety of notes embedded (i.e., listings of the smallest, oldest, youngest, etc.). The file is organized under headings, as opposed to having the ride listed on each line. All of these make it difficult, if not impossible, to automate entering it into a database, or at best, it could only be loaded in very small sections.

In short, the list will take a considerable amount of massaging before it could be loaded into a database. This is in addition to doing the database design, which is dependent on the use to which it would be placed. In this regard, the average user just wants to look up a name or two. Others would want to be able to answer a variety of questions, such as "how many riders from India have completed a Bun Burner 1500?", or "what is the oldest bike to complete a Bun Burner GOLD?".

This project would be non-trivial. I mention this because neither you nor Mike would want to initiate it, just to find out that it is beyond the capability or time constrains of the volunteer.

Ira Agins
Iron Butt Association
This is not that difficult but there may be some time involved. Easy part is copy and paste, open in spreadsheet, separate values, adjust columns and concatenate others, create organized fields.
Access is a great tool and newest versions are great for the web.
 

Ira

Staff member
Premier Member
IBA Member
IBR Finisher
IBR Staff
#22
This is not that difficult but there may be some time involved. Easy part is copy and paste, open in spreadsheet, separate values, adjust columns and concatenate others, create organized fields.
Access is a great tool and newest versions are great for the web.
I agree - it's not hard, just labor-intensive.

Ira Agins
Iron Butt Association
 

Super8mm

Premier Member
#23
It appears that to run a Access database on the web requires a web server running Share Point server.

if you want to have the database local and upload text files the up load would work like you do now but you would be able to output and series of text files with one button.
 

Rony6ble

Premier Member
#24
That is correct about the sharepoint but it would be way easier to obtain statistics from a database than from a simple list in the case admin is looking for something like this.
It takes the same effort to add data to a list than to a database but the potential of the DB is just not comparable.