a thread about stringy things

[snowyweston]

So we (finally) updated our Newforma server & clients last night - woohoo!

And w/ the re-index some ungodly-long filepaths were found, so many that my normal bounce-on of the auto-email alert would have been pointless... but seizing the opportunity to settle a curiosity, I set on little Dynamo study.

You see, whilst Newforma might auto generate/send a .msg in a html-like format:

HEADER
Project: JobNumber - JobName
Folder: FolderName
Files:
* FileName (list)
FOOTER

it/they don't offer up the same in a useful (to me) .csv format. No bother, save the .msg as a .txt then pick it apart with Dynamo then re-write it... easy, no?

Sure, so, I trim out the header & footers, then start using string-splits... and I end up with a structured list following the form:

>Project
>>Folder
>>>File

So far so good. But then I hit a stumbling block, and suspect I went the wrong way "cleaning" the list(s) - because instead of getting a transposable list structure I can readily export to Excel, my grouping of files-under-folders-under-project (which isn't how the Newforma auto-report comes at all, unhelpfully) just doesn't want to play nice.

_____________




I know I've got to add the column headers as first items at some point, which may potentially require I use list cycles, but for the life of me I'm stuck at making that list-structure make sense for the excel write node.


Attached is my fugly (annotated) dyn & sample .txt file (that handles all the conditions that can/do occur in the Newforma report original .msg) and I'm fairly certain there are far cleaner, quicker and surer ways of handling this that one or more of you might see instantaneously. Would be most appreciative if you'd take a look!

[Nurlan]

I think it would be easier to process this data using Excel Power Query.

[snowyweston]

I think it would be easier to process this data using Excel Power Query.

you know, shortly after posting this as I crawled into bed and had that very thought.

[Bjorn_K]

Assuming you wanted them "1 file on 1 line" in 1 long row, this is a solution.

Maybe you wanted to sort them by project or each project on an Excel Sheet?

[snowyweston]

Assuming you wanted them "1 file on 1 line" in 1 long row, this is a solution.

Maybe you wanted to sort them by project or each project on an Excel Sheet?

*squints*

where's that second 4K screen I need?

Thanks dude, will take a look then answer your query with surety (at a guess, no, I wasn't looking to split out to sheets, was just looking for a raw table w/ repeated items, which looks like what you've done...)

diving in!



EDIT
Bjorn you beaut!

[Bjorn_K]

*squints*

Thought I had included the full-size screenshot. If you need the file for legibility reasons, let me know.

[snowyweston]

Thought I had included the full-size screenshot. If you need the file for legibility reasons, let me know.

no you had, I meant more that it reads so teeny full-screen, even here!

I've just spied the folders (in my export and my-reworked script) don't differentiate, so think I might have missed a trick so taking another look.

Edit
Fixed


(I'd set that's list's cycle amount's level wrong)


…on level's, why do they sometimes go blue and @@

does it affect anything?

or is it one of those geek in-jokes?

[Nurlan]

Practiced a little in PowerQuery

[Bjorn_K]

The Blue color should indicate that you also have the other checkmark on, where you check List@Level. The maintain List Structure option. I think the original List@Level Blog on DynamoBIM.org is a good resource to read up on what it does exactly.

https://dynamobim.org/introducing-li...s-made-easier/