Skip to content

z. Rock Solid Demo Church Specification (sample data)

Jump to bottom Edit New page
Nick Airdo edited this page Aug 3, 2019 · 26 revisions

These are the specifications for the Rock Solid demo church and sample data we're planning that people can use when explaining or building tutorials. This is Rock's "Northwind" type sample data: /Documentation/sampledata.xml

SampleData Block

⚠️ NOTE: Due to the current nature of the SampleData block, it is NOT recommended that you try to import more than 400 families at a time.

The SampleData block attempts to DELETE all data associated with the given families, members, etc. It does this so that you can run the import tool multiple times using the same family data. However, it is possible to create related records while using the imported sample data which can't be removed by this tool. In those cases your easiest option is to create a fresh database and start over.

Families

The initial set of names of are below. The 250 remaining names can be initially randomly generated (like we do in the Populate_Plethora_of_Person_wRandomNames.sql script) but once generated it must become a static list of known names.

  • Decker Family - address: 11624 N 31st Dr, Phoenix, AZ 85029

    • Theodore (Ted) - age: 38, phone: 623-555-3322, baptism date: 9/13/2001, first visit: 12/15/2012
    • Cindy - age: 37
    • Noah - age: 10
    • Alexis (Alex) - age: 7

  • Marble family - address: 3002 W Lupine Ave, Phoenix, AZ 85029 33° 35.478', -112° 7.419'

    • William (Bill) - age: 50
    • Alisha - age: 48

  • Foster family - address: 1543 W Joan de Arc Ave, Phoenix, AZ 85029 (33.6075439, -112.0931931)

    • Peter (Pete) - age: 50
    • Adelle (Pamela) - age: 50

  • Michaels family - address: 3139 W Bloomfield Rd, Phoenix, AZ 85029 (33.598404, -112.12709)

  • Smith family - address: 3935 E Rough Rider Rd, Phoenix, AZ 85050 (33.6878242, -111.9908905)

  • McClintock family - address: 3944 E Cat Balue Dr, Phoenix, AZ 85050, (33.685314, -111.991045)

Jennifer Michael notes: She's been coming for 4 yrs. Jenny is not on staff, but she helps coordinate the Annual Car Show so that’s why she has the email address.

Security Groups

  • Alisha Marble (login: amarble)

    • Administrators
    • Prayer Admin
    • Prayer Team
    • Finance Admin
    • Staff User
    • Website Content Editor

  • Ted Decker (login: tdecker)

    • Pastoral Staff
    • Communication Admin
    • Prayer Team
    • Staff User
    • Website Administrator

  • Cindy Decker (she volunteers; login: cdecker )

    • Prayer Team
    • Staff-Like User
    • Website Content Editor
    • Finance User (she helps count)

  • Peter Foster (login: pfoster)

    • Prayer Team
    • Staff User
    • Pastoral Staff

  • Adelle Foster (peter’s wife; login: afoster)

    • Prayer Team
    • Staff-Like User

  • Jenny Michaels

    • Staff-Like User

Other photos can be used legally from http://uifaces.com/authorized. You’ll have to dig pretty deep to get good ones though.

Blended Families

Families should pattern blended situations with a couple of kids in both families. Try to pattern some of the odd cases as I’m sure they will become known use cases to test with.

Should be linked to both the Jones Family and Simmons family to model one type of blended family. Brian has a relationship of “Step-Child” to Jim (and reverse relationship of “Step Parent” back from Jim to Brian)

Madison is only in a family with Mariah but has the relationship of “Allow check-in by” to Craig (with reverse relationship back).

TODO: one of these families should be "new" and one (or more) of these families should be no-longer-attending due to family moving, misc-dropp-off, etc. (and their attendance data should reflect this too).

Duplicates

Some records will need to be duplicates too in order to illustrate and show how merging works in Rock.

  • Tom Miller and Thomas Miller
    • different address:
      • 11827 N 33rd Circle, Phoenix, AZ 85029 (33.5943947, -112.1305923)
      • 2302 E Curnow Dr, Phoenix, AZ 85016 (33.4840026, -112.0321966)
    • same emails: [email protected]
    • birthdate: Tom has birthdate: 4/1/1979 Thomas has none
    • connectionStatus: Tom is "member" Thomas is "web prospect"

Phone Numbers

These can be initially randomly generated using (480)|(602)|(623) 555 - #### (excluding those listed below and 623-555-2444 since this is the demo church phone number).

  • Rock Solid Church: 623-555-2444

Addresses

  • Rock Solid Church: 3120 W Cholla St, Phoenix, AZ 85029 (the school CCV first started in).

Alisha & Bill Marble's local Bible study group member addresses:

  • Jack Harper: 11609 N 31st Ln, Phoenix, AZ 85029 33° 35.544', -112° 7.617'
  • William Jones: 3029 W Lupine Ave, Phoenix, AZ 85029 33° 35.461', -112° 7.483'
  • Dale Tucker: 3009 W Lupine Ave, Phoenix, AZ 85029 33° 35.458', -112° 7.432'
  • Brian & Becky Peterson: 3028 W Lupine Ave, Phoenix, AZ 85029 33° 35.478', -112° 7.479'
  • James & Nancy Sweeney: 11428 N 30th Ave, Phoenix, AZ 85029 33° 35.426', -112° 7.423'
  • Robert & Sheryl Tennant: 11462 N 30th Ln, Phoenix, AZ 85029 33° 35.486', -112° 7.503'
  • Jenny Michaels:

Below are 250+ more random addresses from around the demo church address.

257 Random Addresses Near Demo Church

  • Jones Family: 10601 N 32nd Dr, Phoenix, AZ 85029 (33.5822525, -112.1283722)
  • Frank Dexter Family (http://uifaces.com/trek): 10623 N 18th Dr, Phoenix, AZ 85029 (33.5829163, -112.0983353)
  • 10638 N 16th Ave, Phoenix, AZ 85029 (33.5835953, -112.09478)
  • 10806 N 33rd Ave, Phoenix, AZ 85029 (33.5844955, -112.1309509)
  • 10822 N 17th Dr, Phoenix, AZ 85029 (33.5841959, -112.0966105)
  • Simmons Family: 10828 N Biltmore Dr, Phoenix, AZ 85029 (33.5855064, -112.1186981)
  • 10828 N Biltmore Dr, Phoenix, AZ 85029 (33.5855064, -112.1186981)
  • 10828 N Biltmore Dr, Phoenix, AZ 85029 (33.5855064, -112.1186981)
  • 10828 N Biltmore Dr, Phoenix, AZ 85029 (33.5855064, -112.1186981)
  • 11012 N 34th Ave, Phoenix, AZ 85029 (33.5861397, -112.132782)
  • 11016 N 28th Ave, Phoenix, AZ 85029 (33.5856743, -112.1217728)
  • 11022 N 35th Dr, Phoenix, AZ 85029 (33.58622, -112.135094)
  • 11026 N 28th Dr, Phoenix, AZ 85029 (33.5881844, -112.121933)
  • 11026 N 28th Dr, Phoenix, AZ 85029 (33.5881844, -112.121933)
  • 11026 N 28th Dr, Phoenix, AZ 85029 (33.5881844, -112.121933)
  • 11026 N 28th Dr, Phoenix, AZ 85029 (33.5881844, -112.121933)
  • 11038 N 28th Dr, Phoenix, AZ 85029 (33.5895233, -112.1217804)
  • 11038 N 28th Dr, Phoenix, AZ 85029 (33.5895233, -112.1217804)
  • 11042 N 28th Dr, Phoenix, AZ 85029 (33.5906067, -112.12043)
  • 11044 N 28th Dr, Phoenix, AZ 85029 (33.590199, -112.120049)
  • 11048 N 28th Dr, Phoenix, AZ 85029 (33.5899353, -112.1206055)
  • 11048 N 28th Dr, Phoenix, AZ 85029 (33.5899353, -112.1206055)
  • 11048 N 28th Dr, Phoenix, AZ 85029 (33.5899353, -112.1206055)
  • 11443 N 25th Ave, Phoenix, AZ 85029 (33.5907784, -112.1117249)
  • 11444 N 28th Dr, Phoenix, AZ 85029 (33.591507, -112.1197281)
  • 11445 N 30th Ave, Phoenix, AZ 85029 (33.5908737, -112.1233215)
  • 11449 N 30th Ave, Phoenix, AZ 85029 (33.5909958, -112.1232681)
  • 11612 N 20th Ave, Phoenix, AZ 85029 (33.5916367, -112.1023865)
  • 11624 N 31st Dr, Phoenix, AZ 85029 (33.5930443, -112.1265182)
  • 11666 N 28th Dr, Phoenix, AZ 85029 (33.593037, -112.120491)
  • 11666 N 28th Dr, Phoenix, AZ 85029 (33.5930367, -112.120491)
  • 11666 N 28th Dr, Phoenix, AZ 85029 (33.5930367, -112.120491)
  • 11666 N 28th Dr, Phoenix, AZ 85029 (33.5930367, -112.120491)
  • 11666 N 28th Dr, Phoenix, AZ 85029 (33.5930367, -112.120491)
  • 11666 N 28th Dr, Phoenix, AZ 85029 (33.593037, -112.120491)
  • 11666 N 28th Dr, Phoenix, AZ 85029 (33.593037, -112.120491)
  • 11666 N 28th Dr, Phoenix, AZ 85029 (33.5930367, -112.120491)
  • 11833 N 40th Dr, Phoenix, AZ 85029 (33.5938797, -112.145874)
  • 11839 N 40th Dr, Phoenix, AZ 85029 (33.5940895, -112.1458817)
  • (Daniel Peak) 12201 N 29th Ave, Phoenix, AZ 85029 (33.5966911, -112.1207657)
  • 12224 N 25th Ave, Phoenix, AZ 85029 (33.597435, -112.113121)
  • 12235 N 25th Ave, Phoenix, AZ 85029 (33.5977936, -112.1125565)
  • 12245 N 41st Ave, Phoenix, AZ 85029 (33.5981178, -112.1464539)
  • 12445 N 21st Ave, Phoenix, AZ 85029 (33.5999908, -112.1035614)
  • 12446 N 36th Dr, Phoenix, AZ 85029 (33.6000061, -112.1360474)
  • 12606 N 20th Dr, Phoenix, AZ 85029 (33.6004677, -112.1031189)
  • 12620 N 38th Ave, Phoenix, AZ 85029 (33.6000862, -112.1402817)
  • 12631 N 17th Ave, Phoenix, AZ 85029 (33.601307, -112.094826)
  • 12648 N 17th Ave, Phoenix, AZ 85029 (33.6018982, -112.0954895)
  • 12648 N 32nd Ave, Phoenix, AZ 85029 (33.6017151, -112.1276169)
  • 12819 N 17th Ave, Phoenix, AZ 85029 (33.6030045, -112.0949478)
  • 12833 N 40th Dr, Phoenix, AZ 85029 (33.6027679, -112.1456223)
  • 13015 N 33rd Ave, Phoenix, AZ 85029 (33.6043091, -112.1279068)
  • 13219 N 31st Dr, Phoenix, AZ 85029 (33.6063461, -112.125824)
  • 13222 N 26th Dr, Phoenix, AZ 85029 (33.6071854, -112.1157608)
  • 13230 N 34th Dr, Phoenix, AZ 85029 (33.6064339, -112.13311)
  • 13236 N 17th Ave, Phoenix, AZ 85029 (33.6077461, -112.0962143)
  • 13249 N 33rd Ave, Phoenix, AZ 85029 (33.6068268, -112.1288147)
  • 13409 N 24th Ln, Phoenix, AZ 85029 (33.6091232, -112.1124115)
  • 13423 N 37th Ave, Phoenix, AZ 85029 (33.6081505, -112.1380157)
  • 13432 N 18th Ave, Phoenix, AZ 85029 (33.6092911, -112.0976105)
  • 13432 N 31st Ave, Phoenix, AZ 85029 (33.6083183, -112.1254883)
  • 13436 N 18th Dr, Phoenix, AZ 85029 (33.6090927, -112.0984421)
  • 13614 N 18th Ave, Phoenix, AZ 85029 (33.6101379, -112.0976105)
  • 13615 N 24th Ave, Phoenix, AZ 85029 (33.6100693, -112.1101913)
  • 13635 N 32nd Dr, Phoenix, AZ 85029 (33.6103249, -112.1275101)
  • 13636 N 18th Dr, Phoenix, AZ 85029 (33.610847, -112.098579)
  • 13652 N 40th Dr, Phoenix, AZ 85029 (33.6104965, -112.1458664)
  • 13658 N 21st Ave, Phoenix, AZ 85029 (33.6102676, -112.1041794)
  • Foster Family: 1543 W Joan de Arc Ave, Phoenix, AZ 85029 (33.6075439, -112.0931931)
  • 15430 N 25th St, Phoenix, AZ 85032 (33.6266908, -112.0285374)
  • 1548 W Sahuaro Dr, Phoenix, AZ 85029 (33.5841179, -112.0935364)
  • 1610 W Becker Ln, Phoenix, AZ 85029 (33.5830767, -112.0938841)
  • 1633 W Andorra Dr, Phoenix, AZ 85029 (33.606216, -112.095131)
  • 1649 W Cholla St, Phoenix, AZ 85029 (33.589157, -112.095268)
  • 1649 W Pershing Ave, Phoenix, AZ 85029 (33.6055489, -112.095726)
  • 1712 W Voltaire Ave, Phoenix, AZ 85029 (33.6092644, -112.096344)
  • 1716 W Cortez St, Phoenix, AZ 85029 (33.5917625, -112.0954666)
  • 1716 W Cortez St, Phoenix, AZ 85029 (33.5917625, -112.0954666)
  • 1716 W Cortez St, Phoenix, AZ 85029 (33.5917625, -112.0954666)
  • 1727 W Wood Dr, Phoenix, AZ 85029 (33.6042366, -112.0971527)
  • 1733 W Voltaire Ave, Phoenix, AZ 85029 (33.6088409, -112.0971451)
  • 1809 E Marco Polo Rd, Phoenix, AZ 85024 (33.6679001, -112.0421371)
  • 1819 W Cholla St, Phoenix, AZ 85029 (33.5890465, -112.0979385)
  • (Sam Hanks) 1901 W Eugie Ave, Phoenix, AZ 85029 (33.6079559, -112.0999908)
  • 1950 W Aster Dr, Phoenix, AZ 85029 (33.6026497, -112.1012802)
  • 1950 W Aster Dr, Phoenix, AZ 85029 (33.6026497, -112.1012802)
  • 1950 W Aster Dr, Phoenix, AZ 85029 (33.6026497, -112.1012802)
  • 1950 W Aster Dr, Phoenix, AZ 85029 (33.6026497, -112.1012802)
  • 2010 W Wood Dr, Phoenix, AZ 85029 (33.6045609, -112.1020355)
  • 2027 W Lupine Ave, Phoenix, AZ 85029 (33.5899048, -112.1036224)
  • 2031 W Windrose Dr, Phoenix, AZ 85029 (33.6018295, -112.1030121)
  • 2032 W Cactus Rd, Phoenix, AZ 85029 (33.5975342, -112.1023941)
  • 2032 W Cactus Rd, Phoenix, AZ 85029 (33.597534, -112.102394)
  • 2034 W Cactus Rd, Phoenix, AZ 85029 (33.5972748, -112.1023941)
  • 2039 E Heartwood Ln, Phoenix, AZ 85022 (33.6381874, -112.0386279)
  • 2041 E Heartwood Ln, Phoenix, AZ 85022 (33.6381807, -112.0385917)
  • 2043 E Heartwood Ln, Phoenix, AZ 85022 (33.6381747, -112.0385548)
  • 2045 E Heartwood Ln, Phoenix, AZ 85022 (33.638168, -112.0385186)
  • 2049 W Joan de Arc Ave, Phoenix, AZ 85029 (33.6071968, -112.1036758)
  • 2065 E Heartwood Ln, Phoenix, AZ 85022 (33.6381552, -112.038137)
  • 2113 W Lupine Ave, Phoenix, AZ 85029 (33.5898666, -112.1044464)
  • 2122 W Poinsettia Dr, Phoenix, AZ 85029 (33.5941582, -112.1048584)
  • 21255 N 36th Pl, Phoenix, AZ 85050 (33.6793566, -112.0041528)
  • 2131 W Cholla St, Phoenix, AZ 85029 (33.5890312, -112.1052399)
  • 2143 W Eugie Ave, Phoenix, AZ 85029 (33.6078758, -112.1058807)
  • 2202 W Sunnyside Ave, Phoenix, AZ 85029 (33.5933533, -112.1061096)
  • 2210 W Wethersfield Rd, Phoenix, AZ 85029 (33.5974655, -112.1061096)
  • 2234 W Laurel Ln, Phoenix, AZ 85029 (33.5943871, -112.1073532)
  • 2242 W Windrose Dr, Phoenix, AZ 85029 (33.601944, -112.1075211)
  • 2250 W Altadena Ave, Phoenix, AZ 85029 (33.5922966, -112.1076126)
  • 2250 W Larkspur Dr, Phoenix, AZ 85029 (33.600296, -112.1077652)
  • 2250 W Sierra St, Phoenix, AZ 85029 (33.59161, -112.1076202)
  • 2301 W Bloomfield Rd, Phoenix, AZ 85029 (33.5984535, -112.108223)
  • Tom Miller: 2302 E Curnow Dr, Phoenix, AZ 85016 (33.4840026, -112.0321966)
  • 2315 N 52nd St, Phoenix, AZ 85008 (33.4732704, -111.9693527)
  • 23221 N 40th Way, Phoenix, AZ 85050 (33.6972396, -111.9802992)
  • 2324 W Shaw Butte Dr, Phoenix, AZ 85029 (33.5961533, -112.1091385)
  • 2338 W Cortez Ave, Phoenix, AZ 85029 (33.5908966, -112.1096802)
  • 2339 W Shaw Butte Dr, Phoenix, AZ 85029 (33.5956751, -112.1090935)
  • 2409 W Lupine Ave, Phoenix, AZ 85029 (33.5897827, -112.1107635)
  • 2419 W Laurel Ln, Phoenix, AZ 85029 (33.5943184, -112.1112061)
  • 2424 W Laurel Ln, Phoenix, AZ 85029 (33.5947227, -112.1113281)
  • 2427 W Sweetwater Ave, Phoenix, AZ 85029 (33.6034317, -112.1126099)
  • 2514 W Pershing Ave, Phoenix, AZ 85029 (33.6067848, -112.1127472)
  • 2607 W Pershing Ave, Phoenix, AZ 85029 (33.6065483, -112.1142426)
  • 2640 W Wood Dr, Phoenix, AZ 85029 (33.604866, -112.1156235)
  • 2641 W Sweetwater Ave, Phoenix, AZ 85029 (33.6033897, -112.1161423)
  • 2800 W Sahuaro Dr, Phoenix, AZ 85029 (33.5845451, -112.1196671)
  • 2907 W Windrose Dr, Phoenix, AZ 85029 (33.601337, -112.121399)
  • 2917 W Charter Oak Rd, Phoenix, AZ 85029 (33.597755, -112.121902)
  • 2918 W Sierra St, Phoenix, AZ 85029 (33.5919991, -112.1223602)
  • 3005 W Sierra St, Phoenix, AZ 85029 (33.5915184, -112.1237183)
  • 3009 W Orangewood Ave, Phoenix, AZ 85051 (33.5453415, -112.1235657)
  • 3016 W Mescal St, Phoenix, AZ 85029 (33.5878792, -112.1240616)
  • 3023 W Windrose Dr, Phoenix, AZ 85029 (33.6012383, -112.1237717)
  • 3029 W Shaw Butte Dr, Phoenix, AZ 85029 (33.5952873, -112.1236038)
  • 3033 W Columbine Dr, Phoenix, AZ 85029 (33.5991058, -112.124382)
  • 3040 W Columbine Dr, Phoenix, AZ 85029 (33.5995026, -112.1244049)
  • 3115 W Cactus Rd, Phoenix, AZ 85029 (33.5959969, -112.126236)
  • 3120 W Sahuaro Dr, Phoenix, AZ 85029 (33.5840607, -112.1262436)
  • 3124 W Desert Cove Dr, Phoenix, AZ 85029 (33.58617, -112.126556)
  • 3125 W Cortez Ave, Phoenix, AZ 85029 (33.5918541, -112.126564)
  • Jenny Michaels: 3139 W Bloomfield Rd, Phoenix, AZ 85029 (33.598404, -112.12709)
  • 3141 W Surrey Ave, Phoenix, AZ 85029 (33.605278, -112.1268539)
  • 3162 W Altadena Ave, Phoenix, AZ 85029 (33.5934715, -112.1280441)
  • Lowe Family: 3224 W Sahuaro Dr, Phoenix, AZ 85029 (33.5837936, -112.1293106)
  • 3226 W Sharon Ave, Phoenix, AZ 85029 (33.6096802, -112.1281586)
  • 3239 W Mescal St, Phoenix, AZ 85029 (33.5864944, -112.1294174)
  • 3240 W Cholla St, Phoenix, AZ 85029 (33.5900726, -112.1292496)
  • 3240 W Mescal St, Phoenix, AZ 85029 (33.5867433, -112.1291403)
  • 3245 W Corrine Dr, Phoenix, AZ 85029 (33.6002617, -112.1290054)
  • 3247 W Mercer Ln, Phoenix, AZ 85029 (33.5849609, -112.129509)
  • 3301 W Windrose Dr, Phoenix, AZ 85029 (33.6012688, -112.1302261)
  • 3325 W Aster Dr, Phoenix, AZ 85029 (33.6019669, -112.1311417)
  • 3325 W Shaw Butte Dr, Phoenix, AZ 85029 (33.5953751, -112.1308365)
  • 3328 W Corrine Dr, Phoenix, AZ 85029 (33.6009636, -112.1312866)
  • 3401 W Rosewood Ave, Phoenix, AZ 85029 (33.5998459, -112.1319046)
  • 3402 W Columbine Dr, Phoenix, AZ 85029 (33.5995293, -112.1321259)
  • 3402 W Laurel Ln, Phoenix, AZ 85029 (33.5943718, -112.1320343)
  • 3402 W Lupine Ave, Phoenix, AZ 85029 (33.5907745, -112.132019)
  • 3402 W Sierra St, Phoenix, AZ 85029 (33.5915527, -112.1319427)
  • 3424 W Bloomfield Rd, Phoenix, AZ 85029 (33.5987968, -112.1329575)
  • 3435 W Columbine Dr, Phoenix, AZ 85029 (33.5991135, -112.1334)
  • 3442 W Sunnyside Ave, Phoenix, AZ 85029 (33.5929718, -112.1336823)
  • 3532 W Altadena Ave, Phoenix, AZ 85029 (33.5918999, -112.1354752)
  • 3536 W Sahuaro Dr, Phoenix, AZ 85029 (33.5845604, -112.1349258)
  • 3569 W Wood Dr, Phoenix, AZ 85029 (33.6039352, -112.1369629)
  • 3615 W Yucca St, Phoenix, AZ 85029 (33.5873642, -112.1366501)
  • 3620 W Shangri la Rd, Phoenix, AZ 85029 (33.586998, -112.1368332)
  • 3620 W Shangri la Rd, Phoenix, AZ 85029 (33.586998, -112.1368332)
  • 3626 W Windrose Dr, Phoenix, AZ 85029 (33.6019592, -112.1357651)
  • 3630 E Cat Balue Dr, Phoenix, AZ 85050 (33.6841049, -112.0021591)
  • 3646 W Cholla St, Phoenix, AZ 85029 (33.5889778, -112.1381836)
  • E Zachary Dr, Phoenix, AZ 85050 (33.6791306, -111.9993973)
  • E Zachary Dr, Phoenix, AZ 85050 (33.6791306, -111.9993973)
  • 3701 W Aster Dr, Phoenix, AZ 85029 (33.601944, -112.138489)
  • 3713 W Rosewood Ave, Phoenix, AZ 85029 (33.6005707, -112.1389542)
  • 3715 W Yucca St, Phoenix, AZ 85029 (33.5873184, -112.1391449)
  • 3717 W Columbine Dr, Phoenix, AZ 85029 (33.598835, -112.1392136)
  • 3719 E Matthew Dr, Phoenix, AZ 85050 (33.6771431, -112.0023041)
  • 3725 W Shangri la Rd, Phoenix, AZ 85029 (33.5865364, -112.1394348)
  • 3730 W Shangri la Rd, Phoenix, AZ 85029 (33.5869675, -112.1396484)
  • 3750 E Matthew Dr, Phoenix, AZ 85050 (33.6781044, -112.0013962)
  • 3755 E Fairmount Ave, Phoenix, AZ 85018 (33.4926105, -112.000578)
  • 3757 W Willow Ave, Phoenix, AZ 85029 (33.6061859, -112.1403427)
  • 3778 E Zachary Dr, Phoenix, AZ 85050 (33.6787148, -111.9971924)
  • 3802 W Wethersfield Rd, Phoenix, AZ 85029 (33.5971069, -112.1405792)
  • 3807 W Sweetwater Ave, Phoenix, AZ 85029 (33.6035219, -112.1411962)
  • 3825 W Sahuaro Dr, Phoenix, AZ 85029 (33.5834427, -112.14151)
  • 3826 W Wethersfield Rd, Phoenix, AZ 85029 (33.5971069, -112.1414795)
  • 3837 W Charter Oak Rd, Phoenix, AZ 85029 (33.597393, -112.1419296)
  • 3902 W Joan de Arc Ave, Phoenix, AZ 85029 (33.607845, -112.142761)
  • 3910 W Wood Dr, Phoenix, AZ 85029 (33.6046257, -112.1443176)
  • 3912 W Surrey Ave, Phoenix, AZ 85029 (33.6054115, -112.1442108)
  • 3918 W Paradise Dr, Phoenix, AZ 85029 (33.5953979, -112.1436081)
  • 3926 W Voltaire Ave, Phoenix, AZ 85029 (33.6086655, -112.1437454)
  • 3927 W Mercer Ln, Phoenix, AZ 85029 (33.58461, -112.1440964)
  • Paul Smith Family: 3935 E Rough Rider Rd, Phoenix, AZ 85050 (33.6878242, -111.9908905)
  • 4001 W Desert Cove Ave, Phoenix, AZ 85029 (33.5853271, -112.1446457)
  • 4014 E Walter Way, Phoenix, AZ 85050 (33.695753, -111.9820091)
  • 4021 E Hashknife Rd, Phoenix, AZ 85050 (33.6948558, -111.9820742)
  • 4023 E Casitas del Rio Dr, Phoenix, AZ 85050 (33.6979853, -111.9811488)
  • 4025 W Corrine Dr, Phoenix, AZ 85029 (33.6001129, -112.1465149)
  • 4036 W Lupine Ave, Phoenix, AZ 85029 (33.5900497, -112.1470871)
  • 4062 W Mercer Ln, Phoenix, AZ 85029 (33.5850296, -112.1469955)
  • 4125 W Altadena Ave, Phoenix, AZ 85029 (33.5910339, -112.1484222)

Start business block

  • 4129 W Charter Oak Rd, Phoenix, AZ 85029 (33.5978737, -112.1479263) Copper State Glass and Screen
  • 4132 W Sweetwater Ave, Phoenix, AZ 85029 (33.6038284, -112.1490555)
  • 4145 W Paradise Dr, Phoenix, AZ 85029 (33.5942154, -112.1493073)
  • 4146 W Columbine Dr, Phoenix, AZ 85029 (33.5997963, -112.1484451)
  • 4151 W Bloomfield Rd, Phoenix, AZ 85029 (33.5986137, -112.148674)
  • 4151 W Paradise Dr, Phoenix, AZ 85029 (33.5942116, -112.1495514)
  • 4157 W Columbine Dr, Phoenix, AZ 85029 (33.5993538, -112.1488724)
  • 4206 W Garden Dr, Phoenix, AZ 85029 (33.588466, -112.1494541)
  • 4216 W Willow Ave, Phoenix, AZ 85029 (33.6069794, -112.1501541)
  • 4225 E McDowell Rd, Phoenix, AZ 85008 (33.4656423, -111.9908202) Ace Hardware

End business block

  • E Angela Dr, Phoenix, AZ 85032 (33.6464882, -111.9951706)
  • E Angela Dr, Phoenix, AZ 85032 (33.6464882, -111.9951706)
  • 4702 E Clarendon Ave, Phoenix, AZ 85018 (33.4908409, -111.9807358)
  • 4924 N 108th Dr, Phoenix, AZ 85037 (33.506958, -112.2935791)
  • Jackson Family: 4931 E White Gates Dr, Phoenix, AZ 85018 (33.5123291, -111.9730911)
  • 5010 N 34th St, Phoenix, AZ 85018 (33.5105364, -112.0086086)
  • 5010 N 34th St, Phoenix, AZ 85018 (33.5105364, -112.0086086)
  • Phoenix, AZ", (33.4482613, -112.0757675)
  • Phoenix, AZ", (33.4482613, -112.0757675)
  • Phoenix, AZ", (33.4482613, -112.0757675)
  • Phoenix, AZ", (33.4482613, -112.0757675)
  • 5301 E Wonderview Rd, Phoenix, AZ 85018 (33.5087433, -111.9679031)
  • 5350 E Deer Valley Dr, Phoenix, AZ 85054 (33.6768843, -111.9644272)
  • 5350 E Deer Valley Dr, Phoenix, AZ 85054 (33.6768843, -111.9644272)
  • Phoenix, AZ", (33.4482613, -112.0757675)
  • 60 E Mitchell Dr, Phoenix, AZ 85012 (33.488945, -112.0711212)
  • 6102 E Carnation Circle, Phoenix, AZ 85018 (33.4829636, -111.9498825)
  • 7821 W Pike Pl, Phoenix, AZ 85035 (33.4692688, -112.227829)
  • 7822 W Palm Ln, Phoenix, AZ 85035 (33.4689751, -112.227829)
  • 7834 W Holly St, Phoenix, AZ 85035 (33.4701614, -112.228157)
  • 7841 W Pike Pl, Phoenix, AZ 85035 (33.4692726, -112.2283936)
  • N 20th Ln, Phoenix, AZ 85015 (33.52845, -112.1031113)
  • 810 E Harmont Dr, Phoenix, AZ 85020 (33.5554962, -112.0633087) John Smith
  • 8196 W Lynwood St, Phoenix, AZ 85043 (33.464592, -112.2351227) Jonathan Smith, John Smith

Roles

Both Alisha and Ted are “on staff” at the church “Rock Solid Church” so they are in the Staff Users group (group type Security Role).

Attendance Data

We need 16 weeks of attendance data for families. Jon’s thinking was that each family would have a percentage attendance rate. The sample data then would create attendance data based on this rate. I would see that that attendance data is entered from the current data and goes backward 16 weeks so you get fresh data with every run. (? - Jon’s words)

The Decker family attends approximately 80% of the time but that drops to 50% during the summer months (Jul - Sep). 88% of the time they attend the 9:00am service on Sunday but occasionally attend the 10:30am due to their hectic life schedule. They check-in typically 0-15 minutes early, but 1 out of 4 times they are 0-15 minutes late (arriving after the event start time).

Giving Data

This represents the contribution (donation) data for a family.

 <family>
    ...
    <giving startGiving="12/25/2012" frequency="monthly" endingGivingWeeksAgo="0" 
       percentGive="100" accountAmount="General Fund:75, Building Fund:25"
       growRatePercent="3" growFrequencyWeeks="52" specialGiftPercent="50" 
       personGuid="8FEDC6EE-8630-41ED-9FC5-C7157FD1EAA4"
       imageUrls="http://storage.rockrms.com/sampledata/check-images/decker-01.png,http://storage.rockrms.com/sampledata/check-images/decker-02.png">
      </giving>
   ...
   </family>
  • startGiving - This is the date the giving begins.
  • frequency - onetime, weekly, monthly.
  • endingGivingWeeksAgo - This is the number (int) of weeks ago when the giving stops. If not given, today will be used.
  • percentGive - This is the percent (int) of the time that a weekly giving record should be generated. If less than 100, then sometimes a giving transaction will not be created (based on a randomizer).
  • accountAmount - a comma delimited list of account-names:amount colon pairs. The amount of money given to the named fund (account). The account name should match an existing Rock FinancialAccount name otherwise the first active account will be used.
  • growFrequencyWeeks - Number of weeks after which the grow rate should occur. If empty or 0 then giving will never grow.
  • growRatePercent - Percent of growth that occurs after the given number of growFrequencyWeeks occurs.
  • specialGiftPercent - (not implemented; future) The percent of the total given that will be occasionally added as a special gift (like Christmas, Easter, special event).
  • imageUrls - Comma delimited list of image URLs to use for the transaction/check images. List is treated like a circular linked list.
  • personGuid - the guid of the person who's being tied to the donation/contribution.

EventRegistration

This is a set of event registration give data. This will record a payment transaction in Rock. In the future we may create the event registration group member records too (future).

 <family>
    ...
    <eventRegistrations>
       <event guid="future" batchGuid="51F1B3A7-46E9-423B-8A72-F8C0B5BDB0A5"
          personGuid="8FEDC6EE-8630-41ED-9FC5-C7157FD1EAA4" account="Event Registration"
          cost="299" date="7/1/2015 5:15" transactionCode="AT0AD5F1A9DA">
       ...
      </eventRegistrations>
      ...
   </family>
  • guid - the guid of the event (not implemented yet)
  • batchGuid - the guid of the batch it will create for the registration.
  • personGuid - the person who registered.
  • account - a Rock FinancialAccount Name (if not found it will create/add a new one).
  • cost - the decimal value of the event cost
  • date - the datetime the person registered/paid or a negative integer representing the number of days ago they registered. If left blank it will randomly select a date at some point in the recent past.
  • transactionCode - a cryptic code (you know how those things are) or leave blank and one will be auto-generated.

Notes

  • More than anything we should make sure that our data tells stories. Placing an xml comment in front of a section will include that story in the output when everything is successfully loaded.

Other stuff (future TODO)

  • Next up would be group data. Need 10-15 "bible study groups".

Example:

    <!-- Mariah Jackson has sole custody of her child Madison Lowe.  Madison is also the child of 
    of her father Craig, of the Lowe family.
    -->
    <family name="Jackson Family" guid="DFBF8D82-3D34-406B-8C84-9F10046ADE30" campus="main campus"
       ...

Sample Data XML Specification

Section: <mapping><person_attributes> 

  <mapping>
    <person_attributes>
      <attribute name="Baptism Date" id="[foreign_id]" /> 
    </person_attributes>
  </mapping>

The <mapping><person_attributes> section allows you specify person attributes from a foreign system.

Each attribute will be presented back to the user (upon first run) along with a drop down list of unmatched Rock Person Attributes so the user can select a Rock attribute to map it to. If none is selected, a new one with a datatype of string will be created automatically. Once matched, the value of the foreign id will be stored in Rock for the attribute.

These foreign ids may be referenced later in in the <attribute ...> element of the <person><attributes> section like this:

`<attribute id="[foreign_id]" value="[value]" />`

recordStatus, connectionStatus, maritalStatus

NOTE: This is not implemented in the current version of the SampleData block.

The import tool will pre-process the XML looking for all distinct recordStatus values, connectionStatus values, and maritalStatus values. If no matching values can be found in Rock, the import tool will warn the user which items will be created as new values (for the corresponding Rock DefinedType's DefinedValues) new ones will be added. This will give the user a chance to correct any problems they may have with invalid data in their XML file.

Example

<data>
  <mapping>
    <person_attributes>
      <attribute name="Baptism Date" id="[foreign_id]" /> 
    </person_attributes>
  </mapping>

  <families>
    
    <family name="Decker Family" guid="53A02527-C2A7-4F36-8585-71A85B8E4601" campus="main campus"
            startingAttendance="12/25/2012" endingAttendanceWeeksAgo="0" percentAttendance="80" 
            percentAttendedRegularService="88" attendingScheduleId="3" attendingAltScheduleId="4">
      <addresses>
          <address type="home" street1="11624 N 31st Dr" street2="" city="Phoenix" state="AZ" zip="85029"
            lat="33.593043" long="-112.126518" />
      </addresses>
      <members>
        <person guid="8FEDC6EE-8630-41ED-9FC5-C7157FD1EAA4" firstName="Theodore" nickName="Ted"
            lastName="Decker" birthDate="2/10/1973" age="38" gender="male"
            email="[email protected]​"
            emailIsActive="​true" emailDoNotEmail="false" recordType="person" recordStatus="active"
            recordStatusReason="Deceased" suffix="Jr."
            connectionStatus="member"  maritalStatus="married" familyRole="adult"
            anniversaryDate="1/4/1996"
            photoUrl="http://STORAGE.ROCKRMS.COM/photos/teddecker.jpg" 
            homePhone="6235553322" mobilePhone="6235553322" workPhone="602555-2911">
          <attributes>
            <attribute id="[foreign_id]" value="[value]" />
            <attribute BaptismDate="9/13/2001"/>
            <attribute FirstVisit="12/15/2012"/>
          </attributes>
          <logins>
              <login userName="tdecker"/>
          </logins>
          <notes>
            <note type="Personal Note" text="Left a message for Ted to follow up with Debbie Green
               who is looking for financial assistance."/>
            <note type="Personal Note" text="Notes can have a date and be by a person's guid."
               date="4/1/2012 1:30 PM" byGuid="2D562281-F4C5-4A0D-A2D2-CFA6D9217E77" />
            <note type="Personal Note" text="Important: notes can be marked as Alert" isAlert="true" />
          </notes>
          <previousNames>
            <name lastName=""/>
          </previousNames>
        </person>
      </members>
      <giving startGiving="12/25/2012" endingGivingWeeksAgo="0" percentGive="100" 
         accountAmount="General Fund:75, Building Fund:25" growRatePercent="3" growFrequencyWeeks="52" specialGiftPercent="50">
      </giving>
    </family>
    
    <family name="Jones Family" guid="">
      <members>
        <person guid="2D562281-F4C5-4A0D-A2D2-CFA6D9217E77" firstName="Brian" ... />
      </members>
    </family>

    <family name="Simmons Family" guid="">
      <members>
        <person guid="2D562281-F4C5-4A0D-A2D2-CFA6D9217E77" firstName="Brian" />
      </members>​
    </family>​
  </families>

  <relationships>
    <relationship a="Ben" personGuid="3C402382-3BD2-4337-A996-9E62F1BAB09D" is="step-parent"
        forGuid="3D7F6605-3666-4AB5-9F4E-D7FEBF93278E" name="Brian" />
    <relationship a="Brian" personGuid="3D7F6605-3666-4AB5-9F4E-D7FEBF93278E" is="step-child"
        forGuid="3C402382-3BD2-4337-A996-9E62F1BAB09D" name="Ben" />

    <relationship a="Craig" personGuid="B701E5D2-ADBD-4C66-91E8-3D6CD298D9A0" is="can-check-in" 
        forGuid="C398A8E3-C9BC-4017-A3F6-7C2BFF654056" name="Madison Lowe"/>
    <relationship a="Madison" personGuid="C398A8E3-C9BC-4017-A3F6-7C2BFF654056" is="allow-check-in-by" 
       forGuid="B701E5D2-ADBD-4C66-91E8-3D6CD298D9A0" name="Craig"/>
  </relationships>

  <groups>
    <group type="serving" name="Ushers" guid="0BA93D66-21B1-4229-979D-F76CEB57666D">
      <person fullname="Ted Decker" guid="8FEDC6EE-8630-41ED-9FC5-C7157FD1EAA4"/>
      <person fullname="Jim Simmons" guid="FB5D2DC6-5AB4-4CBD-B02F-3FB9ADBEFD33"/>
      <location guid="D5171D44-C801-4B7D-9335-D23FB4EA0E60">
        <schedule guid="7883CAC8-6E30-482B-95A7-2F0DEE859BE1"/>
        <schedule guid="33FF69E9-059B-4702-B1E5-4D499CB7B07A"/>
        <schedule guid="FF6FB240-0C32-4542-BE40-159C522F7E51"/>
        <schedule guid="4628D917-EC9C-4269-B39C-5BCBEF3658E7"/>
        <schedule guid="1F6C15DA-982F-43B1-BDE9-D4E70CFBCB45"/>
      </location>
    </group>

    <group type="smallgroup" name="Decker Group" guid="62DC3753-01D5-48B5-B22D-D2825D92900B"
           parentGroupGuid="C05E60C4-6DFC-420D-8DBA-28DBB5F0E3F9"
           meetsAtHomeOfFamily="53A02527-C2A7-4F36-8585-71A85B8E4601"
           meetsAtHomeOfPerson="8FEDC6EE-8630-41ED-9FC5-C7157FD1EAA4"
           studyTopic="Book of Genesis" meetingTime="19:00:00"
           description ="Small group with Ted as the group leader.">
      <person fullname="Ted Decker" guid="8FEDC6EE-8630-41ED-9FC5-C7157FD1EAA4"/>
      <person fullname="Cindy Decker" guid="B71494DB-D809-451A-A950-28898D0FD92C"/>
      <person fullname="Bill Marble" guid="1EA811BB-3118-42D1-B020-32A82BC8081A"/>
      <person fullname="Alisha Marble" guid="69DC0FDC-B451-4303-BD91-EF17C0015D23"/>
    </group>

  </groups>
  
  <connections>
    <connection type="Involvement" opportunity="Children's" 
            comment="I would love to help teach kids about Jesus." date="2015-10-11T00:00:00"
            personGuid="1dfff821-e97c-4324-9883-cf59b5c5bdd6" />
  </connections>

  <following>
    <follows personGuid="8FEDC6EE-8630-41ED-9FC5-C7157FD1EAA4" 
           followsGuid="1dfff821-e97c-4324-9883-cf59b5c5bdd6" type="person" />
    <follows personGuid="8FEDC6EE-8630-41ED-9FC5-C7157FD1EAA4"
           followsGuid="CD65C668-B324-4F41-BBB7-BEC9C62233F1" type="group" />
  </following>

  <security_roles>
    <group name="Communication Administrators" guid="B1906B7D-1A1E-41B9-BBA4-F4482CECAF7B" >
      <members>
        <person fullname="Ted Decker" guid="8FEDC6EE-8630-41ED-9FC5-C7157FD1EAA4"/>
      </members>
    </group>
  </security_roles>
</data>
Add a custom footer
Add a custom sidebar
Clone this wiki locally