Microstation: Import kela wahi a me annotations

Ka hihia: Ua loaʻa iaʻu kaʻikepili i hoʻolahaʻia me Promark 100 GPS, a i ka hoʻohanaʻana i ka noi o GNSS ma hope o kēia mau polokalamu, hiki iaʻu ke hoʻouna i kaʻike i Excel.

Nā kolamu hoailono aku la ma ka melemele i na wahi hikina, ma ka akau a me ko lakou mau mooolelo; eia paha ka pono 'ike e pili ana i ka postprocessing.

Kapu: ʻImi au i kēlā poʻe hoʻohana me ko lākou mau polokalamu o Microstation e komo i kaʻikepili.

Slugs aoao e hana

Ināʻoe e hoʻokomo i nā kikowaena me Microstation me ka i no keia kauoha a, ʻo nā kiko wale nō ka hele mai, ʻaʻole ka lepili. Ma ke ala lōʻihi, lawe mai kahi mea hoʻohana iā lākou mai CivilCAD e hana kupaianaha ana, a laila mai Microstation ua wehe ʻia a ua hoʻohuli ʻia i ka tn kahi ke ʻano kahi e hana ai i kēlā me kēia lā ʻino. No laila… Aʻu i hele aku nae aneane, Mahalo wau ua noi mai ʻoe iaʻu i kahi manaʻo pehea e hana ai; ʻoiai i ka hohonu i lalo manaʻo wau hana lākou i mea e hōʻoia ai i ka ʻā ʻole nā ​​kauoha. ʻO ia wale nō nā kaʻina hana aʻu i wehewehe ai ma mua me ka AutoCAD.

Like concatenate kahi kūlike me kela aku

Vba makemake e ka maikaʻi, akā, me mau hoʻokahi lā mea, ke manao: kela aku e e oi hoʻomāhuahua ai ma mua o ka e payroll papa, 'aneʻi ke kaʻina hana hoʻohuiʻia Microstation kauoha (ki i) me kela kauoha (concatenated)

Hana ʻia kahi kiko me Microstation me ke kauoha "place point", a inā makemake ʻoe e kau iā ia ma kahi kikoʻī kikoʻī, e hoʻohana i ka "xy=", me ka hoʻohana mau ʻana i ka separator kauoha ʻo ia ka semicolon (;). No laila, ma ke komo ʻana i ke kauoha kahi wahi; xy = 388218.835,1566315.816 Oe E kikoo aku i ka maikaʻi wahi i kahi kūlike o.

I ka hihia o Excel, hana ke kauoha concatenate e like me kēia: concatenate command, open parentheses, a laila kuhikuhi i nā mea āpau e concatenated, a i ka hopena pani ʻia nā pākeke. Hoʻomaopopo au iā ia i kahi ala maʻalahi, akā ʻaʻole paʻakikī inā maopopo a hana ʻia ma hoʻokahi manawa.

ʻO ke kauoha Concatenate = CONCATENATE hamama parenthesis ( a laila,ʻo ke kauoha commando he kikokikona, me ka'ōmaʻomaʻu e wehe ai i ke kauoha "wahi wahi;" a laila ka pahu e hoʻokaʻawale i ke kaula hou , a lailaʻo ke kauoha ma nā hua'ōlelo e like me ka'ōlelo “xy=" ke'āpana e hōʻike i ke kaula hou , a maʻaneʻi mākou e koho i kēlā me kēia pūnaewele  C3 a laila ka pahu e hōʻike i ke kaula hou , a me ka helu i nā hua'ōlelo no ka kaʻawaleʻana o nā kūlana "," ke'āpana e hōʻike i ke kaula hou , kele e loaʻa ana ke kūkulu ʻākau a me ka semicolon hope D3,“;” a laila pani mākou i nā pale )

Makemake heluhelu:

= CONCATENATE(“wahi wahi ;", "xy =",C3, ",",D3, ";")

Once keia ua hana, wale mākou kope i ka haʻilula i na kolamu koena like penei:

hoonoho wahi; xy = 388218.835,1566315.816;
hoonoho wahi; xy = 388219.911,1566320.28;
hoonoho wahi; xy = 388216.28,1566320.868;
hoonoho wahi; xy = 388215.36,1566316.473;
hoonoho wahi; xy = 388211.706,1566317.245;
hoonoho wahi; xy = 388212.713,1566321.593;

Pehea e hoʻouna ai iā Microstation

Kēia kikokikona hiki ke mānewanewa kanikau a me ka hola i hala 'ana ma ka noho luna ana laina (kīʻaha hui uila ma) a me ka ike i ka mea e holo ana i nā mea nui.

Akā, au hiki i kope ia ma ka txt a CSV waihona i ke kapa hiki like kōmi'ōkuhi.

No ka laʻana, ua kapaia ka waihona puntosgeofumadas.txt, a ua mālamaʻia ma C; no laila e kāhea iā ia e kākau i ke ki i  @c: \ puntosgeofumadas.txt. ʻAʻole pono ka inoa i nā hakahaka, a ʻoi aku ka maikaʻi e waiho iā ia i kahi ala maʻalahi.

Pehea e Import annotations

Ke hana nei ia ma keʻano like, me kaʻokoʻaʻaʻole ka pane o ke kauoha akāʻo ka'ōnaehana kiʻi:  wahi kikokikona ikona

Concatenate like me, ia wahi aku kikokikona e kauoha ikona, ke kelepona hele i loaʻa ka annotation, kahi kūlike ma ke kikokikona ua kau:

=CONCATENATE(“kahi ikona kikokikona ;”,B3,”;”,”xy=”,C3,”,”,D3,”;”)

A laila ka mea, e ia ala e noho ai.

hoonoho kikokikona ikona; 10; xy = 388218.835,1566315.816;
hoonoho kikokikona ikona; 11; xy = 388219.911,1566320.28;
hoonoho kikokikona ikona; 12; xy = 388216.28,1566320.868;
hoonoho kikokikona ikona; 13; xy = 388215.36,1566316.473;
hoonoho kikokikona ikona; 14; xy = 388211.706,1566317.245;
hoonoho kikokikona ikona; 15; xy = 388212.713,1566321.593;

A malaila oe i mea:

E hoʻomāhuahua i ke ala hele, e hana like ʻoe, akā me ka laina wahi kauoha, me ke akahele e pono ke kaʻina i nā kiko; ʻaʻole kēia ka hihia. He laina kauoha ia, e hoʻomaka i ka hoʻohui, kahi hoʻonohonoho wahi.

Sure aia kekahi mau ala ʻē aʻe e hana ai, a wehe i nā papahana kumumanaʻo e hana kupaianaha ia. Akā pono ka hoʻoikaika kino e streamline i koʻu noʻonoʻo a i koʻu hihia, pale i kaʻu mau kauoha mai ka pala.