Import ODBC and CSV data types

Bentley Map's Interoperability features can be used to import data from CSV (comma separated values) or ODBC data sources. Often customers maintain features such as survey monuments, borehole locations, leaks, place names and so on in text files or ODBC databases. The attached materials provide a document and working examples of importing CSV and ODBC data types.

csv.zip

Parents

Jeff Nolan Wed, Aug 27 2008 9:17 PM
It is also possible to bring in lines or polygons as well. Attached is an example of both. Just follow the instructions from Keith, and inside of the zip file attached to this message there is an example for polygon and another for lines.
Polygon-SingleLineCSV.zip
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Reply

Jeff Nolan Wed, Aug 27 2008 9:17 PM
It is also possible to bring in lines or polygons as well. Attached is an example of both. Just follow the instructions from Keith, and inside of the zip file attached to this message there is an example for polygon and another for lines.
Polygon-SingleLineCSV.zip
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Children

Richard Lomas Wed, Dec 3 2008 11:00 AM in reply to Jeff Nolan
Hi, I am trying to import some ODBC access data that is in Britsh National Grid coordinate system but I can't seem to get the syntax correct in the vrt file. Does anyone know what the correct syntax is?

<LayerSRS>OSGB</LayerSRS> does not work

<LayerSRS>OSGB1936</LayerSRS> does not work

<LayerSRS>OSGB:1936</LayerSRS> does not work

<LayerSRS>BritishNationalGrid</LayerSRS> does not work

Thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Richard Lomas Wed, Dec 3 2008 11:07 AM in reply to Richard Lomas
Also, <LayerSRS>EPSG:27700</LayerSRS> does not work
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Offline Cesar Calingasan Fri, Dec 5 2008 4:48 AM in reply to Richard Lomas

Hi there, I am using a Microstation V08.01.02.15 (1990-2003) version (not a Bentley Map), do you know how to import or plot a CSV database to the file, like when i want to plot multiple points using my version?

Cesar Calingasan
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Offline Jon Summers Fri, Dec 5 2008 9:46 AM in reply to Cesar Calingasan
Cesar:
I am using a Microstation V08.01.02.15 (1990-2003) version (not a Bentley Map)

Then post to the relevant newsgroup.

Regards, Jon Summers
LA Solutions

Regards, Jon Summers
LA Solutions
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Offline Cesar Calingasan Mon, Dec 8 2008 2:48 AM in reply to Jon Summers

Is the interoperability options applicable to my version?. I have big table (in .xls format) of points to plot, and I need an automated way, can u help me?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel