table builder

Could somebody at Bentley please update the still delivered  ms basic Macro "table.bas"  to a VBA macro, in V8i we cant  easily create tables  like our acad brothers, this little tool does a great  job but  it needs to be updated to VBA any takers....?

Parents
  • Unknown said:
    In V8i we can't  easily create tables

    FlexiTable™ solves that omission!  It provides quite a few other tools as well.

     
    Regards, Jon Summers
    LA Solutions

  • Unknown said:

    Lorys
    In V8i we can't  easily create tables

    FlexiTable™ solves that omission!  It provides quite a few other tools as well.

    Yes Flexitable is an excellent product with loads of features ... however as Basic  was said to be deprecated even when v8i was released, bentley provided  Table.bas FREE as part of the install V8i ss3 package .. I believe they should release or  provide a vba version or equivalent tool ... the old tool still works but under strict conditions  no bylevel anything or overrides to be used at all or it will give an overflow error, this may have mislead some  users to think it doesnt  work.. but this is still the same  code we had back in Version J...( well thats when I first saw it  could have been MS95 .. whichever came  first with it...)

    Lorys

    Started msnt work 1990 - Retired  Nov 2022 ( oh boy am I old )

    But was long time user V8iss10 (8.11.09.919) dabbler CE  update 16 (10.16.00.80) 

    MicroStation user since 1990 Melbourne Australia.
    click link to PM me 

  • Unknown said:
    Bentley provided  Table.bas FREE as part of the install V8i ss3 package

    Bentley Systems may provide table.bas with MicroStation, but it is not 'free'.  It's part of a software product for which your employer has purchased a license.  It's no more 'free' than, say, the cell dialog is 'free'.  To put it another way, if you were to advertise table.bas (or a modified version of it) as your table generator for MicroStation, Bentley Systems might take a legal action against you for violating their copyright, license agreement or both.

    Unknown said:
    The old tool [table.bas] still works but under strict conditions  no bylevel anything or overrides to be used at all

    As I may have mentioned before, MicroStation BASIC omits a lot of functionality that would make it play well with the V8 generation.  In particular, it knows nothing about named levels.  Nor does it comprehend level overrides.  That's one reason why MicroStation VBA, which does know about named levels and level overrides, is a much better choice for in-house programming.

    Unknown said:
    I believe [Bentley Systems] should release or  provide a vba version

    Well, MicroStation CONNECT includes reports and tables.  The table functionality in CONNECT is way better than BASIC or VBA could provide.  However, the technology behind it is not compatible with the V8 generation, so don't expect Bentley Systems to back-port tables to V8i.

     
    Regards, Jon Summers
    LA Solutions

  • ok its  not free but its included in the  package  for no extra cost , however  as I tried to say it was obsolete when it was supplied ... no matter..

    As regards to CE , I dont feel its  good enough to  use in production  office use yet , there seems to be  too many posts for CRs and defects  being  posted here  ... so we will wait  a little while longer and suffer V8i ...  there is still a very large  user base using  v8i I wonder if  we out number  the CE users...?

     

    Lorys

    Started msnt work 1990 - Retired  Nov 2022 ( oh boy am I old )

    But was long time user V8iss10 (8.11.09.919) dabbler CE  update 16 (10.16.00.80) 

    MicroStation user since 1990 Melbourne Australia.
    click link to PM me 

  • I'm pretty sure V8i outnumbers CE by quite a lot.
  • But MSBASIC works in v8i why you need it updated? Or you would like to edit tables created in CONNECT edition?

    >the old tool still works but under strict conditions  no bylevel anything or overrides to be used at all or it will give an overflow error

    This can be easy fixed just by changing variable declaration "Dim saveStyle   as Integer" to "Dim saveStyle as Long"  as bylevel(-1) for macro is equal to value 2147483647 which doesn't fit in integer variable(-32768 to 32767) that is why overflow error. Strange that such old macro which doesn't work is still included in v8i installation but it is not a surprise as MSBasic documentation also is full of examples which just don' t work.

    edit: attached as zip as otherwise forum renamed files and macro couldn't find the correct dialog.

    table-v8i.zip

    Answer Verified By: Lorys 

  • Unknown said:

    But MSBASIC works in v8i why you need it updated? Or you would like to edit tables created in CONNECT edition?

    >the old tool still works but under strict conditions  no bylevel anything or overrides to be used at all or it will give an overflow error

    This can be easy fixed just by changing variable declaration "Dim saveStyle   as Integer" to "Dim saveStyle as Long"  as bylevel(-1) for macro is equal to value 2147483647 which doesn't fit in integer variable(-32768 to 32767) that is why overflow error. Strange that such old macro which doesn't work is still included in v8i installation but it is not a surprise as MSBasic documentation also is full of examples which just don' t work.

    (Please visit the site to view this file)

    (Please visit the site to view this file)(Please visit the site to view this file)

    I  was asking for it to be updated to VBA  for two reasons,

    First  it wouldnt  work with  with  overrides and or bylevel etc   settings being active.

    Secondly because it was basic if I asked or mention if anyone would fix  as basic to stay basis.. I would undoubtedly be flamed  by  at least two of our most frequent posters as has happened every time I have  offered basic as a solution  or alternative  to solve a problem or  free tool..

    I have acquired many public domain  basic  programs  as well as made quite a few custom ones  myself over 25 years, and still use them  in v8i..

    I'm trying  to wean myself of basic in favour of vba, to prepare for the inevitable day  when we are compelled to use CE with much kicking and screaming .... I just dont  like the ribbon bar in anything I 've come across  ie MS office , Acad etc....I really  wish it was optional to use it........ oh back to topic

    Thanks for taking a look... cant wait to use the  updated tool ... I have one client that insists on tables being text  not  excel.... the  table bas is very good at getting the  data out of csv  ( ex excel tables....)

    Lorys

    Started msnt work 1990 - Retired  Nov 2022 ( oh boy am I old )

    But was long time user V8iss10 (8.11.09.919) dabbler CE  update 16 (10.16.00.80) 

    MicroStation user since 1990 Melbourne Australia.
    click link to PM me 

Reply
  • Unknown said:

    But MSBASIC works in v8i why you need it updated? Or you would like to edit tables created in CONNECT edition?

    >the old tool still works but under strict conditions  no bylevel anything or overrides to be used at all or it will give an overflow error

    This can be easy fixed just by changing variable declaration "Dim saveStyle   as Integer" to "Dim saveStyle as Long"  as bylevel(-1) for macro is equal to value 2147483647 which doesn't fit in integer variable(-32768 to 32767) that is why overflow error. Strange that such old macro which doesn't work is still included in v8i installation but it is not a surprise as MSBasic documentation also is full of examples which just don' t work.

    (Please visit the site to view this file)

    (Please visit the site to view this file)(Please visit the site to view this file)

    I  was asking for it to be updated to VBA  for two reasons,

    First  it wouldnt  work with  with  overrides and or bylevel etc   settings being active.

    Secondly because it was basic if I asked or mention if anyone would fix  as basic to stay basis.. I would undoubtedly be flamed  by  at least two of our most frequent posters as has happened every time I have  offered basic as a solution  or alternative  to solve a problem or  free tool..

    I have acquired many public domain  basic  programs  as well as made quite a few custom ones  myself over 25 years, and still use them  in v8i..

    I'm trying  to wean myself of basic in favour of vba, to prepare for the inevitable day  when we are compelled to use CE with much kicking and screaming .... I just dont  like the ribbon bar in anything I 've come across  ie MS office , Acad etc....I really  wish it was optional to use it........ oh back to topic

    Thanks for taking a look... cant wait to use the  updated tool ... I have one client that insists on tables being text  not  excel.... the  table bas is very good at getting the  data out of csv  ( ex excel tables....)

    Lorys

    Started msnt work 1990 - Retired  Nov 2022 ( oh boy am I old )

    But was long time user V8iss10 (8.11.09.919) dabbler CE  update 16 (10.16.00.80) 

    MicroStation user since 1990 Melbourne Australia.
    click link to PM me 

Children
  • Unknown said:
    I have one client that insists on tables being text  not  excel.

    FlexiTable™ creates tables using MicroStation graphic elements, including text elements for words & numbers.  That provides excellent quality graphics that print to PDF or paper with full fidelity.  That contrasts sharply with the poor quality of a linked Excel spreadsheet.

    Unknown said:
    ... table.bas is very good at getting the  data out of csv  ( ex excel tables....)

    It does a good job if the input text is literally unquoted strings separated by commas...

    one,two,three,...

    However, it doesn't accept anything other a comma as the field delimiter.  That is, you can't use a tab, say, or semi-colon to separate the fields. It will fail also if the CSV contains quoted text with an embedded comma (e.g. "1, High Street").

    FlexiTable reads Excel files directly, so there's no need to export from Excel to CSV before reading the CSV in MicroStation.

    Unknown said:
    I'm trying  to wean myself of basic in favour of VBA

    Good plan!  With the problems you've found with table.bas, I hope that you're beginning to appreciate the recommendation to prefer MicroStation VBA to BASIC.

     
    Regards, Jon Summers
    LA Solutions