Excel Columns Name
Hi All,
One question. Whenever I download from my account on excel I have names of the columns I cannot decifer. I have posted here below an example. Can you help me to understand the meaning of the data of those columns?
"_id","uid","lac","did","last_req","fac","md5_did","hasInfo","name","username","email","organization","custom_firstName","custom_lastName","custom_companyID","custom_roles","custom_isProxyUser","custom_userRoles","custom_last-browser","custom_platform-language","custom_uhs","custom_uhs-class","chr_93dc80beabbde4661a621430aa4edb71_i","chr_93dc80beabbde4661a621430aa4edb71_o","chr_161eda16483017beb5ca68ca991ae9d1_i","chr_161eda16483017beb5ca68ca991ae9d1_in","chr_cc661525a5dede87603ba60f21f2a3ac_i","chr_cc661525a5dede87603ba60f21f2a3ac_in","chr_740eb737be2c311ea18112689cb2e253_i","chr_740eb737be2c311ea18112689cb2e253_o","chr_740eb737be2c311ea18112689cb2e253_in","chr_e876b6a73639ef08ce81c03cdd7fbf99_i","chr_e876b6a73639ef08ce81c03cdd7fbf99_in","chr_b356a9fdfa4536c541bad990e8a50b9f_i","chr_b356a9fdfa4536c541bad990e8a50b9f_in","chr_af6dfa43979e38116c94a3cbdb8a6752_i","chr_af6dfa43979e38116c94a3cbdb8a6752_in","chr_f8d02a2170bf8cf3ead1301f4d2daebf_i","chr_f8d02a2170bf8cf3ead1301f4d2daebf_o","chr_873c91d93cb43d81301096ed6a63cde8_i","chr_873c91d93cb43d81301096ed6a63cde8_in","chr_7c2cc348ee06ca4ea7d6828019302cd2_i","chr_7c2cc348ee06ca4ea7d6828019302cd2_o","cc","cty","loc_gps","loc_geo_type","loc_geo_coordinates","loc_date","rgn","av","brw","brwv","d","dnst","fs","la","lo","ls","mt","p","pv","r","sc","src","fsd","fsm","fsw","lsid","lv","lvt","vc","lvid","sd","tsd","cawfs","nxret_ad","nxret_aw","nxret_rd","nxret_rw","nxret_am","nxret_rm","camfs","cmfs","last_sync","sdk_name","sdk_version","hadAnyFatalCrash","hadAnyNonfatalCrash","ornt","chr_cf0977e86e39b0f9a569a250add7a6b9_in","chr_cf0977e86e39b0f9a569a250add7a6b9_i","chr_af6dfa43979e38116c94a3cbdb8a6752_o","lest","lbst","cwfs","c","cadfs","cdfs","merged_uid","tz","hos","hadNonfatalCrash","chr_c027b73654f50bd23ccfccc8612b3e50_i","chr_c027b73654f50bd23ccfccc8612b3e50_o","chr_873c91d93cb43d81301096ed6a63cde8_o","chr_c027b73654f50bd23ccfccc8612b3e50_in","hadFatalCrash","chr_f8d02a2170bf8cf3ead1301f4d2daebf_in","chr_7c2cc348ee06ca4ea7d6828019302cd2_in","merges","chr_cc661525a5dede87603ba60f21f2a3ac_o","chr_161eda16483017beb5ca68ca991ae9d1_o"
"baf3dfb0c946e39807b7c80771b0f9ae54cb1806","13J",1602773849923,"0927283a-097d-4596-91bb-caa7f6169e41","350303572f7c41c4218ea06822508a51a583c0a041731dabdddb9b5d56c1a1d95fbd1474a25d2939e7406a8c6c0ba9df910e2d27b16e1d9d8f78b1ef02a295661602773850818",1532510878020,"a87ce82a5f094f1522c8f4125632fcf6",true,"Lechner, Michael","0927283a-097d-4596-91bb-caa7f6169e41","m.lechner@mainova.de","Mainova AG","Michael","Lechner","723bf854-7fb2-4a82-af14-f087fdd2bcd2","Member, Trader, PriceScreenMember, EngreenMember, EngreenTrader, PriceScreenTrader","false","Member, Trader, PriceScreenMember, EngreenMember, EngreenTrader, PriceScreenTrader","Chrome 85","de-de",2,"unhappy",1532512801,1583510101,1571296987,"true",1571304421,"true",1602686102,1602205209,"true",1585726801,"true",1585726801,"true",1589790901,"true",1602661804,1602720012,1594189292,"true",1602664203,1602722102,"DE","Dietzenbach",false,"Point","8.7778, 50.0098",1602773842958,"DE-HE","0:0","Chrome","[chrome]_85:0:4183:121","Unknown","mw1:00",1583509136,"de","de-DE",1602773842,false,"Windows","mw10","1680x1050",431,"enmacc.de","20200306","202003","20200302","5f8863532b41b3475668807f",,1602767412,0,"5f884a34cc62117b092705f1",7,1965745,1,1,1,1,1,1,1,7,7,1602773851857,"javascript_native_web","20.04",1602773842,1602773842,"landscape",,,,,,,,,,,,,,,,,,,,,,,
"a260062b66637481c9e2ed12a8f02e3a06d47fad","15l",1602682857093,"98de5de0-f702-4922-bbd9-70af1af37001","7ca2f7401326e958dc59143620c06926e528d8b322a93607a217f9d5257bbb9fa9adced9a5cd46b32e040ff6a0f72a7a5e39d0ae3bd8590dd4d402aea1d620661602682857093",1532612873015,"10c14747e5ce548a0f1a82863b057085",true,"Reintges, Stefan","98de5de0-f702-4922-bbd9-70af1af37001","stefan.reintges@rhenag.de","rhenag Rheinische Energie AG","Stefan","Reintges","98ab26bd-bb94-423e-9a89-9f8ec35bf410","EngreenTrader, PriceScreenTrader, Trader","false","EngreenTrader, PriceScreenTrader, Trader","Firefox 81","de-de",5.5,"alright",1532613601,1532671200,,,1571304421,"true",1601545202,1601510405,"true",1532671200,"true",1537434204,"true",1602154503,"true",,,1594189292,"true",1598867095,1598867180,"DE","Frankfurt am Main",false,"Point","8.7537, 50.1506",1602676079045,"DE-HE","0:0","Firefox","[firefox]_81:0","Unknown","mw1:00",1532669245,"de","de",1602676079,false,"Windows","mw10","1920x1080",614,"iOS","20180727","201807","20180723","5f86e56fcc62117b0925e6d2","/entender",1602679794,4,"5f86f3f2cc62117b09260509",4104,1644623,7,,,,,,,10,10,1602682857111,"javascript_native_web","20.04",1602676079,1602676079,"landscape","true",1558947484,1600908602,1585045542,1572274887,6,"Telekom:de",,,"8xU",60,,,,,,,,,,,,
"2ee8c95383f7519fce89cd67fddfc9445eef7a37","1LZ",1602770969356,"5c3918d5-a4e7-4959-bde7-940dd0e27c6c","321b582119d7d2404700c3cc24396ba7c854cc9bd0e134537a75e90c2b50abbb22e760ab75162576396167ad8fe67af54799b83590621413befd4b331d9792331602770969356",1537436503298,"378f32a71afe7ce9bbfc71678cf391e9",true,"Schwabe, Florian","5c3918d5-a4e7-4959-bde7-940dd0e27c6c","florian.schwabe@hamburgenergie.de","HAMBURG ENERGIE GmbH","Florian","Schwabe","fa1dc4c3-6b85-46f1-8666-f3eddbcc629d","PriceScreenMember, EngreenTrader, PriceScreenTrader, Trader","false","PriceScreenMember, EngreenTrader, PriceScreenTrader, Trader","Firefox 78","de-de",5,"alright",1537437600,1537441201,1571296987,"true",1571304421,"true",1601641202,1602721204,,1588751701,"true",1588751701,"true",1602675902,"true",1600759501,1601648102,1594189292,"true",1600760103,1601648102,"DE","Hamburg",false,"Point","9.9116, 53.566",1602768164331,"DE-HH","0:0","Firefox","[firefox]_78:0","Unknown","mw1:00",1537437827,"de","de",1602768164,false,"Windows","mw10","1920x1080",124,"enmacc.de","20180920","201809","20180917","5f884d24cc62117b09270ab2","/entender",1602768167,2,"5f884d294970ab7b0bd62df4",245,131021,,,,,,,,,,1602770970251,"javascript_native_web","20.04",1602768164,1602768164,"landscape",,,1596932101,1537454779,1537448836,,,,,,,,,,,,,,,,,,
"d43f845f35f888a5cb3532ea00e942cb31347c5d","1bV",1602770087524,"52768949-2b76-4977-b028-d96b9d3fb2c7","9726ce272ed9029f9b0bf5aabbd484f3a54971cb553fe0df24ddb235a4a3d3aa1a52ca0b42d556662775472091627dda16839374f4ae1a277ce9a6e5a74431581602770088450",1533559057419,"02273f04af9291d88558c5967a2a8fff",true,"Tersteegen-Dörrenberg, Johanna","52768949-2b76-4977-b028-d96b9d3fb2c7","Johanna.Tersteegen-Doerrenberg@deutschebahn.com","DB Energie GmbH","Johanna","Tersteegen-Dörrenberg","56ddc30e-6b24-4d90-9315-e04fab986f32","EngreenTrader, PriceScreenTrader, Trader","false","EngreenTrader, PriceScreenTrader, Trader","Chrome 86","en-gb",5,"alright",1533560401,1540288802,,,1571304421,"true",1602670503,1601425504,"true",1540288802,"true",1540288802,"true",1600158003,"true",,,,,1598867095,1598867180,"DE","Unknown",false,"Point","9.491, 51.2993",1602766871424,"Unknown","0:0","Chrome","[chrome]_86:0:4240:75","Unknown","mw0:83",1540285659,"de","de-DE",1602766871,false,"Windows","mw10","1536x864",721,"enmacc.de","20181023","201810","20181022","5f8848184970ab7b0bd62498",,1602766906,1,"5f88483ccc62117b09270182",1257,924576,3,,,,,1,1,2,1,1602770089631,"javascript_native_web","20.04",1602766871,1602766871,"landscape","true",1558947484,1591491301,1575277916,1575277904,7,,3,1,,,,,,,,,,,,,,
"dc70f5dc7f69f08024640e71bd99d72c11116d9d","1en",1602513315967,"81b429bb-039d-4090-ae72-b55cec4ac1b6","3e4d2b8d7668b18f3bca526481a3e6569c1064eba10d191482de82497a715fe300d883fc80271824ed174fdbb14d7bae7afd49e5eece27f183091f076c4101b81602513342110",1533736854793,"5adff05ed23f3ab8fd9231504def7475",true,"Bauer, Marc","81b429bb-039d-4090-ae72-b55cec4ac1b6","bauer@naturstrom.de","NaturStromHandel GmbH","Marc","Bauer","27da638d-1d9d-44f3-982f-69972cf13ac7","EngreenTrader, Trader, PriceScreenTrader, CompanyAdmin","false","EngreenTrader, Trader, PriceScreenTrader, CompanyAdmin","Firefox 81","de-de",0,"unhappy",1533740401,1539090000,,,1571304421,"true",1548770401,1549839601,,1539669601,"true",1539669601,"true",1600846802,"true",,,1594189292,"true",,,"DE","Düsseldorf",false,"Point","6.7861, 51.2278",1602508644670,"DE-NW","0:0","Firefox","[firefox]_81:0","Unknown","mw1:00",1539087155,"de","de",1602508644,false,"Windows","mw10","1920x1080",229,"Windows","20181009","201810","20181008","5f8457644970ab7b0bd33c7f","/pricescreen",1602508774,1,"5f8457e6cc62117b092419df",3602,498439,10,,,,,,,10,10,1602513315969,"javascript_native_web","20.04",1602508644,1602508644,"landscape","true",1558947484,1598489401,1570456742,1570456743,10,,3,2,,,true,,,,,,,,,,,
"f3e5b3f59927ce95f1c7a12e2c2197328658ee04","1iY",1602772678238,"459aff8e-ddce-49db-b13e-1596efcffa1a","5ed5e3c99e409668fd68f5713b19a90a3faeb5fe6deae21b92c160c504d660e0404d7239f0dce9fb4a3fe3ca6947b3c1607de95e67d4e4381f732b525be3a9f41602772678238",1534252425986,"11044f06f5a5cb8de8e1fb9e3aa9e036",true,"Rathert, Henning","459aff8e-ddce-49db-b13e-1596efcffa1a","H.Rathert@stadtwerke-soest.de","Stadtwerke Soest GmbH","Henning","Rathert","c8bb8c08-3c66-4710-9d2a-94d60e533ae8","Price...
Comments
Hi Alberto!
Thanks for reaching out.
The column names in the Excel file are the field names of the 'users' collection. You can see the list of all the possible fields and their description here.
Please let me know should you have any questions.
Hi Subodh,
Thank you a lot for your kind and quick help. Really appreciated.
Have a wonderful day,
Alberto
Please sign in to leave a comment.