sketchucation logo sketchucation
    • Login
    ℹ️ Licensed Extensions | FredoBatch, ElevationProfile, FredoSketch, LayOps, MatSim and Pic2Shape will require license from Sept 1st More Info

    [Plugin] TIG_ReportConverter

    Scheduled Pinned Locked Moved Plugins
    27 Posts 9 Posters 10.1k Views 9 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • TIGT Online
      TIG Moderator
      last edited by

      Your 'original' CSV still has the misplaced NAME column, throwing off LENZ.
      Also there are either some missing ',' and/or extra doubled=up " characters.
      e.g.
      "TOTALS,""-"",""-"",""-"",""-"",""-"",""53.448389"",""-"",""-11.456557"",...
      should be perhaps:
      "TOTALS","-","-","-","-","-","53.448389","-","-11.456557",...

      I can trap for 'out of order' columns, BUT messed-up 'separators' is never going to be resolvable !

      Is this CSV direct;y out of SketchUp 'Generate Report', or have you edited it...
      If it's 'raw', then SketchUp is really flaky !

      I also see there are unusual characters in the earlier ANSI file that might trip up the parsing...
      e,g, in the TOTALS at the end ...kesä.85...13.heinä [...Summer...Hay 😕 ??]
      which does not occur in the original UTF-8 CSV ?

      TIG

      1 Reply Last reply Reply Quote 0
      • TIGT Online
        TIG Moderator
        last edited by

        Here's v1.3 http://sketchucation.com/pluginstore?pln=TIG_ReportConverter
        It is more robust.
        The cells for VOLUME/X,Y,Z/LENX,LENY,LENZ are now converted 'by-header', rather than by column index.
        So an 'inch' report file that has been manually edited can still be converted, even when column order is changed.
        The default cell 'separator' of a comma [ ,] and for all cells below the first header-row surrounded with "" is used for the converted CSV, BUT the original input CSV can use any separator format - e.g. default "," or plain , or ; or a TAB [ \t] etc...
        It also now forces the CSV encoding into "UTF-8-without-BOM" [>=v2014], so if the CSV file has been edited and ill-advisedly saved as ANSI it will still be read in OK, although note that some obscure Unicode accented-characters might get replaced by '?' where they cannot be converted...

        TIG

        1 Reply Last reply Reply Quote 0
        • TIGT Online
          TIG Moderator
          last edited by

          Here's v1.4 http://sketchucation.com/pluginstore?pln=TIG_ReportConverter The encoding fix now only applies in SketchUp >= v2014 [previous typo allowed it to try on earlier versions too!], so this now allows the tool to be used with earlier versions again, but they might have issues with oddly encoded strings in edited descriptions etc...
          Also the robustness of the column spotting is improved.

          TIG

          1 Reply Last reply Reply Quote 0
          • B Offline
            bealj
            last edited by

            Hello,
            I have a question... It's very important!
            I have Sketchup 2013 pro (In spanish)
            I have download this plugins, because I need the report in meters no inches.
            But, when I generate that in excel, it continues to be in inches! I don't know what happens...
            Help me please...

            1 Reply Last reply Reply Quote 0
            • TIGT Online
              TIG Moderator
              last edited by

              @bealj said:

              Hello,
              I have a question... It's very important!
              I have Sketchup 2013 pro (In spanish)
              I have download this plugins, because I need the report in meters no inches.
              But, when I generate that in excel, it continues to be in inches! I don't know what happens...
              Help me please...
              Do you have the latest version [v1.4] ?
              Do you use a ',' as a decimal-separator - instead of '.' ?
              Although I have tested it in both formats and it works for me.
              The 'headings' which are converted are the columns X Y Z LENX LENY LENZ and VOLUME ?
              Are yours ?
              Can you send me the original report CSV [in inches] by Private Message, so I can look into it...

              TIG

              1 Reply Last reply Reply Quote 0
              • TIGT Online
                TIG Moderator
                last edited by

                Here's v1.5 http://sketchucation.com/pluginstore?pln=TIG_ReportConverter
                Have have finally tracked down the issue with failures in some locales...
                Turns out that although X/Y/Z and LENX etc are common headings in the Generated Report, other headings may be changed to suit a locale - so EN-US's 'ENTITY VOLUME' becomes 'ELEMENTVOLUMEN' in German etc.
                The headings are used to find the columns to adjust as the Volume is not consistently put in Column-G.
                This fix now looks for a match to /[Vv][Oo][Ll][Uu][Mm][Ee]/ in the column header [this applies to all Latin based alphabets], or a match to 'Volume' translated into various other locales - like RU,JA,KO,CH
                Hopefully this will now resolve the issues reported from other locales...

                TIG

                1 Reply Last reply Reply Quote 0
                • BarbaraDB Offline
                  BarbaraD
                  last edited by

                  I'm afraid my english doesn't reach a disussion.
                  But the image shows more than words can say.

                  Hope this is helpful.


                  Importing with LibreOffice (OpenSorce)


                  Converter v1.5


                  Last but not least the Faktor!

                  1 Reply Last reply Reply Quote 0
                  • TIGT Online
                    TIG Moderator
                    last edited by

                    OK Barbara[D],
                    I guess this is a follow up from an earlier discussion, 'elsewhere'.

                    I believe that the Generate-Report CSV made in the German locale still uses '.' as the decimal separator.
                    Your Excel setting might well then display the data using ,
                    I am aware of the two competing conventions for decimal-points [. versus ,] and separating 'thousands':
                    UK/USA etc 1,234.5 or 1 234.5
                    and EU etc 1.234,5 or 1 234,5
                    But as far as I can see those settings don't affect the original CSV format.
                    It is not formatted to locale in the original CSV or the converted version.

                    If you use the v1.5 is it converted OK ?
                    That is, inches >>> metres !
                    The 'format' is unchanged.
                    Can you post the original CSV and the converted CSV.
                    ZIP then so they can be attached to a post.
                    You'll probably need to get at least one more post approved by an Admin before you can make attachments...

                    TIG

                    1 Reply Last reply Reply Quote 0
                    • N Offline
                      Neroro
                      last edited by

                      @tig said:

                      This fix now looks for a match to /[Vv][Oo][Ll][Uu][Mm][Ee]/ in the column header [this applies to all Latin based alphabets], or a match to 'Volume' translated into various other locales - like RU,JA,KO,CH
                      Hopefully this will now resolve the issues reported from other locales...

                      Will the Plugin contain "zh-tw" in future?
                      Chinese characters be replaced by '?'

                      1 Reply Last reply Reply Quote 0
                      • TIGT Online
                        TIG Moderator
                        last edited by

                        @neroro said:

                        @tig said:

                        This fix now looks for a match to /[Vv][Oo][Ll][Uu][Mm][Ee]/ in the column header [this applies to all Latin based alphabets], or a match to 'Volume' translated into various other locales - like RU,JA,KO,CH
                        Hopefully this will now resolve the issues reported from other locales...

                        Will the Plugin contain "zh-tw" in future?
                        Chinese characters be replaced by '?'
                        It's hard to fix non-ASCII characters in the reports.
                        The best it can do is not-trip up on them.
                        Also with <= v2013 I think it would not be possible at all.
                        My only intention is to change lengths and volumes from the default 'inches' into the user's choice - say 'meters'.

                        TIG

                        1 Reply Last reply Reply Quote 0
                        • H Offline
                          HandShake
                          last edited by

                          hello - i installed this plugin and it does a great job - many thanx
                          yet - i went to great trouble to have the 'dot' or '.' that i have on teh numeric key pad to make a 'comma' so that it would work in a spreadsheet to seperate entires from decimals in the language setting - i believe - that i have.
                          now, after applying the plugin, the colums for values come with the 'dot'seperator --- uuuugh
                          so - may spreadsheet program sees them as texts and not as numbers - bugger.

                          can i fix this without changing the setting i went through trouble to make?

                          many thanx
                          geert-hugo

                          1 Reply Last reply Reply Quote 0
                          • BarbaraDB Offline
                            BarbaraD
                            last edited by

                            I will make a new modell without IFC import. Maybe it will be easier to read.

                            Edit:
                            v1.5 almost perfect now.
                            By importing, I forgot to unhock the space seperator.
                            In colum A there are more words with space. That toggled the colums.
                            Don't really need colum A + B. What are they for? Rather groups and komponents would be helpfull.

                            Edit:
                            Hi TIG,
                            what happend to the Report in SU 2016? That's nothing I would need. 👿
                            The Converter dosen't work anymore. What a pitty. 😢


                            Made new files and it looks much better. Congratulations it is Meter.

                            1 Reply Last reply Reply Quote 0
                            • S Offline
                              saldstudio
                              last edited by

                              thank very much for the plugin it save a lot of time! great job!

                              1 Reply Last reply Reply Quote 0
                              • 1
                              • 2
                              • 2 / 2
                              • First post
                                Last post
                              Buy SketchPlus
                              Buy SUbD
                              Buy WrapR
                              Buy eBook
                              Buy Modelur
                              Buy Vertex Tools
                              Buy SketchCuisine
                              Buy FormFonts

                              Advertisement