je7sen / NFCPunch_System

To create a punch system to replace current analog punch.
1 stars 0 forks source link

Store online database #20

Closed yancyn closed 11 years ago

yancyn commented 11 years ago

Look for available database format which can be integrate with arduino.

yancyn commented 11 years ago

Use AppSpot http://arduino-fusion.appspot.com/ but seems like it is a third party proxy. see https://wiki.internet-village.be/display/arduino/How+to+use+a+Google+Fusion+table

je7sen commented 11 years ago

currently i oso use third party api to write to spreadsheet... u can check on www.pushingbox.com

i try on url from laptop, it work fine every time, but when using arduino, sometimes it doesn't work. On 4 Nov 2013 10:59, "yancyn" notifications@github.com wrote:

Use AppSpot http://arduino-fusion.appspot.com/ but seems like it is a third party proxy. see https://wiki.internet-village.be/display/arduino/How+to+use+a+Google+Fusion+table

— Reply to this email directly or view it on GitHubhttps://github.com/je7sen/NFCPunch_System/issues/20#issuecomment-27662374 .

yancyn commented 11 years ago

Sen, have you try to access auth token with arduino native web client by adding content-type and length in header? I saw there are quite few other examples accessing google spreadsheet or google form by defining the content-type and content-length as well. They claimed that it is working with https also. But not sure how accurate are they because all blogs and forums already outdate.

Content-length is a variable, need to calculate based on total length of your url string Maybe for GET no need define content-length. But in POST it is a mandatory. I'm not sure, you try and see. Read http://playground.arduino.cc/Code/WebClient

capture

yancyn commented 11 years ago

What do you think about method no. 2 if we can't make it for no.1 at this moment? see https://github.com/je7sen/NFCPunch_System/wiki/Database-Conceptual-Diagram.

je7sen commented 11 years ago

change the header to GET solve all the problem.