

strarray = [
"101005354,Robin,Macagni",
"102006013,Martha,Carle",
"104007643,Shirley,Powell",
"105000754,Lisa,Smithee",
"105003809,Paul,Woods",
"108001365,Oscar,DeLong",
"109004464,Shirley,Yaw",
"110004936,Shannon,Avra",
"112009045,Cheryl,Chapman",
"113007767,Abigail,Perrine",
"114001209,Barry,McVinney",
"117002251,Alex,Chalupka",
"119003725,Sharrone,Cox",
"119007354,Julia,Ramey",
"121006792,Jesse,Poff",
"121007865,Ben,Rains",
"122008412,Casson,Brock",
"123001234,Jane,Doe",
"126004481,Tamisha,Doublin",
"127004109,Chris,Paradis",
"129007389,Carla  J.,Moody",
"133007962,Nicolette,Smith",
"133007995,David,Durr",
"135002802,Neil,Mitchell",
"135008665,Leslie,Lovenstein",
"136000170,Sherry,Bowman",
"136004717,Caroline,Elmore",
"137006175,Natalie,Rollins",
"139007397,Paul,Bennett",
"143005563,Larhonda,Jackson",
"144006035,Patricia,Martinez",
"143008980,Clayton,Ruff",
"149003360,Lynn,Strong",
"149003684,Larry,Taylor",
"151003894,Martha,Kubin",
"151006519,Dennis,Welch",
"152004114,Rebecca,Nelson",
"152008238,Cheryl,Reinhart",
"153000665,Dioneedra,Irvin",
"154000886,Jeffrey,Walker",
"156008167,Cynthia,Randolph",
"156008453,Elizabeth,Clyburn",
"159006869,Leslie,Cloer",
"160007624,Osmonetta,McRae",
"160005617,George T.,Davis ",
"160009826,Joanna,Ewing",
"161005514,Cheri,Courtright",
"162002971,Jayson,Malik",
"162003773,Roy,Minton",
"165001026,Mischel,Elliott",
"166001702,Randall,Robertson",
"166002708,Alan,Pogue",
"167005242,Terence,Cox",
"169004248,Starlett,Mack",
"171006446,Nykela,Jackson",
"173002226,Tiffany,Smith",
"179000476,Ernesto,Velazquez",
"180006454,Kenneth,Lipsmeyer",
"184001853,Kelley,Cowley",
"184007212,William,Wyngaard",
"185004988,Shelley,Oberste-Hanson",
"187005687,Logan,Oliver",
"189008266,Don,Kuonen",
"190003477,Lindsay,Ratliff-Kullenberg",
"190008645,Michael,Milligan",
"190008938,Jimmy,Brooks",
"194003650,Emily,Norman",
"196004149,Mary,Olm",
"196008422,Laura,Govia",
"198009979,Amy,Baldwin",
"199001576,Jonathan,Purkiss",
"205004420,Francine,Leon",
"206006464,Karin,HodginJones",
"208006810,Nancy,Reedy",
"209002691,Deana,Nall",
"210003589,Elivia,Wafford",
"210006647,Constance,Meadors",
"211002028,Karren,Lee",
"212009158,Shirley,Kelley",
"213009954,James,Becker",
"214008372,Ruth,Reavis",
"215003842,Shannon,Vaughn",
"216007542,Christopher,Phillips",
"217001351,Julianne,Nelson",
"218004419,George,Lauster",
"219004498,Jeanne E.,Williams",
"220004314,Dale,Harris",
"220007929,Marcus,Montgomery",
"221003501,Bill,Peery",
"221007264,Carlton,Coleman",
"223004965,Lydia,Hart",
"223005584,Heather,Solano",
"226005530,Sabrina,Waters",
"226005815,Paula,Long",
"226009531,Laura,Iverson",
"229007082,Joan,Dudley",
"231006655,Brenda,Bradley",
"233005717,Mary,Bishop",
"235000382,Dianne,McKinney",
"235000427,Maribeth,Anders",
"235003770,K. Aurora,Adney",
"236001904,Scott,Warrior",
"237000874,Sarah,Clements",
"240006061,Michelle,Harris",
"241001300,Chad,Smith",
"241002377,Mike,Dahly",
"242007840,Christal,GravettCarrington",
"244008285,Dorothy,Martin",
"245006568,Ruth,Goff",
"246005158,Howard,Nesmith",
"248004109,Yolanda,Mitchell",
"248008859,Tarlease,Jones",
"249003878,William (Jay),Adkins",
"249003980,Cynthia,Fehrenbach",
"249008291,Mary Kate, Terrell",
"250008690,Laura,Goadrich",
"252008069,Terry,Brown",
"255001700,Meenakshi,Budhraja",
"255002080,Mike,McMillan",
"255009824,Paula,Morell",
"256006000,Shannon,Wilcox",
"258008355,Jason,Bass",
"261009750,Michael,Loya",
"267003845,Pat,Pierce",
"269008542,Don,Gundolf",
"275004097,Robert,Moritz",
"275005308,Robert,Habimana",
"277006400,Deborah,Desjardin",
"277007345,Vondra,Armstrong",
"278008077,Renee,Bennett",
"279004746,Amanda,Bishop",
"280007461,Matthew,Chase",
"284009395,Gary,Winkler",
"285000374,Ginny,Wood",
"285009052,Jesse,Gatewood",
"285009142,Staci,Hufhines-McHenry",
"286003791,John,Morgan",
"287006833,David,Carpenter",
"288001433,Rebecca,Hobby",
"289006774,Jason, Choate",
"291002387,Tammy,Richardson",
"291006232,Beata,Lovelace",
"293005978,Susan,Dollar",
"296009718,Angela,Langston",
"303004394,Kathryn,Young",
"308007100,Joe,Jansen",
"311000390,Debra,Mcindoe",
"311004765,Doris,Pierce",
"312007629,H. Oscar,Hirby",
"312007700,Sofia,Gonzalez",
"314005149,Valerie,Duckery",
"315004204,Derek,Moore",
"318003799,Richard,Moss",
"319003169,Robert,Clark",
"320009364,Valerie,JohnsonFranks",
"322007946,James,Johnson",
"324007905,Tammy,Whitfield",
"325002233,Jolie,Mosley",
"326003387,Billy,Parchman",
"327001267,Charles,Cole",
"328001189,Brad,Pierce",
"328004744,Meredith,Lemons",
"328008338,Robert  D.,Coates",
"329002288,Susan,Gernenz-Taylor",
"329005414,Roni,Bowman",
"330006482,Michael,Slater",
"333001803,Wendy,Davis",
"336001719,Bob,Glidewell",
"336005034,Daniel,Egbe",
"336008868,Carl Mike,Daily",
"338008316,Timothy,Bennett",
"338009780,Pam,Cicirello",
"340009216,Nicole,Holcomb",
"341009085,Christin,Hankins",
"341009489,John,Farrell",
"342009376,Lindsey,Maestri",
"347007208,William,Strigel",
"348002404,Jennifer,Boccarossa",
"350009538,Cynthia ,East-Malik",
"351005486,Jacqueline,Griffin",
"352002877,Casey,Griffith",
"352009058,Macaiah,Tillman",
"353001581,Olivia,Powers",
"353003365,Julia,Crow",
"361000978,Neil,Furqueron",
"363006805,Ron,Skidgel",
"365009380,Benjamin,Pecock",
"367009719,Lori,Jones",
"369004470,Darrellyn,Williams",
"371006397,Benjamin,AndersonBauer",
"373005417,Andre,Robinson",
"374004521,Wayne,Floyd",
"378003215,James,Layton",
"378008796,Sandra,Harrington",
"379003381,Cynthia,Beck",
"379006754,Moluwa,Matute",
"380003734,Jeffrey,Skrdlant",
"381001431,Deborah,Germany",
"381002349,Alex,Carraway",
"382002650,Barbara,Williams",
"382009527,Jennifer,Ingram",
"385006827,Jordan,Oroark",
"385007501,Veronica,Stewart",
"386009607,Matthew,McKay",
"387002090,Ebony,Conley",
"388001873,Deena,Martin",
"389002852,Karen,Tate",
"391009899,Gloria,Maddox-Powell",
"395001150,Norma (Jean),Vowell",
"397003066,Jessica,Walker",
"397004212,Erika,Martin",
"398001340,Sherry,Clay",
"401004897,Christina,Oberste",
"401007671,Meredith,McMillan",
"403001456,Meghan,MacKrell",
"404006456,Sherlyn,Harris",
"405000455,Danny,Martin",
"405003210,Phyllis,Felton",
"406003356,Stephen,Mackey",
"406003404,Colby,Gunter",
"409003500,Mohamad,Nawaz",
"411007029,Kimberly,Gilbert",
"411007687,Elizabeth,Sims",
"411009566,Jennifer,Aunspaugh",
"412002873,Jason,Walker",
"414004966,Anne,Virden",
"414008210,Candace,Pierce",
"415001155,Alisa,Williams",
"416007347,M. Paige,Redd",
"417002792,Kellye,Mashburn",
"418007123,Sheila,Glasscock",
"418008254,Stephen,Paul",
"420007231,Stacy,Fortney",
"423005923,Jacqueline,Wright",
"425003026,Casey,Rockwell",
"427001556,Sandy,Longhorn",
"428002605,James,Pasley",
"428003640,A. Elizabeth,Reves",
"428006908,Jana,Porter",
"429007391,Aaron,Baldwin",
"429009489,Janine,Tiner",
"430006194,Austin,Lovenstein",
"431004487,J. Michelle,Palmer",
"432007801,Geoff,Thiers",
"433000355,Mandie,Smith",
"434004080,Letrishe,Hence",
"437004924,Werner,Trieschmann",
"437007434,Jason,Jewell",
"441008120,Gloria,Reyes",
"441008889,Robert,Best",
"443005497,Harold,Daigle",
"444004137,Tracie,Rushing",
"447003876,Aubrey,Pangle",
"449008400,David,Warren",
"449009347,Paula,Watson",
"451006015,Terry,Allmon",
"452003910,Jennifer,Martslolf",
"452007483,Susanne,Ashby",
"455001221,Natalie,Molineaux",
"458002441,Dana,Curry",
"459003626,Ashley,Embry",
"459003875,Devin,McKnight",
"459008292,Amanda,Armstrong",
"459008700,Dalana,Nugent",
"460002978,Allen,Loibner",
"461003088,Michael,Hostetler",
"465003535,Donna Jean,Rausch",
"466006426,Michele Alice,French",
"467003413,Sonya,Russ",
"471004513,Gary,Gaines",
"474003797,Rick,Babic",
"481009263,Sarah,Nixon",
"482000879,John,Galbraith",
"482003917,Jessica,Scharbor",
"483007242,Jason,Hancock",
"484008428,Kristen,Holloway",
"485004685,Jason K.,Green",
"485007588,Jasmine,Williams",
"486004916,Laura,Campbell",
"487001905,Ashia,Muhammad",
"489001986,Amie,Csege",
"492004991,William,Stoval",
"497007673,Susan,Williamson",
"498006833,Kenneth (Kent),Douglas",
"501009803,Kathryn,Evans",
"505008055,Angela,Peace",
"508005076,Trude,Puckett",
"509003889,Mayo,Johnson",
"512007290,Terry,Mercing",
"516002301,Stephanie,Williams",
"518006218,Alisa,Brown",
"519009007,Beverly,Smith",
"520003466,Mindy,Hodges",
"521007106,Teri,Cox",
"522001344,Jimmy,Davis",
"523000700,Samantha,White",
"525000115,Bonnie,Faupel",
"529006429,Beth,Miller",
"529008311,Zachary,Perrine",
"531002765,Melissa,Douglas",
"531007939,Phillip,Harris",
"535009547,Cheryl,Moody",
"539006314,Julie,Wright-Locke",
"541002650,Kimberly,Kwee",
"541003679,Carmen,Scanlon",
"541006430,Samuel,Gregory",
"544000692,Jerry,Armstrong",
"548006156,Lara,Crane",
"549006674,Samantha,Staggs",
"549006859,Ashlyn,Dugan",
"554000538,Tracy,Pennington",
"554007486,Annie  D.,Robinson",
"554008661,Nicole,Smith",
"555009273,Thomas,Price",
"558003626,Tommy,Bennett",
"561007513,DeAnna,Davis",
"562001405,Laura,Austin",
"564006220,Marilyn,Harris",
"569003891,Primo,Voisin",
"569008954,Kristin,Wagner",
"570007673,Karen,Shaw",
"574008779,James,Mcafee",
"577005139,Heather,Barnett",
"577006173,Weeda,Jones",
"577007513,Amanda,Linn",
"578006417,Melisa,Quesenberry",
"578008384,Shannon,Clowney",
"579000371,Rebecca,Stone",
"579008433,Jennifer,Gilley",
"581005203,Joe,McAfee",
"584002107,Jennifer,Kilmore",
"584007572,Rachael,Rice",
"588009451,Madhu,Reniguntala",
"592006311,Faysal,Ahmed",
"596000194,David,Cullipher",
"597007455,Jacob,Standley",
"602000956,Neal,Farris",
"602001620,Ian,Thomas",
"606001567,Anna,Mitchell",
"608004323,Don,Spitler",
"608008354,Angie,Macri",
"610001420,Paul,Wiltz",
"610001674,Josh,Weaver",
"610009236,Amanda,Doyle",
"611001587,Kevin,Baer",
"613004012,Heather,Murski",
"614007511,William,Roark",
"615001683,Sandra,Kirkpatrick",
"615002567,Deborah,Huber",
"616009117,J. Allan,Holloway",
"617009030,Patricia,Covington",
"618002384,Todd,Gold",
"620003509,Lisa,Fisher",
"620006903,Nicki,Feldman",
"621009962,Stephanie,Pierce",
"622000365,Terry,Ballard",
"623002742,Ralph,Schultz",
"623008819,Daryl,Swinson",
"629005445,Matt,Bradke",
"631002998,Erin,Dail",
"631006916,Raymond,Williams",
"632000313,Amber,Strain",
"632004627,Patricia M.,Reid",
"632004943,Holly,Bass",
"635001325,Sarah,Johnson",
"635002560,William,Byrd",
"637006811,Aiwei,Borengasser",
"638002974,Barbara ,Wilborn",
"639006732,Teresa,Upshaw Wallent",
"640004314,Chelsey,Moore",
"641001578,Janet,Bayless",
"642001802,Constance,Hurd",
"644008794,Michael,Julian",
"645001124,Johnnie,Green",
"645002774,John,Price",
"646001139,Terry,Johnson",
"646003951,Terrill,Beckerman",
"647009109,Carolyn,Jennings",
"648005455,Floyd,Ross",
"649003446,L. Crecy,Ragan",
"650006754,Mark,Barnes",
"651008784,Jonathan,Childs",
"652008431,Joanna,Newkirk",
"652008438,LaShundra,Watson",
"655004158,Jamie,Ables",
"656009435,Darin,Archer",
"659005162,Cynthia,Fletcher",
"664001468,M. Katie,Davis",
"665007163,Debbie,Schlesinger",
"669000216,Amy,Ballard",
"669002045,DeAndre,Smith",
"669005078,Nick,Reeves",
"672008103,Tasha,Ward-Henderson",
"673001613,Jesse,Holcomb",
"675005518,Jeseph,Elliott",
"676004245,Cindy,Beckett",
"679007700,Jessica,Otto",
"680001492,Jessica,Sahene",
"680007336,Martha,Eschleman",
"682002850,Joe,Schneider",
"682007464,John E.,Marshall",
"683009509,Rebecca,Sterling",
"685004891,Bonnie,Kenney",
"686005687,Cynthia,Beckett",
"689001967,Kirsten,Heintz",
"690006195,Monty,Self",
"696003148,Jennifer,Stewart",
"698003578,Edward,Hale",
"703006801,Sherrie,Ray-Trevino",
"704006973,Carol,Parker",
"705001866,Janine,Armstrong",
"705003835,William,Lindsey",
"707001321,Melissa,Potter",
"708004088,Margery,Wage",
"709008772,Joseph,John",
"709009906,Siobhan,Bartley",
"714004486,Thomas,Russell",
"714006004,Robert,Dixon",
"718005154,Kay,Shuttleworth",
"718009713,Jennifer,Knetig",
"719002104,Dieterick,Govan",
"720004027,Ashley,Wyatt",
"721006513,Keith,Hearnsberger",
"721006981,Sonjia,Michaels",
"722004904,Rebecca,Chism",
"723000846,Keiona,Middleton",
"723006559,Joey,Cole",
"724002800,Mary,Walla",
"724005283,Cathy,Underwood",
"728002370,Marilyn,Barlow",
"729001373,Tom,Hunt",
"729002034,Robert,Rands",
"729007370,Rhonda,Carroll",
"729007801,Courtney,Dycus",
"730002635,Jamie,Ryan",
"732006443,Tatiana,Ryckman",
"732009017,George,Balogh",
"733001383,Linda,Ducrot",
"735007044,Earl,Davis",
"736003203,Alandrea,Kilpatrick",
"736006138,Adrian,Correa",
"737000653,James,Vinson",
"738004251,Brenda,Aycock",
"738005234,Anissa,Ford",
"739000581,Craig,Jones",
"740001267,Miriam,Karanja",
"741004797,Shelley,Farmer ",
"742000627,Regena,Bishop",
"742008883,Tammie,Deaton",
"743000886,Gabrielle,Haulmark",
"743002901,Lisa,Lamoureux",
"744007723,Tachelle,Nettles",
"745008024,Mike,Pridmore",
"746006808,Jean,Swillum",
"747009097,Jay,Sprigg",
"748004893,George,Simonof",
"748005457,Gregory,Heintz",
"748000839,Dustin,Johnson",
"749002201,Daniel,Hoskins",
"750003862,Lisa,TwillieWoodruff",
"750004487,Rhonda,Troillett",
"751002538,Helen,Snyder",
"755008775,Lacee,Werdehausen",
"756004452,Matthew,Franks",
"757008237,Theresa,Allred",
"761003395,Stella,Bowers",
"762005847,Brannon,Runions",
"766002715,Suzanne,Reed",
"766004952,Jaafar,Alazzawi",
"767003155,Doug,Ford",
"768007135,Tyrrell,Schneider",
"771006452,Terry,Hunkapiller",
"773000377,Allan,Lemmon",
"773007057,Stephanie,Sheppard",
"774002757,Traci,Johnston",
"774004561,Sarah,Buford",
"778000844,Denise,Hammett",
"779002781,Denies,Matlock",
"781002203,Calvin,White",
"782003804,Eugene,Rathfon",
"785005475,Amanda,Willey  ",
"788005486,James,Hunt",
"791004703,Greg,Drzazgowski",
"791007446,Karen,Trevino",
"794004927,Kami,Wentz",
"794007468,Julia,Gibbins",
"795009119,Robert,Musser",
"796000965,Michelle,Herrera",
"796008056,Caron,Bowen",
"799008766,Anna ,Ortiz",
"801001151,Karen,Jensen",
"801002557,Mike,Leach",
"801008278,Deborah,Ahring",
"803003934,Jeffrey,Fischer",
"803007613,Phillipe,Ducrot",
"805003823,Jomeka,Mosby",
"808005565,J Robyn,Spence",
"814007697,Bernica,Tackett",
"816005499,Lekita,Pounds",
"823000277,Brian,Hight",
"824006033,James (Jim),Pearson",
"825000977,Jayne,Pyle",
"825002201,Andy,Turner",
"826003461,Leslie,Omalley",
"827006565,Melody,Berning",
"828000334,Anna,Tanner",
"828006010,Sherelle,Lee",
"830003066,Jim,Porter",
"831009198,Bruce,Schulte",
"833005405,Renee,Smith",
"836005496,Mrghan,Cantlon",
"837006898,Stephanie,Phillips",
"838006634,Jason,Martin",
"841007550,Berna,Love",
"842005659,Jack,Wood",
"843000928,Jeff,Dixon",
"845003182,Joe,Guy",
"847002004,J. Don,Keller",
"847008000,Jessica,Martin",
"847008922,Tressa,Ashberry",
"848003937,Michael,Mills",
"848004726,Michael,Harris",
"851003569,Antonia,Garcia",
"853007221,LaTasha,Ursery",
"855000744,Anna,Pagan",
"855009316,Suzanne,Campbell",
"856005483,Rachel,Miller",
"857001431,Debbie,Scharbor",
"857005924,Steven,Eisenberg",
"858004108,William,Ginocchio",
"859005632,Frank,Opitz",
"859009670,Joshua,Johnson",
"860006751,Christie,Sherrill",
"865006358,Dora,Bradley",
"865007913,Frank,Latimer",
"866001643,Vince,Gemmiti",
"866007131,Jerri,Shertzer",
"866009908,Martha (MJ),Bennett",
"868005387,Kristi,Tucker",
"870008382,Steven Bryan,Frazer",
"872003371,Angel,Dorsey",
"874002175,Alicia,Boatwright",
"878009119,Stacey,Boone",
"882005622,Betty,Raper",
"883008368,S. Whittington,Brown",
"884009456,April,Hearne",
"889004556,Jasmine,Greer",
"892005536,Chris,Weaver",
"893001094,Shana,Wilson",
"893005947,Amy,Garst",
"893006539,Deborly,Wade",
"894006935,Carol,Gale",
"896002180,Reba,Treece",
"899001692,Jesse,Hall",
"899006421,Jan,Lewandowski"
]

#print strarray
i = 1
for line in strarray:
    id, first, last = line.split(',')
    #print str(i) + " " + first + " " + last + " - " + id
    i += 1

    #print 'DB::table(\'users\')->insert([\n\
    #            \'name\' => \'' + first + " " + last + '\',\n\
    #            \'email\' => \'' + first[0].lower() + last.lower() + '@uaptc.edu\',\n\
    #            \'password\' => bcrypt(\'Letmein123\'),\n\
    #            \'isAdmin\' => 0,\n\
    #            \'personal_id\' => \'' + id  + '\',\n\
    #        ]);'
    print 'DB::table(\'training_registrations\')->insert([\n\
                      \'name\' => \'' + first + " " + last + '\',\n\
                      \'email\' => \'' + first[0].lower() + last.lower() + '@uaptc.edu\',\n\
                      \'personal_id\' => \'' + id  + '\',\n\
                      \'courses_taught\' => \'N/A\',\n\
                      \'course_type\' => \'basic\',\n\
                      \'training_session_id\' => \'1\',\n\
                      \'attended_first\' => \'1\',\n\
                      \'attended_second\' => \'1\',\n\
                      \'completed_certification\' => \'1\',\n\
                      \'registered_user_id\' => DB::table(\'users\')->where(\'personal_id\', \'=\', \'' + id +   '\')->get()->first()->id,\n\
                  ]);'
