|
|
|
Home | Forums |
Downloads | Gallery |
News & Articles | Resources |
Jobs | FAQ |
| Join |
Welcome !
|
126 Users Online (124 Members):
Show Users Online
- Most ever was 626 - Mon, Jan 12, 2015 at 2:00:17 PM |
Forums
|
Forums >> Community >> Newbies >> about scheduling
|
|
|
active
Joined: Mon, Oct 25, 2004
13 Posts
No Rating |
Hiii...I'm new to Revitcity forum. I have a case confusing me recently.
When I create a multi-category schedule, it doesn't display all building elements created. No floor, wall, roof, etc. I need to make it for building cost estimation. Someone suggests me to export to ODBC but I'm still don't understand with this feature since I'm new to Revit. Anyone can teach me? Thx. 
|
This user is offline |
|
 | |
|
|
site moderator|||
Joined: Mon, Jan 12, 2004
2889 Posts
 |
What program do you want to export to?
|
This user is offline |
View Website
|
|
|
active
Joined: Mon, Oct 25, 2004
13 Posts
No Rating |
I prefer working with Excel to Access.
|
This user is offline |
|
|
|
site moderator|||
Joined: Mon, Jan 12, 2004
2889 Posts
|
Okay,
First open excel and create a blank workbook and save it in a location.
In Revit:
Go to File-->Export-->ODBC Database...
Click on Machine Data Source Tab and double click excel files.
Then find the file you just created and click okay.
Now all information from the project will be exported out to this file.
Open the file and each different component is broken up into various tabs, ie: walls, floors, slab edges etc etc.
|
This user is offline |
View Website
|
|
|
active
Joined: Mon, Oct 25, 2004
13 Posts
No Rating |
IWhen I try to open the Excel file there's an error message and the file couldn't be opened. Here's the error message.
|
This user is offline |
|
|
|
site moderator|||
Joined: Mon, Jan 12, 2004
2889 Posts
|
Interesting.
Try this first:
Go to File-->Export-->ODBC Database...
Where it says DSN Name click NEW.
Navigate down to 'Microsoft Excel Driver (*.xls)'
Make sure you pick this name exactly.
Click NEXT,
Now Give it a name, ie Microsoft Excel
Click Finish.
Now select the DSN you just created and click OK and select the *.xls workbook you wish to export to and click ok.
Hopefully this should work.
|
This user is offline |
View Website
|
|
|
active
Joined: Mon, Oct 25, 2004
13 Posts
No Rating |
It works!! Thanks alot Mr. Spot.
Then.... I have to fill the cost for every family's type? The cost parameter is just appear in family's type not in family right? And I have to link and paste each data to new sheet one by one? I hope it's my last question...
|
This user is offline |
|
|
|
active
Joined: Wed, Feb 16, 2005
7 Posts
No Rating |
The OBDC output into Excell is an output of the B.I.M. database, correct? The fundamental scheduling of all the building elements within your model is not created simply by outputing ALL the database. Have you been able to use Revit in order to make the quantity take-off you mentioned in your initial query, iPang?
|
This user is offline |
View Website
|
|
|
Similar Threads |
|
Retaining Curtain Wall Door Scheduling Data |
Revit Building >> Technical Support
|
Thu, Jan 8, 2015 at 2:47:08 PM
|
5
|
|
Wall Scheduling |
Revit Building >> Technical Support
|
Mon, Sep 10, 2018 at 8:06:43 AM
|
1
|
|
SCHEDULING CONDUIT BENDS |
Community >> Newbies
|
Thu, Sep 21, 2017 at 10:06:06 AM
|
1
|
|
Calculation for Text in Scheduling |
Revit Structure >> Technical Support
|
Mon, May 30, 2016 at 8:02:21 AM
|
1
|
|
scheduling structural props of walls or roofs |
Community >> Newbies
|
Sat, Nov 8, 2008 at 12:03:47 PM
|
1
|
|
|
Site Stats
Members: | 2000977 | Objects: | 22886 | Forum Posts: | 152181 | Job Listings: | 3 |
|
Search