Importing Racers into GPRM from Excel (or CSV)?
- PWD_addict
- Master Pine Head
- Posts: 705
- Joined: Mon Jan 22, 2007 10:35 am
- Location: Middle River, Maryland
Importing Racers into GPRM from Excel (or CSV)?
Is there a way that racer and car names can be imported into GPRM from Excel or another program?
I haven't run GPRM before but I am in charge of our District Derby in the Fall (long story). I will be receiving the registration forms beforehand and would like to put them in a format that can be imported into GPRM on another leader's laptop. Is there a way to do this?
TIA,
Dave
I haven't run GPRM before but I am in charge of our District Derby in the Fall (long story). I will be receiving the registration forms beforehand and would like to put them in a format that can be imported into GPRM on another leader's laptop. Is there a way to do this?
TIA,
Dave
- gpraceman
- Site Admin
- Posts: 4926
- Joined: Fri Jun 20, 2003 12:46 am
- Location: Highlands Ranch, CO
- Contact:
Re: Importing Racers into GPRM from Excel (or CSV)?
Yes. You can save the file first as a CSV (comma separated vaules) file and then use the import button on the Registration section of the main screen to suck it into GPRM. The columns do need to be in the correct order. Info on the proper format is in the help file.PWD_addict wrote:Is there a way that racer and car names can be imported into GPRM from Excel or another program?
Randy Lisano
Romans 5:8
Awana Grand Prix and Pinewood Derby racing - Where a child, an adult and a small block of wood combine for a lot of fun and memories.
Romans 5:8
Awana Grand Prix and Pinewood Derby racing - Where a child, an adult and a small block of wood combine for a lot of fun and memories.
- PWD_addict
- Master Pine Head
- Posts: 705
- Joined: Mon Jan 22, 2007 10:35 am
- Location: Middle River, Maryland
Re: Importing Racers into GPRM from Excel (or CSV)?
Thanks Randy! I figured it would have to be the case. I downloaded the demo at home but didn't see a way to do it. But, I didn't have much time to play and was having too much fun with other features. I will practice on the demo version so that I can be ready for the real registrations.
Re: Importing Racers into GPRM from Excel (or CSV)?
There is a nice spreadsheet that is floating around out there with INSTRUCTIONS on how to fill it out even. I don't have mine on the web yet, but another group has one posted.
http://www.abunchofoldguysandatrack.com ... dsheet.xls
saving the scout data sheet as a CSV and importing it works slick, if I may say so myself!
The columns for the older version of GPRM that I use is slightly different than theirs. I use LastName, FirstName, Group, Rank, CarNumber, CarName, Passed as the column headings in row 1. The CarName and Passed columns are usually all empty which is fine.
The CSV can also be imported into MS-Access so that labels with the races name and rank can be preprinted from the data using Avery 18167 - 3/4" by 1 3/4" labels and the free software that they provide. The left over labels are then the ones that "Do Not Pass" the inspection.
Here are some sample labels for an upcoming Girl Scout race.
http://www.abunchofoldguysandatrack.com ... dsheet.xls
saving the scout data sheet as a CSV and importing it works slick, if I may say so myself!
The columns for the older version of GPRM that I use is slightly different than theirs. I use LastName, FirstName, Group, Rank, CarNumber, CarName, Passed as the column headings in row 1. The CarName and Passed columns are usually all empty which is fine.
The CSV can also be imported into MS-Access so that labels with the races name and rank can be preprinted from the data using Avery 18167 - 3/4" by 1 3/4" labels and the free software that they provide. The left over labels are then the ones that "Do Not Pass" the inspection.
Here are some sample labels for an upcoming Girl Scout race.
Mr. Slick says: Honey, I am doing this for the kids, not myself.
- Pinewood Daddy
- Pine Head Legend
- Posts: 1500
- Joined: Mon Feb 28, 2005 6:04 pm
- Location: Wallingford, Connecticut
Re: Importing Racers into GPRM from Excel (or CSV)?
We did it that way this year. Use the RaceRosterData.xls file in the DATA directory as a base. I used our Scout roster and renamed and reordered the columns.gpraceman wrote: Yes. You can save the file first as a CSV (comma separated vaules) file and then use the import button on the Registration section of the main screen to suck it into GPRM. The columns do need to be in the correct order. Info on the proper format is in the help file.
- gpraceman
- Site Admin
- Posts: 4926
- Joined: Fri Jun 20, 2003 12:46 am
- Location: Highlands Ranch, CO
- Contact:
Re: Importing Racers into GPRM from Excel (or CSV)?
There I go forgetting I had started including that file. Thanks for pointing that out!Pinewood Daddy wrote:We did it that way this year. Use the RaceRosterData.xls file in the DATA directory as a base. I used our Scout roster and renamed and reordered the columns.
Randy Lisano
Romans 5:8
Awana Grand Prix and Pinewood Derby racing - Where a child, an adult and a small block of wood combine for a lot of fun and memories.
Romans 5:8
Awana Grand Prix and Pinewood Derby racing - Where a child, an adult and a small block of wood combine for a lot of fun and memories.
- Pinewood Daddy
- Pine Head Legend
- Posts: 1500
- Joined: Mon Feb 28, 2005 6:04 pm
- Location: Wallingford, Connecticut
Re: Importing Racers into GPRM from Excel (or CSV)?
Thank you for helping me when I had questions about GPRM.gpraceman wrote:There I go forgetting I had started including that file. Thanks for pointing that out!Pinewood Daddy wrote:We did it that way this year. Use the RaceRosterData.xls file in the DATA directory as a base. I used our Scout roster and renamed and reordered the columns.
- BigDozer66
- Master Pine Head
- Posts: 131
- Joined: Mon Mar 27, 2006 2:26 pm
- Location: Lufkin, Texas USA
Re: Importing Racers into GPRM from Excel (or CSV)?
I don't see that file listed in my data file?
I have one labeled for AWANA GP racing.
I have some other questions but I will start my own thread.
Lynn
I have one labeled for AWANA GP racing.
I have some other questions but I will start my own thread.
Lynn
"one Nation under God, indivisible, with liberty and justice for all."
Cubmaster and AWANA Game Director
Cubmaster and AWANA Game Director
- gpraceman
- Site Admin
- Posts: 4926
- Joined: Fri Jun 20, 2003 12:46 am
- Location: Highlands Ranch, CO
- Contact:
Re: Importing Racers into GPRM from Excel (or CSV)?
It is in the Data directory for GPRM (C:\Program Files\Lisano Enterprises\GrandPrix6\Data).BigDozer66 wrote:I don't see that file listed in my data file?
Randy Lisano
Romans 5:8
Awana Grand Prix and Pinewood Derby racing - Where a child, an adult and a small block of wood combine for a lot of fun and memories.
Romans 5:8
Awana Grand Prix and Pinewood Derby racing - Where a child, an adult and a small block of wood combine for a lot of fun and memories.