I have a spreadsheet that identifies individual itemized vegetation (S1 - S400, for example) along with the northing and easting values of where the vegetation is located. I have created Item Types within my DGN file. Is it possible to place a corresponding cell and attach the item type all in the same process through some sort of import function?
To simplify what I want to import; there would be 4 columns in my spreadsheet:
1. Vegetation_Number
2. Northing (Y location)
3. Easting (X Location)
4. Item_Type (Item Type I want to attach already existing in my file)
There will be more columns with other type of data but that is not of concern, this can already be done once the cell has the item type attached.
(Otherwise, I understand that you would need to manually place the cells, attach the item type and then change the Vegetation_Number manually so that the proper corresponding data is presented.)
Eduardo Mendoza said:Is it possible to place a cell and attach the item type all in the same process through some sort of import function?
I don't think that's possible out of the box.
Can you post an example Excel file that illustrates your data? Is there anything special about your vegetation cell library?
Regards, Jon Summers LA Solutions
Vegetation_Test.xlsx Ignore all of the extraneous data in the spreadsheet. As I mentioned, I am only interested in placing a cell at the northing and easting values in the spreadsheet, systematically attaching the Item Type with the corresponding Vegetation_Number ID associated to the placed cell.
Hi Eduardo,
I agree with Jon there is no such tool available in MicroStation, but probably VBA would be enough (but C# is better) to implement such task.
What is not clear from your description:
I'd like to also to point out that when the requirement is to have a cell with ItemType(s) attached, it's better to attach ItemType(s) to the cell (to the model) in cell library, so when the cell is placed, the attached data are placed with the cell automatically.
With regards,
Jan
P.S. Please, follow the best practices: Use standardized subject format and also specify exactly what product and namely version you use (there have been 16 CE versions released so far).
Bentley Accredited Developer: iTwin Platform - AssociateLabyrinth Technology | dev.notes() | cad.point
Eduardo Mendoza said:Vegetation_Test.xlsx Ignore all of the extraneous data in the spreadsheet. As I mentioned, I am only interested in placing a cell at the northing and easting values in the spreadsheet, systematically attaching the Item Type with the corresponding Vegetation_Number ID associated to the placed cell.
Here's a revised version of your spreadsheet. I've added Excel range names to each column of data. Named ranges make it easier to correlate your Excel data with a MicroStation Item Type or Tag schema when writing VBA or other code.
5008.Vegetation_Test.xlsx
To see named ranges in Excel, use Formulas|Name Manager.
You might want to try our FDO Reader. It can read several kinds of geospatial data sources including Excel.
You can download a trial version and see if it works. It will create the Item Types for you during import.
Have a look at consulting.surell.se.
Regards,
Krister Surell
Owner consultant at Surell Consulting AB