--- title: Batch - Data Ingestion slug: att-ajo-hol/batch-data-ingestion docTags: createdAt: 2023-10-26T20:21:41.456Z --- ## Download sample CRM data in the .csv file. ::File{src="https://api.archbee.com/api/presign/1Jp0iolWv35Z_mkI7oUiT/DiKk_aymCD40_cbHzAsk5_multicust-crm-full.csv" label="multicust_crm_full.csv" isUploading="false"} ::::CodeDrawer{title="CRM Profile CSV as Text" isResponseExpanded="true"} :::CodeblockTabsExamples ```none crmid,email,first_name,last_name,gender,mobilePhone.number,homeAddress.city,country,homeAddress.postalCode,homeAddress.state,homeAddress.street1,birthday,loyaltyTier,loyaltyMemberSinceDate,loyaltyPointsTotal 6122273956,sissoo2000@gmail.com,Sommer,Cleveland,female,378-065-8735,New Bedford,United States,11195,Hawaii,758 Bartlett,4/16/95,Silver,2000,700 6693023125,gambet2022@yahoo.com,Willie,Benton,male,281-325-6763,Rancho Palos Verdes,United States,42908,Wyoming,1013 Rice,5/7/92,Gold,2019,1672 7316989091,epigrammatic1895@yahoo.com,Robby,Boone,male,515-737-7830,Lee's Summit,United States,82740,Idaho,224 Cordova,4/10/82,Platinum,2018,2994 6982806974,callorhynchidae1994@gmail.com,Rosette,Joyner,female,919-264-9383,Tampa,United States,24039,Hawaii,444 Carrizal,7/16/58,Diamond,2008,1000 8276189891,pilgrim1933@outlook.com,Louis,Raymond,male,046-695-4607,Zion,United States,36835,Kentucky,128 Reposa,4/23/76,Silver,2018,2665 3405802899,anthonin1932@live.com,Deandrea,Vargas,female,782-970-8623,South Jordan,United States,71342,Vermont,463 Weatherly,2/13/58,Gold,2014,886 7575587011,patter1869@gmail.com,Tobias,Fernandez,male,608-979-7579,Long Branch,United States,83590,Florida,1336 Allison,4/13/84,Platinum,2015,1836 1464831680,centric1857@gmail.com,Bryon,Guzman,male,481-019-2956,Milford,United States,10382,Delaware,822 Levant,2/16/90,Diamond,2009,2461 2390678384,saltee2049@gmail.com,Gema,Hawkins,female,425-112-1030,Stillwater,United States,23144,Iowa,339 Sutter,3/13/57,Silver,2007,2633 3466010000,prefavorably1897@yandex.com,Loren,David,female,427-214-6958,Perrysburg,United States,88698,Iowa,455 Goleta,11/7/88,Gold,2002,877 6910938685,postscapular1949@yahoo.com,Jeffery,Wilkinson,male,432-027-3864,Napa,United States,93713,Michigan,970 Landers,11/11/95,Platinum,2019,1848 8551539116,snapberry1960@outlook.com,Xochitl,Nolan,female,037-000-1160,West Allis,United States,91553,Alabama,747 Bessie,12/18/46,Diamond,2011,1664 6451567154,pony1990@live.com,Isaac,Mckay,male,755-093-4753,Sulphur,United States,82869,Nevada,1099 Swiss,5/19/42,Silver,2009,1675 7767586923,chicken1917@live.com,Arturo,Griffith,male,265-311-2914,Miami Beach,United States,15048,Michigan,1114 Gaven,2/26/90,Gold,2014,1598 4335542946,uncovenant2069@live.com,Osvaldo,Mayer,male,909-608-8860,Asheboro,United States,44590,North Dakota,514 Brady,8/18/34,Platinum,2009,2579 6796556068,forgeability1865@yahoo.com,Aldo,Valenzuela,male,421-894-1874,Bartlett,United States,02657,Florida,101 Paul,1/29/36,Diamond,2020,1352 6212192278,vibrative1825@outlook.com,Leeanne,Carver,female,902-223-4796,Duluth,United States,81567,Arkansas,1145 Holloway,5/5/56,Silver,2004,2456 2363661786,beachwear1835@outlook.com,Orval,Hyde,male,654-439-3538,Brownsville,United States,94006,Rhode Island,983 Medical Center,7/15/42,Gold,2001,2316 8491584103,resubmitted1934@live.com,Orlando,Gill,male,570-434-5306,Urbandale,United States,04425,Connecticut,330 Boylston,11/14/33,Platinum,2018,1222 1632018709,nebraskan2034@gmail.com,Edward,Gallagher,male,720-005-2912,Stillwater,United States,45685,Massachusetts,713 Burns,9/17/83,Diamond,2004,2723 4671486617,defiant1978@yahoo.com,Oralee,Barker,female,345-875-7529,Cleburne,United States,33334,North Carolina,668 Kenneth Rexroth,7/2/48,Silver,2008,2350 7831242140,cobblerless2064@gmail.com,Jodee,Cain,female,729-777-1630,Downey,United States,81359,Arizona,1213 Ggp Access Road,4/5/55,Gold,2017,2578 1002120837,nongaseous2056@outlook.com,Truman,Gould,male,341-553-3197,Marshfield,United States,93633,North Carolina,92 Mount,11/12/87,Platinum,2022,1073 2421364825,reamalgamated2060@gmail.com,Adam,Knowles,male,248-238-6043,Angleton,United States,54052,New York,583 Concord,10/1/32,Diamond,2013,1759 1442234653,rugbeian1899@live.com,Ozella,Brennan,female,445-705-8461,Corona,United States,49573,Alaska,481 Willie B Kennedy,7/4/50,Silver,2016,1858 8739808154,idylls2027@outlook.com,Duncan,Jackson,male,048-731-0390,Palm Beach Gardens,United States,60115,Rhode Island,38 Romain,1/19/89,Gold,2009,1223 3711678555,chromomere2000@yandex.com,Gonzalo,Dejesus,male,783-905-9527,Frankfort,United States,04292,Montana,741 Annapolis,1/20/63,Platinum,2018,785 2986975476,newborns1829@outlook.com,Chadwick,Buchanan,male,399-007-9807,Bay City,United States,06039,South Carolina,468 Cedro,2/4/36,Diamond,2017,1779 5489940254,agaty1859@yahoo.com,Carroll,Sampson,female,670-739-6229,Hoffman Estates,United States,00060,Delaware,572 Robinson,1/14/72,Silver,2003,1495 7823943271,epomophorus1879@live.com,Jerold,Kramer,male,149-806-9377,Adrian,United States,24923,South Dakota,1156 Monte Vista,5/17/30,Gold,2005,2132 5439463469,hotpot1931@yahoo.com,Bret,Miller,male,565-781-0878,Bay City,United States,03525,Tennessee,1182 Yukon,2/20/36,Platinum,2009,996 9828237843,parterres2042@yandex.com,Stacy,Herring,female,836-438-9901,McMinnville,United States,60579,Montana,970 Hancock,11/28/88,Diamond,2010,1264 9300126064,castell2042@yahoo.com,Gonzalo,Baker,male,310-034-9008,Lexington,United States,21606,Wisconsin,902 Mckinnon,5/29/82,Silver,2023,2948 9472997652,climber2064@yandex.com,Mel,Nicholson,male,449-159-1005,Harrison,United States,79906,Wisconsin,1235 Tioga,12/12/70,Gold,2021,1889 4011537566,elided1930@outlook.com,Chas,Ryan,male,568-699-8231,Hermosa Beach,United States,18305,Washington,874 Hunter,2/27/71,Platinum,2014,2455 3751856154,deposit2003@gmail.com,Alfred,Britt,male,655-660-0959,Arnold,United States,00382,Georgia,1057 Redondo,1/4/33,Diamond,2018,2358 5707887540,plantula1880@outlook.com,Maye,Fleming,female,861-997-2739,New York,United States,13518,Tennessee,289 Pretor,3/12/97,Silver,2019,2613 8862803573,airish2006@live.com,Deon,Beasley,female,595-105-2367,Fargo,United States,90784,Ohio,1122 Alton,2/2/61,Gold,2020,1038 7058445190,brooklyn1824@outlook.com,Lonny,Simpson,male,254-507-9549,Zanesville,United States,93580,Kansas,1139 Egbert,6/27/43,Platinum,2001,724 1178514851,elusory1984@yandex.com,Keven,Huber,male,047-702-5828,Minnetonka,United States,81313,Mississippi,162 Zircon,2/4/91,Diamond,2023,1166 1732218875,woodpecker1972@yandex.com,Morgan,Grimes,male,879-341-5056,Yorkville,United States,59413,Louisiana,1252 Malta,2/26/96,Silver,2011,2318 1821938016,spiring1927@gmail.com,Angel,Montoya,female,580-752-1713,Muskogee,United States,45094,Oklahoma,183 Angelos,7/12/94,Gold,2019,758 4637534806,tonsured1893@yahoo.com,Dong,Glass,male,262-537-0021,Herriman,United States,34393,Idaho,487 Pierpoint,5/2/71,Platinum,2005,2140 7401055631,gharial1872@outlook.com,Basilia,Manning,female,011-797-2709,Davis,United States,05910,Delaware,304 Chumasero,1/18/53,Diamond,2019,1896 6312756754,molybdite2066@yandex.com,Charlena,Mendez,female,829-394-6157,East Point,United States,08300,Wyoming,640 Carrizal,2/20/57,Silver,2009,2576 2527230857,inbounds1987@live.com,Leopoldo,Daugherty,male,614-844-0688,Orinda,United States,91217,Nebraska,1183 Drummond,6/7/45,Gold,2008,1783 9021688822,scrod1893@gmail.com,Vern,Evans,male,120-389-8260,Yuma,United States,64322,Idaho,290 Brooklyn,8/16/63,Platinum,2013,2425 8315463378,snowdrops1896@gmail.com,Grant,Lott,male,990-343-2090,Bentonville,United States,28186,Oklahoma,100 Egbert,4/17/38,Diamond,2004,2645 6865648224,bencher2040@live.com,Lemuel,English,male,008-501-8241,Yuba City,United States,73868,South Carolina,498 Birchwood,12/28/75,Silver,2008,625 3285632620,anthroxan2001@live.com,Joella,Goodwin,female,413-610-2976,Claremont,United States,65693,Tennessee,11 Pacific,11/26/47,Gold,2020,1952 9870423946,lactim1835@yahoo.com,Anthony,Johns,male,621-660-9276,Plano,United States,97030,Vermont,498 Crestmont,1/15/36,Platinum,2000,700 1154199409,analgesist1896@yandex.com,Reginald,Sharp,male,455-216-4955,Victoria,United States,04214,Oklahoma,1353 Watchman,8/27/41,Diamond,2019,1672 1684554849,boatly1883@gmail.com,Walter,Beck,male,448-168-0979,Flagstaff,United States,11700,South Dakota,615 Edward,3/29/62,Silver,2018,2994 6511561628,anita1972@live.com,Stephen,Livingston,male,776-111-7189,Long Branch,United States,79057,New York,149 Mcdowell,12/31/84,Gold,2008,1000 9744933969,berates1925@yandex.com,Shannon,Chambers,female,647-236-8152,Racine,United States,92066,Hawaii,232 Emil,4/22/78,Platinum,2018,2665 5433060301,penguin1936@yandex.com,Agustin,Simon,male,982-045-2878,Augusta,United States,68874,Texas,145 Hollywood,11/21/35,Diamond,2014,886 5900800577,alive2058@yandex.com,Orlando,Bentley,male,346-840-3037,Marshfield,United States,43415,North Carolina,717 Saint Francis,8/22/87,Silver,2015,1836 1550026424,batteries1951@yandex.com,Willard,Blanchard,male,581-806-5517,Pleasant Hill,United States,60016,Washington,605 Via Ferlinghetti,10/3/39,Gold,2009,2461 5986313089,missilery1977@live.com,Erick,Rodriguez,male,504-417-4955,Whittier,United States,83477,New Mexico,1190 Middle Point,8/14/73,Platinum,2007,2633 1559781396,ruttily1846@yandex.com,Rafael,Salas,male,920-762-8365,Sikeston,United States,85374,Hawaii,867 Castle Manor,10/20/92,Diamond,2002,877 3653802265,experimentalist1917@yahoo.com,Craig,Weeks,male,157-137-5775,Kansas City,United States,00961,Iowa,243 Ada,1/8/76,Silver,2019,1848 3466567273,bevin2063@gmail.com,Young,Johnston,male,487-866-9661,Springfield,United States,97050,North Carolina,577 Richter,1/23/96,Gold,2011,1664 5759899865,wakened2052@live.com,Jack,Reilly,male,678-436-5894,Hilton Head Island,United States,49172,Alaska,570 Raccoon,7/29/72,Platinum,2009,1675 6812797153,intersoil1987@yahoo.com,Brain,Mendez,male,914-776-5643,Brownsburg,United States,02339,Illinois,47 Ramona,1/20/42,Diamond,2014,1598 7479857177,cardamom1876@yandex.com,Augustine,Harrington,female,684-202-4925,Socorro,United States,76140,Idaho,1151 Rebecca,11/21/88,Silver,2009,2579 9173142479,turkophil1929@live.com,Domenica,Mejia,female,286-943-1950,Springville,United States,25422,South Carolina,899 Robblee,3/20/59,Gold,2020,1352 6305734004,hoers1813@yahoo.com,Chad,Acevedo,male,654-484-0433,Victoria,United States,00084,Mississippi,1038 Lake Merced,11/3/30,Platinum,2004,2456 2999423327,adminstration1831@live.com,Brian,Solis,female,911-953-9604,Point Pleasant,United States,16840,New Hampshire,382 Falmouth,10/2/46,Diamond,2001,2316 8832721902,industry1849@yahoo.com,Mauro,Rojas,male,248-325-4006,Berwyn,United States,33024,Maine,298 Napoleon,7/25/38,Silver,2018,1222 8661369727,bardsley2030@outlook.com,Del,Landry,male,780-870-0840,Millville,United States,60154,West Virginia,18 Shipley,11/6/91,Gold,2004,2723 1643964612,chapfallen2036@gmail.com,Yvone,Jefferson,female,147-420-0550,DeSoto,United States,57094,Georgia,954 Sansome,9/15/53,Platinum,2008,2350 5854223847,unpurchasable2000@outlook.com,Garth,Hinton,male,603-441-7128,Ferguson,United States,10403,New Hampshire,281 Armory,4/8/62,Diamond,2017,2578 8965527527,amylan2015@yahoo.com,Margy,Randall,female,175-058-3633,Petersburg,United States,15730,Wisconsin,859 Zircon,10/11/53,Silver,2022,1073 2357204883,pityriasis1921@outlook.com,Russell,Garcia,male,426-329-1726,Burlington,United States,48924,Kentucky,817 May,8/11/43,Gold,2013,1759 4449358503,scriptures1932@live.com,Shavonne,Poole,female,107-150-0529,Newport,United States,18974,Kentucky,335 Aerial,3/22/97,Platinum,2016,1858 9712542032,caprice1872@yahoo.com,Annett,Tran,female,488-535-9408,Clifton,United States,98881,New Jersey,1057 Macarthur,1/29/48,Diamond,2009,1223 4172540346,clitia1984@yahoo.com,Sandee,Hinton,female,277-933-6241,Vernon Hills,United States,89437,Mississippi,564 Forest Side,8/14/49,Silver,2018,785 3867171452,espriella2026@yahoo.com,Fernanda,Keith,female,483-884-9937,East Point,United States,13448,Maryland,577 Sears,3/16/57,Gold,2017,1779 1541506962,locust1955@yahoo.com,Marivel,Townsend,female,944-146-9642,Nicholasville,United States,73383,Michigan,1017 Silverview,12/6/97,Platinum,2003,1495 4565188388,jotisi1958@yahoo.com,Maynard,Nunez,male,397-206-1594,Oregon City,United States,59296,Massachusetts,1265 Bayside,7/31/99,Diamond,2005,2132 2558570816,dustbox1820@yahoo.com,Alonso,Monroe,male,756-099-1123,Snellville,United States,31290,Kentucky,1116 Battery East,2/10/78,Silver,2009,996 7897469346,interscene2050@live.com,Isaura,Boyer,female,860-017-8470,Englewood,United States,23699,South Dakota,175 Rotteck,4/3/59,Gold,2010,1264 1698177346,coronet1813@yandex.com,Magaly,Smith,female,080-375-0225,Chambersburg,United States,31885,Missouri,707 Atoll,6/27/46,Platinum,2023,2948 6988398854,chaka1963@live.com,Chris,Fields,male,207-560-1693,Oak Ridge,United States,76769,Rhode Island,1239 De Montfort,11/13/99,Diamond,2021,1889 4318023468,scope2013@gmail.com,Tiny,Long,female,811-038-2107,Cleburne,United States,50481,Georgia,16 Mallorca,9/17/48,Silver,2014,2455 2343040151,cudgeled1997@yahoo.com,Toshiko,Wong,female,245-694-2681,Santa Maria,United States,18905,Missouri,360 Iowa,11/29/46,Gold,2018,2358 8241605794,meteorology1997@live.com,Brock,Pollard,male,951-758-5452,Westland,United States,00697,Missouri,166 Exposition,11/3/42,Platinum,2019,2613 2250544939,convolutedly1958@live.com,Chance,Herman,male,175-787-0995,Lemoore,United States,01487,Maryland,261 Dolores,1/15/82,Diamond,2020,1038 1216233373,rauwolfia2054@live.com,Darcel,Tate,female,409-110-6706,Cottonwood Heights,United States,14914,New Hampshire,306 Linda,2/28/51,Silver,2001,724 1641137821,ananda1801@outlook.com,Sanford,Sosa,male,801-511-0796,McMinnville,United States,17850,Alabama,311 Balance,3/9/88,Gold,2023,1166 5938144605,constitutions2013@outlook.com,Sal,Powers,male,282-277-8762,Jackson,United States,89448,Washington,837 Van Dyke,12/31/75,Platinum,2011,2318 7952129546,dowse2015@yahoo.com,Jeannetta,Maldonado,female,406-281-7786,San Jose,United States,55677,Ohio,1390 Montcalm,10/26/98,Diamond,2019,758 4752404655,hagmane1840@yandex.com,Fredric,Whitley,male,208-049-1054,Huntersville,United States,09217,West Virginia,1304 Camp,2/18/73,Silver,2005,2140 6218383139,borneo2047@live.com,Katherina,Woodard,female,376-330-3299,Elizabeth City,United States,24795,Mississippi,1362 Linden,5/31/59,Gold,2019,1896 5048020504,skipjack1867@yahoo.com,Marshall,Leonard,male,272-921-3764,Keizer,United States,95133,Utah,360 Marietta,9/19/76,Platinum,2009,2576 9679271006,craving1910@yahoo.com,Jimmie,Collins,male,365-606-0548,Kenner,United States,45126,Rhode Island,1030 Mauldin,7/12/77,Diamond,2008,1783 6980616459,coleridge2050@yandex.com,Magaret,Larsen,female,296-314-8615,Cicero,United States,95525,Tennessee,666 Vicente,6/17/47,Silver,2013,2425 8726784322,chien1984@live.com,Rory,England,male,918-377-1479,Morgantown,United States,59444,Mississippi,253 Gerard,10/7/93,Gold,2004,2645 2939270024,motivator1977@yahoo.com,Collin,Lloyd,male,136-433-3853,Norwalk,United States,84590,Connecticut,670 Ulloa,8/27/99,Platinum,2008,625 1642334836,buyable1925@gmail.com,Deja,Hurst,female,396-942-3092,Delaware,United States,96412,Mississippi,1009 Marlin,11/4/54,Diamond,2020,1952 1536194054,vibrational1802@live.com,Larae,Blackwell,female,223-734-7934,Charlotte,United States,90456,Kansas,269 Grafton,5/3/46,Silver,2000,700 5898905708,stad1979@yahoo.com,Russ,Holt,male,421-302-5543,Gardena,United States,29436,Minnesota,1006 Cyril Magnin,4/6/65,Gold,2019,1672 8281340778,abatis2048@live.com,Gene,Owens,male,507-632-0819,St. Peters,United States,92858,North Dakota,19 Aquavista,4/22/33,Platinum,2018,2994 4625875459,scandalisation1924@live.com,Kandace,Bridges,female,696-469-0710,Farmington Hills,United States,24269,Vermont,243 San Lorenzo,4/4/61,Diamond,2008,1000 5973371891,callery1944@live.com,Wade,Barrett,male,134-808-5993,Overland Park,United States,36287,Utah,727 Petrarch,10/22/68,Silver,2018,2665 7040700903,chinotti2001@gmail.com,Kenton,Deleon,male,034-346-5652,Hurst,United States,78875,Vermont,470 Martinez,12/29/74,Gold,2014,886 9945639388,sidetracked2054@live.com,Laverne,Gill,female,763-882-2438,West Palm Beach,United States,24334,New York,832 Cleveland,11/13/62,Platinum,2015,1836 2277895524,cebus1830@live.com,Reginald,Young,male,834-876-4997,Bergenfield,United States,48063,Hawaii,13 Manzanita,8/29/38,Diamond,2009,2461 6330499704,zorse1970@gmail.com,Virgil,Osborn,male,287-807-4687,Littleton,United States,92060,Michigan,553 Commer,4/2/83,Silver,2007,2633 2775711735,findings1879@yandex.com,Michael,Wyatt,male,809-172-2188,Palm Bay,United States,36447,Illinois,318 Wright,7/20/73,Gold,2002,877 7798253115,retort1804@live.com,Evelin,Sherman,female,996-250-4054,Corpus Christi,United States,91405,New York,419 Birchwood,11/6/51,Platinum,2019,1848 5391836093,mose1991@yahoo.com,Ryan,Moon,male,624-608-7198,Martinez,United States,56966,Louisiana,766 Shawnee,9/24/87,Diamond,2011,1664 7614641838,enchanter1946@live.com,Na,Trujillo,female,636-160-8364,Deerfield,United States,83812,Utah,548 Mint,12/13/54,Silver,2009,1675 1522047796,clipper1956@yahoo.com,Herman,Maddox,male,439-479-7283,University City,United States,47552,Indiana,1150 Rankin,4/25/81,Gold,2014,1598 8955699183,beaucoup1948@outlook.com,Rolf,Gibson,male,017-597-5429,Kankakee,United States,88724,North Dakota,78 Lake Forest,5/24/76,Platinum,2009,2579 2833533791,viva1933@outlook.com,Mel,Sawyer,male,616-272-6416,Portsmouth,United States,82639,Montana,1258 Arthur,4/21/67,Diamond,2020,1352 6203619068,abstruseness1892@yahoo.com,Bev,Gregory,female,713-572-4223,Cincinnati,United States,03171,Montana,1057 Columbia Square,1/12/47,Silver,2004,2456 1643143060,sculpt2022@live.com,Benny,Johnson,male,239-196-0672,Ramsey,United States,04641,Nevada,442 Miller,1/15/38,Gold,2001,2316 6744595606,christianson1890@gmail.com,Reinaldo,Tucker,male,252-144-2315,Port Arthur,United States,22688,Vermont,364 Carmel,3/10/67,Platinum,2018,1222 4882984618,attune1939@live.com,Dudley,Langley,male,513-689-2315,Billings,United States,14867,Alaska,1196 Macondray,3/17/39,Diamond,2004,2723 8218198946,axonophora1800@yahoo.com,Jama,Sanchez,female,966-416-6516,Fairhope,United States,76730,South Carolina,913 Lettuce,12/7/61,Silver,2008,2350 7340627937,carful1956@outlook.com,Erich,Campos,male,179-635-1240,Rochester Hills,United States,91594,Mississippi,1327 Beaver,4/5/35,Gold,2017,2578 5889865509,assays1866@gmail.com,Sherman,Kelley,male,833-601-8933,Bourbonnais,United States,66775,Connecticut,1287 Sunset,11/21/40,Platinum,2022,1073 7625551516,centrist1996@yahoo.com,Stanford,Harper,male,127-836-6701,Bettendorf,United States,93253,Delaware,466 Waterville,9/13/38,Diamond,2013,1759 7050884129,massekhoth1808@yandex.com,Wilbur,Vega,male,419-953-5669,McAllen,United States,08917,South Carolina,265 Anthony,1/1/88,Silver,2016,1858 4368229023,bourreau1840@gmail.com,Agustin,Parsons,male,086-203-7153,Watertown,United States,92508,Alabama,1225 Cambridge,4/16/88,Gold,2009,1223 9334526390,nonimposition1868@yandex.com,Booker,Pena,male,513-580-5418,Kentwood,United States,30011,Oregon,292 Vidal,6/2/77,Platinum,2018,785 1524290077,thob1910@gmail.com,Jordan,Macias,female,128-762-8937,Salinas,United States,60865,Arizona,239 Gloria,1/27/64,Diamond,2017,1779 6156318352,groggy1956@gmail.com,Robena,Schmidt,female,287-291-1629,Cutler Bay,United States,40602,Michigan,302 Hangah,7/26/52,Silver,2003,1495 4514993525,shmaltzier1817@gmail.com,Foster,Koch,male,009-780-2509,Saginaw,United States,68458,Kentucky,47 Adolph Sutro,4/16/44,Gold,2005,2132 8124246497,anent1950@outlook.com,Jerry,Dean,male,093-998-2845,Libertyville,United States,23367,Vermont,741 Buchanan,5/19/82,Platinum,2009,996 8201651070,biologists2041@yahoo.com,Merrill,O'donnell,male,786-783-9744,Laramie,United States,93696,Massachusetts,102 Scott,4/13/80,Diamond,2010,1264 1972198583,castling1942@yandex.com,Harold,Lawrence,male,363-561-0910,Wichita Falls,United States,79692,Iowa,572 Robert Kirk,7/21/72,Silver,2023,2948 8056941588,biabo1828@yahoo.com,Ezekiel,Poole,male,819-989-1070,San Mateo,United States,30226,Arkansas,217 Lyell,3/2/80,Gold,2021,1889 3700893418,retepora1917@yahoo.com,Delbert,Atkinson,male,532-694-6315,Monrovia,United States,36032,Washington,654 Jennings,6/4/92,Platinum,2014,2455 4650721513,heiress1942@yahoo.com,Laverna,Wolf,female,708-208-1181,Coppell,United States,26927,Arkansas,1246 Quint,5/31/50,Diamond,2018,2358 8334889595,spectrochemical1856@yahoo.com,Dudley,Branch,male,585-894-7124,Grandview,United States,86903,West Virginia,495 Coldspring,5/21/67,Silver,2019,2613 3442198788,blissfully1836@yandex.com,Dane,Sweeney,male,066-858-8958,Poway,United States,35817,Colorado,1035 Bruce,6/20/72,Gold,2020,1038 9903532822,byproducts1918@yahoo.com,Genaro,Jennings,male,191-701-2667,Hoover,United States,46229,Iowa,262 Colonial,8/3/73,Platinum,2001,724 2096344014,unseduceability1854@yandex.com,Eugenio,Hartman,male,987-736-0080,Sycamore,United States,69243,Illinois,280 Omar,12/14/67,Diamond,2023,1166 5051084236,basset1914@outlook.com,Jennine,Chase,female,742-052-6894,Providence,United States,75120,New Jersey,239 Geary,10/8/46,Silver,2011,2318 9439928726,betumbled2061@gmail.com,Maurice,George,female,281-634-4366,Elkhart,United States,93952,Alabama,1330 Farnsworth,6/11/59,Gold,2019,758 7532582939,mantoid1852@yandex.com,Jay,Wooten,male,375-055-7815,Lino Lakes,United States,09827,Idaho,385 Clara,1/28/83,Platinum,2005,2140 8622343816,gregariousness2005@gmail.com,Tristan,Lambert,male,262-450-9644,Bangor,United States,50762,Nevada,952 Galewood,9/17/36,Diamond,2019,1896 3215870267,unreportedly1898@outlook.com,Nga,Small,female,624-979-5670,Vestavia Hills,United States,61855,Florida,506 Auburn,7/27/55,Silver,2009,2576 3495228626,appointment1843@live.com,Kendrick,Barron,male,760-795-8804,Libertyville,United States,01403,Wisconsin,70 Carmelita,2/20/82,Gold,2008,1783 7849560446,axled2030@gmail.com,Madalene,Kerr,female,159-271-8857,Downey,United States,38241,Illinois,524 Windsor,6/16/55,Platinum,2013,2425 6730965918,tryptone1999@yandex.com,Lewis,Robertson,male,661-578-7759,Buena Park,United States,96313,South Carolina,1372 Stanley,11/23/42,Diamond,2004,2645 9040930453,cheryl1999@outlook.com,Sudie,Herrera,female,205-795-0091,Chelsea,United States,74589,Oregon,572 Hazelwood,8/13/46,Silver,2008,625 2485748620,censitaire1839@live.com,Olinda,Norton,female,137-104-9739,Deltona,United States,34385,West Virginia,780 Costa,7/22/54,Gold,2020,1952 3907636166,installation1855@yandex.com,Cletus,Kramer,male,984-693-9967,Hemet,United States,81752,Washington,902 Cochrane,4/5/71,Platinum,2000,700 2662883857,tyrantship2043@yahoo.com,Valentine,Kramer,female,937-236-9197,Ossining,United States,61589,New Mexico,702 Fair,3/17/95,Diamond,2019,1672 5467552090,suprastandard1812@yahoo.com,Elwood,Hopper,male,746-287-7606,Redmond,United States,01980,Virginia,834 Sunbeam,11/6/40,Silver,2018,2994 4001464129,majesty1800@outlook.com,Luci,Moore,female,251-231-2235,Enid,United States,56958,Alabama,163 Gonzalez,10/11/59,Gold,2008,1000 9577068630,countersink1967@outlook.com,Sanford,Carpenter,male,752-209-3382,Apache Junction,United States,58576,Iowa,1096 Castenada,9/5/33,Platinum,2018,2665 4422695802,scimitar2049@live.com,Walter,Mcgowan,male,660-175-1830,Anderson,United States,54466,Colorado,928 Crestlake,10/19/32,Diamond,2014,886 8549708073,exceedingly1936@gmail.com,Margarito,Spencer,female,035-306-3089,Shawnee,United States,51986,Alabama,546 Shipley,3/5/89,Silver,2015,1836 9857937514,chemosynthesis2039@yandex.com,Lonny,Mann,male,158-204-9740,Lathrop,United States,07524,Georgia,1061 Lucerne,1/9/81,Gold,2009,2461 8243410307,outlivers1930@yahoo.com,Kina,Mccoy,female,496-481-3989,Chelsea,United States,75384,Connecticut,1024 Coral,12/9/46,Platinum,2007,2633 6290144385,serines1845@yahoo.com,Monty,O'donnell,male,041-982-0083,Burlington,United States,84736,Maryland,309 Arbor,7/22/43,Diamond,2002,877 2313723474,pulsific2018@yandex.com,Marshall,Dalton,male,958-850-1298,Morgantown,United States,71828,Nevada,1152 Colon,12/13/93,Silver,2019,1848 1484619496,glowfly1960@outlook.com,Danilo,Livingston,male,373-097-2788,Muncie,United States,05639,Michigan,791 Merriam,2/4/94,Gold,2011,1664 7514957515,fastuousness2018@yahoo.com,Jorge,Joseph,male,265-262-7046,Bismarck,United States,63279,Nevada,417 South Hill,10/20/39,Platinum,2009,1675 7144675528,secateurs1987@gmail.com,Edwin,Bartlett,male,195-510-5972,Wheeling,United States,46564,Idaho,232 Beeman,11/22/87,Diamond,2014,1598 4433960773,ilicaceae1850@live.com,Kim,Young,female,845-605-7388,Menlo Park,United States,44998,New York,839 Child,7/29/89,Silver,2009,2579 6805293576,equilibrio2047@yandex.com,Rhett,Rush,male,171-161-2859,Melrose Park,United States,98166,Wyoming,1294 Scotia,7/28/89,Gold,2020,1352 1366337078,exaggerating1861@yandex.com,Annamaria,Copeland,female,311-758-2694,Parkland,United States,11349,Hawaii,459 Tubbs,1/7/50,Platinum,2004,2456 7656903711,exploiters1891@gmail.com,Carisa,Petty,female,280-132-2228,East Point,United States,77007,Arkansas,1022 Butte,12/3/57,Diamond,2001,2316 9731938469,bateman1843@live.com,Reuben,Griffin,male,482-042-0190,Laguna Hills,United States,21356,Colorado,982 San Leandro,5/7/79,Silver,2018,1222 5238180497,restipulatory1969@yandex.com,Alberto,Fisher,male,927-239-2185,Bergenfield,United States,01392,Wyoming,556 Kirkwood,1/10/38,Gold,2004,2723 3959064105,aerobatic1887@yahoo.com,Harold,Landry,female,033-176-2180,Copperas Cove,United States,75501,California,551 Meadowbrook,10/7/50,Platinum,2008,2350 1314114689,funambulatory2008@yandex.com,Emmanuel,Cook,male,877-007-7969,Santa Fe,United States,77610,Illinois,275 Forsyth,11/26/76,Diamond,2017,2578 9020973359,clatty1913@yandex.com,Jae,Lang,female,717-771-1138,Elmhurst,United States,21271,West Virginia,454 Kingston,4/17/59,Silver,2022,1073 7896930739,diploptera1855@yandex.com,Irwin,Ferguson,male,965-530-2916,Maple Valley,United States,20927,Illinois,1360 Clipper Cove,5/30/86,Gold,2013,1759 3504253176,rabbitmouth2066@yahoo.com,Keena,Charles,female,460-717-6416,Crystal Lake,United States,71794,Vermont,31 Seneca,12/9/52,Platinum,2016,1858 7795838507,aptness1800@yandex.com,Emanuel,Marshall,male,371-961-4487,Winona,United States,66961,Idaho,478 Welsh,11/27/77,Diamond,2009,1223 5229329292,insect1916@live.com,Carlton,Craft,male,464-428-2874,Gretna,United States,81304,Virginia,280 Halibut,9/7/68,Silver,2018,785 9744423187,hoidening1906@outlook.com,Lawanna,Small,female,384-908-4396,Costa Mesa,United States,97872,Mississippi,828 Moscow,12/25/51,Gold,2017,1779 2275215419,blotto1818@live.com,Diego,Gould,male,774-139-8915,Pinecrest,United States,54953,Minnesota,562 Rankin,9/30/93,Platinum,2003,1495 6095961583,combaz1985@gmail.com,Cristen,Mckee,female,208-905-3157,White Plains,United States,61766,Pennsylvania,158 Bedford,11/26/47,Diamond,2005,2132 5431795490,carful1911@yandex.com,Lionel,Velazquez,male,401-699-2087,Macon,United States,76879,Illinois,448 Wattson,12/20/85,Silver,2009,996 9695997284,landshard1997@yandex.com,Evia,Britt,female,980-749-8688,Cupertino,United States,85923,Kansas,23 Fredson,12/19/52,Gold,2010,1264 7582150256,amuck1812@outlook.com,Adolfo,Jacobson,male,079-660-8722,Santa Barbara,United States,40689,Alabama,1150 San Anselmo,5/2/86,Platinum,2023,2948 5722260947,echovirus1830@yahoo.com,Riley,Klein,male,457-381-5004,Fort Smith,United States,76724,Ohio,603 Bonifacio,12/25/63,Diamond,2021,1889 2418476636,thalamolenticular2054@outlook.com,Yong,Skinner,female,836-004-6249,Vicksburg,United States,28057,Utah,891 Webb,4/29/65,Silver,2014,2455 8756544399,apurba1945@yandex.com,Geoffrey,Chambers,male,047-649-2887,Los Gatos,United States,67856,Iowa,345 Dunshee,11/15/84,Gold,2018,2358 6803782140,misentreat2043@gmail.com,Shon,Aguilar,female,794-127-6599,Long Beach,United States,33597,New Mexico,376 Blatchford,5/14/84,Platinum,2019,2613 9302706637,airish2055@yahoo.com,Josphine,Silva,female,386-721-1721,Eagan,United States,22474,South Dakota,911 Gilbert,4/27/56,Diamond,2020,1038 3288277175,bribe1868@yahoo.com,Lyle,Glover,male,370-637-8458,Biddeford,United States,38721,Georgia,130 Alberta,6/11/39,Silver,2001,724 8570854622,chiefs1968@outlook.com,Allena,Potter,female,001-939-1318,Chapel Hill,United States,07551,North Dakota,633 Chumasero,1/23/46,Gold,2023,1166 2035264491,ectozoans2008@live.com,Elbert,Olson,male,228-644-3868,Kennewick,United States,89952,Idaho,847 Norwich,9/30/77,Platinum,2011,2318 8900739872,aouad1805@yandex.com,Dong,Bryant,male,876-634-3516,Carson City,United States,86177,Michigan,1322 Jasper,11/21/44,Diamond,2019,758 9779723602,pintada1930@live.com,Serafina,Paul,female,441-172-0021,Cliffside Park,United States,54424,New Mexico,257 Lillian,10/25/48,Silver,2005,2140 5178455312,neglectingly1845@yandex.com,Janay,Snow,female,769-330-2474,Colton,United States,22940,Massachusetts,778 Charlton,4/27/49,Gold,2019,1896 6919794639,underlain1984@yahoo.com,Gaylord,Lindsay,male,649-672-5569,Greenbelt,United States,29622,Mississippi,996 Minerva,4/6/68,Platinum,2009,2576 7657234232,blizz1821@gmail.com,Ludivina,Wilson,female,206-713-0251,Rochester Hills,United States,83946,North Dakota,1243 Bruce,6/4/50,Diamond,2008,1783 5952541805,ringtailed1897@yahoo.com,Jay,Coffey,male,859-816-8635,Pleasant Prairie,United States,98371,Vermont,1316 Vermont,5/10/74,Silver,2013,2425 6835663019,hepatolith1866@yahoo.com,Emilio,Casey,male,869-695-7244,Jonesboro,United States,75518,Louisiana,268 Naylor,9/11/76,Gold,2004,2645 7816165186,butcheress2029@yandex.com,Russell,Skinner,male,635-765-0081,Andover,United States,41473,Alaska,477 Pelican Cove,8/27/32,Platinum,2008,625 4231660066,animations2039@gmail.com,Toby,Rodriquez,male,793-181-3452,Hamtramck,United States,17946,Wyoming,1167 Acadia,3/23/69,Diamond,2020,1952 ``` ::: :::CodeblockTabsResponses ```javascript ``` ::: :::: This data is a sample representation of the CRM fields you would ingest to feed your business cases. ## Ingesting .csv data in Adobe Experience Platform 1. Navigate to the **Workflows** section in the left panel 2. Choose **Map CSV to XDM schema** 3. Click **Launch** in the right panel ::Image[]{src="https://adbecdn.azureedge.net/labs/archbee/toyotaaephandsonlabs/image392.png" size="50" isUploading="false" width="2534" height="490" darkWidth="2534" darkHeight="490" showCaption="false"} 4\. Select the **Existing Dataset** option 5\. Search and select your dataset by name from the dropdown 6\. Enable **Partial Ingestion**. Set threshold to the default 5% 7\. Update the **Dataflow** to include your initials ::Image[]{src="https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/vzQDXD3ND3iZ_DNGz3ukm_2024-06-17-09-46-15.png" size="50" width="2926" height="1716" position="center" showCaption="false"} 8\. Click **Next** 9\. **Upload the .CSV file downloaded from your local machine**. Drag & Drop or click Choose files to upload ::Image[]{src="https://adbecdn.azureedge.net/labs/archbee/toyotaaephandsonlabs/ScreenShot2023-09-13at10.47.07AM.png" size="50" isUploading="false" width="2852" height="1552" darkWidth="2852" darkHeight="1552" showCaption="false"} 10\. Review the sample data and then choose **Next** ### Mapping source columns to XDM schema fields 1. As you proceed into the field mapping step, a couple of things to note; - This mapping step is a requirement to ingest delimited files ONLY. Parquet and JSON formatted files can be dragged and dropped into the appropriate dataset since they are key value pairs and do not need to be explicitly mapped. - Adobe Experience Platform's AI has correctly mapped most of the source fields to the best matched XDM schema field. - **Fix the fields that are not mapped as desired**. - Remove any fields that are not required. ::Image[]{src="https://adbecdn.azureedge.net/labs/archbee/toyotaaephandsonlabs/ScreenShot2023-09-13at10.52.11AM.png" size="50" isUploading="false" width="2844" height="1558" darkWidth="2844" darkHeight="1558" showCaption="false"} 1. Click on **New field type** and choose **Add a Calculated Field** We will add a new field in the field mapping workflow using [data prep functions](https://experienceleague.adobe.com/docs/experience-platform/data-prep/home.html?lang=en). Data engineers can use calculated fields to perform in-row calculations that can be assigned to XDM attributes. - Copy \&paste the following **`first_name+" "+last_name`** - Map the calculated source field to the **`Full Name`** XDM field 2. Click **Finish.** This will start the data ingestion flow ### Validating the ingestion workflow 1. Navigate to **Datasets** 2. Search and select your newly created dataset ::Image[]{src="https://adbecdn.azureedge.net/labs/archbee/toyotaaephandsonlabs/ScreenShot2023-09-16at12.05.46PM.png" size="50" isUploading="false" width="1588" height="1200" darkWidth="1588" darkHeight="1200" showCaption="false"} - Notice a batch is created as a result of the ingestion workflow that was triggered ::Image[]{src="https://adbecdn.azureedge.net/labs/archbee/toyotaaephandsonlabs/ScreenShot2023-09-16at12.08.22PM.png" size="50" isUploading="false" width="2172" height="1208" darkWidth="2172" darkHeight="1208" showCaption="false"} 1. Once the status for the batch says **"Success"**, click on the **Preview Dataset** button on the top right of your screen. This allows for validation of source columns to XDM schemas with the corresponding values.