Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenCities Map
  • Product Communities
  • Geospatial
  • OpenCities Map
  • Cancel
OpenCities Map
OpenCities Map Forum
    • Sign In
    • All tags
    • SQL Server
    • API
    • Bentley Geospatial Administrator
    • Bentley Map
    • Database
    • DFS
    • Geospatial Administrator
    • Interoperability
    • Oracle
    • Oracle Spatial
    • Promote
    • Register Features
    • VBA
    • XFM
    • XFT
    • Register Feature from SQL Server table with bit datatype column

      asj
      asj
      I'm in the process of designing a SQL Server database where one of the tables contain a column with the datatype bit. When I try to register the features in the table, Geospatial Administrator doesn't seem to recognize this column. In the end, I want…
      • over 7 years ago
      • OpenCities Map
      • OpenCities Map Forum
    • RE: [BM SS4] User Data Linkages and Group Hole Elements

      Jeff Bielefeld
      Jeff Bielefeld
      Bruce, I appreciate the additional sample data. I've been out of the office for the past few days travelling on business but earlier today using the new data I ran the attached promote2.mvba process which created 4 new polygon collection feature instances…
      • over 7 years ago
      • OpenCities Map
      • OpenCities Map Forum
    • RE: [BM SS4] User Data Linkages and Group Hole Elements

      Jeff Bielefeld
      Jeff Bielefeld
      Bruce, thank you for that confirmation. If you could send me one more sample design file that contains shapes, complex shapes and grouped holes connecting to at least 3 different MSLINK values then I will complete verification testing of my revised code…
      • over 7 years ago
      • OpenCities Map
      • OpenCities Map Forum
    • RE: [BM SS4] What happens to User Data Linkages?

      Jeff Bielefeld
      Jeff Bielefeld
      Bruce, Please zip up and send me via private message... Your modified MVBA file. A sample design file containing the original MicroStation shape elements. A current copy of your Bentley Geospatial Administrator schema file. ...and I will…
      • over 7 years ago
      • OpenCities Map
      • OpenCities Map Forum
    • RE: [BM SS4] What happens to User Data Linkages?

      Jeff Bielefeld
      Jeff Bielefeld
      Bruce, The provided MVBA example code demonstrates how one could read the MSLINK value from the graphical element in the promoted polygon collection feature instances and write the value to a business property, which after posting would appear in a…
      • over 7 years ago
      • OpenCities Map
      • OpenCities Map Forum
    • RE: [BM SS4] What happens to User Data Linkages?

      Jeff Bielefeld
      Jeff Bielefeld
      Bruce, During the "Promote" process the database linkages should be preserved and remain available on the elements. However database linkage information is not automatically available on the feature instance or inserted into the spatial database during…
      • over 7 years ago
      • OpenCities Map
      • OpenCities Map Forum
    • RE: [BM SS4] Registered SQL*Server Feature has no Text Sub-Feature

      Jeff Bielefeld
      Jeff Bielefeld
      Bruce, I contacted one of my colleagues familiar with the "Insert > Polygon Placement Metadata..." process in the Bentley Geospatial Administrator and was able to determine that the "Align" annotation option is not available for polygon collection feature…
      • over 7 years ago
      • OpenCities Map
      • OpenCities Map Forum
    • RE: [BM SS4] Registered SQL*Server Feature has no Text Sub-Feature

      Jeff Bielefeld
      Jeff Bielefeld
      Bruce, It sounds as if you may have failed to select or define a "Text Expression" during registration of your point feature. In the following image... ...the "[NAME]" property was selected as the "Text Expression" which should result in... …
      • over 7 years ago
      • OpenCities Map
      • OpenCities Map Forum
    • RE: [BM SS4] GSA and Registering Spatial Features

      Jeff Bielefeld
      Jeff Bielefeld
      Bruce, The documentation appears to be in error. I would recommend that you rename your columns to MS_X_SCALE and MS_Y_SCALE and register your feature class again, verifying that the expected columns are automatically selected and not showing up as…
      • over 7 years ago
      • OpenCities Map
      • OpenCities Map Forum
    • RE: [BM SS4] GSA and Registering Spatial Features

      Jeff Bielefeld
      Jeff Bielefeld
      During the "Register Features..." process columns named MS_ANGLE, MS_X_SCALE and MS_Y_SCALE are automatically selected as shown in the following. As Jerry mentions you can use any database column names for angle and rotation but manual selection in…
      • over 7 years ago
      • OpenCities Map
      • OpenCities Map Forum
    • Geospatial Administrator connect to SQL Server View

      Nathan Lawrence
      Nathan Lawrence
      Hi All, I am wondering if it is possible to connect to a MS SQL Server view as a graphical source. I have created the view with an unique clustered index but when attempting to retrieve feature data from it via Graphical Sources> SQL Server Spatial…
      • Answered
      • over 9 years ago
      • OpenCities Map
      • OpenCities Map Forum
    • View related content throughout OpenCities Map
    • More
    • Cancel
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies