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.

MicroStation kahi kūlike kela aku

Slugs aoao e hana

Ināʻoe e hoʻokomo i nā kikowaena me Microstation me ka i no keia kauoha a, aia wale nā ​​mea e hiki mai ana,ʻaʻole nā ​​hōʻailona. No ka lōʻihi lōʻihi, ua hoʻokomo mai kekahi mea hoʻohana iā lākou mai CivilCAD, a hana maikaʻiʻo ia, a laila ua weheʻia mai ka Microstation a hoʻololiʻia i kahi o ka manawa e hana ai i kēlā me kēia lā. No laila ... Aʻu i hele aku nae aneane, Ke mahalo nei au ua noi maiʻoe iaʻu no kekahi manaʻo pehea e hana ai; me ka hohonu e noʻonoʻo wau ua hana lākou i mea e hōʻoia aiʻaʻole i hoʻoholoʻia nā kauoha. ʻO ka pololei wale nō ia i wehewehe muaʻia e aʻu 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)

Hoʻomumuʻia kahi helu me Microstation me ke kauoha "wahi wahi", a inā makemakeʻoe e kau ia i kahi kikowaena maʻamau, e hoʻohana i "xy =", e hoʻohana mau i ka mea wehewehe kauohaʻo ia ka semicolon (;). No laila, i 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: kauoha concatenate, wehe i nā mākua, a laila e kuhikuhi i nā mea a pau e hoʻokomoʻia, a me ka lā palena pale. Ke wehewehe maopopo nei au, akāʻaʻole paʻakikī ke hoʻomaopopoʻia a hanaʻia i 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 «Kau 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 , kelepona e loaʻa ana ka coordinate'ākau a me ka semicolon whakamutunga D3,"A laila pani mākou i nā pale )

Makemake heluhelu:

= MAKAHIKI («wahi wahi ;«, »xy =",C3, »,",D3, »;«) Kauha

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.

MicroStation kahi kūlike kela aku

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ā wahi āpau, a maikaʻi e kau ma kahi alalahi.

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 ("e kau i ka 'ōlelo' ōlelo;", 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:

MicroStation kahi kūlike kela aku

No ka hoʻomohalaʻana i ke ala, e hanaʻia ka mea hoʻokahi, akā me ke kauoha o ka laina laina, me ka mālamaʻana i nā mākia e pono ke holo; ʻaʻole kēia hihia. E hoʻokau i kahi kauoha laina, e hoʻomaka i ka pilikino, i ka hoʻonohonohoʻana i ka makamua ...

Loaʻa aia kekahi mauʻano'ē aʻe e hana ai, a me nā polokalamu hoʻomaka i nā hana hana nui. Akā, ua pono ka hanaʻana e wikiwiki i ka noʻonoʻo a me kaʻu hihia, e pale i nā hua'ōlelo.

6 Nā pane i "Microstation: Hoʻopili nā kumu a me nā hōʻike mai Excel"

  1. Aloha ʻoluʻolu, ke ʻike maikaʻi, ua hoʻokele wau e hōʻoluʻolu a ʻoi hou ke hoʻoponopono ʻana i nā kūlana i manaʻo au ʻaʻole hiki ke hana ʻia i ka microstation, loaʻa iaʻu kahi nīnau e pili ana i ke kumuhana i kūkā ʻia e ʻoe, pehea wau e kau ai i kahi pōʻai ma kahi o ka pane a kahi kuhikuhi maikaʻi ? Ala akula ka p? Hana wau i nā hana āpau i hōʻike ʻia aʻe e hoʻohana ana ma ke ʻano he kiko hoʻohālike: = CONCATENATE ("wahi pōpoki; ... ..) a laila lawe ʻia i .txt a laila lawe ʻia i ke kī i loko o ka @d: \ circulo.txt. E kōkua mai iaʻu i kēlā?

    Aloha.

  2. Hello, maikaʻi lā, au kahaha ina oe i kekahi hōʻike aʻo i 'ole' ana i kumumanaʻo ma pehea e e kekahi kia-aaioee no ka GPS 200 ProMark GNSS pāʻoihana ma ka polokalamu ?? Au i lā a me ka ho'āʻo akā,ʻaʻole hiki iā no ka mea, o ka GPSʻano .csv Ka Wailele O iaʻu ... au manaolana i kou pane ai i ke aloha.

  3. Good, no ka mea, au e hai aku ia oe i ka Shop i ole e hele mai i ka Victores A i ka wā aʻu i makemake e holoʻokoʻa i hele mai ia i kou kōkua, a me au ua aho hakuloli nā mea a pau, a me au freaked nonoi ia koke me ka mea i hana ai ... heh heh'ōlelo mai iaʻu naita lanakila nana aku no ka mea, i loko o egeomates ... maikai mea mākou mau kākoʻo no ka mea, ua mau mea i kuʻu haku i loko o kēia, eia kekahi,ʻaʻole au i ho'āʻo au i hana ai no ka mea, nana aku la au hiki maopopo iki paha i kekahi mea me ka vuelterio i ua e hana me Civilcad akā maoli a pau i loko o ka Workshop ua pīhoihoi lākou ...

    ka mea, kōkua paha nui loa i loko o nā tausani o ka liana e hiki ke hana ia me ka PC iā mākou, akā, he alakai ka manawa e pono ai i ka mea hiki ke aʻo ..

    Mahalo hapa o ka oaoieei-, no ka mea a pau au e hai aku i koʻu guaoooo mea he waiū.

Haʻalele i ka manaʻo hoʻopuka

Kāu leka uila aae? E,ʻaʻole e paʻiʻia.

Ke hoʻohana nei kēia pūnaewele i ka Akismet e ho'ēmi i ka spam. E aʻo pehea e hanaʻia ai kāuʻikeʻikepili.