I am using Tasker on the headunit in my car and want to export my tripdata to a local spreadsheet when my car is offline. As soon as I reach my house, my car is online so that the spreadsheet can be synchronised to the spreadsheet that is stored on Dropbox.
I know how to update a Google sheet from Tasker, but as far as I know this can only be done when the car is online when I upload my tripdata. Therefore I assume that updating to an Excel spreadsheet that is stored on Dropbox with an offline copy on my headunit is the way to go. Is is possible to add a row to an offline Excel spreadsheet with Tasker or are there better alternatives?
Your help is greatly appreciated!
EJOK2 said:
I am using Tasker on the headunit in my car and want to export my tripdata to a local spreadsheet when my car is offline. As soon as I reach my house, my car is online so that the spreadsheet can be synchronised to the spreadsheet that is stored on Dropbox.
I know how to update a Google sheet from Tasker, but as far as I know this can only be done when the car is online when I upload my tripdata. Therefore I assume that updating to an Excel spreadsheet that is stored on Dropbox with an offline copy on my headunit is the way to go. Is is possible to add a row to an offline Excel spreadsheet with Tasker or are there better alternatives?
Your help is greatly appreciated!
Click to expand...
Click to collapse
Tasker is an amazing tool. There are many alternatives for a thing to be done. You can try to create two separate profile.
#01
when you are in trip your trip data will be stored in a csv file in local storage. you can open that csv file from any spreadsheet app.
#02
this profile will activate when there is wifi or mobile data. this will trigger a task which will upload that csv file to google drive. Or you can make that task to read csv file line by line and update google sheets. when updating google sheets or doing any http get/post I prefer javascriptlet fetch function with url encode. because "#" hash is not sent in http request.
Related
Hi
I have set up my Exchange Server 2003 to use the push technology for email updates etc., on my Kaiser. All is working well, except.....
The notes field in Contacts is truncated. I desperately need my full notes when away from my office.
I have looked at the various setup options and can't see a size 'threshold' parameter.
There must be some way of getting AirSync to sync the whole contact entry including the whole notes field.
TX in advance
Shobosh
[email protected]
Does anybody here know where the android browser bookmarks are stored on the file system? I'm hoping to keep a backup of my bookmarks so I don't need to go thru the hassle of entering all my favorite sites each time I have to wipe my phone!
thanks in advance
They're stored in a database in the browser's data directory. Check http://forum.xda-developers.com/showpost.php?p=3223060&postcount=199 -- it gives you the command to use to retrieve them from the database, i.e.
sqlite3 /data/data/com.android.browser/databases/browser.db "SELECT * FROM bookmarks;"
You can also use the My Backup app (available from the Market) to back them up.
Thanks for the quick reply.
I'm not really familiar with sqlite, more of a mysql guy personally
The bookmarks table holds the browser history as well.
Bookmarks backup
You should check out MyBackup on the Market. It's a free app that will backup your bookmarks (plus a lot of other things) to your SD card. It works quite well. The restore feature is also very simple.
There is also my bookmarks as well that allows you to import your bookmarks to your phone from your desktop browser.
speoples20 said:
There is also my bookmarks as well that allows you to import your bookmarks to your phone from your desktop browser.
Click to expand...
Click to collapse
What I'd like to see (and I can't believe wasn't included in the OS) is automatic syncing of your Android bookmarks with Google Bookmarks. (or ones labeled as mobile in Google Bookmarks)
I had this frustration as well (not being able to sync or backup my bookmarks) so I finally just found a simple website where I could save all of my bookmarks, then I set it as the browser home page. There are tons of websites out there that allow you to store your bookmarks, but the one that I chose was murl.com.
Since I use Firefox I use foxmarks. Which is one of the best programs I have ever used. It sycs all of your bookmarks through firefox on as many computers as you want. They have a mobile site you can bookmark in your browser or steel bookmarks and access all of them. Not perfect but better then nothing.
I use Foxmarks too, and I love it! Every time I use a different computer, I just sync my bookmarks, and everything stays the same on each machine!
Now when I use my phone, I can also just go to Foxmarks and click on any bookmark there to go to a website.
No FireFox here. (Work doesn't allow it for some reason.)
I use the Google Toolbar on both my desktop and notebook pcs at home and at the office to keep track of my bookmarks. I'm still surprised that it doesn't doesn't sync with android though. Seems like about the only Google thing that doesn't at this point.
I just wish someone would write a utility that automatically alphabetized the bookmarks, why this isn't an option by default is annoying. I'm thinking about making it my first Android project.
grokdesigns said:
I just wish someone would write a utility that automatically alphabetized the bookmarks, why this isn't an option by default is annoying. I'm thinking about making it my first Android project.
Click to expand...
Click to collapse
I don't think it would be hard to sort the list and dump out all the history entries as well. You can do this all with some SQL commands.
Is there anyway to create a shortcut to list all the Bookmarks? I am using Dwang 1.12 Rom.
I have been searching and can not find anything on how to do it. I love the ability to push an icon, it will list all the bookmarks like the bookmark widget in the Hero Rom.
Thanks
i use the live bookmarks app from the market it lets you make an icon that opens a folder with all your bookmarks. Also bookmarkBR from the market backs up and restores bookmarks.
foxtrickle said:
You should check out MyBackup on the Market. It's a free app that will backup your bookmarks (plus a lot of other things) to your SD card. It works quite well. The restore feature is also very simple.
Click to expand...
Click to collapse
Seems it is pay ware now. Any alternative?
manually changing bookmarks
short/y said:
They're stored in a database in the browser's data directory. Check http://forum.xda-developers.com/showpost.php?p=3223060&postcount=199 -- it gives you the command to use to retrieve them from the database, i.e.
sqlite3 /data/data/com.android.browser/databases/browser.db "SELECT * FROM bookmarks;"
You can also use the My Backup app (available from the Market) to back them up.
Click to expand...
Click to collapse
Thanks for the info.
I used this to bookmark a url that was a google maps redirect. I used the adb shell to get on my rooted EVO and ran these commands:
Code:
sqlite3 /data/data/com.android.browser/databases/browser.db
update bookmarks set bookmark = 1 where url = ''http://goo.gl/maps/XXXX';
This url was already in my bookmarks because I had visited it. but I couldn't bookmark it because I was immediately redirected to google maps.
To list all of your urls:
Code:
select url from bookmarks;
I'm trying to get an rss feed out of gmail with either purerss or RSSreader which are both free on the market. I'm trying to read a label on my gmail acct so I can get e-mail alerts for things I filter. Anyone have any suggestions on how to make this work or a better way of doing it?
I sent this e-mail to the people at PureRss
Hi Matthew,
Clicking on the link you supplied leads to a login page rather than an XML feed, so presumably this is the problem. PureRSS does support HTTP Digest Authentication, so if Google accepts this form of login on the feed then you may be able to get it to work that way.
Thanks,
Chris
Chris Mellish
Managing Director
Email: [email protected]
Telephone: 01256 702 444
Fax: 01256 703 335
Address: Pure Innovation, 123 High Street, Odiham, RG29 1LA
Web: http://www.pureinnovation.com/
- Hide quoted text -
I wrote:
>
> Trying to use your rss reader to read a gmail label
>
> I couldn't get it to work with http://mail.google.com/mail/atom/label
>
> Any tips I am getting the error "error: java.net socket exception: the connection was reset"
Are you trying to use your google reader or actual email? If your trying to use google reader I use Greed, its made just for google reader. There is a paid version now not sure if the free one is still on the market though.
speoples20 said:
Are you trying to use your google reader or actual email? If your trying to use google reader I use Greed, its made just for google reader. There is a paid version now not sure if the free one is still on the market though.
Click to expand...
Click to collapse
Trying to read gmail. for new messages in a label when they are set to skip the inbox, I want notifications for these so I was trying to use an rss reader to do it.
You can go to settings - Labels and there you can select which labels should be auto-synced
lilithpro said:
You can go to settings - Labels and there you can select which labels should be auto-synced
Click to expand...
Click to collapse
Yes they are auto synced but there is no notifications for e-mails that skip the inbox. I have to open gmail app and go to view labels to see if I have new messages under these labels.
Suggestion 1: If you can find out how to sync only that label using IMAP, then create a standard email account connection using that info.
Suggestion 2: Whatever filter you have set up, have it also forward to a new email address through gmail, and then add that inbox to the email client. [email protected]
Suggestion 3: Something that has been covered: http://lifehacker.com/software/gmail-tips/get-rss-feeds-from-your-gmail-labels-157701.php and then just finding an app that supports the authenticated feed, which a run through the app market leaves me empty on solutions for that.
Temp: You can also add a shortcut to the desktop that links directly to a label.
I currently use a web of softwares to organize my IT business but am overwhelmed by what I have created. There has to be something better than the mishmash of programs I am using...
My billing and invoicing is all Quickbooks.
Client contact info is all maintained in Outlook.
To Do Lists are in OneNote.
Client notes are in OneNote/Outlook
Computer Asset info is in OneNote/Visio
Im also using different services from logmein...
You can see why I am in need of advice!
I have seen spiceworks but it is more for an admin of an IT company vs a consultant with many clients and assets belonging to those clients. I have seen a host of products from advent but with so many to choose from Im not sure where to dip in.
Hey, thanks for reading this and taking anytime to reply!
Thresher said:
I currently use a web of softwares to organize my IT business but am overwhelmed by what I have created. There has to be something better than the mishmash of programs I am using...
My billing and invoicing is all Quickbooks.
Client contact info is all maintained in Outlook.
To Do Lists are in OneNote.
Client notes are in OneNote/Outlook
Computer Asset info is in OneNote/Visio
Im also using different services from logmein...
You can see why I am in need of advice!
I have seen spiceworks but it is more for an admin of an IT company vs a consultant with many clients and assets belonging to those clients. I have seen a host of products from advent but with so many to choose from Im not sure where to dip in.
Hey, thanks for reading this and taking anytime to reply!
Click to expand...
Click to collapse
Check these out.
MS Sharepoint
Citrix
GoToMyPC
GoToMeeting
Having a terminal server to remote into your network to check your notes is important.
Microsoft Exchange for emails
FTP server for files
I use notepad for everything.
I use google docs and exchange calendar and email.
A quick shameless plug... I have been writing my own app for a while now and will need some IT consulting folks to test it.
If you are interested just message me.
Hi all, I'm self employed and receive most of my work via email with the details in a pdf or doc file.
If at home I just transfer the details to calendar on my PC which syncs with my google calendar and then onto my note calendar. From the note calendar I can tap the location field and navigate to the customer with google maps and, if necessary, tap the contact number to call the customer easily while on route.
The problem is this requires manually typing the data from the document into the calendar. Easy on my PC but a pain in the butt if I'm on the road at the time.
Does anyone know of a way to automate this so I can do it easily from my note?
In summary I want to be able to get the job details into the calendar (stock at moment but not set in concrete), specifically the address into the location field and contact name and number into the description field.
Would it work if I got them to send out as a calendar invitation, I assume but don't know for sure, that they use outlook.
Sorry for the long drawn out question, I hope it makes sense. Any ideas greatly appreciated. Love using the note for my jobs but need to be able to streamline it's use when jobs come in on the road. At the moment I have to open the email, download and open the attachment, write down the details and either enter them into a diary event or type them directly into phone/navigation as appropriate. Not exactly high tech
Sent from my GT-N7000 using Tapatalk 2
cliver said:
Would it work if I got them to send out as a calendar invitation, I assume but don't know for sure, that they use outlook
Click to expand...
Click to collapse
imo the simplest solution would be if customers would send you invitations from google calendar - when accepted would automatically get into your note calendar,
Thanks p107r0,
I think it will also work if they create a diary event on their system and invit me as an atendee. In theory I then get an email invite which, if I accept it will populate my calendar.
Just messing with it myself and seems to work. I'll have to get my companies to try it out if I can convince them.
genious question, brilliant idea for an app, someone should make it
Sent from my GT-N7000 using Tapatalk 2
What if you did some sort of mashup where your clients go to a google hosted google apps page with a google spreadsheet that is acting as a form,
in this they can type the requirements.... and perhaps can select / type who they are (or perhaps type their UID which does a lookup to prevent data protection act) that has an action of add to calendar + email alert for you with the attached PDF that they select in the form?
I might have a look in to this myself as it seems kinda fun!
Edit: Found this example, that is kinda close
https://sites.google.com/site/drupa...usiness/apps-script-examples/calendar-service
Second edit
Perhaps http://www.jotform.com/ can help.
Thanks fooby, at moment I'm working on getting them to set up a calendar event and inviting me as an attendee as I think that will work with a few tweaks.
Trouble is getting them to play with me
Sent from my GT-N7000 using Tapatalk