Link Map to DBF?

[Peter.Greulich]

Re: Link Map to DBF?

Yup, it works w. dbf. But you have to make sure that your "empty" lat/long fields are not 0, otherwise you get a marker(s) at the equator.

[Keith Hubert]

Re: Link Map to DBF?

Hi Gregg,

Not yet but I'm working on it. The video FP11_DLGMAP6 covers several topics at the same time, making it rather difficult learn from it, in a step by step approach.

The map is shown below a repeating section and the function is fired as each row gets focus.

Question, must it be a repeating section?

The main function in the Javascript functions is the following:

function setMap() {
	var lat = {dialog.Object}.getValue('lat');
	var lng = {dialog.Object}.getValue('lng'); 
	var address = {dialog.Object}.getValue('address'); 
	if(A5.map.initState == 1) {
		var m1 = {dialog.object}.getControl('m1');
		m1.addMarker('marker1',[lat,lng], {
			title: address,
			detail: {
				has: true,
				data: address
			}
		});
		m1.viewMarkers('marker1');
		m1.setZoom(17);
	}
}

Hope this gives you something to chew on.

Peter, please can you show us how you did it.

[Peter.Greulich]

Re: Link Map to DBF?

Peter, please can you show us how you did it.

Keith I used a grid. Haven't done mapping in a dialog. Sorry.

[ADCO Service]

Re: Link Map to DBF?

Hi Keith

I just got long and lat to work with my dbf table. Attached is a simple sample of my database. I hope this helps you.

I'm really interested in your script to get the long and lat values for an address. Would you be able to send me a sample?

[Keith Hubert]

Re: Link Map to DBF?

Hi Melvin,

I first created 3 fields, Address, Longitude and Latitude. I set the address as calculated with the following expression

ALLTRIM(ADDRESS1)+","+ALLTRIM(ADDRESS2)+","+ALLTRIM(ADDRESS3)+","+ALLTRIM(COUNTY)+","+ALLTRIM(POSTCODE). I first did a recalc, then ran the xbasic code in message #7. As there were over 2000 records, it took about 10 minutes to process the table.

I shall now look at your sample.

[Keith Hubert]

Re: Link Map to DBF?

Hi Melvin,

I can see your table and the grid, where is the map linked to it?

[Keith Hubert]

Re: Link Map to DBF?

Peter,

A grid is good, all part of learning.

[Peter.Greulich]

Re: Link Map to DBF?

Peter,

A grid is good, all part of learning.

Keith,

There's nothing to it. Just use an alternate view and see the settings highlighted in the attached image...

lat_long.gif

[Peter.Greulich]

Re: Link Map to DBF?

Keith,

I used your script and it works great. I'm learning today.

[ADCO Service]

Re: Link Map to DBF?

Keith

The Map is linked under "Alternative View".

Slightly off topic, but is there a way to hide the circle radius until the user clicks on a specific icon?

[madtowng]

Re: Link Map to DBF?

Keith,

Right now, I have a dialog that does not use repeating rows.
It shows the locations for 3 points, Pickup, Delivery, and Base.

I'm not sure if this will help you much, but it certainly shouldn't hurt.
I'd attach the dialog itself, but there are a lot of controls on that would just get in the way.

function maporder(){

var pklat = {dialog.object}.getValue('pickup_lat');
var pklon = {dialog.object}.getValue('pickup_lon');
var dllat = {dialog.object}.getValue('delivery_lat');
var dllon = {dialog.object}.getValue('delivery_lon');
var m1 = {dialog.Object}.getControl('mapit');
var pun = {dialog.object}.getValue('pickup_name')+'\n'+{dialog.Object}.getValue('pickup_address')+'\n'+{dialog.Object}.getValue('pickup_city')+' '+{dialog.Object}.getValue('pickup_statcode');
var dun = {dialog.object}.getValue('delivery_name')+'\n'+{dialog.Object}.getValue('delivery_address')+'\n'+{dialog.Object}.getValue('delivery_city')+' '+{dialog.Object}.getValue('delivery_statcode');
var bun = 'BASE'


m1.addMarker('pickup',[pklat,pklon],{
icon: {
url: 'http://www.wisux.com/mapping/pngs/p.png',
},
title: pun,
detail: {has: true, data: pun}
});

m1.addMarker('delivery',[dllat,dllon],{
icon: {
url: 'http://www.wisux.com/mapping/pngs/d.png',
},
title: dun,
detail: {has: true, data: dun}
});

m1.addMarker('base',[42.9352874755859,-87.9111862182617],{
icon: {
url: 'http://www.wisux.com/mapping/pngs/b.png',
},
title: bun,
detail: {has: true, data: bun}
});

m1.viewMarkers('pickup','delivery','base');

[Keith Hubert]

Re: Link Map to DBF?

Hi Gregg,

Your code looks very good, how do you implement it?

[madtowng]

Re: Link Map to DBF?

The code is for a dialog.

At a minimum, it expects data for 2 addresses (pickup and delivery).
The data for Base is static.

I haven't done much with the different layers yet, but I really expect
I will before long.

I just realized that it assumes you have lat/lon information, but I think
you already said you have that.

[Keith Hubert]

Re: Link Map to DBF?

Hi Gregg,

I realise the code is for a dialog, I did not ask my question properly.

What I meant was, what do you do to make the code run which then displays the map with the markers?

[madtowng]

Re: Link Map to DBF?

I do have a googlemap component/control that is part of the dialog.
I might be a bit slower than normal, but I was battling A5V10 for most of today.