Xuat Dulieu Tu Revit Thanh Dinh Dang Excel...
Transcript of Xuat Dulieu Tu Revit Thanh Dinh Dang Excel...
-
7/30/2019 Xuat Dulieu Tu Revit Thanh Dinh Dang Excel...
1/15
Exporting Revit to ODBC Database and Reports
Autodesk Revit soft gm 3 ci: 1- Revit Architechture l phn mm dng cho
chuyn ngnh thit kkin trc. 2- Revit Structure l phn mm thit kkt cu. 3-
Revit MEP l phn mm thit kMEP ((Machanical, Electrical, Plumbing).
Mt trong nhng chc nng rt mnh ca Revit l cho php cc bn xut d liuca cc bng thng k, hay thng tin ca bt k mt i tng no trong d n.Thc t cc bng thng k cng cho php chng ta thc hin chnh sa hay thm
bt rt nhiu trng km theo cc gii thut tnh ton, tuy nhin, c l n khngc quen thuc (d dng) nh khi ta dng bn excel chng hn. V vy nhu cu
xut d liu qua excel l kh ln, chnh v l do hm nay ti mun gii thiuvi cc bn cch thc chng ta xut d liu t Revit qua cc nh dng quenthuc nh excel
Exporting to ODBC Database
Bn c th xut d liu ca cc phn t trong m hnh ra mt file d liu ODBC(Open Database Connectivity) no . Trong file d liu c xut ra bao gmcc tham s m bn gn cho cc phn t trong d n. Trong Revit qun l cc
phn t theo cc Category (Air Terminals, Columns, Doors), v vy khi xut dliu cc d liu ca cc phn t trong m hnh cng c phn ra (qun l) tngnhm tng ng vi category mi nhm trong mt bng. V d, Revit to ra mt
bng danh sch tt c cc loi ca v mt bng danh sch tt c cc ca trongm hnh.
ODBC export ch s dng n v mt. Nu mt project s dng dn v Imperial thtrc khi xut n s chuyn sang n v mt.
-
7/30/2019 Xuat Dulieu Tu Revit Thanh Dinh Dang Excel...
2/15
Khi xut ODBC, Revit to ra cc bng cho cc phn t sau:
Model Objects: Types and Instances Levels v Rooms: Instances Key Schedules Assembly Codes:
File d liu ODBC to ra mi quan h (relational) gia cc bng bng cch sdng kha chnh (primary keys bn no s dng MS Access hay lp trnh CSDLth hiu r thng ny) v cc gi tr tham chiu. Vi Relational trong csd liu,mt cha kha chnh (primary key) l mt gi tr duy nht, n xc nh mt bn ghi(Record) trong mt bng csd liu. Tham chiu c cc gi tr tham chiutrong ct l tham chiu c tt c cc gi trn trong ct khc. Yu t then chttrong mi bng l ct gn nhn ID (ct ny l primary key - cha cc gi tr
tham chiu). Bng thng k ca sau y minh ha cc kha chnh v gi trtham chiu to ra mi quan h trong mt bng csd liu:Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions */
table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-
size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:"";
mso-padding-alt:0mm 5.4pt 0mm 5.4pt; mso-para-margin:0mm; mso-para-
margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-
family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-
language:#0400; mso-bidi-language:#0400;} table.MsoTableGrid {mso-style-
name:"Table Grid"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0;
border:solid windowtext 1.0pt; mso-border-alt:solid windowtext .5pt; mso-
padding-alt:0mm 5.4pt 0mm 5.4pt; mso-border-insideh:.5pt solid windowtext;
mso-border-insidev:.5pt solid windowtext; mso-para-margin:0mm; mso-para-
margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-
family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-
language:#0400; mso-bidi-language:#0400;}
Ct Tng xng viId Duy nht, mi gi tr chc xut hin mt
ln, xc nh cho mt ca c thType
Id
L Id ca bng DoorTypes, bit ca nyca loi no.
Level L Id ca bng Levels, bit ca ny thuctng no
Room L Id ca bng Rooms, bit ca ny thucphng no
Ch : S dng mt csd liu duy nht cho mic d n. Khng phi chngtrnh no cng hi trquan h gia cc bng nh nu trn, v d Excel.
-
7/30/2019 Xuat Dulieu Tu Revit Thanh Dinh Dang Excel...
3/15
y ti s gii thiu vi cc bn cch xut d liu ra file csd liu Access,su xut ra Excel. Nu bn xut d n Revit ra csd liu ODBC l ln uth bn thc hin cc bc nh sau:
1. Trong Revit, md n mun xut d liu2. Kch File Export ODBC Database bc 1.
Hnh 1.1
-
7/30/2019 Xuat Dulieu Tu Revit Thanh Dinh Dang Excel...
4/15
3. Kch vo New to mt DSN (Data Source Name) mi bc 2.
Hnh 1.2
4. Trong hp thoi Create New Data Source, lm nh sau:o Chn mt driver v kch Next bc 3 v 4o Nhp mt tn DSN bt k hoc kch vo Browse chn mt ci
(thng thng l cha c) bc 5.o Nhn Next bc 6o Nhn Finish bc 7
5. To file csd liu:
-
7/30/2019 Xuat Dulieu Tu Revit Thanh Dinh Dang Excel...
5/15
o Trong hp thoi ODBC Microsoft Setup, kch Create - bc 8
Hnh 1.3
o Trong hp thoi New Database:
Hnh 1.4
Chn a mun lu file d liu cho hp Drives bc 9 Duyt n th mc mun lu trong mc Directories bc
10
-
7/30/2019 Xuat Dulieu Tu Revit Thanh Dinh Dang Excel...
6/15
Nhp tn file mun xut ra trong Database Name bc11
Nhp OK bc 12o Xc nhn OK hai ln xut d liu bc 13 v 14
Hnh 1.5
oTruy cp n th mc ta chn trn bc 10 ta s thy file cxut ra.
Hnh 1.6
Kch kp mxem ni dung ca d liu bc 14
-
7/30/2019 Xuat Dulieu Tu Revit Thanh Dinh Dang Excel...
7/15
Ta thy file ny cha rt nhiu bng chut tt c cc bngca tt c cc i tng trong d n, nh thy trn hnh 07
6. Xem ni dung mt bng v xut sang Excelo Chn bng Doors, kch kp mxem ni dung ca bng bc 15
Hnh 1.7
-
7/30/2019 Xuat Dulieu Tu Revit Thanh Dinh Dang Excel...
8/15
o T menu File Export - bc 16
Hnh 1.8
o Trong hp thoi Export Table Doors To Nhp tn file cho File Name bc 17 Chn nh dng file l MS Excel cho hp Save as Type
bc 18 Bng d liu ca Doors c xut ra nh dng Excel.
Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions */
table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:"";
mso-padding-alt:0mm 5.4pt 0mm 5.4pt; mso-para-margin:0mm; mso-para-
margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-
family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-
language:#0400; mso-bidi-language:#0400;}
-
7/30/2019 Xuat Dulieu Tu Revit Thanh Dinh Dang Excel...
9/15
Exporting to Reports
1. Trong Revit, md n mun xut d liu
2. Kch File Export Reports Schedule.
Hnh 2.1
-
7/30/2019 Xuat Dulieu Tu Revit Thanh Dinh Dang Excel...
10/15
3. Trn hp thoi Export Shedule:
Hnh 2.2
a. Trong mc Save in: dn n th mc mun lu file xut ra
b. Trong mc File Name: nhp li tn file mun lu
c. Nhn Save.
-
7/30/2019 Xuat Dulieu Tu Revit Thanh Dinh Dang Excel...
11/15
4. Hp thoi Export Shedule mi xut hin, nhp OK chn theo mc nh.
Hnh 2.3
5. Khi ng MS Excel
-
7/30/2019 Xuat Dulieu Tu Revit Thanh Dinh Dang Excel...
12/15
6. T menu File Open
Hnh 2.4
-
7/30/2019 Xuat Dulieu Tu Revit Thanh Dinh Dang Excel...
13/15
7. Trong hp thoi Open
Hnh 2.5
a. Trong mc Look in: dn n th mc va lu file *.txt
b. Trong mc Files of Type: chn Text Files
c. Chn file *.txt m ta va xut ra
d. Nhn Open
-
7/30/2019 Xuat Dulieu Tu Revit Thanh Dinh Dang Excel...
14/15
8. trn hp thoi Text Import Wizard, nhn Finish chn mc nh
Hnh 2.6
9. Ta c k qu nh mt file *.xls bnh thng, kt qu ca ti c nh hnhdi y:
-
7/30/2019 Xuat Dulieu Tu Revit Thanh Dinh Dang Excel...
15/15
Hnh 2.7
10. Nhn Ctrl + S lu n li