ONLY ONE REPLY? Here are some suggestions; 1. Rearrange order of Items. NAME IS THE MOST IMPORTANT ITEM. 2. FULL NAMES unless unknown or if usually abbreviate. There are many Southern names, example "T.J." that are only just "T.J.") 3. All Dates in this format (day 2 numbers, Month 3 letters, Year 4 numbers). NO ERRORS. Yes, I know we are usually talking about mostly the 1800, BUT, some persons did in the 1900. 4. 24 - Location of prison (State) I would add the exact location, not just State. 01 - Last Name (FULL) 02 - First Name (abbreviate ONLY as necessary) 03 - Birth Date (dd/mmm/yyyy) 04 - Birth Place and STATE 05 - Parents 06 - Description of Person at time of muster 07 - Age at time of muster 08 - Enlistment place AND date (dd/mmm/yyyy) 09 - Service, CSA, CSN, CSN Marine, etc. 10 - Branch; Inf, Cav, H Arty, L Arty, etc. 11 - CSA or CSN unit; ex: 13 12 - State (+ description, as needed - ex: NC JR, SR, HG) 13 - Terms of enlistment-90d, war, CONscription 14 - Rank - at beginning of enlistment; Pvt. Cpl, Sgt, MSgt, 1 Lt, B Gen, etc 15 - SERVICE Wounded/Hospitalized 16 - SERVICE Killed/Died (from wounds or disease), Accidental death, Shot as deserter. 17 - SERVICE Cause of death 18 - SERVICE Prisoner (P) Deserter (D) 19 - SERVICE Location of POW Camp (if confined) 20 - SERVICE Location of POW Camp (State and location) 21 - Rank - at end of enlistment 22 - Pension # 23 - State pension issued 24 - Pension Beneficiary 25 - Death date (dd/mmm/yyyy) 26 - Cemetery - NAME and LOCATION 27 - Grave #; either assigned # or cemetery code 28 - Interment date (dd/mmm/yyyy) From here on up to you 29 - National Park Service - grave # 30 - AFN/ID number (do we want a # used by on-line GEDs and LDS #'s?) What are the most complete and most used? 31 - Reference(s) (BOOK TITLES, etc.) 32 - Notes --------------------- 33 - Military Record (database - IF INFORMATION IS not incl. on spreadsheets) I hope this will help, Richard Callard -----Original Message----- From: Derick S. Hartshorn [mailto:derickh@charter.net] Sent: Wednesday, July 16, 2003 6:14 PM To: CIVIL-WAR-L@rootsweb.com Subject: [CIVIL-WAR] Re: Univeral CSA database-time's a-wastin' You may have missed my last message or I may not have included you for a copy. If that's the case, I apologize. I am not going to make a major effort to convert currently archived data to a standard that may or may not be appropriate. Bear in mind, what I have put out there is my opinion only. < http://www.rootsweb.com/~nccatawb/database.htm > I'm not going to focus my energies on this project until I begin to hear from those who have the opportunity and the wherewithal to help make this concept a reality. If there is no support for a standard, I'm not going to tax my resources for something that nobody wants, believe me! I would be just as content to create one for my own personal use and that of my friends. I never expressed any desire to be a "team leader" nor did I espouse my own personal format as the ideal. I asked for suggestions and got one single reply. It was for the addition of 'rank at the end of enlistment' (which was implemented). Am I to believe that only one person chooses to discuss this project? Have I expressed too high an expectation for a tool that would make research sooo much easier? Perhaps some folks have never tried to reconcile the different Fredericksburg, Va accounts? Or determine the actual number of Catawba County NC Troops who died at Elmira, NY Prison. (13). I'm saying that 'time's a-wastin' because I know how things tend to get bogged down in committees. Dropped the ball? Maybe! . I got a 'bargain' upgrade to a 1.5ghz AMD Athelon. The thing crashes a half-dozen times a day. Sometimes the mail goes out, sometimes it comes in. I have more web pages to maintain than a sane person should ever volunteer for. Maybe I need to establish a discussion list, or maybe a guest book. Maybe I should buy a SQL server on my Social Security! Probably not. As far as dropping the ball, Al, I was passing it at the time. Since nobody caught it, I guess I did drop it. --Derick ----- Original Message ----- From: Al Dalton To: derickh@charter.net Cc: James Pierce Sent: Wednesday, July 16, 2003 5:19 PM Subject: Re: Univeral CSA database-time's a-wastin' Derick, You said, "Time's a-wastin'." That being the case, why have you seemingly dropped the ball? I'm just wondering. Thanks. Al ________________________________________________________ Sat, 5 Jul 2003 13:55:40 -0400 Derick, I have the resources. I need details of what you have in mind. I think a MySQL database with PHP would work. Do you know how to set that up? Al ----- Original Message ----- From: "Derick S. Hartshorn" <derickh@charter.net> To: "Al Dalton" <daltona@scv-vindicators.org> Sent: Saturday, July 05, 2003 1:20 PM Subject: Re: [SCV Dispatch] Univeral CSA database-time's a-wastin' > Hi Al, > > Thanks for the response. As unprepared as I am for this venture, I > really don't know what I need for server space or the best way to > organize the data > beyond this meager start. > > The best solution might be a search engine. Or it might be the display > of the raw data, I don't know. The page I have done on the three camps > is over > two meg so far and that's only 4,800 records. > > If you have the space to house this project and care to assist, that > will certainly make this effort more viable than it is now. > > Best wishes, > > Derick S. Hartshorn > CF Connor Camp #849 > > > > ----- Original Message ----- > From: "Al Dalton" <daltona@scv-vindicators.org> > To: <scvdispatch@confederacy.net> > Cc: <derickh@charter.net> > Sent: Saturday, July 05, 2003 1:05 PM > Subject: Re: [SCV Dispatch] Univeral CSA database-time's a-wastin' > > > > Derick, > > > > Contact me off list and provide details of your projected needs. I > > may be > > able to assist with this project. > > > > > > Al Dalton > > #828 > > Callands VA > > daltona@scv-vindicators.org http://www.phantacom.net/ ==== CIVIL-WAR Mailing List ==== To unsubscribe from list mode, email CIVIL-WAR-L-REQUEST@rootsweb.com and in the text area of the message, type only the word unsubscribe --- [This E-mail scanned for viruses by Surfside Internet] --- [This E-mail scanned for viruses by Surfside Internet]