Education >> Tools Previous   Index   Next   Threaded

Jump to first unread post. Pages: 1 Digital_Explorer Tourist Reged: 06/06/08 Posts: 15 Loc: London, UK How do I import a spreadsheet properly?       #1224177 - 08/26/08 03:17 AM Edit   Reply   Quote   Quick Reply   I have imported some data from .csv files into Google Earth. It works wonderfully and it has been a success. The problem comes when I want to use the resulting .kml file with Google Maps and another programme GE-Graph. Neither of this applications would recognise the kml. I opened the kml and saw that where there is usually a <Placemark> denoting the start of a particular point there is currently a <S>. Guesswork suggests that this formatting may be the reason why I can't use the kml file in Google Maps or GE-Graph. Can anyone let me know how I can work around this? Am I doing something wrong? Thanks, Jamie Post Extras:       tekgergedan Master Guide Reged: 09/25/05 Posts: 8053 Loc: Turkey GMT+2 Re: How do I import a spreadsheet properly? [Re: Digital_Explorer]       #1224569 - 08/26/08 06:30 PM Edit   Reply   Quote   Quick Reply   Something must have gone wrong. I cannot think of any reason to this behavior. Try to Find-Replace all <S> with <Placemark> in NotePad. Also, there must be </Placemark>s or are there </S>s? Or paste some part of the kml codes here to let us see it directly. Otherwise, we cannot help much. -------------------- ...::: | | | Install 4.3 and be aware you can switch back | | | :::... ...::: | | | what you are is what you eat and what you think | | | :::... ...::: | | | if you want to get something, first look and ask for its very details | | | :::... Post Extras:       Digital_Explorer Tourist Reged: 06/06/08 Posts: 15 Loc: London, UK Re: How do I import a spreadsheet properly? [Re: tekgergedan]       #1228826 - 09/04/08 04:35 AM Edit   Reply   Quote   Quick Reply   Thank you... Here's the kml which my csv import created. Just as an explanation it is a list of Shockkwaves over the past few years in San Francisco which I was looking to use in GE Graph to add values to. <?xml version="1.0" encoding="UTF-8"?> <kml xmlns="http://earth.google.com/kml/2.2"> <Document> <name>practice1.csv</name> <Schema parent="Placemark" name="S_practice1_DDS"> <SimpleField type="double" name="_7_774702"></SimpleField> <SimpleField type="double" name="_122_392239"></SimpleField> <SimpleField type="wstring" name="Shockwave_15"></SimpleField> </Schema> <StyleMap id="default+nicon=http://maps.google.com/mapfiles/kml/pal4/icon57.png+hicon=http://maps.google.com/mapfiles/kml/pal4/icon49.png"> <Pair> <key>normal</key> <styleUrl>#default+icon=http://maps.google.com/mapfiles/kml/pal4/icon57.png</styleUrl> </Pair> <Pair> <key>highlight</key> <styleUrl>#default+icon=http://maps.google.com/mapfiles/kml/pal4/icon49.png</styleUrl> </Pair> </StyleMap> <Style id="default+icon=http://maps.google.com/mapfiles/kml/pal4/icon57.png"> <IconStyle> <Icon> <href>http://maps.google.com/mapfiles/kml/pal4/icon57.png</href> </Icon> </IconStyle> </Style> <Style id="default+icon=http://maps.google.com/mapfiles/kml/pal4/icon49.png"> <IconStyle> <scale>1.1</scale> <Icon> <href>http://maps.google.com/mapfiles/kml/pal4/icon49.png</href> </Icon> </IconStyle> <LabelStyle> <scale>1.1</scale> </LabelStyle> </Style> <Folder id="layer 0"> <name>practice1</name> <S_practice1_DDS> <name>Shockwave 14</name> <description><![CDATA[_7_774702 = 37.7886<br>_122_392239 = -122.436<br>Shockwave_15 = Shockwave 14<br>]]></description> <styleUrl>#default+nicon=http://maps.google.com/mapfiles/kml/pal4/icon57.png+hicon=http://maps.google.com/mapfiles/kml/pal4/icon49.png</styleUrl> <Point> <coordinates>-122.436427,37.78857600000001,0</coordinates> </Point> <_7_774702>37.788576</_7_774702> <_122_392239>-122.436427</_122_392239> <Shockwave_15>Shockwave 14</Shockwave_15> </S_practice1_DDS> Post Extras:       tekgergedan Master Guide Reged: 09/25/05 Posts: 8053 Loc: Turkey GMT+2 Re: How do I import a spreadsheet properly? [Re: Digital_Explorer]       #1228963 - 09/04/08 09:57 AM Edit   Reply   Quote   Quick Reply   GE Graph gives a general error with me at my current configuration and I cannot check. But if you ask what the wrong is with this code... You need to change <S_practice1_DDS> to <Placemark> and </S_practice1_DDS> to </Placemark> They are not kml elements. The element for objects in kml is <Placemark>. If it IS NOT a part of a bigger code, also add these at the bottom: </Folder> </Document> </kml> -------------------- ...::: | | | Install 4.3 and be aware you can switch back | | | :::... ...::: | | | what you are is what you eat and what you think | | | :::... ...::: | | | if you want to get something, first look and ask for its very details | | | :::... Post Extras:       Digital_Explorer Tourist Reged: 06/06/08 Posts: 15 Loc: London, UK Re: How do I import a spreadsheet properly? [Re: tekgergedan]       #1228981 - 09/04/08 10:41 AM Edit   Reply   Quote   Quick Reply   Thanks so much for this. Would you know why the csv import function (GE plus and pro) generated this code rather than something that is valid kml? Post Extras:       tekgergedan Master Guide Reged: 09/25/05 Posts: 8053 Loc: Turkey GMT+2 Re: How do I import a spreadsheet properly? [Re: Digital_Explorer]       #1229139 - 09/04/08 04:56 PM Edit   Reply   Quote   Quick Reply   They are import-specific features the details of which I don't know. I think GE Graph gets confused there because, I guess, it does not understand this type. Rsgrillo (the creator of GE Graph) may fix this later. Not sure. -------------------- ...::: | | | Install 4.3 and be aware you can switch back | | | :::... ...::: | | | what you are is what you eat and what you think | | | :::... ...::: | | | if you want to get something, first look and ask for its very details | | | :::... Post Extras:       Pages: 1

Previous   Index   Next   Threaded

UBB.threads™ 6.5.1.1