Excel mobile & web queries - new app opp? - Touch Diamond, MDA Compact IV Themes and Apps

I would like to use Excel Mobile in my Diamond to retrieve data found on web pages - this is something I can do easily on my desktop pc, but not on Excel Mobile. Is there a workaround - ie can I save a web page as an html file that can be then read by ExcMob? Or maybe even a different spreadsheet that allows web access/data retrieval?
If neither, is this something that would interest anyone on this forum to take a look at?
Thanks
Nikos

Not sure if this is what you want but its much better than excel mobile (not freeware)....
http://www.softmaker.com/english/ofp_en.htm

Excel mobile
Thanks Omareo for the suggestion. It looks good but the site has no information on the specific feature I am looking for. Have you used it? If so, can you retrieve web data (from Yahoo for instance) on to the spreadsheet via a query?

Im really not sure about that, but you can download a trial
http://www.softmaker.com/english/ofpdemo_en.htm

Related

Web Browser

Before I start, yes I know to try searching the forums first and if thats fails search the web...I have...hence me turning to posting this
The problem is, I am looking for a smaller, faster replacement for Pocket IE. One program in particular, but I cant remember its name (hence searching for it being a problem :wink: )
Name was something like vx????? or xP????? - anyone help?
Thanks
don't know which program you're try to recall. but opera 8.6 works much better than PIE.
You were looking for ftxPbrowser. But it's not optimised for WM5 yet.
ftxPBrowser
Mobile IE sucks. ftxPBrowser works pretty well for Windows Mobile 5 on my MDA Pro. The AOL classic e-mail URL works to some degree--I can get all of my text e-mails, but I cannot get anything with a "picture"--in other words, HTML. Handango sells a program to directly connect to AOL e-mail--but it also doesn't work properly--it displays HTML messages as HTML code! And there is no reply button or back button!!
Opera works well to display Web pages, but will not access AOL e-mail at all.
So: what else is there? Surely there's got to be something better!!
transpower said:
Mobile IE sucks. ftxPBrowser works pretty well for Windows Mobile 5 on my MDA Pro. The AOL classic e-mail URL works to some degree--I can get all of my text e-mails, but I cannot get anything with a "picture"--in other words, HTML. Handango sells a program to directly connect to AOL e-mail--but it also doesn't work properly--it displays HTML messages as HTML code! And there is no reply button or back button!!
Opera works well to display Web pages, but will not access AOL e-mail at all.
So: what else is there? Surely there's got to be something better!!
Click to expand...
Click to collapse
Strange you've found ftxPBrowser usable under WM5 (read my related article on its problems under WM5.)
As far as your (and the others') other questions are concerned, read my browsing-related articles at http://www.pocketpcmag.com/blogs/index.php?cat=61 - they answer ALL your questions.
Opera Mini?
I checked your link--it's your blog. I skimmed through it and I don't see how it answers my questions. Why would Opera Mini solve the problems, if Opera [regular] would not? Have you tested Opera Mini with AOL?

Personal Homepage in PIE improved!

Sure, you can have your homepage point to google or MSN or some other site.
Wouldn't it great if you could have your own homepage where you can set your own links? Well, hell yeah. Better having to go to favourites > link... etc.
This lady created a HTM page that you can edit and set your own links.
For example on my own page I have links to google.ca, my yahoo email, HoFo, the two social groups I run, my bank's website. All the moment that PIE starts.
Excellent share...
It is easy to setup and you really do not need any HTML experience.
Cheers!
http://msexchangeteam.com/archive/2004/03/03/83349.aspx
Amazing, it's only 2 weeks ago that I was looking for something exactly like this, as it's a bit of a pain using the favourites in pie. Thanks for the link.
Bit of a pain to edit.
I use Google Bookmarks as my home page. It loads quickly and means I can access my favourites (with tags!) from anywhere. Editing it is even more easily done on my PC.
http://www.google.com/bookmarks/
Although it is good that people are coming out with more options.
You cannot compare a 2k file that pops up instantly when you start off PIE with 10-15 of your favourite links.
Going to Google Bookmarks is not as easy specially if you have tons of bookmarks. Not bad when using a Laptop but not as easy when using a PPC.
But hey, to which is own, right?
check http://mobilust.net/bookmarks via mobile. easy to signup and save you bookmarks. i use it . still needs to be improved but at least designed for mobiles.
I checked it out, promising, but if you don't mind having a small, unknown company knowing all your bookmarks.
no. i wouldn't put my bank accoutn details there lol

Fulltext search tool for Windows mobile Smartphone device (Snap)

Hi All,
do you know about a application, which can search data on my Windows Mobile Smartphone (in my case Snap)? I am using Bing and Google for online search, but I need local search on my device. For example, I would like to find all data which consist of text string Peter (mails, contacts, documents, maybe chat...). Something like Deskop Search on PC.
I have found SmartPhoneFind from SyncData (http://www.syncdata.it/), but the aplication is too old and do not have search-as-you-type funkcionality.
Thank you for help.
Matej

[Q] download gdocs spreadsheet? [SOLVED]

Seems like a simple thing, but I can't find a good solution.
I have some gdocs spreadsheets that I want to download (as xls or ods) and then edit via thinkfree. Yes I know you can do gdocs spreadsheets online via browser on my sgt. However, the gdocs spreadsheet mobile is not to my liking.
There are several Market apps that do downloading or synching of gdocs to/from android. A couple I have tried are 'my docs' and 'gdocs' but these don't support spreadsheets or I couldnt figure out how to make them do spreadsheets; they worked ok for text docs.
The online spreadsheat, on a desktop, does have a good save as feature. However, google is too smart and won't let me use the desktop experience from my sgt, even when I ask (nicely).
And, I prefer a low or no cost solution. I do see that Documents To Go suggests that you can do this; that isn't low/no cost.
Any other options?
Oh I tried think free online, too. Despite having some sort of 'login with google account' feature; I didnt see how it provides links or other techniques for getting at my gdocs. Maybe I am doing it wrong. Oh and I'd like to avoid signing up for another online service too. Besides I do shared authoring of some gdocs; no way could I get others to switch to a new online docs service.
___________
Found a solution. Reading closely the 'not suppurted browser' page, you can add an override flag (to the submitted url) that instructs the full google docs web experience to skip th browser check. By doing this, I can get the docs browser page of google docs that has a control that allows me to download my spreadsheets.
The url is like:
https://docs.google.com/DocAction?browserok=true#home
You need to add an app like 'Download all Files' so that the stock browser will save the file.
Hope this helps someone else!
use full desktop mode in your browser,
downlaod FIREFOX, and use it to download /open with think free
firefox is the only android broswer that lets me properly download/OPEN WITH by clicking on a link and I can select which app.
;-)
I think office suite pro will perfectly fit your need. After 30days of trial you can remove and re_install the app. Have Fun!

Best approach for loading website data into android app (without webview)?

Hi,
I am wondering what possible ways would be for loading a simple website into my app. My first thought is using a WebView, but I would like a dynamic app, while webview takes some time when loading between pages and links.
Is a common solution to load the html resources locally, from let say the assets folder? Than I could use AsyncTask to keep the files up to date and whenever the app starts it would load and work much quickly.
Or should I use HTTP Requests and parse the external Html document?
What would be the most situable solution for this kind of app?
Thanks,
Ved
vedtam said:
Hi,
I am wondering what possible ways would be for loading a simple website into my app. My first thought is using a WebView, but I would like a dynamic app, while webview takes some time when loading between pages and links.
Is a common solution to load the html resources locally, from let say the assets folder? Than I could use AsyncTask to keep the files up to date and whenever the app starts it would load and work much quickly.
Or should I use HTTP Requests and parse the external Html document?
What would be the most situable solution for this kind of app?
Thanks,
Ved
Click to expand...
Click to collapse
I think it's probably a decision best made by yourself. You have not said what type of data ? Cause really you should be wanting the minimal amount required. My app uses lots of data from my server for things like themes, but these come direct from SQL Database
deanwray said:
I think it's probably a decision best made by yourself. You have not said what type of data ? Cause really you should be wanting the minimal amount required. My app uses lots of data from my server for things like themes, but these come direct from SQL Database
Click to expand...
Click to collapse
Hi deanwray,
Thanks for your reply. I made some more researching and I have realised that my best bet is SQL, as you said.
Do you request data in your app directly from the online mySql database generally? I have read about a technique on downloading the data from the online database and converting it to SQLite (which is the local database on android) inside the application. This would be really cool, would really boost performance.
ved.
vedtam said:
Hi deanwray,
Thanks for your reply. I made some more researching and I have realised that my best bet is SQL, as you said.
Do you request data in your app directly from the online mySql database generally? I have read about a technique on downloading the data from the online database and converting it to SQLite (which is the local database on android) inside the application. This would be really cool, would really boost performance.
ved.
Click to expand...
Click to collapse
well my app uses a hosted database for
Online Theme Data (thumbnails store in just web space)
Settings Overrides (settings that I may have to force on the app)
Announcements ( Messages that trigger dialogs, adverts, html boxes)
Purchase info
other stuff that I forget
Any database that I access online I cache data local in cache sqlite database
So lets say the most complex things is the purchase list... a rough flow is as follows :
Get idents from online purchasable list
get descriptions and titles from idents
store local database
Simultaneous query of google IAP data from play to get locale info and pricing (along with IAP ident)
Store that in same local db
Display to user at, initial data, updated data and price additions
The database online is accessed via php (not a fan of that but hey ho, not really a programmer so there ya go) and given to the app as encoded JSON
I'm currently considering an ORM system like greenDAO or something like that...but not looked too much into it currently.
The themes database is quite good as it hold descriptions of views, shading, dimensions etc, these too are never displayed to the user from the server, but are cached local, cause failure of internet and failure of sync should not prevent any vital parts of what appears to be an offline app from working (e.g. my Smart SMS app)
Hope that helps, I could pass you the php although tis quite simple, there are security issues to look out for though
deanwray said:
well my app uses a hosted database for
Online Theme Data (thumbnails store in just web space)
Settings Overrides (settings that I may have to force on the app)
Announcements ( Messages that trigger dialogs, adverts, html boxes)
Purchase info
other stuff that I forget
Any database that I access online I cache data local in cache sqlite database
So lets say the most complex things is the purchase list... a rough flow is as follows :
Get idents from online purchasable list
get descriptions and titles from idents
store local database
Simultaneous query of google IAP data from play to get locale info and pricing (along with IAP ident)
Store that in same local db
Display to user at, initial data, updated data and price additions
The database online is accessed via php (not a fan of that but hey ho, not really a programmer so there ya go) and given to the app as encoded JSON
I'm currently considering an ORM system like greenDAO or something like that...but not looked too much into it currently.
The themes database is quite good as it hold descriptions of views, shading, dimensions etc, these too are never displayed to the user from the server, but are cached local, cause failure of internet and failure of sync should not prevent any vital parts of what appears to be an offline app from working (e.g. my Smart SMS app)
Hope that helps, I could pass you the php although tis quite simple, there are security issues to look out for though
Click to expand...
Click to collapse
Thanks for the details! It was really useful to see your workflow, I was not sure about the direction I should choose for my app development, but now is much clearer.
Thanks!
ved
Hy deanwray,
I could use a litle help, regarding the methods you have adopted for synchronising your online database with your apps local database.
I have reached a point where my database is ready, I am parsing (via JSON) data from a local xml file, and inserting it into my SQLite database. Everything works ok, but I need to get the data from my online mySql server into my app on a regular basis.
I have found threads wich mentiones the Android sync adapter, and others where people use the HTTPClient to pass data to/from the server. To be hones I am a bit confused, I would really glad if you could light me up on what would be the best approach, or what works for you the best
Thanks!!
vedtam said:
Hy deanwray,
I could use a litle help, regarding the methods you have adopted for synchronising your online database with your apps local database.
I have reached a point where my database is ready, I am parsing (via JSON) data from a local xml file, and inserting it into my SQLite database. Everything works ok, but I need to get the data from my online mySql server into my app on a regular basis.
I have found threads wich mentiones the Android sync adapter, and others where people use the HTTPClient to pass data to/from the server. To be hones I am a bit confused, I would really glad if you could light me up on what would be the best approach, or what works for you the best
Thanks!!
Click to expand...
Click to collapse
If you want do operate online database server then generally php is used.there is a tutorial on androidhive check it . you will get the answer
Sent from my GT-S5570 using XDA Premium 4 mobile app
vedtam said:
Hy deanwray,
I could use a litle help, regarding the methods you have adopted for synchronising your online database with your apps local database.
I have reached a point where my database is ready, I am parsing (via JSON) data from a local xml file, and inserting it into my SQLite database. Everything works ok, but I need to get the data from my online mySql server into my app on a regular basis.
I have found threads wich mentiones the Android sync adapter, and others where people use the HTTPClient to pass data to/from the server. To be hones I am a bit confused, I would really glad if you could light me up on what would be the best approach, or what works for you the best
Thanks!!
Click to expand...
Click to collapse
if you need a real time chat hit me up on hangouts https://plus.google.com/+DeanWray/

Categories

Resources