Adding record fails

[GoogleCodeExporter]

When I try to add a record through the api (using Worksheet.addRecord) a 

java.io.FileNotFoundException: 
https://spreadsheets.google.com/feeds/<key>/records/<tableId>

exception is thrown from HttpConHandler. Also the record is not added, 
indicating that the call failed completely. I'm using the latest version on 
android 2.2, if you need any more information please let me know.

Thanks

Original issue reported on code.google.com by tomjames...@gmail.com on 1 Jan 2011 at 2:58

[GoogleCodeExporter]

Hi,

It seems it is unable to find associated Table for this WorkSheet.

This Lib can add records only to those WorkSheets which are created using this 
Lib. 
[Reason] - it stores data in SpreadSheet "Table" which doesn't get created when 
you use Web UI.

I hope you are trying to Add records after creating the WorkSheet through this 
Lib. Please let me know if this is the case.

Thanks,
Prasanta

Original comment by pprasant...@gmail.com on 3 Jan 2011 at 10:43

[GoogleCodeExporter]

No, even when adding to a worksheet I created with the lib it doesn't work. The 
Worksheet object that I am using definitely has a table member, with the 
correct columns.

Thanks,
Tom

Original comment by tomjames...@gmail.com on 3 Jan 2011 at 11:28

[GoogleCodeExporter]

P.s. If I run the post command through curl (unless I copied it down 
incorrectly) I get "It looks like someone else already deleted this cell."

Thanks

Original comment by tomjames...@gmail.com on 3 Jan 2011 at 11:34

[GoogleCodeExporter]

Hi,

Are you using the latest Lib 2.0 i.e. gss_lib_bin_2.0.zip  ? 
Is there anyway you can share some more log or trace or if you could share that 
spreadsheet with my gmail id pprasanta4u ?

Thanks,
Prasanta

Original comment by pprasant...@gmail.com on 3 Jan 2011 at 11:44

[GoogleCodeExporter]

Original comment by pprasant...@gmail.com on 3 Jan 2011 at 12:05

[GoogleCodeExporter]

Hi,

can you please try with the latest 2.0_u1 release. I have added a patch which 
now works for Android SDK.
Android SDK seems removes "gs:" prefix of SpreadSheet List/Table Feeds, and due 
to that probably it was causing the problem for you.

Please add the following line in your code (along with 2.0_u1 release)-
 if("sdk".equals(Build.PRODUCT) || "google_sdk".equals(Build.PRODUCT))
            ParseFeed.doCustomizationForSDK();
This adjustment is required only for Android Emulator or SDK.

Please let me know if it solves your issue ?
Thanks,
Prasanta 

Original comment by pprasant...@gmail.com on 11 Jan 2011 at 3:11

[GoogleCodeExporter]

I wanted to thank you for taking the time to write this extremely helpful 
library.  After trying the gdata api and just about everything else I could 
find, I am able to access my sqreadsheets in my android app.  

Now I am at the point where I want to be able to write data in the spreadsheets 
and I see above that the spreadsheets must be created by the api, so I imagine 
that I would first check for a sheets existance, and if it does not exist, then 
I would create it and send any data up.

Do you happen to have any code you have already written that creates a sheet 
and adds data?  Anything I could use as an example or starting point would be 
most helpful.

Thanks again,

Brian

Original comment by BGormanly on 25 Jan 2011 at 3:44

[GoogleCodeExporter]

Hi Brian,
thanks for your comments.

You can look into "WorkSheetSample.java" it is under "samples" folder of binary 
distribution. It shows steps to create "WorkSheet" and add data into WorkSheet.

Kindly note:
SpreadSheets directly don't hold data, rather it can have multiple "WorkSheets" 
and WorkSheets hold data. 

Hope it helps.
Thanks,
Prasanta

Original comment by pprasant...@gmail.com on 25 Jan 2011 at 6:08

[GoogleCodeExporter]

I checked this lib on android emulator. It is working fine there.

Original comment by naveen1...@gmail.com on 18 Feb 2011 at 5:50

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

"This Lib can add records only to those WorkSheets which are created using this 
Lib. 
[Reason] - it stores data in SpreadSheet "Table" which doesn't get created when 
you use Web UI."

Question: what if i have 2 Android devices who want to make changes into a 
spreadsheet (the same spreadsheet).   The spreadsheet would be created before 
(from code) by one of the devices, can the other access it?? or it can access 
it only if it is the creator of the spreadsheet?

Original comment by likethewind89 on 29 Nov 2011 at 6:23

[GoogleCodeExporter]

I can't write any row/cell data. The spreadsheet and worksheet was created 
using this library. I am using version gss-2.2 but also tried on version 2.2b1.

The stacktrace when trying to add record:

[SpreadSheet] Get Table Feed
[HttpConHandler] URL=https://spreadsheets.google.com/feeds/XXXXX/tables
[HttpConHandler] Error in connection: java.io.FileNotFoundException: 
https://spreadsheets.google.com/feeds/XXXXX/tables
[HTTP_Response] HTTP Response Code: 404
[HTTP_Response] HTTP Response: Not Found
[HTTP_Response] Error Msg from Server: <!DOCTYPE html><html 
lang="pl"00;position:absolute;........
[HTTP_Response] Error in Connection: 
https://spreadsheets.google.com/feeds/XXXXX/tables
java.io.FileNotFoundException: 
https://spreadsheets.google.com/feeds/XXXXX/tables
at 
com.android.okhttp.internal.http.HttpURLConnectionImpl.getInputStream(HttpURLCon
nectionImpl.java:197)
at 
com.android.okhttp.internal.http.DelegatingHttpsURLConnection.getInputStream(Del
egatingHttpsURLConnection.java:210)
at 
com.android.okhttp.internal.http.HttpsURLConnectionImpl.getInputStream(HttpsURLC
onnectionImpl.java:25)
at com.pras.conn.HttpConHandler.doConnect(HttpConHandler.java:131)
at com.pras.SpreadSheet.getTables(SpreadSheet.java:588)
at com.pras.SpreadSheet.getAllWorkSheets(SpreadSheet.java:479)
at com.pras.SpreadSheet.getAllWorkSheets(SpreadSheet.java:411)
at com.pras.SpreadSheet.getAllWorkSheets(SpreadSheet.java:401)

Original comment by mpola...@gmail.com on 7 Dec 2014 at 7:15

[GoogleCodeExporter]

Hello. Try use WorkSheet#addListRow(HashMap<String, String> records) instead 
addRecord(). In addition all column names should be lower case.

Original comment by serAro...@gmail.com on 23 Jan 2015 at 9:39