• Replies 6 replies
  • Subscribers 30 subscribers
  • Views 5060 views
  • Users 0 members are here

[Contextcapture] Convert pose metadata to CSV

Oto
Offline

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
  • in reply to Oto

    Dear Oto,

    Thank you for the converter. Please let me ask a question.

    After converted XML to CSV, x and y are all the same value, although z is correct.

    Do you think of any reason? I appreciate if you could check the attached screenshots. 

  • Offline in reply to Jos

    Need small example in xml format. Maybe related to negative values.

  • in reply to Oto

    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 

  • Offline in reply to Jos

    Fullscreen Transformed-csv.txt Download 
    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.

  • in reply to Oto

    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.

Communities
Support and Services
Training and Learning
Social Media