StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POGoogle spreadsheed API with Sencha Touch Ext.List
primarykey
Id
16543432
data
AcceptedAnswerId
16557617
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-05-14T12:40:56.890
FavoriteCount
1
LastActivityDate
2013-05-17T08:00:02.620
LastEditDate
2013-05-17T08:00:02.620
LastEditorUserId
887835
OwnerUserId
887835
ParentId
0
PostTypeId
1
Score
0
ViewCount
325
LastEditorDisplayName
text
Body
<p>I am using Sencha touch 2.1 to build a mobile app. I am trying to load a google spreadsheet as a datasource for a list.</p> <p>I have made the google spreadsheet public you can find it at this link:</p> <p><a href="https://docs.google.com/spreadsheet/pub?key=0AhW0xtL9j2bAdHlwRE1qcE1WdDVLa2dRdDBxNTJBV0E&output=html" rel="nofollow">https://docs.google.com/spreadsheet/pub?key=0AhW0xtL9j2bAdHlwRE1qcE1WdDVLa2dRdDBxNTJBV0E&output=html</a></p> <p>However I am not able to get it working.</p> <p>Here is the code I have so far:</p> <p><strong>The Model</strong></p> <pre><code>Ext.define('MyApp.model.InfoList', { extend: 'Ext.data.Model', config: { fields: [ 'Title', 'Description', 'Icon' ], idProperty: '_id' } }); </code></pre> <p><strong>The Store</strong></p> <pre><code>Ext.define('MyApp.store.InfoList', { extend : 'Ext.data.Store', config : { model : 'MyApp.model.InfoList', proxy: { type: 'jsonp', url : 'https://spreadsheets.google.com/feeds/list/0AhW0xtL9j2bAdHlwRE1qcE1WdDVLa2dRdDBxNTJBV0E/od6/public/basic?alt=json-in-script', reader: { type: 'json', root: 'feed.entry' } } } }); </code></pre> <p><strong>The View</strong></p> <pre><code>Ext.define('MyApp.view.home.infolist', { extend : 'Ext.List', xtype : 'infoListView', disableSelection: true, config : { title : 'Info List', itemTpl: [ '<div class="itemInfo">', '<div class="iconDiv">', '<img src="{Icon}" class="icon"/>', '</div>', '<div class="descriptionDiv">', '<div class="title">{Title}</div>', '<div class="description">{Description}</div>', '</div>', '<div class="disclosureDiv">', '<img src="images/infoListDisclosure.png" class="iconImage"/>', '</div>', '<div class="clear"></div>', '</div>', ].join(''), store : 'InfoList' } }); </code></pre> <p>The list is always empty. And if I use jsonp instead of json in the proxy the app stop running.</p> <p>Is there a way to see what is the responce I get from the proxy in an alert? or any indications for what might be the problem is appreciated</p> <p>PS: I building the application on IBM Worklight, but I am using sencha for the codings. I'm not sure if that affects anything</p> <p>Thank you</p>
Tags
<json><sencha-touch-2><google-spreadsheet-api>
Title
Google spreadsheed API with Sencha Touch Ext.List
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USYoussef
UserOwnerUserId
1. USYoussef
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POGoogle spreadsheed API with Sencha Touch Ext.List
  UserUserId
  USThinkFloyd
  VoteTypeVoteTypeId
  VTFavorite
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.