Archive for the Category »Google Docs «

update to iOS4 and latest xcode

just did a massive update to the xcode, itunes and iphone to the latest.

first thought is slow for mapkit rendering.

second is that compiling is much tighter now.  what used to work for iPhone OS 3.13  doesn’t work for iOS4 for some cases, especially the memory intensive stuff for some Coredata calls that I made earlier.  Need to optimize or remove some of the fetch.  Seems like iOS4 is quite adamant on memory.

also, need to rework some of the google docs code that import into coredata.

was able to import earlier, not was busted.

did like the compiler and some enhance debugging tools in xcode.

looks like got lots to clean up and debug for version iOS4

GoggleDocs Spreadsheet headers need no spaces

I have downloaded speadsheets before with GoogleDocs Spreadsheet API, but never with headers that have spaces in between them.

Was assuming that this will work with header titles with no spaces, but was wrong.  Remove the spaces between the title wording and the API continue to work as before.

No sure if this is a bug, but it seem strange that header titles cannot have spaces between words.

Example Headers before, not working
Display Name    E-mail Address

Example Headers after, working
DisplayName    E-mailAddress

for (int count = 0; count < entriesCount; count++) {

entry = [[mEntryFeed entries] objectAtIndex:count];
listEntry = (GDataEntrySpreadsheetList *)entry;
customElements = [listEntry customElementDictionary];
enumerator = [customElements objectEnumerator];

while ((element = [enumerator nextObject]) != nil) {

kName = [element name];
kValue = [element stringValue];
NSLog(@”kName kValue %@”, kName, kValue);

Category: Google Docs  Comments off

gdata objective client 1.10.0

Downloaded the API about 2 weeks ago.  Now’s the time to replace the existing  1.9.

Should be same for me as still using only the Spreadsheet API.  Later, will need to find a way to store last modified file so as not to download if requested.

Maybe that’s for version 1+.

Import vcard using GData

Looking into importing vcard using GData.

Likely to be using some sort of contacts and address for a project.  What’s a better way than using an open standard such as vCard as payload.

Have done some code for GData for spreadsheet import and export.  Need to find some examples for this.  Could be a really useful code to have for managing contacts.  Also, will be using ABAddressBook API which is handy with vCard.

vCard is text based.  Simply put the contents of the vcard into one of the spreadsheet cell.  Then import as string and then convert to NSData for use when needed for address.

Cell Feed vs List Feed when importing Google Docs

List Feed halved the time needed and create less objects while importing.  When using cell feed, the iphone completely bombs when reading.  When using list feed, it did import all the data but required 20 minutes.  Now it is time to import in batches to follow the feed.

Category: Google Docs  One Comment

Reducing memory footprint when using Core Data

Got this persistence memory overload when importing data from a Google Docs spreadsheet into Core Data.

XXXXX <89476b67fcbc4c49f1ba498af5d06040>   17483 (jettisoned) (active)

Give up after 17483 count.  At the moment is using [managedObjectContext save:&error] at the end of the input.  Maybe can consider saving every record at the end of each loop.

New project using Google Spreadsheet & Core Data

Halfway through a new project that uses Google Spreadsheet & Core Data.

SmartMeter updates uses Google Spreadsheet to export meter readings & tariffs to user google docs account.  Started using the Core Data APIs for this next project to have clean and easier way to manage persistent data.

Goodbye IE6 for Google Docs

CNET reported that changes in IE market share, with IE8 gaining usage at the expense of IE7 & IE6.

Google last week also announce end of support for IE6. Google now supports IE7+, FireFox 3.0+, Chrome 4.0+ and Safari 3.0+.

IE6 has been around for a decade.  It is full of security holes and breaks HTML standards.  It is also rumored to be used recently to hack Google Gmail accounts in China.  Time to drop IE6!

Google Docs API and iPhone SDK

Google Docs API is more than just Apps.  It’s Google’s massive APIs for docs, videos, maps and others for people to share stuff over the internet.  Lots of well known products are based on Google Docs APIs.

The basic setup for Google Docs and Xcode | iPhone coding is shown in this link

SmartMeter 1.1 released

SmartMeter 1.1 for sale at new reduced price of US$0.99.  New feature is exporting readings, tariffs, consumption & billing as a spreadsheet to goggle docs.