Results 1 to 4 of 4

Thread: Batch Export Schedules

  1.    #1
    Member koolair's Avatar
    Join Date
    July 31, 2014
    Posts
    264
    Current Local Time
    08:42 AM

    Not allowed! Not allowed!

    Batch Export Schedules

    ***EDIT***
    Thread Title should be "Batch Export Schedules"
    **********

    Does anyone do batch excel exports of their Revit schedules?

    I tried BimOne's app, but their excel export only exports .xls format. I could work with this but would rather have a system that uses Revit's native data export format, which is .csv.

    Background:
    I have a project-wide schedule for a particular subcategory of elements which I export as .csv, which I then import into Excel via Excel's Data tab, Get Data. The schedule is already sorted by four parameters but the PM wants it sorted by a fifth parameter (level). So I added a level filter to exclude all elements except those on level 1. Duplicated 10 times and adjusted the level filter's value for each. But now I have to create 11 separate .csv files. Every time the PM wants the current Bill of Material, I have to open all 11 schedules and export each manually.

    Checked Google, no dice.

    Any ideas? Thanks.
    Last edited by DaveP; October 10th, 2019 at 01:50 PM. Reason: mod: fixed the title

  2.    #2
    Senior Member
    Join Date
    December 16, 2010
    Posts
    883
    Current Local Time
    10:42 PM

    Not allowed! Not allowed!
    If you look in the complements tab in Revit there is DB Link. Have you tried the DB link?

  3.    #3
    Junior Member
    Join Date
    September 25, 2014
    Posts
    15
    Current Local Time
    08:42 AM

    Not allowed! Not allowed!
    Our office developed a pretty simple Dynamo script that asks where to save the CSVs and for criteria to filter which schedules are exported.


    I don't understand why you are doing what you are doing, though. The way I would set up is one schedule in RVT that exports to one CSV. The final Excel sheet would have one 'presentation' sheet and one 'export from Revit' sheet where the CSV data is imported/reloaded. The presentation sheet reads from the export sheet to show the data however you want it to. It takes time to write the formulas to pull what you want from the export sheet, but it ends up being much more flexible.

  4.    #4
    Member
    Join Date
    February 29, 2012
    Posts
    65
    Current Local Time
    07:42 AM

    Not allowed! Not allowed!
    There are two data challenges here:
    1. Exporting all of the BOM content at once. A Revit multi-category schedule, for example, excludes all system families which, are kinda' important for a BOM
    2. Identifying the Level property of each, since they are organized differently across various data categories (Wall level is different than equipment level, for example).

    This is how we manage that challenge, in case you are interested: https://ideatesoftware.com/support/h...uality-takeoff

    Best Regards,
    Glynnis Patterson
    www.ideatesoftware.com

Similar Threads

  1. Export to DWG settings help
    By Kyle Roseman in forum Structure - General Questions
    Replies: 0
    Last Post: July 31st, 2015, 11:41 PM
  2. Export Realistic View Settings
    By Versiamo01 in forum Architecture and General Revit Questions
    Replies: 1
    Last Post: March 25th, 2015, 05:33 PM
  3. Export Realistic View Settings
    By Versiamo01 in forum Rendering and Gallery
    Replies: 1
    Last Post: March 25th, 2015, 05:33 PM
  4. Is it possible to export your UI settings
    By joewallace in forum Architecture and General Revit Questions
    Replies: 5
    Last Post: October 10th, 2014, 06:51 PM
  5. 2012: Export to DWG Layer settings file
    By DaveP in forum Architecture and General Revit Questions
    Replies: 3
    Last Post: August 10th, 2011, 06:11 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •