Microstation: Tumirai mazano uye zvinyorwa kubva kune Excel

Nyaya yacho: Ndine dhamusi yakasimudzwa neParchark 100 GPS, uye kana ndichishandisa gNSS yekugadziriswa kwekushandiswa kwekuti majaira aya, inondibvumira kutumira mashoko kune Excel.

Mifananidzo yakaiswa mujena ndeyekumabvazuva, nharaunda dzekumusoro uye zvinyorwa zvavo; Zvose zvinongoratidzira ruzivo rwakafanana nehuwandu hwekushambadzira.

The Problem: Ndinoda kuti vashandisi vane zvinyorwa zve Microstation dzine data inotumira.

Slug nzira dzokuzviita

Kana iwe ukatumira mitsuwa ne Microstation ne murairo wakaitwa nokuda kweizvi, chete mapoinzi anouya, kwete mavara. Nenzira refu, mushandisi aivapinza kubva kuCivilCAD inozviita zvinoshamisa, kubva kuMicrostation yakavhurwa uye ikashandurwa kuita dgn inova fomati kwavanoshanda zuva rega rega rekubira. Saka… kunyange zvazvo ndakanga ndava kuda kuenda, Ndinotenda kuti wakandibvunza zano rekuti uzviite sei; kunyangwe zvakadzika pasi ndinofunga vanozviita kuratidza kuti mirairo haisi ngura. Iyi ingori maitiro andakatsanangura kare uye AutoCAD.

Nzira yekubatanidza nhaurirano neExcel

Vba kuti dzakanakira, asi senguva rimwe zuva chii isu tati: Excel vanofanira hunobudirira pane kuti Payroll matafura, pano muitiro tichibatanidza Microstation mirayiro (kiyi mu) pamwe Excel mirayiro (concatenated)

Kugadzira imwe pfungwa neMicrostation kunoitwa ne "place point" murairo, uye kana iwe uchida kuiisa pane imwe nzvimbo yakarongeka, shandisa "xy =", nguva dzose uchishandisa murairo wekuparadzanisa iyo ndiyo semicolon (;). Saka, nekupinda murairo nzvimbo nzvimbo; xy = 388218.835,1566315.816 Ndinofanira kukwevera pfungwa pane imwe sangano.

Muchiitiko cheExcel, iwo concatenate rairo rinoshanda seizvi: concatenate rairo, yakavhurika mabhureki, wobva waratidza zvese kuti zvibatanidzwe, uye pakupedzisira vhara mabhureki. Ini ndinozvitsanangura nenzira inonzwisisika, asi haina kuomarara kana ikanzwisiswa uye ikaitwa kanenge kamwe:

Concatenate command = CONCATENATE tinozarura vabereki ( ipapo murairo we commando ndiwo mutsara, uye semicolon yayo inoparadzanisa murairo "nzvimbo yenzvimbo;" ipapo comma kuti iparadzanise tsvimbo inotevera , ipapo murairo muzvinyorwa sezvazviri mutsara “xy=” iyo comma kuratidza tambo itsva , uye pano tinosarudza sero rinobata  C3 ipapo comma inoratidza tsamba itsva , uye comma muzvinyorwa zvekuparadzaniswa kwemasangano "," iyo comma kuratidzira tsvimbo inotevera , sero rine chikamu chekuchamhembe uye semicolon yekupedzisira D3,";" tobva tavhara maparentheses )

Zvingaita sezvizvi:

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

Kana izvi zvaitika, tinongotevedzera rondedzero kumakoromo anotevera, sezvinotevera:

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

Nzira yekuitumira nayo kuSyststation

Rugwaro urwu runogona kunyorwa uye kunyorerwa zvakananga kumutsara wemirairo (kiyi yebatsiri mukati) uye ona kuti pfungwa dzacho dzinotorwa.

Asi ini ndinokwanisa zvakare kuiripa iyo mu txt kana csv faira iyo ini ndinogona kudana se script.

Somuenzaniso, faira inodanwa phobiafreedom.txt, uye inochengeterwa C; saka kuitumidza iwe unyore kiyi in  @c: \ sweetpots.txt. Zita harifanirwe kunge riine nzvimbo, uye zviri nani kuti riiswe munzira iri nyore.

Nzira yekutumira zvinyorwa

Inoshanda nenzira imwecheteyo, nemusiyano wekuti murairo hausi kureva asi mifananidzo icon:  place text icon

Concatenamos yemafanana akaenzana, command nzvimbo text text, sero rine ine annotation, inobatanidza apo ndima yacho ichaiswa:

=CONCATENATE(“icon text icon ;”,B3,”;”,”xy=”,C3,”,,D3,”;”)

Uye zvino tinofanira kugara sezvizvi.

nzvimbo text icon; 10; xy = 388218.835,1566315.816;
nzvimbo text icon; 11; xy = 388219.911,1566320.28;
nzvimbo text icon; 12; xy = 388216.28,1566320.868;
nzvimbo text icon; 13; xy = 388215.36,1566316.473;
nzvimbo text icon; 14; xy = 388211.706,1566317.245;
nzvimbo text icon; 15; xy = 388212.713,1566321.593;

Uye ikoko vanezvo:

Kugadzira iyo yekuyambuka, iwe waizoita zvakafanana, asi neinoraira nzvimbo tambo, nehungwaru kuti iwo mapoinzi anofanira kunge aine nhevedzano; izvo zvisiri izvo. Inenge iri yekuraira nzvimbo mutsetse, tanga kurongedza, kwekuenda kuronga ...

Chokwadi pane dzimwe nzira dzekuzviita, uye kuvhura sosi mapurogiramu anozviita zvinoshamisa. Asi kurovedza muviri kunobatsira kugadzirisa pfungwa dzangu uye kwandiri, kudzivirira mirairo yangu kubva pakuita ngura.