public Parcel(PropertyInfo p, ListFeed memberList)
{
this.Number = p.parcelNumber;
this.Owner = p.ownerName1;
this.Address = p.address;
this.City = p.city;
this.Zip = p.zipCode;
this.Legal = p.legal;
this.Subdivision = !string.IsNullOrWhiteSpace(p.subdivDescr) ? p.subdivDescr : GetSubdivision();
this.Filing = GetFiling();
this.IsAnnexed = GetAnnex();
Membership m = GetLienInfo(memberList);
this.IsMember = !string.IsNullOrWhiteSpace(m.MemberId) ? true : false;
this.GrantFiled = !string.IsNullOrWhiteSpace(m.GrantFiled) ? m.GrantSigned : "";
this.GrantSigned = !string.IsNullOrWhiteSpace(m.GrantSigned) ? m.GrantSigned : "";
this.MemberId = !string.IsNullOrWhiteSpace(m.MemberId) ? m.MemberId : "";
// mailing addres
this.MailAddress1 = !string.IsNullOrWhiteSpace(p.mailAddress1) ? p.mailAddress1 : "";
this.MailAddress2 = !string.IsNullOrWhiteSpace(p.mailAddress2) ? p.mailAddress2 : "";
this.MailAddressCity = !string.IsNullOrWhiteSpace(p.mailCity) ? p.mailCity : "";
this.MailAddressState = !string.IsNullOrWhiteSpace(p.mailState) ? p.mailState : "";
this.MailAddressZip = !string.IsNullOrWhiteSpace(p.mailZipCode) ? FormatZipCode(p.mailZipCode) : "";
// owner
this.Owner1 = this.Owner;
this.Owner2 = !string.IsNullOrWhiteSpace(p.ownerName2) ? p.ownerName2 : "";
}
/// <summary>
/// Inserts a new row in the specified worksheet.
/// </summary>
/// <param name="service">an authenticated SpreadsheetsService object</param>
/// <param name="entry">the worksheet into which the row will be inserted</param>
/// <returns>the inserted ListEntry object, representing the new row</returns>
private static ListEntry InsertRow(SpreadsheetsService service, WorksheetEntry entry)
{
AtomLink listFeedLink = entry.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
ListQuery query = new ListQuery(listFeedLink.HRef.ToString());
ListFeed feed = service.Query(query);
ListEntry firstRow = feed.Entries[0] as ListEntry;
ListEntry newRow = new ListEntry();
Console.WriteLine();
Console.WriteLine("Inserting a new row...");
foreach (ListEntry.Custom element in firstRow.Elements)
{
Console.Write("Enter the value of column \"{0}\": ", element.LocalName);
String elementValue = Console.ReadLine();
ListEntry.Custom curElement = new ListEntry.Custom();
curElement.LocalName = element.LocalName;
curElement.Value = elementValue;
newRow.Elements.Add(curElement);
}
ListEntry insertedRow = feed.Insert(newRow);
Console.WriteLine("Successfully inserted new row: \"{0}\"",
insertedRow.Content.Content);
return(insertedRow);
}
/// <summary>
/// Retrieves and prints a list feed of the specified worksheet.
/// </summary>
/// <param name="service">an authenticated SpreadsheetsService object</param>
/// <param name="entry">the worksheet to retrieve</param>
/// <param name="reverseRows">true if the rows in the worksheet should
/// be reversed when returned from the server</param>
private static void RetrieveListFeed(SpreadsheetsService service, WorksheetEntry entry,
bool reverseRows)
{
AtomLink listFeedLink = entry.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
Console.WriteLine();
Console.WriteLine("This worksheet's list feed URL is:");
Console.WriteLine(listFeedLink.HRef);
ListQuery query = new ListQuery(listFeedLink.HRef.ToString());
if (reverseRows)
{
query.OrderByPosition = true;
query.Reverse = true;
}
ListFeed feed = service.Query(query);
Console.WriteLine();
Console.WriteLine("Worksheet has {0} rows:", feed.Entries.Count);
foreach (ListEntry worksheetRow in feed.Entries)
{
ListEntry.CustomElementCollection elements = worksheetRow.Elements;
foreach (ListEntry.Custom element in elements)
{
Console.Write(element.Value + "\t");
}
Console.WriteLine();
}
}
List <string> GetColumnTitles(ListFeed feed)
{
List <string> titles = new List <string>();
if (titleRowActual < 0)
{
ListEntry row = feed.Entries[0] as ListEntry;
foreach (ListEntry.Custom element in row.Elements)
{
titles.Add(element.LocalName);
}
}
else
{
ListEntry row = feed.Entries[titleRowActual] as ListEntry;
foreach (ListEntry.Custom element in row.Elements)
{
titles.Add(element.Value);
}
}
return(titles);
}
/// <summary>
/// updates a rows information based on the instance of dataname found in the worksheet
/// </summary>
/// <param name="worksheet"></param>
/// <param name="rowNumber">The number of the row to be modified</param>
/// <param name="newData"></param>
public static void ModifyRowData(this GS2U_Worksheet worksheet, int rowNumber, Dictionary <string, string> newData)
{
if (worksheet.GetWorksheetSize().y < rowNumber)
{
Debug.Log("Worksheet is smaller than rowNumber to edit");
return;
}
ListFeed feed = worksheet.LoadListFeedWorksheet();
ListEntry row = (ListEntry)feed.Entries[rowNumber - 1];
foreach (var entry in newData)
{
bool found = false;
foreach (ListEntry.Custom element in row.Elements)
{
if (element.LocalName.ToLower() == entry.Key.ToLower())
{
element.Value = entry.Value;
found = true;
break;
}
}
if (!found)
{
Debug.LogError("No field found for " + entry.Key);
}
}
row.Update();
}
private string ToGoogleTable()
{
WorksheetFeed wsFeed = TargetTable.Worksheets;
WorksheetEntry worksheet = (WorksheetEntry)wsFeed.Entries[0];
// Define the URL to request the list feed of the worksheet.
AtomLink listFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
// Fetch the list feed of the worksheet.
ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString());
ListFeed listFeed = service.Query(listQuery);
CellQuery cellQuery = new CellQuery(worksheet.CellFeedLink);
CellFeed cellFeed = service.Query(cellQuery);
CellEntry cellEntry = new CellEntry(1, 1, "oid");
cellFeed.Insert(cellEntry);
cellEntry = new CellEntry(1, 2, "value");
cellFeed.Insert(cellEntry);
cellEntry = new CellEntry(1, 3, "type");
cellFeed.Insert(cellEntry);
ProgressBarSetStartParams(progressBar1, ListData[ListData.Count - 1].Count);
tabControlShow(progressBar1);
tabControlShow(label3);
for (int i = 0; i < ListData[ListData.Count - 1].Count; i++)
{
IncrementProgressbar(progressBar1);
IncrementGeneralLabel(string.Format("Выполнено {0}/{1}", i + 1, ListData[ListData.Count - 1].Count));
service.Insert(listFeed, ListData[ListData.Count - 1].GetCustom(i));
}
tabControlShow(progressBar1, false);
tabControlShow(label3, false);
return("Данные записаны");
}
internal WorksheetRow(ListFeed feed)
{
// TODO need to pre-init listEntry columns
_feed = feed;
_entry = new ListEntry();
_unsaved = true;
}
public bool Process()
{
Debug.WriteLine("start AddMissionResultEntry");
WorksheetEntry sheet = GetWorksheet("Mission");
if (sheet == null)
{
_finishCallback(false);
return(false);
}
ListFeed listFeed = _wrapper.Query(sheet);
//ListEntry listRow = new ListEntry();
ListEntry row = (ListEntry)listFeed.CreateFeedEntry();
foreach (var it in _info.KeyValue)
{
row.Add(it);
}
listFeed.Insert(row);
_finishCallback(true);
return(true);
}
private Dictionary <string, JobInfo> getGoogleDocsJobs()
{
Dictionary <string, JobInfo> jobs = new Dictionary <string, JobInfo>();
WorksheetEntry ws = this.getDataWorksheet();
AtomLink feedLink = ws.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
ListQuery listQuery = new ListQuery(feedLink.HRef.ToString());
ListFeed feed = this.service.Query(listQuery);
foreach (ListEntry row in feed.Entries)
{
string key = null;
string col1 = null;
string col2 = null;
foreach (ListEntry.Custom element in row.Elements)
{
if (key == null)
{
key = element.Value;
}
else if (col1 == null)
{
col1 = element.Value;
}
else if (col2 == null)
{
col2 = element.Value;
}
}
jobs.Add(key, new JobInfo(key, col1, col2));
}
return(jobs);
}
public bool Process()
{
Debug.WriteLine("start AddMaterialChangeEntry");
WorksheetEntry sheet = GetWorksheet("Materials");
if (sheet == null)
{
_finishCallback(false);
return(false);
}
sheet = CheckColumns(sheet, LogData.MaterialChangeInfo.SpreadsheetColumnTitle());
ListFeed listFeed = _wrapper.Query(sheet);
//ListEntry listRow = new ListEntry();
ListEntry row = (ListEntry)listFeed.CreateFeedEntry();
foreach (var it in _info.KeyValue)
{
row.Add(it);
}
listFeed.Insert(row);
_finishCallback(true);
return(true);
}
public void ListQuery(WorksheetEntry worksheet)
{
// Define the URL to request the list feed of the worksheet.
AtomLink listFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
// Fetch the list feed of the worksheet.
ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString());
//listQuery.MinPublication = new DateTime(2013, 9, 18);
//listQuery.ModifiedSince = new DateTime(2013, 9, 18);
listQuery.StartDate = new DateTime(2013, 9, 18);
ListFeed listFeed = this.Service.Query(listQuery);
Console.WriteLine("Results {0}", listFeed.Entries.Count);
for (int rowIdx = 0; rowIdx < 10; rowIdx++)
{
// TODO: Choose a row more intelligently based on your app's needs.
ListEntry row = (ListEntry)listFeed.Entries[rowIdx];
// Update the row's data.
foreach (ListEntry.Custom element in row.Elements)
{
Console.WriteLine(element.LocalName + " : " + element.Value);
Console.ReadLine();
}
}
}
private ListFeed GetWorksheetFeed(WorksheetEntry pWorksheetEntry)
{
AtomLink wListFeedLink = pWorksheetEntry.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
ListQuery wquery = new ListQuery(wListFeedLink.HRef.ToString());
ListFeed w2feed = tService.Query(wquery);
return(w2feed);
}
private void UpdateListFeed()
{
WorksheetEntry worksheet = (WorksheetEntry)worksheetFeed.Entries[0];
AtomLink listFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString());
listFeed = spreadsheetsService.Query(listQuery);
}
public IEnumerable <ListEntry> GetAllRows()
{
AtomLink listFeedLink = WorksheetEntry.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString());
ListFeed feed = service.Query(listQuery);
return(feed.Entries.Select(e => (ListEntry)e));
}
protected TranslationModule FromWorksheet(string project, WorksheetEntry worksheet)
{
// Define the URL to request the list feed of the worksheet.
AtomLink listFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
// Fetch the list feed of the worksheet.
ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString());
ListFeed listFeed = this.Service.Query(listQuery);
Console.WriteLine("Results {0}", listFeed.Entries.Count);
List <string> languages = new List <string>();
var dicts = new Dictionary <string, Dictionary <string, string> >();
var comments = new Dictionary <string, string>();
//language information is in first row
var firstRow = (ListEntry)listFeed.Entries[0];
for (int column = 1; column < firstRow.Elements.Count; column++)
{
var lang = firstRow.Elements[column].LocalName;
languages.Add(lang);
dicts.Add(lang, new Dictionary <string, string>());
}
var tp = new TranslationModule(project, "en", languages.ToArray());
for (int rowIdx = 1; rowIdx < listFeed.Entries.Count; rowIdx++)
{
ListEntry row = (ListEntry)listFeed.Entries[rowIdx];
string comment = null;
string key = row.Elements[0].Value; // first column is the key
// Update the row's data.
for (int column = 1; column < row.Elements.Count; column++)
{
var element = row.Elements[column];
//in list based feeds localname always correponds to first row
if (element.LocalName.ToLower() == "comment")
{
comment = element.Value;
}
else
{
tp.Add(new Segment(element.LocalName, key, element.Value));
}
}
foreach (var seg in tp.ByKey[key])
{
seg.Comment = comment;
}
}
return(tp);
}
static void Main(string[] args)
{
Thread.CurrentThread.CurrentCulture = new CultureInfo("es-ES");
// CHARACTERS
List <string> charactersAndUpgradesStrings = new List <string>();
ListFeed list = GDriveManager.GetSpreadsheet(DriveUrl, 1);
foreach (ListEntry row in list.Entries)
{
string name = row.Elements[0].Value;
float multiplier = float.Parse(row.Elements[1].Value);
int health = int.Parse(row.Elements[2].Value);
int klid = int.Parse(row.Elements[3].Value);
float klidRegen = float.Parse(row.Elements[4].Value);
float speed = float.Parse(row.Elements[5].Value);
float whoaPower = float.Parse(row.Elements[6].Value);
float mass = float.Parse(row.Elements[7].Value);
int spellSlots = int.Parse(row.Elements[8].Value);
int price = int.Parse(row.Elements[9].Value);
charactersAndUpgradesStrings.Add(String.Format("\n\n//{0}\nWhoaCharacter {0} = new WhoaCharacter({0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}, {8}, {9});\ncharacters.Add({0});", name, multiplier, health, whoaPower, speed, mass, klid, klidRegen, spellSlots, price));
}
ListFeed upgradesList = GDriveManager.GetSpreadsheet(WhoaPlayerProperties.DRIVE_DOCUMENT_URL, 2);
foreach (ListEntry row in upgradesList.Entries)
{
int id = int.Parse(row.Elements[0].Value);
if (id == -1)
{
upgrade.Effects.Add(parseEffect(row));
}
else
{
currentlyUpgradedCharacter = characters[id];
string name = row.Elements[1].Value;
int maxLevel = int.Parse(row.Elements[2].Value);
int basePrice = int.Parse(row.Elements[3].Value);
float priceMultiplier = float.Parse(row.Elements[4].Value);
upgrade = new CharacterUpgrade(name, maxLevel, basePrice, priceMultiplier);
upgrade.Effects.Add(parseEffect(row));
currentlyUpgradedCharacter.AddUpgrade(upgrade);
}
}
ReplaceAutoGenerated(WhoaScriptsFolderPath + "WHOATESTING.txt", charactersAndUpgradesStrings);
// Keep the console window open in debug mode.
Console.WriteLine("Press any key to exit.");
Console.ReadKey();
}
protected void button2_Click(object sender, EventArgs e)
{
if (spreadsheetName.Length > 0)
{
if (listView2.SelectedIndex > -1)
{
wrkSheetName = listView2.SelectedItem.Text;
}
else
{
return;
}
SpreadsheetsService GoogleExcelService;
GoogleExcelService = new SpreadsheetsService("Spreadsheet-Abhishek-App");
GoogleExcelService.setUserCredentials("*****@*****.**", "Lucknow@");
// ListQuery query = new ListQuery("0AmYgMIof-5mgdGM2OGxoTmUyc3JRTFlMZ1BTUG5SOVE", "1", "public", "values");
// ListQuery query = new ListQuery("https://docs.google.com/a/laitkor.com/spreadsheet/ccc?key=0AttN4WWVg0qodF9RSG8tOXptV0RwZm1LOWFJQ3g0Mnc#gid=0", "1", "public", "values");
//ListFeed myFeed = GoogleExcelService.Query(query);
SpreadsheetQuery query = new SpreadsheetQuery();
SpreadsheetFeed myFeed = GoogleExcelService.Query(query);
foreach (SpreadsheetEntry mySpread in myFeed.Entries)
{
if (mySpread.Title.Text == spreadsheetName)
{
WorksheetFeed wfeed = mySpread.Worksheets;
foreach (WorksheetEntry wsheet in wfeed.Entries)
{
if (wsheet.Title.Text == wrkSheetName)
{
AtomLink atm = wsheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
ListQuery Lquery = new ListQuery(atm.HRef.ToString());
ListFeed LFeed = GoogleExcelService.Query(Lquery);
myTable = new DataTable();
DataColumn DC;
foreach (ListEntry LmySpread in LFeed.Entries)
{
DataRow myDR = myTable.NewRow();
foreach (ListEntry.Custom listrow in LmySpread.Elements)
{
DC = myTable.Columns[listrow.LocalName] ?? myTable.Columns.Add(listrow.LocalName);
myDR[DC] = listrow.Value;
}
myTable.Rows.Add(myDR);
}
dataGridView1.DataSource = myTable;
dataGridView1.DataBind();
}
}
}
}
}
//System.Windows.Forms.MessageBox.Show("Data Reading is Completed");
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('Data Reading is Completed');", true);
}
public void getValues(string sheetName, DataSet dataSet)
{
var tableName = sheetName;
if (dataSet.Tables[tableName] == null)
{
tableName = sheetName + "_";
}
if (dataSet.Tables[tableName] == null)
{
throw new ArgumentException("Neither " + sheetName + " nor " + sheetName + "_ tables could be found in the passed dataset!!!");
}
DataColumnCollection columnNames = dataSet.Tables[tableName].Columns;
WorksheetEntry entry = (WorksheetEntry)m_worksheets[sheetName];
if (entry == null)
{
string message = sheetName + " not found in " + m_spreadsheetName;
Trace.WriteLine(message);
throw new ArgumentNullException(message);
}
AtomLink listFeedLink = entry.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
ListQuery query = new ListQuery(listFeedLink.HRef.ToString());
ListFeed feed = m_service.Query(query);
Trace.WriteLine("Found " + feed.Entries.Count + " rows of data in " + sheetName);
if (feed.Entries.Count > 0)
{
ListEntry worksheetRow = (ListEntry)feed.Entries[0];
ListEntry.CustomElementCollection elements = worksheetRow.Elements;
for (int j = 0; j < feed.Entries.Count; ++j)
{
worksheetRow = (ListEntry)feed.Entries[j];
elements = worksheetRow.Elements;
DataRow workRow = dataSet.Tables[tableName].NewRow();
for (int i = 0; i < elements.Count; ++i)
{
string value = "" + elements[i].Value;
Type type = columnNames[i].DataType;
if (type == System.Type.GetType("System.Double") && string.IsNullOrWhiteSpace(value))
{
value = "0";
}
if (type == System.Type.GetType("System.Int32") && string.IsNullOrWhiteSpace(value))
{
value = "0";
}
workRow[columnNames[i].ColumnName] = value;
}
dataSet.Tables[tableName].Rows.Add(workRow);
}
}
return;
}
private List <DatablockDetectionInfo> ParseSpreadsheet(SpreadsheetEntry spreadsheet)
{
WorksheetFeed wsFeed = spreadsheet.Worksheets;
if (wsFeed.Entries.Count == 0)
{
return(null);
}
var worksheet = (WorksheetEntry)wsFeed.Entries[0];
if (worksheet.Rows < 2)
{
return(null);
}
// Define the URL to request the list feed of the worksheet.
AtomLink listFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
// Fetch the list feed of the worksheet.
var listQuery = new ListQuery(listFeedLink.HRef.ToString());
ListFeed listFeed = sheetsAPI.Service.Query(listQuery);
var headers = new List <string>();
spreadsheetRows = listFeed.Entries;
nameColumnIndex = -1;
var row = (ListEntry)spreadsheetRows[0];
for (int index = 0; index < row.Elements.Count; index++)
{
ListEntry.Custom element = row.Elements[index];
if (element.LocalName.Equals("name", StringComparison.OrdinalIgnoreCase))
{
nameColumnIndex = index;
}
headers.Add(element.LocalName);
}
List <DatablockDetectionInfo> datablockTypes = AutoDetectDatablockType(headers);
if (datablockTypes == null)
{
Debug.Log("Unable to auto detect datablock type");
return(null);
}
return(datablockTypes);
}
private static bool UpdateLinkInfo(WorksheetEntry wsEntry, List <LinkInfo> linkToUpdate)
{
bool updated = false;
try
{
LinkInfo firstLinkInfo = linkToUpdate.First();
AtomLink listFeedLink = wsEntry.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString());
listQuery.SpreadsheetQuery = "sourcemodelid = \"" + firstLinkInfo.SourceModelId + "\"";
ListFeed listFeed = sheetsService.Query(listQuery);
if (listFeed.Entries.Count > 0)
{
foreach (ListEntry row in listFeed.Entries)
{
string itemSourceId = row.Elements[Array.IndexOf(googleHeaders, "ItemSourceID")].Value;
var linkFound = from linkInfo in linkToUpdate where linkInfo.SourceItemId.ToString() == itemSourceId select linkInfo;
if (linkFound.Count() > 0)
{
try
{
LinkInfo linkInfo = linkFound.First();
row.Elements[Array.IndexOf(googleHeaders, "ItemType")].Value = linkInfo.ItemType.ToString();
row.Elements[Array.IndexOf(googleHeaders, "SourceName")].Value = linkInfo.SourceModelName;
row.Elements[Array.IndexOf(googleHeaders, "SourcePath")].Value = linkInfo.SourceModelPath;
row.Elements[Array.IndexOf(googleHeaders, "DestinationPath")].Value = linkInfo.DestModelPath;
row.Elements[Array.IndexOf(googleHeaders, "ItemSourceName")].Value = linkInfo.SourceItemName;
row.Elements[Array.IndexOf(googleHeaders, "ItemDestinationID")].Value = linkInfo.DestItemId.ToString();
row.Elements[Array.IndexOf(googleHeaders, "ItemDestinationName")].Value = linkInfo.DestItemName;
row.Elements[Array.IndexOf(googleHeaders, "ItemDestinationImage1")].Value = linkInfo.DestImagePath1;
row.Elements[Array.IndexOf(googleHeaders, "ItemDestinationImage2")].Value = linkInfo.DestImagePath2;
row.Elements[Array.IndexOf(googleHeaders, "LinkModified")].Value = linkInfo.LinkModified;
row.Elements[Array.IndexOf(googleHeaders, "LinkModifiedBy")].Value = linkInfo.LinkModifiedBy;
row.Update();
}
catch (Exception ex)
{
string message = ex.Message;
}
}
}
updated = true;
}
}
catch (Exception ex)
{
MessageBox.Show("Failed to update the link information.\n" + ex.Message, "Update Link Information", MessageBoxButton.OK, MessageBoxImage.Warning);
}
return(updated);
}
public WorksheetValues GetList(WorksheetEntry worksheet)
{
AtomLink listFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString());
ListFeed listFeed = _service.Query(listQuery);
var values = listFeed.Entries.Select(row => ((ListEntry)row).Elements.Cast <ListEntry.Custom>().ToDictionary(el => el.LocalName, el => el.Value));
return(new WorksheetValues()
{
Values = values
});
}
private void ClearSheet(string workbookName)
{
var page1 = (WorksheetEntry)GetWorkbookSheets(workbookName)[0];
if (page1 == null)
{
throw new ApplicationException("Worksheet not found");
}
AtomLink listFeedLink = page1.Links.FindService(GDataSpreadsheetsNameTable.CellRel, null);
ListFeed listFeed = spreadsheetService.Query(new ListQuery(listFeedLink.HRef.ToString()));
CellFeed cells = spreadsheetService.Query(new CellQuery(listFeedLink.HRef.ToString()));
int ctr = 0;
CellEntry toUpdateA;
CellEntry toUpdateB;
AtomFeed batchFeed = new AtomFeed(cells);
// This is for the header row
ctr = (int)cells.ColCount.Count;
// Skip all of this if there are no cells with values in them other than those in the header row
if (cells.Entries.Count > ctr)
{
// Process through all of the cells that have a value in them starting at the cell below the Header
while (true)
{
toUpdateA = (CellEntry)cells.Entries[ctr];
toUpdateA.Cell.InputValue = "";
toUpdateA.BatchData = new GDataBatchEntryData("A", GDataBatchOperationType.update);
batchFeed.Entries.Add(toUpdateA);
ctr++;
if (ctr >= cells.Entries.Count)
{
break;
}
toUpdateB = (CellEntry)cells.Entries[ctr];
toUpdateB.Cell.InputValue = "";
toUpdateB.BatchData = new GDataBatchEntryData("B", GDataBatchOperationType.update);
batchFeed.Entries.Add(toUpdateB);
ctr = ctr + 1;
if (ctr >= cells.Entries.Count)
{
break;
}
}
// Erase all cells
CellFeed batchResultFeed = (CellFeed)spreadsheetService.Batch(batchFeed, new Uri(cells.Batch));
}
}
public void SelectWorkSheet(string sSheetName)
{
WorksheetQuery worksheetQuery = new WorksheetQuery(m_oLink.HRef.ToString());
worksheetQuery.Title = sSheetName;
m_oWorksheetFeed = m_oAccount.Service.Query(worksheetQuery);
m_oWorksheet = (WorksheetEntry)m_oWorksheetFeed.Entries[0];
AtomLink listFeedLink = m_oWorksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
ListQuery listQuery = new ListQuery(listFeedLink.HRef.ToString());
m_oListFeed = m_oAccount.Service.Query(listQuery);
}
// grab your spreadsheet's ID / "key" from the URL to access your doc...
// make sure stop as soon as you hit an ampersand, those are additional URL parameters we don't need
public static ListFeed GetSpreadsheet(string spreadsheetID, int gridId)
{
// We need this fake certificate to trick Mono's security to use HTTPS... doesn't work in webplayer's security sandbox
InsecureSecurityCertificatePolicy.Instate();
SpreadsheetsService service = new SpreadsheetsService("UnityConnect");
string url = "https://spreadsheets.google.com/feeds/list/" + spreadsheetID + "/" + gridId + "/public/values";
ListQuery listQuery = new ListQuery(url);
ListFeed feed = service.Query(listQuery);
return(feed);
}
private Membership GetLienInfo(ListFeed memberList)
{
Membership m = new Membership();
foreach (ListEntry entry in memberList.Entries)
{
if (entry.Elements[8].Value.ToString().Replace("-", "") == this.Number)
{
m.GrantFiled = entry.Elements[6].Value.ToString();
m.GrantSigned = entry.Elements[5].Value.ToString();
m.MemberId = entry.Elements[0].Value.ToString();
}
}
return(m);
}
/// <summary>
/// Reads the Google Spreadsheet and generates/updates the StringSet asset files
/// </summary>
public void Generate()
{
ListFeed test = GDocService.GetSpreadsheet(GoogleLink);
var languageMap = new Dictionary <string, StringSet>();
var keys = CreateInstance <StringSet>();
languageMap.Add("Keys", keys);
var ignore = new HashSet <string>(_ignoreColumns);
foreach (ListEntry row in test.Entries)
{
keys.Add(row.Title.Text);
foreach (ListEntry.Custom element in row.Elements)
{
string lang = element.LocalName;
if (ignore.Contains(lang))
{
continue;
}
if (!languageMap.ContainsKey(lang))
{
languageMap[lang] = CreateInstance <StringSet>();
}
languageMap[lang].Add(element.Value);
}
}
string folderPath = _saveFolder ? AssetDatabase.GetAssetPath(_saveFolder) : "Assets/Resources/Lang";
foreach (var lang in languageMap)
{
var method = "Generating";
string path = string.Format("{0}/{1}.asset", folderPath, lang.Key);
var language = AssetDatabase.LoadAssetAtPath <StringSet>(path);
if (language)
{
method = "Updating";
language.Copy(lang.Value);
EditorUtility.SetDirty(language);
}
else
{
AssetDatabase.CreateAsset(lang.Value, path);
}
Debug.Log(string.Format("{0} language files for: {1}", method, lang.Key));
}
EditorApplication.SaveAssets();
AssetDatabase.SaveAssets();
}
Dictionary <string, SerializedNestedStrings> generateLanguageDict(ListFeed sheet)
{
var firstRow = (ListEntry)sheet.Entries.FirstOrDefault();
var returnDict = new Dictionary <string, SerializedNestedStrings>();
foreach (ListEntry.Custom element in firstRow.Elements)
{
if (element.LocalName.Equals(KeyIdentifier))
{
continue;
}
returnDict[element.LocalName] = new SerializedNestedStrings();
}
return(returnDict);
}
/// <summary>
/// Add a new row of data to the bottom of the worksheet
/// </summary>
/// <param name="worksheet"></param>
/// <param name="newData"></param>
public static void AddRowData(this GS2U_Worksheet worksheet, Dictionary <string, string> newData)
{
ListFeed feed = worksheet.LoadListFeedWorksheet();
ListEntry newRow = new ListEntry();
foreach (var entry in newData)
{
newRow.Elements.Add(new ListEntry.Custom()
{
LocalName = entry.Key.ToLower(), Value = entry.Value.ToLower()
});
}
SpreadSheetManager.service.Insert(feed, newRow);
}
public NameValueCollection getInfo(Boolean debug = false)
{
NameValueCollection parameters = new NameValueCollection();
WorksheetEntry entry = (WorksheetEntry)worksheets["Info"];
AtomLink listFeedLink = entry.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
ListQuery query = new ListQuery(listFeedLink.HRef.ToString());
ListFeed feed = service.Query(query);
foreach (ListEntry worksheetRow in feed.Entries)
{
ListEntry.CustomElementCollection elements = worksheetRow.Elements;
parameters.Add(elements[0].Value, elements[1].Value);
}
return(parameters);
}
/// <summary> Reads the Google Spreadsheet and generates/updates the StringSet asset files </summary>
public void Generate()
{
ListFeed test = GDocService.GetSpreadsheet(GoogleLink);
var languageMap = new Dictionary <string, Dictionary <string, string> >();
var ignore = new HashSet <string>(_ignoreColumns);
foreach (ListEntry row in test.Entries)
{
var keyEntry =
row.Elements.OfType <ListEntry.Custom>()
.FirstOrDefault(e => e.LocalName.ToLower() == _defaultLanguage.ToLower());
if (keyEntry == null)
{
continue;
}
var key = keyEntry.Value;
foreach (ListEntry.Custom element in row.Elements)
{
string lang = element.LocalName;
if (ignore.Contains(lang))
{
continue;
}
if (!languageMap.ContainsKey(lang))
{
languageMap[lang] = new Dictionary <string, string>();
}
languageMap[lang].Add(key, element.Value);
}
}
var baseFolder = Path.Combine(Application.streamingAssetsPath, "lang");
if (!Directory.Exists(baseFolder))
{
Directory.CreateDirectory(baseFolder);
}
foreach (var lang in languageMap)
{
File.WriteAllText(Path.Combine(baseFolder, lang.Key + LanguageManager.FileExtension),
JsonConvert.SerializeObject(lang.Value, Formatting.Indented));
Log.Info("Generating language files for: {0}", lang.Key);
}
AssetDatabase.SaveAssets();
AssetDatabase.Refresh();
}
