Schedule data from a list not working

Kangal · November 14, 2018, 1:38pm

Hi all,

I gratefully use the Python scripts from Thomas Mahon to read the data of my schedules.
But I can not read the list of schedules. It must be one by one.

I received an advice to us node List.Map, but I don’t no how.
Can someone help me please.

Link to python script:
python script Thomas Mahon

Regards,

Kangal

mellouze · November 14, 2018, 1:43pm

Hi,

The two easiest way would be :

If you know how to code in Python, add a loop to the Python script in order to iterate through your list of schedules
If you don’t know how to code in Python, create a Dynamo custom node, containing only the Python Script (select your script, then right-click, create custom node). Then double-click on the new custom node, and replace what will be written in the input block of the custom node by “ScheduleView”.

One of the two solutions should do the trick

Kangal · November 14, 2018, 2:09pm

Hi Mellouze,

Thanks for your reply.
unfortunately I can not code in Python.
making a custom node is also not an option, because my company does not want to use a custom node.

Have you also a third option

Regards,

Kangal

mellouze · November 14, 2018, 2:20pm

Well, if you cannot apply either options, you’ll pass a pretty rough time while using Dynamo.

Not even sure this works or is optimal, but it is the best I can do. You can also try contacting @Thomas_Mahon.

#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

schedules = IN[0]
result = []

for i in range(len(schedules)):
	schedule = UnwrapElement(schedules[i])
	
	# "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()
	result.append(dataListRow)

OUT = result

Kangal · November 14, 2018, 2:28pm

You are the best Mellouze.
it works

thank you very much!!!

mellouze · November 14, 2018, 2:29pm

Glad I helped

Kangal · November 14, 2018, 3:01pm

Hi Mellouze,

I hate to ask but is it possible to use the script without flatten?
so I do not lose my list.

Regards,

Kangal

mellouze · November 14, 2018, 3:05pm

This is the exact reason why you HAVE to use custom nodes at some point … This solution only work for THIS particular problem…

#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

list_schedules = IN[0]
result = []

for schedules in list_schedules :
	mini_result = []
	for schedule in schedules :
		schedule = UnwrapElement(schedule)
	
		# "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()
		mini_result.append(dataListRow)
	result.append(mini_result)

OUT = result

Jonathan.Olesen · November 14, 2018, 3:07pm

Guess the original code with the list.map (or list.combine) using list levels would works as well but agree, if you’re not allowed to use custom nodes or is able to modify the simplest parts of a python script you’re gonna have a hard time in the land of Dynamo…

mellouze · November 14, 2018, 3:09pm

I don’t think that List.Map and List.Combine actually work with Python Script, as Python scripts cannot be passed as functions I tried before with no success.

Jonathan.Olesen · November 14, 2018, 3:10pm

I’m not at a computer but will give it a go tomorrow might be a fun challenge

Kangal · November 14, 2018, 3:11pm

Thank you Mellouze,

I will also hammer in our office to use Custom Nodes

mellouze · November 14, 2018, 3:16pm

Good luck haha Had a hard time ! (As you can see, the Python Scripts are compiled and not undestood by Dynamo as functions)

a = IN[0]

OUT = a+1

Kangal · November 14, 2018, 3:17pm

hi Jonathan,

I also tried it, but unfortunately I did not succeed with List.Map.
Good luck tomorrow

Jonathan.Olesen · November 14, 2018, 4:03pm

Good luck was not enough Couldn’t wait till tomorrow to try my ideas…
Custom nodes will be the way to go, and if it has to do with sharing the nodes internally you could create a “company-package” containing the custom nodes used in the company

A side-note is that is was possible to pass functions, and I’m guessing using python nodes as functions back in Dynamo 0.6.3 but the functionality disappeared in the migration to 0.7.x…

There is a promise in there that it, as Arnold would say, be back… But so far no cigar.

Kangal · November 14, 2018, 7:17pm

Hi Jonathan,

thanks for trying, too bad that it did not work out
I also think that we must go to a company-package. Thanks for your input.

Regards,

Kangal

Jonathan.Olesen · November 15, 2018, 9:09am

Just wanted to add a solution that does not care about how you list is structured, but will work on any depth like follows:

Credit to @kennyb6 as I’ve borrowed a little of his code from this post: Change list structure to match another list structure

Implementing that in @mellouze adaption of @Thomas_Mahon script it would look something like this, but it could probably be modified so that you keep your list structure in the output

#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(&quot;RevitServices&quot;)
import RevitServices
from RevitServices.Persistence import DocumentManager
from RevitServices.Transactions import TransactionManager
from System.Collections.Generic import *
#
# Import RevitAPI
clr.AddReference(&quot;RevitAPI&quot;)
import Autodesk
from Autodesk.Revit.DB import *

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

result = []

x = []
def rec(_lists):
    for _list in _lists:
        if isinstance(_list,list):
            c = rec(_list)
        else:
            x.append(_list)
    return x
schedules = rec(IN[0])

for i in range(len(schedules)):
    schedule = UnwrapElement(schedules[i])

    # &quot;Start&quot; 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 );

    # &quot;End&quot; the transaction
    TransactionManager.Instance.TransactionTaskDone()
    result.append(dataListRow)

OUT = result;

Kangal · November 16, 2018, 10:16am

Nice Jonathan!!
This will help me in the future.

Thank you!

RubenVivancos · July 2, 2020, 8:03am

Is there a way to make Dynamo quicker to respond reading schedules data?

I tried this python script for dynamo and bimorph node schedule get data and it never finish to run for a list of 35 schedules with many parameters in each, computer running without success, memory RAM used over 6GB. Literally I waited 5 hours and Dynamo still running.

Topic		Replies	Views
Key schedule Revit python	9	4213	August 7, 2017
Creating schedule throught python script struggle Revit	7	2074	September 27, 2017
Read data in Pre-created schedule in Revit Developers revit , schedule	4	7830	September 18, 2016
Custom schedule parameters Lists-Logic	5	635	October 2, 2018
Create Revit Schedules from Excel List or Assemblies	23	1141	November 15, 2019

Schedule data from a list not working

Related Topics