[Contextcapture] Convert pose metadata to CSV

XSL Transform

Attaching two XSL stylesheets for extracting Photo positions and rotation as CSV when exported from Contextcapture as BlockSexChange XML or KML format. After transformation the photo positions are ready for importing using "Import positions" tool. This could be used to simplify merging of blocks if some photos are originally without GPS coordinates.

Convert exported XML or KML to CSV using provided stylesheets. You can use it in MS Excel or any other XML editor or do an online XSL transformation.

Convertor for KML - 8154.Contextcapture-KML2CSV.xsl

Convertor for BlocksExchange XML - Contextcapture-XMLPose2CSV.xsl

Bonus:Automatic tie point export

Also adapted a XML-Sorter utilty to convert Automatic Tie Points from XML to CSV/TXT as exported block is too large to be converted with XML editors. This can be used to export sparse AT Points from block as ASCII Point Cloud without creating reference model first. In some cases if only  terrain height points are needed and not full 3D model this could be useful.

XML-Sorter_v0.4public.zip

Usage: Drag&Drop exported XML on XML-Transform.cmd which will produce transformed.csv file

Now available as Python script also without need to export block: 
https://communities.bentley.com/products/3d_imaging_and_point_cloud_software/f/contextcapture-descartes-pointools-forum/180665/python-api-contextcapture-automatic-tie-point-export

Parents Reply Children
  • Here is a small sample in xml. It does not include automatic tie points.The version is ContextCapture Center v4.4.12.333. Many thanks!

    02_kurose2 - AT - export.xml 

  • D:/cc/kurose/kurose_photo/P1000208.JPG,44220.8895530065,-184874.291528629,297.117303692736,0.95022729527813,-0.311028001496913,0.0181568057005534,-0.311484678633906,-0.949650632688644,0.033778259434002,0.00673663749533342,-0.037752590889829,-0.999264409251306
    D:/cc/kurose/kurose_photo/P1000209.JPG,44220.0607974182,-184878.822685061,297.737300882116,0.951705227685324,-0.306281689821913,0.0211822113165421,-0.306836240933364,-0.951232626273924,0.0317492041143518,0.0104250106142788,-0.0367153536255009,-0.999271385541409
    D:/cc/kurose/kurose_photo/P1000210.JPG,44217.3113094294,-184888.081530879,298.390837297775,0.95438228820522,-0.297645033637259,0.0237040484146621,-0.298304734528437,-0.953923069476773,0.0323274322817642,0.0129897389538284,-0.0379237586624539,-0.999196204561859
    D:/cc/kurose/kurose_photo/P1000211.JPG,44213.621407826,-184899.349883077,297.585621964186,0.955524589494048,-0.293744546623752,0.0262087809910976,-0.294524760013603,-0.955045345767483,0.0338164644337494,0.0150971722902771,-0.0400315982278506,-0.99908435406234
    D:/cc/kurose/kurose_photo/P1000212.JPG,44208.4830622728,-184912.072377583,297.771281777881,0.955569056474164,-0.293489740965598,0.0274144169557524,-0.294340890580808,-0.955051854799149,0.0352050390825374,0.0158498719608109,-0.0417100298807465,-0.999004031506467
    D:/cc/kurose/kurose_photo/P1000213.JPG,44203.414453796,-184923.249205294,296.867175316438,0.95622192938362,-0.291651810921176,0.0240591552691782,-0.292386784968195,-0.955588228627843,0.0368931603940764,0.0122306885264175,-0.042312628071289,-0.999029555000186
    D:/cc/kurose/kurose_photo/P1000214.JPG,44198.2461705068,-184934.022586895,296.39394979272,0.956831416966703,-0.289761522932641,0.0226251924466532,-0.29043189791247,-0.956203277854321,0.036395110875131,0.0110883804250941,-0.0413950630922286,-0.999081326304891
    D:/cc/kurose/kurose_photo/P1000215.JPG,44193.1084699912,-184946.715173656,296.771529647522,0.957882012900866,-0.286233155755311,0.0230787761231008,-0.286921982549392,-0.957270905429828,0.0361689030450445,0.0117399016567825,-0.0412673498532574,-0.999079166305242
    D:/cc/kurose/kurose_photo/P1000216.JPG,44190.6293666383,-184954.085301908,297.646879589185,0.95819862410025,-0.285204162516159,0.0226711811744566,-0.285867448785949,-0.957616817371254,0.0353529745900623,0.0116274888519164,-0.040356124333355,-0.999117703142023
    D:/cc/kurose/kurose_photo/P1000217.JPG,44187.1738399771,-184964.29962258,297.78107597772,0.958461157292651,-0.284363630377635,0.0221254532085466,-0.28498017411285,-0.957960056536773,0.0331486114742864,0.0117690409057558,-0.0380769720239856,-0.999205501324748
    D:/cc/kurose/kurose_photo/P1000218.JPG,44183.3465812625,-184974.17192069,297.687489405274,0.958578336134885,-0.283832241119437,0.0238082421441203,-0.28449326410437,-0.958155123786752,0.0316597763800441,0.0138259239154564,-0.037121660284953,-0.999215105052748
    D:/cc/kurose/kurose_photo/P1000219.JPG,44178.8576882373,-184983.921309841,296.892051559873,0.95934687318629,-0.281051884385927,0.0257568474547487,-0.281785750142828,-0.958957377334215,0.0315838482887876,0.0158230188058798,-0.0375577786803882,-0.999169177535248
    D:/cc/kurose/kurose_photo/P1000220.JPG,44174.2919706699,-184994.608818688,296.464705733582,0.960160764147214,-0.27837811885219,0.024432149650738,-0.279060791395438,-0.959760159106706,0.03139286060909,0.0147099183543633,-0.0369602480482173,-0.999208465920012
    D:/cc/kurose/kurose_photo/P1000221.JPG,44210.1290373201,-185019.617992653,297.638239236549,0.961834831933299,-0.272710152477112,0.0224260744615083,-0.273372452497039,-0.96125421364099,0.0354660256188484,0.0118852133172784,-0.0402431297658712,-0.999119228226067
    D:/cc/kurose/kurose_photo/P1000222.JPG,44209.8805221155,-185013.359299403,297.075207169168,0.962610317215999,-0.2700937816465,0.0207539467380848,-0.270719371307392,-0.961895216228066,0.0383225129198577,0.00961244964849449,-0.0425081417313802,-0.999049877983226
    D:/cc/kurose/kurose_photo/P1000223.JPG,44213.2811138277,-185001.110728334,297.579334910959,0.960994857271623,-0.275961920347833,0.0182730078374584,-0.276482115235374,-0.960232832023122,0.0388657723431176,0.00682086889373522,-0.0424019672042386,-0.999077348819772
    D:/cc/kurose/kurose_photo/P1000224.JPG,44216.844912214,-184992.519786692,297.590464059263,0.96024024019938,-0.278573858580644,0.0183108278712277,-0.279096338654476,-0.959459491618029,0.0392774451019963,0.00662682816318099,-0.0428262683357514,-0.999060556667579
    D:/cc/kurose/kurose_photo/P1000225.JPG,44220.719838763,-184985.254981911,297.198281012475,0.959937263954169,-0.279499197950913,0.0200161838766075,-0.280091650458815,-0.959182897262454,0.0389465908965662,0.00831364032438982,-0.0429926498834778,-0.999040797685737
    D:/cc/kurose/kurose_photo/P1000226.JPG,44224.1648603265,-184977.534787731,297.126555554569,0.96019658303239,-0.278522465541323,0.0211602958794474,-0.279166662813701,-0.959445595652512,0.0391167912341846,0.00940724754562894,-0.0434670584670724,-0.999010569774833
    D:/cc/kurose/kurose_photo/P1000227.JPG,44227.5600036503,-184969.266155812,297.069381573237,0.960624026376159,-0.276949072175439,0.022376133938195,-0.277653089807534,-0.959863211806069,0.0396405895726442,0.0104996032870884,-0.0442925054890851,-0.998963428904339
    D:/cc/kurose/kurose_photo/P1000228.JPG,44230.8464919576,-184957.655336376,297.32325729914,0.961279649633621,-0.274755778747818,0.0212296312955045,-0.27541539305598,-0.960488125350819,0.0401113740464176,0.00936997695213934,-0.0444052148373483,-0.99896965941272
    D:/cc/kurose/kurose_photo/P1000229.JPG,44233.8951454966,-184947.337785349,297.378935683519,0.96127897519295,-0.274832456764945,0.0202448156459079,-0.275461178830768,-0.960408777723831,0.0416667568713881,0.00799192149333907,-0.0456300381279752,-0.998926438138106
    D:/cc/kurose/kurose_photo/P1000230.JPG,44236.59746404,-184938.854332857,297.355699727312,0.960845558475561,-0.276370385882672,0.0198802053523244,-0.276984158994456,-0.959952846038278,0.0420750406909325,0.00745576447600737,-0.0459341179307114,-0.998916647366538
    D:/cc/kurose/kurose_photo/P1000231.JPG,44239.485223801,-184930.15533419,297.449655548669,0.963215718299169,-0.268062317685719,0.0189228395960033,-0.268640135432536,-0.962320268665002,0.042097246362529,0.00692514665580442,-0.0456321635853385,-0.99893430614346
    D:/cc/kurose/kurose_photo/P1000232.JPG,44241.9613593367,-184921.838230368,296.978583431803,0.964124299976484,-0.26476076205298,0.0191330361411991,-0.265347293904372,-0.963256690165096,0.0415615503778667,0.00742615731603247,-0.0451474000282403,-0.998952733845905
    D:/cc/kurose/kurose_photo/P1000233.JPG,44244.6689267567,-184912.572023286,296.688928284682,0.964440404080799,-0.263586044407552,0.0194191701688629,-0.264186317661079,-0.963577101945016,0.0415302078964639,0.0077650844906376,-0.0451836895441707,-0.998948516021737
    D:/cc/kurose/kurose_photo/P1000234.JPG,44247.7668830097,-184901.529357608,296.395365444943,0.964389087591585,-0.263794342314734,0.0191372071370772,-0.264385839619418,-0.963498142601434,0.0420886803347545,0.007335907783351,-0.0456494706028746,-0.998930583319317
    D:/cc/kurose/kurose_photo/P1000235.JPG,44251.8682714848,-184888.029502915,296.308903728612,0.965911530585734,-0.258146082122879,0.0193782188586381,-0.258754096513876,-0.965024094323051,0.0421285522331666,0.0078251273991495,-0.0457066478817132,-0.998924256247992
    D:/cc/kurose/kurose_photo/P1000236.JPG,44257.0354623952,-184874.303806994,296.887737651356,0.967786747789799,-0.251003309798873,0.0196506812211371,-0.251637098822724,-0.966868485180988,0.0429430187563091,0.00822078454446672,-0.0465045248748217,-0.998884251486448
    D:/cc/kurose/kurose_photo/P1000237.JPG,44260.3728351302,-184868.341913078,297.381440140307,0.969131513431144,-0.245463082529866,0.0230647954596665,-0.246267492957535,-0.968229972604056,0.0433940325800705,0.0116803932755255,-0.0477346338216354,-0.998791756647422
    D:/cc/kurose/kurose_photo/P1000238.JPG,44296.9208557011,-184869.811359158,296.528137399815,0.982709273191501,-0.183856511947017,0.0218921766416359,-0.184667829305512,-0.981820968881201,0.0438791281222667,0.013426734637373,-0.0471632068444934,-0.998796953698359
    D:/cc/kurose/kurose_photo/P1000239.JPG,44293.5025218474,-184875.868216494,297.183263854124,0.9841358287271,-0.176124421095778,0.0213742580994726,-0.176949948041144,-0.983130523931739,0.0462935071251025,0.0128602684210852,-0.049341272859366,-0.998699180078143
    D:/cc/kurose/kurose_photo/P1000240.JPG,44289.538998983,-184881.436678407,296.896135879681,0.983553146211159,-0.179629744709548,0.01887758972198,-0.180349159760536,-0.982415792662784,0.0483051850262746,0.00986859421586401,-0.0509152741555675,-0.998654217287378
    D:/cc/kurose/kurose_photo/P1000241.JPG,44288.4056991607,-184886.399947232,295.785965281539,0.982735036214071,-0.184032269447774,0.0190780606778945,-0.184746570567717,-0.98164844887681,0.0472760772613451,0.0100276248830391,-0.0499844637828114,-0.998699654610709
    D:/cc/kurose/kurose_photo/P1000242.JPG,44285.9515777637,-184900.527594371,295.858258034103,0.983491847911632,-0.179687176144957,0.0213612691667451,-0.180501938032337,-0.982508427285819,0.0457847210204191,0.0127606997431044,-0.0488846503659193,-0.998722912273804
    D:/cc/kurose/kurose_photo/P1000243.JPG,44283.3781440889,-184912.225163322,296.330202377401,0.982915373358283,-0.182889017624813,0.0207117369666917,-0.183653159749947,-0.981983790505861,0.0444899100651186,0.0122018740284859,-0.0475335925001747,-0.998795110047211
    D:/cc/kurose/kurose_photo/P1000244.JPG,44280.3109550912,-184923.551414322,296.928312716074,0.979869793990348,-0.198531892229616,0.0209827212973124,-0.199271560041021,-0.979017782706033,0.0426031278685157,0.0120843776889968,-0.0459267777346881,-0.99887171293554
    D:/cc/kurose/kurose_photo/P1000245.JPG,44277.0903131723,-184934.915843923,297.286346377805,0.97918515881157,-0.201819556971616,0.0215706093317344,-0.202565779537045,-0.978401196504895,0.0412092664135157,0.0127878740888077,-0.0447209693719988,-0.998917666864852
    D:/cc/kurose/kurose_photo/P1000246.JPG,44273.9453329359,-184945.135851178,297.223889207467,0.978653443432399,-0.204317986135742,0.0221720138765809,-0.205074792833773,-0.977923035528319,0.040135594268233,0.0134820993207159,-0.0438257586872596,-0.998948214810654
    D:/cc/kurose/kurose_photo/P1000247.JPG,44269.622062427,-184955.751651561,296.331576865166,0.978516800012327,-0.204993629252927,0.0219655197832753,-0.205741724955875,-0.97778032571832,0.0401992195242433,0.0132368691848541,-0.0438548355816191,-0.998950218324363
    D:/cc/kurose/kurose_photo/P1000248.JPG,44266.4154945423,-184965.288675492,296.004432465881,0.97843422220691,-0.205322811363456,0.0225613817876538,-0.206096893758139,-0.977705358823452,0.0402032549820533,0.0138037385373737,-0.0439860712238783,-0.998936775947647
    D:/cc/kurose/kurose_photo/P1000249.JPG,44263.8428459445,-184974.477876949,296.166540416889,0.978351177252351,-0.205671121711649,0.0229861624202978,-0.206471229783998,-0.977604237738174,0.0407380120753126,0.0140927371515893,-0.0446020632957352,-0.998905426308887
    D:/cc/kurose/kurose_photo/P1000250.JPG,44260.067449535,-184983.436267056,296.295225926675,0.978345587452049,-0.205696138619129,0.0230002189182534,-0.206498618591466,-0.977593234862012,0.0408630355191869,0.0140794897962764,-0.0447276839240133,-0.998899996124672
    D:/cc/kurose/kurose_photo/P1000251.JPG,44256.669389933,-184992.327746899,296.561545623466,0.978688566716139,-0.204241004679986,0.0213143469620492,-0.204972460035896,-0.977904434815073,0.0410999634530808,0.0124490965914074,-0.044592918454851,-0.99892767086398
    D:/cc/kurose/kurose_photo/P1000252.JPG,44253.5180329251,-185002.880400261,296.249657985754,0.978348109624061,-0.205802439309002,0.02191648624871,-0.206556483533585,-0.97758096456256,0.0408641265069185,0.0130152028514811,-0.0445063332504283,-0.998924316850549
    D:/cc/kurose/kurose_photo/P1000253.JPG,44275.921660137,-185019.421817561,298.260464147665,0.977681074406099,-0.209118973366627,0.0202230493799448,-0.209794909013409,-0.976892370048878,0.0408337298362803,0.0112166349762972,-0.0441650576629819,-0.998961277918936
    D:/cc/kurose/kurose_photo/P1000254.JPG,44279.0404483166,-185008.109986216,298.341132173315,0.979651767263867,-0.199723810856968,0.0198195427180674,-0.200397712644025,-0.978832476189466,0.0415660958455247,0.0110982730109552,-0.0446920902796795,-0.998939160010563
    D:/cc/kurose/kurose_photo/P1000255.JPG,44281.47104575,-184996.426191826,297.161230229773,0.977309865873178,-0.210905376437001,0.0196048018841922,-0.211564267672323,-0.976463209300906,0.0419542789956892,0.0102949847608177,-0.045150006331574,-0.998927169626011
    D:/cc/kurose/kurose_photo/P1000256.JPG,44284.4237965436,-184984.243574426,296.923619249836,0.986447319167552,-0.163075185155601,0.0181154766323321,-0.163732179677342,-0.985515956917734,0.0441596195480728,0.010651753154131,-0.0465272247935617,-0.998860229215156
    D:/cc/kurose/kurose_photo/P1000257.JPG,44287.2645302852,-184972.020364564,296.904240312055,0.984391990099207,-0.174980333408401,0.0188226658262971,-0.175662717986773,-0.983444206373088,0.0444983422242409,0.0107247068968505,-0.0471102522970394,-0.998832120423891
    D:/cc/kurose/kurose_photo/P1000258.JPG,44290.5403171494,-184957.72364727,296.930613955483,0.983837973194624,-0.178135303108176,0.0181839568535694,-0.178787556846624,-0.982867235044667,0.0447996405394959,0.00989201784819916,-0.0473266527678799,-0.998830484076592
    D:/cc/kurose/kurose_photo/P1000259.JPG,44293.3373929805,-184947.250024314,296.332706516609,0.984006196171069,-0.177092184559599,0.0192396482517511,-0.17780869195706,-0.982988931308333,0.0460090207439997,0.0107645232807342,-0.0486941381812168,-0.998755728867338
    D:/cc/kurose/kurose_photo/P1000260.JPG,44294.451153736,-184938.222755023,296.034975616261,0.982027094121524,-0.187590741672492,0.0207966355451946,-0.188367670605283,-0.981039665853054,0.0455938010442987,0.0118493494325581,-0.0486917617435632,-0.998743563311591
    D:/cc/kurose/kurose_photo/P1000261.JPG,44296.1622197532,-184929.863931382,296.449264152907,0.982142985599985,-0.186888467272041,0.0216299939309828,-0.187711081438354,-0.981149577914805,0.0459353421979756,0.0126374737186872,-0.0491752636831667,-0.998710212073402
    D:/cc/kurose/kurose_photo/P1000262.JPG,44297.4987959436,-184922.235531241,296.748367845081,0.982270279545194,-0.186232506075982,0.0215070128764616,-0.187059286735106,-0.981237974187964,0.046699692265099,0.0124064970222268,-0.0498948062643873,-0.998677418959434
    D:/cc/kurose/kurose_photo/P1000263.JPG,44298.3994117428,-184913.562434831,296.529942967929,0.982425561013911,-0.185425695814236,0.0213852378595225,-0.186234030251149,-0.981444913248317,0.0456373557014166,0.0125260944797767,-0.0488179638126133,-0.998729144145837
    D:/cc/kurose/kurose_photo/P1000264.JPG,44298.9634954093,-184903.294951027,296.609470715746,0.982533717440987,-0.184971861329335,0.0203200543295871,-0.185727082643237,-0.981547673393011,0.045493028362597,0.011530171916688,-0.0484724186845368,-0.998757968560173
    D:/cc/kurose/kurose_photo/P1000265.JPG,44300.5812922666,-184890.872280092,296.622408418916,0.982737270131411,-0.183984780342649,0.0194179941530707,-0.184697132220051,-0.981742909569313,0.0454733862832865,0.0106970670910691,-0.0482748393332056,-0.998776808222439
    D:/cc/kurose/kurose_photo/P1000266.JPG,44303.2548184624,-184876.789247729,296.635143753141,0.983033915911104,-0.182450870821748,0.0188679597431292,-0.18313496718944,-0.982050270138648,0.0451536345506467,0.0102909650181721,-0.0478429373784305,-0.998801856917576
    
    

    Looks correct. Not sure why it didn't work for you. Maybe it is because of editing in Excel.

  • Thank you very much for checking the data. Without using Excel, in the online XSL transformation you indicated, the XML was correctly transformed! Best regards, Jos.