Read data in Pre-created schedule in Revit

Developers
,
1

I have created a schedule in Revit and i just want to select that view in Dynamo and read the data as strings, so it gives me nested lists of each of the columns/rows in the schedule. I know I can return the elements but i want the entire table of information as it has been filtered and sorted. Any ideas?

2

Hi Mark

You’ll need Python / Revit API. I believe there is a package that does this too but not sure which so maybe someone else on the forum can point you in the right direction.

I use this python script…next time, I’ll need to invoice you :wink:

If you use filters, this script will simply pick up the data thats visible

#Copyright 2016. All rights reserved. Bimorph Consultancy LTD, 5 St Johns Lane, London EC1M 4BH www.bimorph.co.uk
#Written by Thomas Mahon @Thomas__Mahon info@bimorph.co.uk

import clr
clr.AddReference('ProtoGeometry')
from Autodesk.DesignScript.Geometry import *

# Import DocumentManager and TransactionManager
clr.AddReference("RevitServices")
import RevitServices
from RevitServices.Persistence import DocumentManager
from RevitServices.Transactions import TransactionManager
from System.Collections.Generic import *
#
# Import RevitAPI
clr.AddReference("RevitAPI")
import Autodesk
from Autodesk.Revit.DB import *

doc = DocumentManager.Instance.CurrentDBDocument
uiapp = DocumentManager.Instance.CurrentUIApplication
app = uiapp.Application

schedule = UnwrapElement(IN[0])

# "Start" the transaction
TransactionManager.Instance.EnsureInTransaction(doc)
		
#count the number of rows and columns in the schedule
table = schedule.GetTableData().GetSectionData(SectionType.Body)
nRows = table.NumberOfRows
nColumns = table.NumberOfColumns

#Collect all of data from the schedule
dataListRow = []
for row in range(nRows): #Iterate through the rows. The second row is always a blank space
	dataListColumn = []
	for column in range(nColumns): #Iterate through the columns
		dataListColumn.Add( TableView.GetCellText(schedule, SectionType.Body, row, column) )
	dataListRow.Add( dataListColumn );

# "End" the transaction
TransactionManager.Instance.TransactionTaskDone()

OUT = dataListRow
11 Likes
3

Haha cheers Tom, I thought I had seen a node in someones package that did it.

4

@Thomas_Mahon,

This is great. Thanks for sharing. I would just have two small comments:

  • you don’t need a Transaction for this as you are not creating anything but merely reading a data in a ViewSchedule

  • You don’t need a ProtoGeometry import since you never use any methods from that library.

Also, @Mark_Thorley1 as an alternative, and I am not sure what you want to do with the data, but if you want to take the data and write it out to Excel, you can do this:

# Copyright(c) 2016, Konrad K Sobon
# @arch_laboratory, http://archi-lab.net

# Import Element wrapper extension methods
import clr
clr.AddReference("RevitNodes")
import Revit
clr.ImportExtensions(Revit.Elements)

# Import RevitAPI
clr.AddReference("RevitAPI")
import Autodesk
from Autodesk.Revit.DB import *

import sys
pyt_path = r'C:\Program Files (x86)\IronPython 2.7\Lib'
sys.path.append(pyt_path)

#The inputs to this node will be stored as a list in the IN variable.
dataEnteringNode = IN

def ProcessList(_func, _list):
    return map( lambda x: ProcessList(_func, x) if type(x)==list else _func(x), _list )

def Unwrap(item):
	return UnwrapElement(item)

if isinstance(IN[0], list):
	schedules = ProcessList(Unwrap, IN[0])
else:
	schedules = [Unwrap(IN[0])]

directory = IN[1]

def ExportSchedule(schedule, dir = directory):
	options = ViewScheduleExportOptions()
	# there are couple of options that can be set here:
	# ColumnHeaders: options are None, OneRow and MultipleRows
	options.ColumnHeaders = ExportColumnHeaders.MultipleRows
	# FieldDelimiter: input is a string. By default Tab is used
	options.FieldDelimiter = ","
	# HeadersFootersBlanks: if you want to export blank headers and footers just set it to True
	options.HeadersFootersBlanks = True
	# ExportTextQualifier: how to identify text fields. Options are None, Quote or DoubleQuote
	options.TextQualifier = ExportTextQualifier.DoubleQuote
	# Title: set to True if you wish to export it.
	options.Title = True
	schedule.Export(dir, schedule.Name + "_export.csv", options)

try:
	errorReport = None
	ProcessList(ExportSchedule, schedules)
except:
	# if error accurs anywhere in the process catch it
	import traceback
	errorReport = traceback.format_exc()

#Assign your output to the OUT variable
if errorReport == None:
	OUT = schedules
else:
	OUT = errorReport

Pasted image926Ă—766 30.9 KB

Result when you import it into an Excel would be this:

Pasted image457Ă—665 10.2 KB

This is a method that is available in API for exporting ViewSchedules directly to CSV, TSV or any other delimited text files. Hope this helps!

Cheers!

13 Likes
5

@Konrad_K_Sobon nice one, appreciate the tips!