Hiero Spreadsheet CSV Export v1.1


 
This location is for Registered Users Only.
Perhaps you need to login or register.
Contributor: Antony Nasce
Export the contents of the Hiero Spreadsheet view to a CSV file.
Requirements:
7.0, 6.3 or later
Linux, Mac, Windows
04 Sep 2013
682

This example exports all the visible columns and rows of in your Spreadsheet to a .CSV file.

This works with the raw data, currently displayed in the View, which means if you've searched in the search box, only the filtered results will be exported.

It also exports all text data displayed in custom columns.

Usage:

1) Copy SpreadsheetExport.py it to ~/.hiero/Python/Startup
2) Right-click in Spreadsheet > Export as .CSV > Select a path to save to.

Note: this does not currently maintain the column ordering in the CSV, but does handle custom visible/hidden columns.

Please login in order to download these files.

Comments   

 
+1 # Ivar Rystad 2012-11-01 04:13
Hi!
This is just the tool I was looking for!
First I couldn't get the script loaded when i put it in /StartupUI/Pyth on directory. But after reading the manual I got it loaded when I put it in /Python/Startup directory.

Now its loaded but I get some error messages when trying to run it. Pasting console output here:

exporting CSV...
seq is Sequence('REMEMBER_50_SEK_DC_EDL')
Traceback (most recent call last):
File "C:/Users/IVAR/ .hieroPythonSta rtupspreadsheet _csv_export.py" , line 165
, in exportCSV
writeCSVFromSeq uence(seq)
File "C:/Users/IVAR/ .hieroPythonSta rtupspreadsheet _csv_export.py" , line 73,
in writeCSVFromSeq uence
csvSavePath = os.path.join(os .getenv('HOME') ,'Desktop',seq. name()+'.csv')
File "C:/Program Files/The Foundry/Hiero1.5v1b8lib
tpath.py", line 96, in jo
in
assert len(path) > 0
TypeError: object of type 'NoneType' has no len()

Using the latest Hiero 1.5b8 version on windows. Hope to hear from you soon.
 
 
# Ivar Rystad 2012-11-02 08:39
Hmmm, I tried it again with a different project and after a restart. And that works. Will try out a couple of other projects and see if it was just a bug with that spesific project.
 
 
# Alexander Somma 2013-05-18 08:50
I'm getting the same result. Any clue to why it gives that error?

Alex
 
 
# Felix Bueno 2015-03-19 10:45
Hi Antony

Is it possible to have an update of your python script that works with nukeStudio?

Many thanks
 
 
# Michael Habenicht 2015-10-16 16:31
First of all, thank you very much for this handy tool and all your other hiero scripts, Antony!!

@Felix: I had no problem using it with nuke 9.0v7 in hiero mode. But it should also work with studio, I guess!
 
 
# Gaston Marcotti 2016-06-30 22:16
Hi, any chance to have it for NukeStudio? thank you
 
 
# Jen Thompson 2016-07-28 16:21
Can't get this to work for Nuke 10. Is there an updated script?
 
 
# Paul Wiens 2016-09-09 01:01
For Nuke 10, you just need to add 1 line at the top:

from hiero.core import *

- Paul
 
 
# adam jones 2017-06-28 02:02
I am unable to get this to work ecvn with new line added, 10v6 mac osx
 
 
# ke han wang 2019-02-11 18:16
I just wanna know if it works on Hiero 11,2v4? Thanks a lot
 
 
# ke han wang 2019-02-11 18:17
And I've already got a "excel exporter" on Hiero so I wonder if it will do sth against my software
 
 
# ke han wang 2019-02-11 18:29
Still cant find the path:.hiero so any one explain about this
 

You have no rights to post comments

We have 2114 guests and 62 members online