Results 1 to 9 of 9

Thread: a thread about stringy things

  1. #1
    Moderator snowyweston's Avatar
    Join Date
    December 21, 2010
    Location
    C.LONDON
    Posts
    4,539
    Current Local Time
    10:07 PM

    Not allowed! Not allowed!

    a thread about stringy things

    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.

    _____________
    Click image for larger version. 

Name:	NPC.png 
Views:	19 
Size:	668.6 KB 
ID:	39955



    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!
    Attached Files Attached Files

  2. #2
    Member
    Join Date
    December 11, 2010
    Location
    Astana
    Posts
    305
    Current Local Time
    04:07 AM

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

  3. #3
    Moderator snowyweston's Avatar
    Join Date
    December 21, 2010
    Location
    C.LONDON
    Posts
    4,539
    Current Local Time
    10:07 PM

    Not allowed! Not allowed!
    Quote Originally Posted by Nurlan View Post
    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.

  4. #4
    Member Bjorn_K's Avatar
    Join Date
    April 8, 2011
    Location
    Rotterdam, Netherlands
    Posts
    446
    Current Local Time
    11:07 PM

    1 Not allowed! Not allowed!
    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?

    Click image for larger version. 

Name:	project-folder-file.png 
Views:	18 
Size:	1.01 MB 
ID:	39958

  5. #5
    Moderator snowyweston's Avatar
    Join Date
    December 21, 2010
    Location
    C.LONDON
    Posts
    4,539
    Current Local Time
    10:07 PM

    Not allowed! Not allowed!
    Quote Originally Posted by Bjorn_K View Post
    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?

    Click image for larger version. 

Name:	project-folder-file.png 
Views:	18 
Size:	1.01 MB 
ID:	39958
    *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!

    Click image for larger version. 

Name:	bjorn.PNG 
Views:	9 
Size:	22.0 KB 
ID:	39960

    Last edited by snowyweston; January 20th, 2021 at 02:43 PM.

  6. #6
    Member Bjorn_K's Avatar
    Join Date
    April 8, 2011
    Location
    Rotterdam, Netherlands
    Posts
    446
    Current Local Time
    11:07 PM

    1 Not allowed! Not allowed!
    Quote Originally Posted by snowyweston View Post
    *squints*
    Thought I had included the full-size screenshot. If you need the file for legibility reasons, let me know.

  7. #7
    Moderator snowyweston's Avatar
    Join Date
    December 21, 2010
    Location
    C.LONDON
    Posts
    4,539
    Current Local Time
    10:07 PM

    Not allowed! Not allowed!
    Quote Originally Posted by Bjorn_K View Post
    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
    Click image for larger version. 

Name:	outlier.PNG 
Views:	8 
Size:	25.8 KB 
ID:	39961

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


    …on level's, why do they sometimes go blue and @@
    Click image for larger version. 

Name:	atat.PNG 
Views:	8 
Size:	30.6 KB 
ID:	39962
    does it affect anything?

    or is it one of those geek in-jokes?
    Click image for larger version. 

Name:	at-at.PNG 
Views:	10 
Size:	91.7 KB 
ID:	39963
    Last edited by snowyweston; January 20th, 2021 at 03:08 PM.

  8. #8
    Member
    Join Date
    December 11, 2010
    Location
    Astana
    Posts
    305
    Current Local Time
    04:07 AM

    1 Not allowed! Not allowed!
    Practiced a little in PowerQuery

    Click image for larger version. 

Name:	Table.PNG 
Views:	11 
Size:	40.6 KB 
ID:	39967Click image for larger version. 

Name:	Pivot.PNG 
Views:	10 
Size:	33.4 KB 
ID:	39968
    Attached Files Attached Files

  9. #9
    Member Bjorn_K's Avatar
    Join Date
    April 8, 2011
    Location
    Rotterdam, Netherlands
    Posts
    446
    Current Local Time
    11:07 PM

    Not allowed! Not allowed!
    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/
    Last edited by Bjorn_K; January 21st, 2021 at 09:33 AM.

Similar Threads

  1. Replies: 0
    Last Post: April 27th, 2016, 01:15 AM
  2. Thread Prefix's
    By Munkholm in forum Forum Suggestions and Feedback
    Replies: 0
    Last Post: March 27th, 2012, 11:24 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •