Mentum Planet - Import sites using MI Table
Daniel O'Brien
I have a large number of points in a MI table that i'm looking to import into Mentum Planet as sites. I'd be happy with only getting the co-ordinates of the site imported, but I do have a number of attributes in the MI table such as antenna type, height, power ect, if that's possible to import too.
Cheers
Daniel
Grant Roberts
jus exp rt the lot as a csv.. surely That importable
--
--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en
---
You received this message because you are subscribed to the Google Groups "MapInfo-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mapinfo-l+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Daniel O'Brien
Mentum Planet is built on top of MapInfo so all my points load in fine BUT the program doesn't treat them as 'sites' and the only way I've been able to find, is to manually place a site one by one on top of each point
Grant Roberts
table export
Daniel O'Brien
Gavin
The process I follow to import a large number of sites into Planet is
- Export the MapInfo table to a csv as Grant stated
- Create a single site in the Mentum Planet Project and populate with dummy values for the site information you want to import from your exported mapinfo table
- Export the site file from Mentum Planet to excel, Planet will create a spreadsheet with a number of tabs for different site properties. By having the dummy site you ensure that Planet will create a site file template that can be re imported later with your added base site data
- Copy and paste the data from the original exported Mapinfo table to the Exported Planet excel sheet, you can do whole column copies.
- Import updated site list back into Planet.
A more detailed process for the above follows:
Create a single site and set it with the preferred parameters. Export the site via
Data -> Export -> project Data -> Select name
Once the default site parameters have been defined export the following tables of this site:
Site
Antennas
Sectors
Sector Antennas
Sector Antenna Ports
Create Sites for Importing
Paste the site names and coords of the sites into the excel sheet under each TAB
Site
Site_ID : Site name
Site_UID : other site identifier
Long/Lat : Easting/Northing projection projected to a single zone. Not sure but I seem to remember that Planet can't import lat/long site data?
Description : whatever
Site name : whatever
Site name 2 : whatever
Candidate Priority : 1
Antenna
Enter the new site list and easting/northing values as in the Site tab. Copy all columns data for the test site with the exception of the ‘Terrain Height (m)’ field. Leave this one blank, Planet will automatically fill this field with the terrain height at that location.
Easier just to import default antenna, then edit for actual antenna within Planet, same with cable length.
Sectors
Enter new sites and copy the test row data
Sector Antennas
Enter new sites and copy the test row data
Sector Antenna Ports
Enter new sites and copy the test row data
After all data has been entered, delete the temp test site and save
Import the data back into Planet via
Data -> Import -> Project Data -> Search for site file -> Check all “Select tables to Import”
Important:
There are a few small things that need to be done to ensure the sites import back into Planet smoothly.
1/ Site Names cannot be too long, if they are the site will fail to import
2/ There can be no trailing spaces in a site name, if there are the site will fail to import
3/ An item with the same key has already been added. This one is a pain. Happens when you use the same name for any entry in the ‘Site ID’ column. All sites must have a unique ID.
Delete the temp site in planet
Hope this helps.Gavin