protected override void ExportMethod() { using (ZipOutputStream s = new ZipOutputStream(System.IO.File.Create(_filename))) { s.SetLevel(9); // 0-9, 9 being the highest compression s.UseZip64 = UseZip64.Off; DateTime dt = DateTime.Now.AddSeconds(2); using (Utils.ProgressBlock progress = new Utils.ProgressBlock(this, STR_EXPORTINGGPX, STR_CREATINGFILE, _gcList.Count, 0)) { int totalGeocaches = _gcList.Count; int totalProcessed = 0; int fileIndex = 1; int geocacheIndex = 0; int gpxSizeLimit = PluginSettings.Instance.MaximumSizeGpxInGgz; //appr. 4.5MB XmlDocument doc = new XmlDocument(); XmlDeclaration pi = doc.CreateXmlDeclaration("1.0", "UTF-8", "yes"); doc.InsertBefore(pi, doc.DocumentElement); XmlElement root = doc.CreateElement("ggz"); doc.AppendChild(root); XmlAttribute attr = doc.CreateAttribute("xmlns"); XmlText txt = doc.CreateTextNode("http://www.opencaching.com/xmlschemas/ggz/1/0"); attr.AppendChild(txt); root.Attributes.Append(attr); XmlElement el = doc.CreateElement("time"); txt = doc.CreateTextNode(string.Format("{0}Z", DateTime.Now.ToUniversalTime().ToString("s"))); el.AppendChild(txt); root.AppendChild(el); //Utils.Crc16 crc16 = new Utils.Crc16(); while (_gcList.Count > 0) { XmlElement elFile = doc.CreateElement("file"); root.AppendChild(elFile); el = doc.CreateElement("name"); txt = doc.CreateTextNode(string.Format("{0}_{1}.gpx", System.IO.Path.GetFileNameWithoutExtension(_filename), fileIndex)); el.AppendChild(txt); elFile.AppendChild(el); XmlElement elCRC = doc.CreateElement("crc"); elFile.AppendChild(elCRC); el = doc.CreateElement("time"); txt = doc.CreateTextNode(string.Format("{0}Z", DateTime.Now.ToUniversalTime().ToString("s"))); el.AppendChild(txt); elFile.AppendChild(el); //create GPX wpt entries until max size is reached List <Framework.Data.Geocache> gpxBatchList = new List <Framework.Data.Geocache>(); List <GeocacheEntryInfo> geiList = new List <GeocacheEntryInfo>(); geocacheIndex = 0; _gpxGenerator.SetGeocacheList(_gcList); StringBuilder sb = new StringBuilder(); _gpxGenerator.Start(); while (sb.Length < gpxSizeLimit && geocacheIndex < _gpxGenerator.Count) { gpxBatchList.Add(_gcList[geocacheIndex]); string gpxText = _gpxGenerator.Next(); GeocacheEntryInfo gei = new GeocacheEntryInfo(); gei.GC = _gcList[geocacheIndex]; gei.FileLen = System.Text.UTF8Encoding.UTF8.GetBytes(gpxText).Length + 2; geiList.Add(gei); sb.AppendLine(gpxText); totalProcessed++; geocacheIndex++; if (DateTime.Now >= dt) { progress.UpdateProgress(STR_EXPORTINGGPX, STR_CREATINGFILE, totalGeocaches, totalProcessed); dt = DateTime.Now.AddSeconds(2); } } sb.AppendLine(_gpxGenerator.Finish()); //insert gpx header _gpxGenerator.SetGeocacheList(gpxBatchList); string gpxHeader = _gpxGenerator.Start(); sb.Insert(0, gpxHeader); _gcList.RemoveRange(0, gpxBatchList.Count); //add gpx to zip byte[] data; using (System.IO.TemporaryFile tmp = new System.IO.TemporaryFile(true)) { using (System.IO.StreamWriter sw = System.IO.File.CreateText(tmp.Path)) { sw.Write(sb.ToString()); } data = File.ReadAllBytes(tmp.Path); } string fn = string.Format("data/{0}_{1}.gpx", System.IO.Path.GetFileNameWithoutExtension(_filename), fileIndex); ZipEntry entry = new ZipEntry(fn); entry.DateTime = DateTime.Now; s.PutNextEntry(entry); s.Write(data, 0, data.Length); Crc32 crc = new Crc32(); crc.Update(data); //txt = doc.CreateTextNode(crc16.ComputeChecksum(data).ToString("X8")); txt = doc.CreateTextNode(crc.Value.ToString("X8")); elCRC.AppendChild(txt); int curPos = System.Text.UTF8Encoding.UTF8.GetBytes(gpxHeader).Length; for (int i = 0; i < geiList.Count; i++) { GeocacheEntryInfo gei = geiList[i]; XmlElement chgEl = doc.CreateElement("gch"); elFile.AppendChild(chgEl); el = doc.CreateElement("code"); txt = doc.CreateTextNode(gei.GC.Code ?? ""); el.AppendChild(txt); chgEl.AppendChild(el); el = doc.CreateElement("name"); txt = doc.CreateTextNode(_gpxGenerator.validateXml(gei.GC.Name ?? "")); el.AppendChild(txt); chgEl.AppendChild(el); el = doc.CreateElement("type"); txt = doc.CreateTextNode(gei.GC.GeocacheType.GPXTag); el.AppendChild(txt); chgEl.AppendChild(el); el = doc.CreateElement("lat"); if (gei.GC.ContainsCustomLatLon) { txt = doc.CreateTextNode(gei.GC.CustomLat.ToString().Replace(',', '.')); } else { txt = doc.CreateTextNode(gei.GC.Lat.ToString().Replace(',', '.')); } el.AppendChild(txt); chgEl.AppendChild(el); el = doc.CreateElement("lon"); if (gei.GC.ContainsCustomLatLon) { txt = doc.CreateTextNode(gei.GC.CustomLon.ToString().Replace(',', '.')); } else { txt = doc.CreateTextNode(gei.GC.Lon.ToString().Replace(',', '.')); } el.AppendChild(txt); chgEl.AppendChild(el); el = doc.CreateElement("file_pos"); txt = doc.CreateTextNode(curPos.ToString()); curPos += gei.FileLen; el.AppendChild(txt); chgEl.AppendChild(el); el = doc.CreateElement("file_len"); txt = doc.CreateTextNode(gei.FileLen.ToString()); el.AppendChild(txt); chgEl.AppendChild(el); XmlElement ratingsEl = doc.CreateElement("ratings"); chgEl.AppendChild(ratingsEl); el = doc.CreateElement("awesomeness"); txt = doc.CreateTextNode("3.0"); el.AppendChild(txt); ratingsEl.AppendChild(el); el = doc.CreateElement("difficulty"); txt = doc.CreateTextNode(gei.GC.Difficulty.ToString("0.#").Replace(',', '.')); el.AppendChild(txt); ratingsEl.AppendChild(el); el = doc.CreateElement("size"); switch (gei.GC.Container.ID) { case 1: txt = doc.CreateTextNode("2.0"); break; case 5: txt = doc.CreateTextNode("2.0"); break; case 6: txt = doc.CreateTextNode("2.0"); break; case 2: txt = doc.CreateTextNode("2.0"); break; case 3: txt = doc.CreateTextNode("4.0"); break; case 4: txt = doc.CreateTextNode("5.0"); break; case 8: txt = doc.CreateTextNode("3.0"); break; default: txt = doc.CreateTextNode("3.0"); break; } el.AppendChild(txt); ratingsEl.AppendChild(el); el = doc.CreateElement("terrain"); txt = doc.CreateTextNode(gei.GC.Terrain.ToString("0.#").Replace(',', '.')); el.AppendChild(txt); ratingsEl.AppendChild(el); if (gei.GC.Found) { el = doc.CreateElement("found"); txt = doc.CreateTextNode("true"); el.AppendChild(txt); chgEl.AppendChild(el); } } fileIndex++; } //add index file // index\com\garmin\geocaches\v0\index.xml /* * <gch> * <code>GC12345</code> * <name>Cache name</name> * <type>Traditional Cache</type> * <lat>33.550217</lat> * <lon>-117.660617</lon> * <file_pos>5875</file_pos> * <file_len>5783</file_len> * <ratings> * <awesomeness>3.0</awesomeness> * <difficulty>1.5</difficulty> * <size>5.0</size> * <terrain>1.5</terrain> * </ratings> * <found>true</found> * </gch> * * 1 = Nano (not supported, unfortunately, by GC.com yet) * 2 = Micro * 3 = Small * 4 = Regular * 5 = Large * */ using (System.IO.TemporaryFile tmp = new System.IO.TemporaryFile(true)) { using (TextWriter sw = new StreamWriter(tmp.Path, false, Encoding.UTF8)) //Set encoding { doc.Save(sw); } byte[] data = File.ReadAllBytes(tmp.Path); ZipEntry entry = new ZipEntry("index/com/garmin/geocaches/v0/index.xml"); entry.DateTime = DateTime.Now; s.PutNextEntry(entry); s.Write(data, 0, data.Length); } s.Finish(); s.Close(); } } }
protected override void PerformExport(object settings) { var gpxSetting = settings as ExportGPXSettings; if (gpxSetting != null && !string.IsNullOrEmpty(gpxSetting.FileName)) { bool canceled = false; try { using (var db = new NPoco.Database(this.DatabaseConnection.Connection, NPoco.DatabaseType.SQLite)) { double minLat = 0, minLon = 0, maxLat = 0, maxLon = 0; if (DatabaseConnection.CurrentDataReader != null && !DatabaseConnection.CurrentDataReader.IsClosed) { DatabaseConnection.CurrentDataReader.Close(); } var gcList = db.Fetch <GeocacheEntryInfo>(string.Format("select Code, Name, CacheType, Difficulty, Terrain, Found, Container, Latitude, Longitude, kAfterLat, kAfterLon from Caches inner join {0} on Caches.Code={0}.gccode left join Corrected on Caches.Code = Corrected.kCode", ActionInputTableName)); minLat = (from a in gcList select Utils.Conversion.StringToDouble(a.Latitude)).Min(); maxLat = (from a in gcList select Utils.Conversion.StringToDouble(a.Latitude)).Max(); minLon = (from a in gcList select Utils.Conversion.StringToDouble(a.Longitude)).Min(); maxLon = (from a in gcList select Utils.Conversion.StringToDouble(a.Longitude)).Max(); DateTime dt = DateTime.Now.AddSeconds(2); using (Utils.ProgressBlock progress = new Utils.ProgressBlock("ExportingGPX", "CreatingFile", gcList.Count, 0, true)) { using (System.IO.TemporaryFile gpxFile = new System.IO.TemporaryFile(false)) { using (ZipOutputStream s = new ZipOutputStream(System.IO.File.Create(gpxFile.Path))) { s.SetLevel(9); // 0-9, 9 being the highest compression s.UseZip64 = UseZip64.Off; int totalGeocaches = gcList.Count; int totalProcessed = 0; int fileIndex = 1; int geocacheIndex = 0; int gpxSizeLimit = 4500000; //appr. 4.5MB XmlDocument doc = new XmlDocument(); XmlDeclaration pi = doc.CreateXmlDeclaration("1.0", "UTF-8", "yes"); doc.InsertBefore(pi, doc.DocumentElement); XmlElement root = doc.CreateElement("ggz"); doc.AppendChild(root); XmlAttribute attr = doc.CreateAttribute("xmlns"); XmlText txt = doc.CreateTextNode("http://www.opencaching.com/xmlschemas/ggz/1/0"); attr.AppendChild(txt); root.Attributes.Append(attr); XmlElement el = doc.CreateElement("time"); txt = doc.CreateTextNode(string.Format("{0}Z", DateTime.Now.ToUniversalTime().ToString("s"))); el.AppendChild(txt); root.AppendChild(el); Utils.GPXGenerator gpxGenerator = new Utils.GPXGenerator( db , (from a in gcList select a.Code).ToList() , gpxSetting.Version , minLat , maxLat , minLon , maxLon ); while (gcList.Count > 0) { XmlElement elFile = doc.CreateElement("file"); root.AppendChild(elFile); el = doc.CreateElement("name"); txt = doc.CreateTextNode(string.Format("{0}_{1}.gpx", System.IO.Path.GetFileNameWithoutExtension(gpxSetting.FileName), fileIndex)); el.AppendChild(txt); elFile.AppendChild(el); XmlElement elCRC = doc.CreateElement("crc"); elFile.AppendChild(elCRC); el = doc.CreateElement("time"); txt = doc.CreateTextNode(string.Format("{0}Z", DateTime.Now.ToUniversalTime().ToString("s"))); el.AppendChild(txt); elFile.AppendChild(el); //create GPX wpt entries until max size is reached List <GeocacheEntryInfo> gpxBatchList = new List <GeocacheEntryInfo>(); List <GeocacheEntryInfo> geiList = new List <GeocacheEntryInfo>(); geocacheIndex = 0; minLat = (from a in gcList select Utils.Conversion.StringToDouble(a.Latitude)).Min(); maxLat = (from a in gcList select Utils.Conversion.StringToDouble(a.Latitude)).Max(); minLon = (from a in gcList select Utils.Conversion.StringToDouble(a.Longitude)).Min(); maxLon = (from a in gcList select Utils.Conversion.StringToDouble(a.Longitude)).Max(); gpxGenerator.SetGeocacheList((from a in gcList select a.Code).ToList(), minLat, maxLat, minLon, maxLon); StringBuilder sb = new StringBuilder(); gpxGenerator.Start(); while (sb.Length < gpxSizeLimit && geocacheIndex < gpxGenerator.Count) { gpxBatchList.Add(gcList[geocacheIndex]); string gpxText = gpxGenerator.Next(); gcList[geocacheIndex].FileLen = System.Text.UTF8Encoding.UTF8.GetBytes(gpxText).Length + 2; geiList.Add(gcList[geocacheIndex]); sb.AppendLine(gpxText); totalProcessed++; geocacheIndex++; if (DateTime.Now >= dt) { if (!progress.Update("CreatingFile", totalGeocaches, totalProcessed)) { canceled = true; break; } dt = DateTime.Now.AddSeconds(2); } } sb.AppendLine(gpxGenerator.Finish()); //insert gpx header minLat = (from a in gpxBatchList select Utils.Conversion.StringToDouble(a.Latitude)).Min(); maxLat = (from a in gpxBatchList select Utils.Conversion.StringToDouble(a.Latitude)).Max(); minLon = (from a in gpxBatchList select Utils.Conversion.StringToDouble(a.Longitude)).Min(); maxLon = (from a in gpxBatchList select Utils.Conversion.StringToDouble(a.Longitude)).Max(); gpxGenerator.SetGeocacheList((from a in gpxBatchList select a.Code).ToList(), minLat, maxLat, minLon, maxLon); string gpxHeader = gpxGenerator.Start(); sb.Insert(0, gpxHeader); gcList.RemoveRange(0, gpxBatchList.Count); //add gpx to zip byte[] data; using (System.IO.TemporaryFile tmp = new System.IO.TemporaryFile(true)) { using (System.IO.StreamWriter sw = System.IO.File.CreateText(tmp.Path)) { sw.Write(sb.ToString()); } data = File.ReadAllBytes(tmp.Path); } string fn = string.Format("data/{0}_{1}.gpx", System.IO.Path.GetFileNameWithoutExtension(gpxSetting.FileName), fileIndex); ZipEntry entry = new ZipEntry(fn); entry.DateTime = DateTime.Now; s.PutNextEntry(entry); s.Write(data, 0, data.Length); Crc32 crc = new Crc32(); crc.Update(data); //txt = doc.CreateTextNode(crc16.ComputeChecksum(data).ToString("X8")); txt = doc.CreateTextNode(crc.Value.ToString("X8")); elCRC.AppendChild(txt); int curPos = System.Text.UTF8Encoding.UTF8.GetBytes(gpxHeader).Length; for (int i = 0; i < geiList.Count; i++) { GeocacheEntryInfo gei = geiList[i]; XmlElement chgEl = doc.CreateElement("gch"); elFile.AppendChild(chgEl); el = doc.CreateElement("code"); txt = doc.CreateTextNode(gei.Code ?? ""); el.AppendChild(txt); chgEl.AppendChild(el); el = doc.CreateElement("name"); txt = doc.CreateTextNode(gpxGenerator.validateXml(gei.Name ?? "")); el.AppendChild(txt); chgEl.AppendChild(el); el = doc.CreateElement("type"); txt = doc.CreateTextNode((from a in ApplicationData.Instance.GeocacheTypes where a.GSAK == gei.CacheType select a.GPXTag).FirstOrDefault() ?? ""); el.AppendChild(txt); chgEl.AppendChild(el); el = doc.CreateElement("lat"); txt = doc.CreateTextNode(gei.kAfterLat ?? gei.Latitude); el.AppendChild(txt); chgEl.AppendChild(el); el = doc.CreateElement("lon"); txt = doc.CreateTextNode(gei.kAfterLon ?? gei.Longitude); el.AppendChild(txt); chgEl.AppendChild(el); el = doc.CreateElement("file_pos"); txt = doc.CreateTextNode(curPos.ToString()); curPos += gei.FileLen; el.AppendChild(txt); chgEl.AppendChild(el); el = doc.CreateElement("file_len"); txt = doc.CreateTextNode(gei.FileLen.ToString()); el.AppendChild(txt); chgEl.AppendChild(el); XmlElement ratingsEl = doc.CreateElement("ratings"); chgEl.AppendChild(ratingsEl); el = doc.CreateElement("awesomeness"); txt = doc.CreateTextNode("3.0"); el.AppendChild(txt); ratingsEl.AppendChild(el); el = doc.CreateElement("difficulty"); txt = doc.CreateTextNode(gei.Difficulty.ToString("0.#").Replace(',', '.')); el.AppendChild(txt); ratingsEl.AppendChild(el); el = doc.CreateElement("size"); switch ((from a in ApplicationData.Instance.GeocacheContainers where a.Name == gei.Container select a.ID).FirstOrDefault()) { case 1: txt = doc.CreateTextNode("2.0"); break; case 5: txt = doc.CreateTextNode("2.0"); break; case 6: txt = doc.CreateTextNode("2.0"); break; case 2: txt = doc.CreateTextNode("2.0"); break; case 3: txt = doc.CreateTextNode("4.0"); break; case 4: txt = doc.CreateTextNode("5.0"); break; case 8: txt = doc.CreateTextNode("3.0"); break; default: txt = doc.CreateTextNode("3.0"); break; } el.AppendChild(txt); ratingsEl.AppendChild(el); el = doc.CreateElement("terrain"); txt = doc.CreateTextNode(gei.Terrain.ToString("0.#").Replace(',', '.')); el.AppendChild(txt); ratingsEl.AppendChild(el); if (gei.Found != 0) { el = doc.CreateElement("found"); txt = doc.CreateTextNode("true"); el.AppendChild(txt); chgEl.AppendChild(el); } } fileIndex++; } //add index file // index\com\garmin\geocaches\v0\index.xml /* * <gch> * <code>GC12345</code> * <name>Cache name</name> * <type>Traditional Cache</type> * <lat>33.550217</lat> * <lon>-117.660617</lon> * <file_pos>5875</file_pos> * <file_len>5783</file_len> * <ratings> * <awesomeness>3.0</awesomeness> * <difficulty>1.5</difficulty> * <size>5.0</size> * <terrain>1.5</terrain> * </ratings> * <found>true</found> * </gch> * * 1 = Nano (not supported, unfortunately, by GC.com yet) * 2 = Micro * 3 = Small * 4 = Regular * 5 = Large * */ using (System.IO.TemporaryFile tmp = new System.IO.TemporaryFile(true)) { using (TextWriter sw = new StreamWriter(tmp.Path, false, Encoding.UTF8)) //Set encoding { doc.Save(sw); } byte[] data = File.ReadAllBytes(tmp.Path); ZipEntry entry = new ZipEntry("index/com/garmin/geocaches/v0/index.xml"); entry.DateTime = DateTime.Now; s.PutNextEntry(entry); s.Write(data, 0, data.Length); } s.Finish(); s.Close(); } if (!canceled) { System.IO.File.Copy(gpxFile.Path, gpxSetting.FileName, true); } } } } } catch { } } }