|
Forums >> Revit Building >> Technical Support >> Revit to Microsoft Access
|
|
|
active
Joined: Wed, Dec 17, 2008
5 Posts
No Rating |
I'm trying to create room data sheets exported from revit as an odbc database to microsoft access. As seen in the attached screen dump jpg - I have all the data in access... Furniture types etc. - however can't make a 'query' work which allocates all the furniture to rooms and schedules it out.  is this the right way to do it) The pdf RDS attached is one which we have created from revit to excell (using tab associations - to keep it somewhat coordinated) and gives an idea of what we are attempting to achieve. Can anyone provide a step by step process as to how I might be able to do this? Or a steer in the right direction. As an aside, is there a way that the sheet information can be exported to access as well? cheers.
|
This user is offline |
|
 |
|
|
|
site moderator|||
Joined: Tue, May 16, 2006
13079 Posts
 |
Why don't you just export the schedule to a tab delimited file. That's easier to do than the ODBC
|
This user is offline |
|
|
|
active
Joined: Wed, Dec 17, 2008
5 Posts
No Rating |
Yeah, the pdf I attached was from excel. But want to make something that's a bit more coordinated than that.
|
This user is offline |
|
|
|
site moderator|||
Joined: Tue, May 16, 2006
13079 Posts
|
Then move that into access.
|
This user is offline |
|
|
|
active
Joined: Wed, Dec 17, 2008
5 Posts
No Rating |
Does anyone have experience with cross table queries in access that may be able to assist me in creating a relationship between furniture and rooms from an ODBC file.
|
This user is offline |
|
|
|
site moderator|||
Joined: Tue, May 16, 2006
13079 Posts
|
You do know that you can schedule furniture by room in REVIT?
|
This user is offline |
|
|
|
active
Joined: Wed, Dec 17, 2008
5 Posts
No Rating |
Yes. That is how I've created my RDS's up to now. Export a txt schedule of a room/furniture schedule to excell and create links between the two. However, theres lots of flaws in doing it this way. Room data sheets not only have furniture, (plumbing, m&e reqs, finishes) which means 100's of schedules ex. revit + issues with presentation on A4 paper if it goes past 1 sheet. if wanting to present from within revit - or do exports by room to excel. I've been mucking round with a txt in access as well - by understand that ODBC is a much better way to go, especially if method of presentation required (fields etc.) change through the course of a project. So, yeah... Looking for guidance over ODBC.
|
This user is offline |
|
|
|
site moderator|||
Joined: Tue, May 16, 2006
13079 Posts
|
Look, I'm really tryin g to help you so please reread my post. THIS IS NOT TWO SCHEDULES ! The schedule is the furniture schedule and you can sort by rooms. You don't need to link anything to do that.
|
This user is offline |
|
|
|
active
Joined: Wed, Dec 17, 2008
5 Posts
No Rating |
I appreciate what your saying mate and the help is good. I know that you can use the drop down menu when creating a schedule for furniture to assess against rooms or spaces. However, when creating 100's of RDS like the pdf I posted - whereby on one document all info needs to be presented (in a specific manner) - using revit becomes difficult. Because a filter needs to be applied to just have one room showing on the schedule. Then duplicate to provide a seperate schedule for each room. Then bring in another for the project parameters (repeat x amount of times etc. as well) - Becomes very very painful. I think using ODBC it will give me better ability to customise the sheet to client requirements. But need help creating relationships between furniture and rooms etc. (seems basic as its easy to do in revit - but the relationships get lost somehow in the export)
|
This user is offline |
|
|
|
active
Joined: Thu, May 20, 2010
1 Posts
 |
Hey I know this is a dumb, open ended question but here goes ! I am looking to use Revit and have it populate RDS for a project I am doing Could someone suggest where the best place to START the process is please? I am a new Revit user just getting knowledge together so that I can easily (hopefully) output this information If this is asking too much, please let me know and I will go back to a more traditional approach  I am getting conficting reports about what can and can't be done...... thx DubDub
-----------------------------------
Dub Dub |
This user is offline |
|
|
|
|
|
active
Joined: Sun, Apr 25, 2004
1207 Posts
 |
The answer to your question is beyond the scope of a simple answer as people make careers out of writing database queries and reports. To get you going in the right direction I would say that you want to export out of Revit to a MS Access file, then link the tables from the exported Access file to another Access database or report writer like Crystal Reports. If you develop the queries and reports in the exported Access DB from Revit, then any future exports from Revit will likely over-write all your work. The link from Access to Access works much like a CAD xref. [Matter of fact mopst of the CAD and Revit concepts are really DB concepts] If you have your queries and reports developed in a separate DB, then when you update the export from Revit you link will auto-refresh in the DB world. The query itself can be developed in Access using the query wizard or by writing an SQL statement. You will have to include multiple tables as Revit usually has a Type ID table for a category and then a instance based table listing all the occurences of the type ID. For furniture you will also have to refence a room ID. The query is going to be somewhat complicated and include numerous joins. There are many great good DB books out there, but Access is probably harder learn than Revit is. Not something you do in an afternoon. I've taken three semester of college level database management courses and that is still not enough and I need to go back and take more. Everything you want to do is possible in Access, but it takes a pretty high level knowledge of databases to pull it off. I wish you well.
-----------------------------------
Tom www.reviteer.com http://twitter.com/Reviteer |
This user is offline |
View Website
|
|
|
Search
63208_20605rds_copy.pdf
