473,394 Members | 2,031 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Transforming Access data to KML

I have an Access database of organizations with geographic locations (name, city, state) that I'd like to export to XML (which I know how to do) and use an XSLT to transform KML. The markers can be located later, but I'd like to have the transform have some way to locate them in a string so they're not on top of each other. Then they can be easily seen and relocated by hand. I know that I need to use FOR EACH but I'd love it if someone else has struggled with this and has an example.
Thanks.
Sep 5 '07 #1
1 2833
Shashi Sadasivan
1,435 Expert 1GB
I have an Access database of organizations with geographic locations (name, city, state) that I'd like to export to XML (which I know how to do) and use an XSLT to transform KML. The markers can be located later, but I'd like to have the transform have some way to locate them in a string so they're not on top of each other. Then they can be easily seen and relocated by hand. I know that I need to use FOR EACH but I'd love it if someone else has struggled with this and has an example.
Thanks.
Hi,
I had an exact problem, especially when the locations were based on a locality basis, if i got 10 users in the same locality, all of them were right above each other.
I figured out that if you do use a for loo / foreach you wud have to recursively make sure that the current marker you are locating isint going to be right oon someone else.
So I took the easier way around. - Randomization :)
Sep 13 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

34
by: jblazi | last post by:
Let us assume I have a list like and would like to transoform it into the string '{1,2},{7,8},{12,13}' Which is the simplest way of achiebing this? (The list is in fact much longer and...
2
by: Mirjana Rakuljic | last post by:
Hi, I need help with transforming XML document. I generate xml document from query using Oracle XSU (DBMS_XMLQUERY) and the document I get is like this: <?xml version = '1.0' encoding =...
5
by: Daniel Crespo | last post by:
Is there a built-in method for transforming (1,None,"Hello!") to 1,None,"Hello!"? Thanks
4
by: Showjumper | last post by:
I am using the NITF DTD for my xml files and i need to use 2 xsl files to do the transform: one for the <body.head> and the second for the <body.content>. I've got this so far for transforming...
3
by: Sergio Otoya | last post by:
Hi all, I need to transform an xml document, using xsl to a HTML output. I can do this successfully using the XslTransform class as below: Dim oTrans As New XslTransform ...
4
by: Cathie | last post by:
Hi All, I am trying to get my style sheet to work. It works fine in IE but I can't get it to work in .net. Below is the function I use for transforming, where advancedOptionsFile is the path...
0
by: Gustaf | last post by:
I'd like to see if someone found a natural explanation to this. I have this method for transforming docs: /** * Transforms an XmlDocument object with an XSL file, and returns * another...
1
by: Jeff.Thorn | last post by:
Hello All, I have a collection of data objects that are based on my application's data model. I want to be able to serialize this data to different XML formats (schemas) for use by different...
1
by: Jeff.Thorn | last post by:
Hello All, I have a collection of data objects that are based on my application's data model. I want to be able to serialize this data to different XML formats (schemas) for use by different...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.