Multi file component list to excel

samyell77 · 2 Sept 2011, 08:26

Hi,
This is a longshot but Im wondering if anyone can help me. Id like to find a way to output a list of all components in multiple SU files to excel / spreadsheet format. Im not sure if the plugin would need to have all the relevant SU files open or if it could run like a batch process in Photoshop where you tell it to run the action on all the files in a specific folder? And the icing on the cake would be having the component list save with the same name as the file it came from (so if I run it on 10 named SU files I would get 10 named separate spreadsheets)? Im not a programmer and have never used Ruby before but I know there are some very clever script writers on here so would be very interested to hear anyones thoughts. Ive seen a couple of threads here but haven't found anything yet that will quite do what Im after. Apologies if this totally unrealistic but if I can find away to do this it would save me hours of work!?
Thanks in advance
Sam

TIG · 2 Sept 2011, 14:07

Find my ComponentReporter++.rb for an example of something you might build on...

jgb · 2 Sept 2011, 16:34

Tig and I are working (although both of us are in a temporary holding pattern due to other conflicts that have taken some priority) on what you are asking about, but from a single SU file only.

Tig is doing the SU data extracts, I am developing the EXCEL spreadsheet into a somewhat flexible report generator. Ultimately, just about all SU data (less the actual drawing vectors) will be accessible and reportable, and later on, some limited ability to edit SU data (such as component names) in EXCEL and upload back to the SU model.

I believe editing text data in EXCEL will be easier than editing in SU as you have all the various text fields visible. In SU you basically can only see what you are editing. This is important if you need to make a wholesale text change to, say, component names to bring about a commonality in sets of names.

If you need a multi-model report now, then I suggest you run TIG's current rep-gen on each SU file, bring them into an EXCEL sheet and merge the data manually.

samyell77 · 27 Sept 2011, 13:56

Thanks both for your responses - Ive been side tracked by another project but will be looking back into this shortly. Component reporter is fantastic TIG - very detailed! And JGB thanks for advice about running the script on files individually, no problem just wondered if I could run it on multiple files to save some time.

Cheers

Sam