CAD mea hoʻolilo kahi kūlike i ka txt
E manaʻo mākou makemake mākou e hoʻokuʻu i nā helu mai ka hōkū CAD, i kahi papa inoa hoʻokaʻawale koma i mea e hoʻouka ai i kahi kikowaena a hana i kahi kikowaena. Ma mua ua ʻike mākou i ka lawe ʻana mai iā lākou mai ka Excel a i ʻole ka txt me ka AutoCAD y me ka MicrostationE nānā kākou pehea e hoʻokuʻu aku ai.
Nui nā ala e hana ai, e like me ka helu ʻana i nā bipi, hiki iā ʻoe ke helu i nā wāwae a hoʻokaʻawale iā lākou i ʻehā a i ʻole hiki iā ʻoe ke helu i nā bipi. E nānā i kekahi mau ala:
1 Hanaʻia me Microstation (dgn a txt)
I loko o ka hiʻohiʻona, aia wau he papahele heʻelima mau manamana, a he pono iaʻu e hoʻokuʻu i nā kuhi i kahi pūnaewele txt.
No kēia, ua kau wau i nā kiko i kahi mānoanoa e ʻike ʻia. E hoʻomanaʻo i ka kaupaona ʻana o nā kaupaona laina ma Microstation, no laila ʻike koke ʻia lākou.
ʻO ka hana mua: Hoʻoulu i ka mea hana hoʻolilo hoʻohui (inā ʻaʻole ʻeleu), no kēia mea mākou e koho ai
hana
nā pahu hana
hoʻohana mākou i ke kauoha hope loa (xyz)
a laila ua pani mākou i ka papa a inā ua hanaʻia ma kēiaʻano
Pākuʻiʻelua: E koho i nā kiko a mākou e makemake ai e hoʻokuʻu aku, a laila koho i ke kauoha "export coordinates", ʻo ia ka pua i luna, a hoʻopiha i nā kūlana:
Kōnae -Data
-Name o ka faile
Waena o nā kikowaena
ʻO ka mea mua
-Ka helu
-Nohapa
Nānā
-Prefix / suffix
- Ke helu helu
Na ka papa eʻae iāʻoe e koho i nā koho, inā wale nō nā kiʻi i kohoʻia, nā kiʻi i loko o ka pā a iʻole ka paukū (ʻo nā mea a pau)
ʻO ka hopena hopena, he ".txt file e hiki iāʻoe ke weheʻia mai ka excel.
I koʻu hihia, ua kau i ka helu, e kaha ana i ka pahu pahu e waiho ana ma ka'ākau
Inā loaʻa ka waihona i kahi puka makani e nīnau ana inā makemakeʻoe e pani aiʻole e hoʻopiha i (hoʻohui a hoʻohui) paha.
No kaʻikeʻana i nā mea i kū ai, microstation ke kau iāʻoe i nā helu ma kēlā me kēia wahi, me ke kala, keʻano o ka laina a me ka nui o nā kikokikona āu e hana nei.
2 Ke hana nei me AutoCAD
Ma mua o kaʻikeʻana iā CivilCAD (Softdesk) ua hoʻohana mākou i kahi noi DOS i kāheaʻia dxf2csv. Hiki iā ʻoe ke hoʻāʻo inā makemake ʻoe e hōʻeha iā ʻoe iho me ka nostalgia, 🙂 aia kekahi mau polokalamu "ʻaʻohe noa", a maopopo iaʻu aia kekahi manuahi akā i kēia hihia e ʻike mākou pehea e hana ʻia ai me Softdesk8, ua like ia ma CivilCAD.
I mea e ʻike ʻia ai nā kikoʻī, ua hoʻololi au i ke ʻano me ke ʻano hōʻano/ʻano kikoʻī. I mea e ʻike ʻia ai ka mānoanoa o nā laina, pono ʻoe e hoʻāla iā "Lts", me ka hoʻohana ʻana i kahi waiwai ma lalo o 1 a ʻike mākou i ka ʻokoʻa.
ʻO ka hana mua: E wehe i kahi papahana a iʻole e hana i kahi hou
AEC
Nā polokalamu Softdesk (e mālama i ka waihona i ka manawa mua)
E hana i ka papahana
E hāʻawi i ka inoa o ka papahana, a laila ua maikaʻi
E koho mākou i ka helu i hoʻomaka ai ka heluʻana
Ok ok, ok a laila
koho mākou i "cogo", a laila ʻae
Pākuʻiʻelua: E komo i nā kikowaena i kaʻikepili: no kēia, aia nāʻano likeʻole, ma kēia hiʻohiʻona e hana mākou i kēia manawa:ʻO nā koho / hoʻonohonoho hoʻonohonoho / kākoʻo, a laila koho i kēlā me kēia laina o ke polygon.
ʻO ka hōʻailona i hoʻokomo ʻia he mau helu / kau helu / papa inoa i nā helu avaible. Pono e hōʻike +6, ʻo ia hoʻi he mau helu 5 i komo i loko o ka waihona.
ʻO ke kolu o ka hana: E hoʻokuʻu i nā mea.
E lawe i nā māka e hana ai mākou:
nā helu / kahi laweʻia / hoʻokomoʻia / nā hoʻokumu i nā kikowaena i ka faile
- E koho i ka hōʻano kūʻaiʻana, ma kēia hiʻohiʻona PNE (helu, northing, hikina)
-E koho mākou i ka waihona huakaʻi o ka faila a kākau i ka inoa
-Ma ke kalima kauoha ua koho mākou i nā koho o ka waho (ma ke koho ʻana, ma o ka pae ... i kēia hihia ke hoʻohana nei mākou āpau, āpau)
-Keʻaneʻa, ua hala ka file, ma kēia hihia i hoʻokaʻawaleʻia e expacios akā hiki ke weheʻia me ka keu
Inā ua kākauʻia nā mākau i ka nui nui, ponoʻoe e hoʻololi i nā'āpana metric no ka hikiʻole mai o ka'ōlelo Pelekane (ʻo ka unuhiʻana o ka hoʻohālikelike AEC / hoʻonohonoho / koho i keʻano)
I kēia manawa,ʻaʻohe kiʻekiʻe o nā kumumanaʻo, eʻikeʻia ana kēlā manaʻo ma kekahi wahi'ē aʻe, i ka wā e kamaʻilio ai mākou i nā laina laina.
E hoʻohaʻahaʻa i kuʻu manaʻo,ʻo wai ke kanaka eʻike i kahi macro no kaʻoihana iʻoi aku ka maʻalahi a me kaʻole?
Hana anei kekahi mea'ē aʻe?
No kēlā mea, koi ʻoe iā CivilCAD a i ʻole Civil3D. ʻO nā modula ʻelua ʻelua e hana ma AutoCAD.
ʻAʻole ponoʻo AutoCAD wale iāʻoe e hana i kēlā.
mihi i koʻu hoʻomakaʻana, Pono wau eʻike i ka heleʻana a / a huki paha i nā keoki a iʻole ka paukū ma ka autocad a me ka heluhelu heluhelu a me nā mamao (ke kelepuniʻaoʻao) i kēlā me kēia 20 mt. ka lōʻihi a ma ka manawa like e hele ai au e hoʻohālikelike i ka nui o nā kīʻaha a me nā'ōkuhi ma ka autocad
ʻĀ, maikaʻi loa kēia pou, nui a hewahewa nā mea hana kākoʻo e hoʻomaʻalahi i ka hana a maikaʻi hoʻi ke kaukaʻi ʻana i ka civilcad i kūpono e hoʻohana, akā ʻo ka mea nui e ʻike i ke kumu o kēlā me kēia manaʻo.
E ho'āʻo me kēia noi
pela Ua halaʻo XYZ-DXF ʻo ia ka mea maikaʻi loa
nā hana maikaʻi e aʻo mau ana iā mākou
Hi, Kovos ma kēia pou Hōʻike mākou i ka hana ʻana me Softdesk8. ʻ telllelo aku wau iā ʻoe ʻaʻole hiki iā mākou ma o kēia blog ke paipai i nā ala e loaʻa ai nā polokalamu pirated, i kēia pou aʻu i ʻōlelo ai 'O Vuze He hana ia no kēlā, akā, aia i kāu pilikia.
Pehea e hiki ai iaʻu ke huki i nā pākuʻu launa ma ke Aautocad? Pehea wau e hoʻouka ai i ka softdesk8?
Alohaʻo Jorge Luis
ʻO ka mea mua, i loko o ka pūnaewele piha, hoʻopukaʻia nā kumumanaʻo i .txt hōpili,ʻoi aku i ka hoʻonohonoho: x coordinate, y coordinate, elevation, description.
a laila wehe iā lākou me Excel, koho i ka faila o .txt
e koho i ka koho i hoʻoholoʻia e nā pākuhi, no laila hiki iāʻoe ke hoʻokaʻawale i nā pou
makemake wau iā lākou eʻoi aku i ka makemake nui e hoʻohana kēia mea hana, e hoʻouka aku ana i ka waiwai o ka dxf
Makemake au i nā ʻanuʻu e hiki ai ke hoʻokuʻu i nā kiko o ke kahua e ʻoi aʻe ... Mahalo
Ka wikiwiki
ʻO Daniel,ʻo kēia wale nō ka mea e hiki iaʻu ke hōʻoia i kēlā hana, he VBA akā pili pū me Excel ma ka lele
http://geofumadas.com/cuadro-de-rumbos-y-distancias-en-excel-interactivo-con-microstation/
E mahalo au, eʻoluʻolu. ʻO kaʻu moʻokūʻauhau a me aʻu wale nō e hana i kēia no ka hoʻoholoʻana a me ka hoʻolālāʻana. NO KA MEA.
E Daniʻela e, eʻike mai iaʻu i kahi nui aʻu i hoʻohana ai i kekahi manawa ma mua ae hoʻouna aku iāʻoe no ka ho'āʻoʻana
e hāʻawi mai iaʻu i kēia lā
ʻaʻole,ʻo ia wale nō ka lawelawe iāʻoe e lawe mai i nā kumukūʻai.
E loaʻa wau i kahi vba a e hoʻokuʻu aku wau iāʻoe no ka ho'āʻoʻana.
¿¿¿Pehea wau e hana ai i ka waiwai o nā COORDINATE MAI EXCEL I MICROSTATION a huki i kaʻu mau laina; MA KE KAUAHI BOXER APP> XYZtext> IMPORT COORDINALES ?????????
E HĀ KE AE HANA WĀ NĀ KAUA I KA LAU AINA I KA IMPORT ???
KA LĀ AKU, GALVAREZHN
Mahalo, akāʻo kaʻu hihia kēia:
Loaʻa iaʻu kahi waihona ma Excel kahi i loaʻa iaʻu nā kumu kumu a me nā hoʻonohonoho huakaʻi, a makemake wau e huki i nā laina ma autocad. """Akā""" Me ka ʻole o ke kope ʻana a me ka hoʻopili ʻana, akā ʻo ka hana maʻalahi, ʻo ia hoʻi, me kahi macro a i ʻole kekahi code e hana ai i ka interface, a i ʻole ma loko o AUTOCAD a i ʻole MICROSTATION AIA KIA INTERFACE e lawe mai i ka ʻikepili mai Excel AUTOCAD a i ʻole. MICROSTATION inā ʻo ia ka hihia
he aha kāu e ʻōlelo mai ai iaʻu galvarezhn
?????? MAHALO
Alohaʻoe Daniel, e like me ka mea i ho'ākākaʻia ma kēia wahi
http://geofumadas.com/como-importar-puntos-de-excel-a-autocad/
hana ia, akā ma kahi o ka hoʻonāʻana i ke kauohaʻoi
ke hoʻouka i ka laina kauoha, aiʻole ka pline
ma kahi o ke kauʻana i nā kumukūʻai e huki aiʻoe i kahi laina
Aloha
ʻO wau he THESISIST a keʻimi nei au i kahi e hiki ai iaʻu ke huki pono i nā laina i ka AutoCAD mai kahi waihonaʻikepili i Excel,ʻo ia hoʻi, me nā kaulana ORIGIN a me nā lāina DESTINATIONS
NO KA HUʻU MA KA HOPE MA KE LINES KAUAʻI ME KA HOʻOPIʻI ANA I KA POʻI POINT POINI A ME NĀ HULA PALAPALA HUI.
GRACIAS
Hiki i kēia lisp ke hana
(kālepa c: txt-xyzs ()
(hoʻonohonoho a (ssget)
n (ke koʻikoʻi a)
i 0
f (wehe (getstring “\nfilename: “) “w”)
)
(hou n
(kapa inoa (ssname ai)
(inoa inoa)
lp (cdr (assoc 0 komo))
)
(inā (= “TEXT” tp)
(inā (a ((((cdr (assoc 71 komo)) 0) (= (cdr (assoc 72 komo)) 0))
hele
(setq ip (cdr (assoc 10 komo))
x (tumomo (ipod ip) 2 2)
a ((ipr ip) 2 2)
z (nā pahu (Xaddan X) 2 2)
s (cdr (assoc 1 komo))
)
(princ(strcat x", "y", "z", "s"\n") f)
); ka kikokikona i'āponoʻoleʻia
hele
(setq ip (cdr (assoc 11 komo))
x (tumomo (ipod ip) 2 2)
a ((ipr ip) 2 2)
z (nā pahu (Xaddan X) 2 2)
s (cdr (assoc 1 komo))
)
(princ(strcat x", "y", "z", "s"\n") f)
),'ē aʻe ma kahi hemahema
);
);
(inā (= “MTEXT” tp)
hele
(setq ip (cdr (assoc 10 komo))
x (tumomo (ipod ip) 2 2)
a ((ipr ip) 2 2)
z (nā pahu (Xaddan X) 2 2)
s (cdr (assoc 1 komo))
)
(princ(strcat x", "y", "z", "s"\n") f)
); ka kikokikona i'āponoʻoleʻia
mtext
(setq i (1 + i))
);
(kokoke f)
)