Greetings again,

Can you provide an example of the proper query to run in Netism Map Extreme to get to the business directory data?

Thank you!

Thanks George,

Any luck?

I was finally able to get ahold of the people at Netism.  They logged into my portal and setup a query, but it doesn't seem to be working.  It returns the correct number of locations - but shows no information, nor point on the map.  If you send me your private email address, I can send you login to the portal.  Perhaps you can also get your modules working at the same time.  

This is their querry:

select

 XmodID as LocationID,

 dbo.KB_XMod_ExtractFieldValue(instancedata, 'Address') as Address,

 dbo.KB_XMod_ExtractFieldValue(instancedata, 'City') as City,

 dbo.KB_XMod_ExtractFieldValue(instancedata, 'Region') as State,

 dbo.KB_XMod_ExtractFieldValue(instancedata, 'Zip') as Zip,

 dbo.KB_XMod_ExtractFieldValue(instancedata, 'Country') as Country,

 dbo.KB_XMod_ExtractFieldValue(instancedata, 'Latitude') as Latitude,

 dbo.KB_XMod_ExtractFieldValue(instancedata, 'Longitude') as Longitude,

 dbo.KB_XMod_ExtractFieldValue(instancedata, 'C1Title') as Title,

 dbo.KB_XMod_ExtractFieldValue(instancedata, 'Company') as Company,

 dbo.KB_XMod_ExtractFieldValue(instancedata, 'ContactEmail') as Email,

 dbo.KB_XMod_ExtractFieldValue(instancedata, 'Phone1') as Phone

from kb_xmod_modules

where formid = 14

-------------------------------------

I ran it on the SQL Database.  It returns only the [City] value [New York] from the dataset:

-------------------------------------

Please advise...

 Let's try that again...maybe commenting it out will work:

 Ok,

Netism support logged in and created a query that works:

select

 XmodID as LocationID,

 dbo.KB_XMod_ExtractFieldValue2(instancedata, 'Address') as Address,

 dbo.KB_XMod_ExtractFieldValue2(instancedata, 'City') as City,

 dbo.KB_XMod_ExtractFieldValue2(instancedata, 'Zip') as Zip,

 dbo.KB_XMod_ExtractFieldValue2(instancedata, 'Latitude') as Latitude,

 dbo.KB_XMod_ExtractFieldValue2(instancedata, 'Longitude') as Longitude

from kb_xmod_modules

where formid = 14

Now what we need is a link to the "Make Inquiry" page.  Any ideas on how to make this work?

Thankyou

cjepp,

Can you post the dbo.KB_XMod_ExtractFieldValue2 function please.

John,

Sorry, we can not publicly post the function due to the fact that it is the Intellectual property of Kelly Ford, developer of XMod.

The Function is located at:

Your SQL Database >> Programmability >> Functions >> Scalar-valued Functions

Kelly Ford can be contacted at XMod Help Desk.