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
{
}
}
}