The case occurred in a project where the central base was Oracle, but to do cadastral maintenance at the level of municipalities or public exhibitions required the basis of features in order to edit maps while offline.
How it was made
Only for those who love knowing how it was smoked, here I explain, because in a couple of years, this project may be migrated to Bentley Map and none of this will be useful, except for some 8 types that will know how to match the rhythm of the public necessity and private ingenuity.
An Access file was created, starting with the Oracle project, which had the 10 basic tables of one Geographics project, including its contents and storing it with the name generica.mdb. The tables are the following:
| || || |
Then the Geographics user configuration file was edited Msgeo.ucf that had basic aspects for the connection to that base. This involved adding the following lines between the connection parameters:
MS_GEODBTYPE = ODBC
MS_GEOPROJDIR = C: /
MS_GEOPROJNAME = local_project
MS_GEODBCONNECT = 1
MS_GEOINITCMD = PROJECT OPEN
MS_GEODBLOGIN = local_project
In principle, what was expected was that users who did not master the guts of a project very well would avoid headaches to connect. After explaining it several times on the board, by phone, by mail, messenger, I have no choice but to write it here since I see that it is the last place where they are asking for it.
If you want step by step, without passing 850 words, do not come out less than 15 steps ... and as they say when they send the reports ... ay va!
1 Stage: Requirements
It is necessary that the user has at least these 5 inputs to proceed with the installation in 15 steps:
- The installer of Microstation V8.5
- The Microstation installer Geographics V8.5
- A seed file with the particular configuration of the called project seed2d.dgn
- A user configuration file called Msgeo.ucf
- The database called Generica.mdb
2 Stage: Installing the Programs
1 Install Microstation
2. Install Geographics (Must be in this order)
3. Copy and replace the seed file at the address:
C: \ Program Files \ Bentley \ Workspace \ System \ seed \ seed2d.dgn
4. Copy the user file at this address:
C: \ Program Files \ Bentley \ Workspace \ Users \ msgeo.ucf
5 Copy the generic base to this address:
C: \ Generica.mdb
You have to be careful, that if Windows is in English, it will be C: Program FilesBentley ... And preferably you have to install the program on disk C, even if you have more than one hard disk.
Step 3: Creating the ODBC Connection
6. As we have established that the connection will be via ODBC, we will configure it in an extended 6 step (I am using Windows XP)
Start> Control Panel> Administrative Tools> Data Sources (ODBC)
-In the panel that is displayed, select the "User DSN" tab and choose "add"> microsoft Driver mdb> finish
-Choose as data source name, local_project and select the "create" button
- Then indicate where to create the database, directly in C and call it project_local.mdb, leave the panel, saying accept twice.
To verify that it has remained as requested, when selecting the origin created and the button "configure" should look like this:
4 Stage: Creating the Project in Geographics
7. Enter Geographics
8. From the top menu select
Project> wizard> next> create project
9 Configure the features as the graph looks. It is not necessary to change the seed file path.
create> next> verify, register mapid> cancel
With this a directory has been created where all the folders used by the Geographics project are, and the tables needed in the base called local_project.mdb. Obviously without features or categories. To check:
10. Close Geographics
11 Open Geographics, you must automatically open the project. (If this does not happen, there is something wrong in the 9 step or we have not copied the ucf file as the 4 step says)
12. If everything went in order
Utilities> Feature manager
The project should be raised, but without features or categories more than the dummy that comes by default.
11. Close Geographics
5: Replace the database
Now what we occupy is to deceive Microstation, removing the blank database, for this:
12. Delete database C: local_project.mdb
13. To the database C: Generica.mdb change the name so that it is of the form C: local_project.mdb
14. Enter Geographics
The base should run automatically, otherwise the name of the file has been incorrectly assigned in step 13
15. If everything works fine, going to Utilities> Feature manager should raise the categories and attributes of the database.
The one of clicking
Man, next time you should have me even if it's totopostes from the border. And to see my faith and mania for the totopostes, here you can download:
The database Generica.mdb
The seed file seed2d.dgn
The file Msgeo.ucf