If I have a data file, and after importing it I notice that I need to change a value in a specific field, is there any way to make this change without having to reimport the entire file? Since I have maps with 100 or so pushpins, I'd rather make the change in Mappoint than have to reimport the file and have Mappoint re-map each location.

Alas no (and the same applies for the API) - data imported with the Data Import Wizard is read-only.

You can only manually and arbitrarily update pushpins which have been been added "by hand" (one at a time, typically by clicking on the map or entering an address).

BTW, I think the only "field" you can edit is the .Notes property, which can be useful when manipulating datasets programmatically.

Eric

Well, I'm not certain about the import, but I needed to be able to change a pushpin from one symbol to another. I was able to make a quick pass through the recordset updating the pin symbols. It was pretty quick; but the map refreshed in batches.

My code looks like this.

foreach (MapPoint.DataSet mds in MPC.ActiveMap.DataSets)
{
if (mds.Name == "My pushpins")
{
if (mds.RecordCount > 0)
{
MPC.ActiveMap.Application.MousePointer = MapPoint.GeoPointer.geoPointerHourglass; // show busy
MapPoint.Recordset mrs = mds.QueryAllRecords();
do
{
if (mrs.Pushpin.Symbol == clsGM.fromPin) mrs.Pushpin.Symbol = clsGM.toPin;
mrs.MoveNext();
}
while (!mrs.EOF);
MPC.ActiveMap.Application.MousePointer = MapPoint.GeoPointer.geoPointerDefault; // all done
}
}
}



Hope it helps.

Don

Ah very good yes.

So on the Pushpin object, besides the .Note property which can be edited, you can also edit the Pushpin symbol.

I didn't realize, but the Help file says that the Name Property of the Pushpin object is also read/write.

And then of course you can also set and read the state of the BalloonState and Highlight Properties.

The Location property can also be modified.

So, if you're clever about it, there's actually quite a few places to store and retrieve bits of information on a pushpin.

However, if you're talking about editing data values in the balloon for a dataset, this cannot be done and would require a re-import.

Eric

Yes the data fields are readonly. In my original reply it looks like I was assuming we were talking about datasets imported with the import or link wizards.

Originally Posted by Eric Frost

Ah very good yes.

So on the Pushpin object, besides the .Note property which can be edited, you can also edit the Pushpin symbol.

I didn't realize, but the Help file says that the Name Property of the Pushpin object is also read/write.

And then of course you can also set and read the state of the BalloonState and Highlight Properties.

The Location property can also be modified.

So, if you're clever about it, there's actually quite a few places to store and retrieve bits of information on a pushpin.

However, if you're talking about editing data values in the balloon for a dataset, this cannot be done and would require a re-import.

Eric

This came about when I was looking for a way to quickly serialize/deserialize loaded maps. Some of my maps have 40,000 points, and take a while to populate. That led to the need to be able to cache them and bring them back. Unfortunately, if they were saved with say, black pushpins, they would conflict with another map that also had black pushpins. Thus the code to change the pushpin symbols.

The notes can indeed be updated. In my case, I'll reload a cached map and update the notes on the pushpins from a different database. When the map get's cached, the notes are saved. Reloading the cache takes seconds compared to hours when loading individual pins (and thats using lat/long; not findbyaddress!).

Thanks,

Don