Excel Mobile Help - Tilt, TyTN II, MDA Vario III General

Hi guys looking for a bit of advice on mobile excel on my Kaiser, I want to be able to load a price list on to it and have a face sheet on it that allows it to be searchable (similar to MS Access)
The price list has multiple products and multiple price breaks.
Ideally I would like a drop down box that selects a product group, then a further drop down box that selects a product from the selected group and then finally enter a quantity that will display a price in an output box.
Been trying to find something suitable without success, is this possible on Mobile Excel or a similar application, anyone use or seen something like it????
Thanks in advance
Matt

Related

Cold-calling/CRM monitoring software? Free? Accessible by WM6?

I am gonna go independent soon (fingers crossed) and will need to contact say about 1000 potential clients, partners and associates. I have the contacts and know most of them, yet I need a system to log, record the main points and the ability to follow-up w/o embarassing mishaps, basically, a small CRM system.
I have never worked with a proper CRM systems, although I have made some primitive Excel or Word tables for this purpose.
Wonder if there is a decent CRM system for a small database of clients, preferably free and accesible by both PC and mobile devices. Guess this can be on a web-site hosting this kind of things (I know there are sites that allow you to have an on-line poll of groups of people, so something like this).
Anyone?
i notice that unf u didnt get a reply to this...did u find any solution? i have exactly the same issue and cant find a decent solution!?

Best FTP client (with support for SFTP/SSH)?

Seems as if there are quite a lot of FTP-clients out there.
I need one that:
1. is bug free/stable
2. is able to use SSH/sFTP (ie encrypted connections)
3. is easy to navigate even when browsing huge archives
4. supports the choice of binary or ascii transfers
Most important is simply just support for sFTP/SSH and letting the user chose between.
I run a large website so sFTP is absolutely a requirement and the whole server tends to go haywire if I transfer files in the wrong mode (ie a textfile in binary mode or a picture in ascii mode).
Any ideas?
I need this too. I'm using resco ftp for now, but i'm not very happy with it.
There's zaSFTP but it costs 20 bucks, not a lot but unless hearing some feedback on it I don't want to shell out the money. Especially not if there are freeware apps that are equal or better.
C'mon, we can't be just two people who needs FTP acess around these parts?
zasftp seems to be pretty good and has a free time limited trial. If this is for work you can surely either expense the twenty bucks or claim it as a tax deduction?
Pocket PuTTY is free (beer and speech) and zatunnel is free (beer) so you could run your ftp session through those if you know what you're doing.
I've been looking for a while now and that's about the best I can offer.
James
I'm in need of an sftp app for WM6 too. I've tried zaSFTP as a trial, but it doesn't seem to allow file-upload without paying for the full version, which seems a bit harsh.
A free app would be great, but I'd happily pay the $20 if there were perhaps some feedback on the product... but I'm struggling to find any.
for those of you who have tried zasftp could you tell me wether there is a switch for binary/ascii(text) transfers or not
(if it's "automatic" is there any filter list that you can edit to choose which extentions whould be transferred as ascii etc?)

New O2 XDA Stellar - Setup info required :)

Hi all,
Just upgraded from my O2 XDA IIi to the XDA Stellar. On my XDA IIi, I would perform a corporate install which would not install the O2 rubbish and make the device run faster. I'm not sure how I do this on the stellar.
Also, I'm looking for suggestions from gurus out here on how to ideally setup the phone so I can set it up and do a sprite backup (this used to work fine on my IIi). Any tweaks to make my stellar run faster?
I plan to install the software list as listed below, please give me your suggestions
Ilium Software eWallet v5
Ilium Software List Pro v5
SPB Pocket Plus v4.0.2
Pocket Breeze
Pocket Informant
TomTom Navigator v7
Lexisgoo Dictionary
Omega One Journal Bar (Recent reviews seem to be bad for this)
Pocket Controller v6
Opera browser
SPB GPRS Monitor
Sprite Backup (Or should I try SPB backup?)
Phone Dashboard
Resco File Explorer
Skype
SPB Mobile Shell
Pocket Mirror (Not sure if this adds any value over Active Sync)
Perhaps install some simple games like minesweeper etc.
I find it very difficult to use the case that comes supplied with the stellar, so I've decided to go in for the Crystal Case (http://www.mobilefun.co.uk/product/16042.htm). Any one has any experience with this case? I need all round protection for my phone, my one year old has a great fascination for phones. And try as I might her sneaky fingers do get to it sometimes and my XDA IIi has ended up on he floor (which has given it a crack or two ). Is it possible to attach this case to the belt with a belt clip?
Also plan to get the Sandisc 8GB SDHC card which should give me plenty of storage for my videos, music and TomTom European maps.
Any other accessories I should be looking at?
Sorry for the long post, just some useful tips from gurus here to get me started on setting up my stellar I love it so far
Forgot, I also plan to install Blackberry Connect (not sure if this already comes installed by default) so I can receive work emails. Has anyone tried this?
Anyone Any help will be greatly appreciated
From the O2 XDA Stella site
#
Before using the software, you must have subscribed to a BlackBerry tariff and your SIM must have been enabled for this service. If you are unsure, please contact O2 via the customer service number on your bill.
# 1. Make sure the Xda Stellar is connected to Activesync
# 2. Once Activesync has connected, click on the Explore button on your PC to open the Xda Stellar storage area
# 3. Insert the Applications CD into your PC
# 4. Locate the file BBConnect_WM6_Professional_BB_4[1].0.0.91.cab
# 5. Copy this file to the Xda Stellar storage area
# 6. Disconnect the Xda Stellar from your PC
# 7. On the Xda Stellar, tap Start > Programs > File explorer. This should take you straight into My documents. If not, please select this from My Device
# 8. Locate BBConnect_WM6_Professional_BB_4[1].0.0.91.cab and tap once to install
# 9. The file will now start to install. On successful installation, select OK
#
To use the BlackBerry client, tap Start > Settings > System > BlackBerry, and follow the on-screen instructions.
Click to expand...
Click to collapse
You can get the Blackberry Connect 4 update here: http://www.my-xda.com/software_updates.jsp (but it's just as easy to get it here: http://www.sems.org/entry.asp?ENTRY_ID=276 )
I'd recalled seeing various posts with people struggling with BB4 with WM6.1 so check out this post http://forum.xda-developers.com/showthread.php?t=371652 if your having problems.
Personally I gave up trying to protect my Kaiser and thankfully it has survived the many drops I've punished it with. Although the screen looks grubby, it always cleans up. It can be rather large for the pocket though in some trousers.
I personally prefer the NetFront Browser 3.5 to Opera ( which you can get here: http://www.access-company.com/products/mobile_solutions/netfrontmobile/browser/35_wm_tp.html ). I just find it more ergonomic than Opera. I'm a bit gutted that the trial ends on Aug 31st though.
I've never used Sprite backup, but you might want to check out the freely available PIMbackup 2.8 and Sashimi 7.0 http://forum.xda-developers.com/showthread.php?t=392983 which may suit your needs.
I would suggest installing the KaiserTweak and Schapp's Advanced Config ( http://forum.xda-developers.com/showthread.php?t=317070 ) programs to give yourself complete control over your device.
Regards,
Rob
Thanks Rob, really helpful. I've never heard of the blackberry tariff, is this different from the normal tariffs that O2 offers?
I'll have a look at the other software you mentioned and give them a try
I've put a screen protector on my phone, so hopefully the screen should stay free of scratches. It is the sides of the phone I'm concerned about since from experience with my XDA IIi, it seems to fall on the side and the case has cracked in a couple of places (still works fine though) and it breaks my heart to think it could happen to a shiny new phone
Thanks again, really good stuff
fmervin said:
Thanks Rob, really helpful. I've never heard of the blackberry tariff, is this different from the normal tariffs that O2 offers?
Thanks again, really good stuff
Click to expand...
Click to collapse
It may be something to do with users that want blackberry style facilities through O2 rather than their own corporate server so you can safely ignore that comment?
However....I have seen Vodafone with different tariff's for Windows mobile phones and blackberry before.
Your welcome by the way.
Rob
rfarnell said:
I personally prefer the NetFront Browser 3.5 to Opera ( which you can get here: http://www.access-company.com/products/mobile_solutions/netfrontmobile/browser/35_wm_tp.html ). I just find it more ergonomic than Opera. I'm a bit gutted that the trial ends on Aug 31st though.
Click to expand...
Click to collapse
Yes I just visited their site and found out that the free trial ends on 31st of August, they don't seem to have a license I could purchase and make use of.
rfarnell said:
From the O2 XDA Stella site
Personally I gave up trying to protect my Kaiser and thankfully it has survived the many drops I've punished it with. Although the screen looks grubby, it always cleans up. It can be rather large for the pocket though in some trousers.
Click to expand...
Click to collapse
Out of interest, how do you carry your phone? Do you use the supplied case or just carry it in your trousers? Working in IT I mostly dress up in jeans and the stellar is definitely too bulky for them Still waiting for the protective hard cover case to arrive, not sure if I've got butter fingers or I've been too finnicky about not dropping it, but I've already managed to drop it twice, luckily on carpets so far
rfarnell said:
It may be something to do with users that want blackberry style facilities through O2 rather than their own corporate server so you can safely ignore that comment?
However....I have seen Vodafone with different tariff's for Windows mobile phones and blackberry before.
Click to expand...
Click to collapse
I spoke to my systems department and they reckon that I might need to enable blackberry services on my SIM and they don't think that is available for personal users. Might need to have a chat with O2 and see if they can offer that to me
Thanks for all the help
if you have a blackbery then anyone on a contract can get the blackbery bolton, its £7.50 per month extra and provides you with unlimited usage(fair use).
the only thing is it needs to be used on a blackberry not a xda or any other phone for that matter due to the fact that blackberrys go through a different portal to get to the net or emails.
for the xda or any other type of handset exc blackberry its best to put on the unlimited web bolton for £7.50 per month this gives you unlimited web(200mb i think) only on the handset not to be used as a modem for laptop etc.the connect software will just connect through the mobileweb apn.
when a blackberry connects it goes through blackberys own apn,when you click home on a blackberry it takes you to the blackberry wap site i think.

Barcode scanner :: Android Webbrowser

Hi,
Today when I ordered my flight tickets i got a SMS with a link to see flight-information. In the browser i also got a "barcode" (QR/DR code? Im not sure).
I have tried the Marked to find an application to scan this code directly from my Android Webbrowser, but I cant find any. (Its pretty hard to use my phone cam to scan my phone screen )
Does anyone knows how?
Forward the SMS to your email account, check your email on a PC, scan the barcode from there
Hmmm, isnt there any barcode scanner that could read from the phone-display? :-((
Dont understand why WAP pages uses this kind of content if the cellphones arent able to use it straight from the phone-webbrowser?
- Kind of irritating that you have to lunch the wap page in a PC-browser and than scan the barcode. I doesnt always have my computer with me, and the reason why im using Andorid- and/or WM-OS, is just because that I could use my phone as a substitute for my computer when I dont have it around.
Tried your solution with "Barcode Scanner", but it didnt reconize it?? Maybe I have to use another type of scanner/app?
Here is the barcode (added the red line because the barcode have personal information)
Er, I was just suggesting a workaround until you found something that worked like you specified
Your QR code looks weird anyway, they usually have boxes in 3 of the corners.
Example
Its seems like my QR Code has one box only - and thats in the middle. Isn' it a QR Code maby?
Looks like the code is a DM Code: Example
nukleuzN said:
Looks like the code is a DM Code: Example
Click to expand...
Click to collapse
It's neither a QR code nor a DM code. I don't know the specific name of it, but the picture you provided above is a new bar code that, as far as I know, is only used for paperless boarding passes. I don't know about internationally, but here in the US, it's currently only available at a few dozen airports while the system is being tested. I've used it flying out of both Newark, NJ (EWR) and Atlanta, GA (ATL).
It's a special 2D barcode that contains encrypted information about your flight information, as well as some personal information to identify you. It is specifically designed to be secure so that only the TSA and the airlines can decode the information. Most likely, the reason you received it was not so that you could scan it to get information about your ticket, but so that the TSA could scan it at security and the airline could scan it at the gate. Ideally, you wouldn't then need to print out a paper boarding pass, all you would need is your phone! (I say ideally, because since it's a brand new program, not everybody's really familiar with it yet, and you get some funny looks from the gate agents sometimes!)

few problems, user fixable or need to wait for update?

Love Windows Phone 7, don't really love the hardware quality of the HD7. There are a few software issue that I am hoping are user fixable and not something I have to wait for an update to address.
1. Search button behavior in Internet Explorer - it irritates me immensely that when you hit the search button on the HD7, it brings up the Google desktop website. Similarly if you enter text in the address bar it searches Google, not Bing. If I wanted to use Google, I'd have kept my Android device. Is there a way to change this yet, and set the T-Mobile USA HD7 to default to the Bing app and not the Google website? Its especially annoying because the results bring you to mobile formatted pages.
2. This is more of a complaint than a fixable issue until copy and paste comes, but I have noticed that the text type recognition doesn't work all the time. In some places if I click an address it goes to Bing Maps but other times it does nothing, it looks like it highlights the word I touch. I haven't been able to find any pattern in which sites work and which don't, but its frustrating.
3. Sometimes when I get a text message the notification sound plays all choppy. It does seem to happen only where service is bad. Is there a fix for this?
4. Office and Skydrive. Maybe I am just retarded but I feel like there should be a way to access my Office files online, specifically through SkyDrive since I can save to it from Office on the computer. Do I have to have a Sharepoint server to do this? Can I really not access my SkyDrive files?
If I remember more I will post.
Also, is there an ETA for Flash?
I have been playing with the skydrive and I added a few files to it to try and see if I could open them on the HD7. The thing is I can open them but have yet to figure out how to open them with Word on the HD7 so that I can edit them and save them back to the skydrive(copy & paste would be nice...meh...soon I hope). But I opened IE and logged into my Windows Live account and I can open anything I have saved on the skydrive, PDFs, word files, excel sheets, ppt presentation, pictures, etc. Now the only issue is editing those files, I haven't tried sending files Word, Excel, etc. to the skydrive and trying to open them on my PC. Will update later with results of further tinkering.
My issues with HD7
Like many people I love this phone but coming from Windows Mobile 6.5 and donw (isn't that weird to say), this phone is really lacking.
1) The Zune software is crap for lack of a better word. No Smart DJ; No Artist photos; no random track play etc. These are not deal breakers but if you came from the Zune HD like me then you'll feel let down.
2) Font Size. It might just be me, but not being able to set a minimal font size is ridiculous. I use the word ridiculous because even my first pocket Pc phone edition in 2001 allowed font resize.
3) No ability to sync my desktop mobile favs. Yes! I know of the work around but wasn't the point of the new OS to avoid all that crap.
4) I want to be able to sync with my local address book. This whole facebook and windows live thing . . . .Look at it this way, if your contacts are based through FB then if one of those contacts cancels their FB acct then you automatically loose all that data. Of course this is not a MS thing.
4) With my HD2 and HTC Sense, I was used to seeing ALL my FB contact photos. Again not an MS thing but . . . .
5) This is really more of a gripe than anything but the battery icon doesn't tell much.How come I can't see exactly how much juice I have left.
6) Unified Inbox, flash, cut and paste. These are all things MS was kind enough to make us aware off so they get a pass on those.
Where is the File Explorer?
c0wb0ycliche said:
Love Windows Phone 7, don't really love the hardware quality of the HD7. There are a few software issue that I am hoping are user fixable and not something I have to wait for an update to address.
1. Search button behavior in Internet Explorer - it irritates me immensely that when you hit the search button on the HD7, it brings up the Google desktop website. Similarly if you enter text in the address bar it searches Google, not Bing. If I wanted to use Google, I'd have kept my Android device. Is there a way to change this yet, and set the T-Mobile USA HD7 to default to the Bing app and not the Google website? Its especially annoying because the results bring you to mobile formatted pages.
2. This is more of a complaint than a fixable issue until copy and paste comes, but I have noticed that the text type recognition doesn't work all the time. In some places if I click an address it goes to Bing Maps but other times it does nothing, it looks like it highlights the word I touch. I haven't been able to find any pattern in which sites work and which don't, but its frustrating.
3. Sometimes when I get a text message the notification sound plays all choppy. It does seem to happen only where service is bad. Is there a fix for this?
4. Office and Skydrive. Maybe I am just retarded but I feel like there should be a way to access my Office files online, specifically through SkyDrive since I can save to it from Office on the computer. Do I have to have a Sharepoint server to do this? Can I really not access my SkyDrive files?
If I remember more I will post.
Also, is there an ETA for Flash?
Click to expand...
Click to collapse
1. Apparently carriers can change the search engine within Internet Explorer, and we can't do anything about it. Once someone gets access to editing the registry, maybe we will be able to change that. BUT I do have some help for you: Search something in Google, and then scroll down to the bottom, find the "Settings" link. Then you can change it to NOT format sites for mobile phones. That should make the experience better!
2. Addresses have to be in a certain format: #### N Street Rd, Zip Code. Like this address, 6362 N Calle Campeche, 85750. If it doesn't have the zip code after the street, it sadly doesn't recognize it. Hopefully they fix that, it's a great feature otherwise.
3. Idk, never had that happen.
4. You can access your Skydrive files and download them to your phone by going to the SkyDrive website (they have a mobile version), but you can't upload any documents from your phone or upload the changes you make in a doc you download. It has been rumored that SkyDrive integration will be implemented at some point.
alabij said:
My issues with HD7
Like many people I love this phone but coming from Windows Mobile 6.5 and donw (isn't that weird to say), this phone is really lacking.
1) The Zune software is crap for lack of a better word. No Smart DJ; No Artist photos; no random track play etc. These are not deal breakers but if you came from the Zune HD like me then you'll feel let down.
2) Font Size. It might just be me, but not being able to set a minimal font size is ridiculous. I use the word ridiculous because even my first pocket Pc phone edition in 2001 allowed font resize.
3) No ability to sync my desktop mobile favs. Yes! I know of the work around but wasn't the point of the new OS to avoid all that crap.
4) I want to be able to sync with my local address book. This whole facebook and windows live thing . . . .Look at it this way, if your contacts are based through FB then if one of those contacts cancels their FB acct then you automatically loose all that data. Of course this is not a MS thing.
4) With my HD2 and HTC Sense, I was used to seeing ALL my FB contact photos. Again not an MS thing but . . . .
5) This is really more of a gripe than anything but the battery icon doesn't tell much.How come I can't see exactly how much juice I have left.
6) Unified Inbox, flash, cut and paste. These are all things MS was kind enough to make us aware off so they get a pass on those.
Where is the File Explorer?
Click to expand...
Click to collapse
1. Yeah, I miss SmartDJ too. I never looked at an artist's pictures however. Their picture does load as a background image, but I know that's not what you're referring to. By random track playing, you mean Shuffle? In the now playing screen, tap on the album art, and then click the shuffle icon.
2. Font size depends on the user of course. I'm good with it as it is, but they should have made an option to change it. Maybe a future update.
3. Eh yeah. I don't use favorites honestly
4. You mean how the HTC Album app in WinMo could access all of your friends online Facebook photo albums, right from their contact card? Yeah I loveeeed that in HTC Sense. I was really disappointed when my WP7 didn't have something like that.
4.2. Umm, if a friend cancels their Facebook account, you don't loose anything that you stored yourself. Just add a contact's info into your Windows Live contacts, it will never disappear.
5. Maybe someone will write a battery percentage app. Idk.
6. I personally can't wait for copy/paste!
7. Microsoft made it decetly clear months ago that there wouldn't be a file explorer.
Thanks for the tips, and I'm really hoping someone figures out how to change the search option. It's annoying when my bosses WP7 (HTC Surround) pulls up the bing app in IE, and mine goes to the Google site. You can remove all carrier and manufacture apps (1 step forward) but can't choose your default internet search while your carrier can (2 steps back.)
Hardware wise, the issues I have are these:
After a couple days, the back and battery color have some discoloration. I don't have particularly dirty or clammy hands, so I don't know why this is. It weirdly also doesn't look like where my fingers actually are, so maybe it's heat related. I've seen similar issues on the Touch Pro and the G2. I think it has something to do with the soft touch material.
There is also a gap between the two pieces of the battery cover. This I have seen on literally every unit I've touched. Mine, my boyfriends, the demo unit at T-Mobile, and the ones at Best Buy.
Likewise, if you press search a little hard, you see like a ripple in the bottom right hand corner. This also was on every device I played with, so it's a general thing.
These things, for me at least, aren't deal breakers, but they are annoying, especially compared to the absolutely astounding build quality of the HD2.
...
anyway.
All of this stuff aside, I must say, my actual general usage experience with the device (again, more WP7 than the HD7 specifically) has been honestly, wonderful.
I've found that in my experience,true to Microsoft's goal, everything just works, and works quickly. Coming from Android (recently, after the HD2 I just couldn't deal with WM6.5) and having had every phone in between (iPhone, Palm Pre, a crap ton of Android phones, even a Symbian phone) I must say that I have had the fewest problems, and most fluid experience of all, on WP7. General usage stuff like calls, texts, e-mail, web browsing, social networking etc. are all just super fast and efficient (with maybe the only exception being Facebook's annoying load time, but its not horribly necessary with the "what's new" section in People. Also, despite some issues (like it taking me a week to realize you can click on the song list under now playing) the media and gaming is hands down the best I've had on a phone.
Ugh, is the T-Mobile HD7 locked into Google?
I thought the whole idea of the Search button was to get quick access to the Bing Search Application. Is this so or is it only the search in IE?
Hoping they'll add a way to change that ASAP.
Jonno2343 said:
Ugh, is the T-Mobile HD7 locked into Google?
I thought the whole idea of the Search button was to get quick access to the Bing Search Application. Is this so or is it only the search in IE?
Hoping they'll add a way to change that ASAP.
Click to expand...
Click to collapse
Only in IE. Press Search from the start screen and it'll work like you expect (opening Bing)
Jonno2343 said:
Ugh, is the T-Mobile HD7 locked into Google?
I thought the whole idea of the Search button was to get quick access to the Bing Search Application. Is this so or is it only the search in IE?
Hoping they'll add a way to change that ASAP.
Click to expand...
Click to collapse
The T-Mobile US variant of the HD7 works like this, in all places other than a) Internet Explorer or b) app that override the search button (like contacts) when you press the search key it bring up Bing. When in IE, it goes to google.com. When in an app with an override, it searches within that app.
c0wb0ycliche said:
The T-Mobile US variant of the HD7 works like this, in all places other than a) Internet Explorer or b) app that override the search button (like contacts) when you press the search key it bring up Bing. When in IE, it goes to google.com. When in an app with an override, it searches within that app.
Click to expand...
Click to collapse
About your part B... that's how the search button is supposed to work, Windows Phone was designed like that. The T-Mobile USA HD7 is only different than other phones in part A.
as a few more days have passed, I also noticed that sometimes the Marketplace will lock up. The phone doesn't, I can still go back to the start screen, use all other apps etc, but when I go into Marketplace again it says loading and then goes back into to start unless I restart the device. Not a big deal, not too common, but still a bug. I think its related to the small freezes while browsing apps when it's loading the icons.
To clarify, you can upload and save your changes to SkyDrive. Simply tap down at the application settings and select synchronize. That will sync any changes with SkyDrive.
Sent from my HD7 using Board Express
Edit: it just works with OneNote.
But I think if you download excel doc from SkyDrive and make changes it will sync with SkyDrive?
Sent from my HD7 using Board Express
c0wb0ycliche said:
as a few more days have passed, I also noticed that sometimes the Marketplace will lock up. The phone doesn't, I can still go back to the start screen, use all other apps etc, but when I go into Marketplace again it says loading and then goes back into to start unless I restart the device. Not a big deal, not too common, but still a bug. I think its related to the small freezes while browsing apps when it's loading the icons.
Click to expand...
Click to collapse
Yep, that's a problem with just about everyone that has an HTC phone. I'm not sure if it affects Samsung and LG too, but I wouldn't be surprised if it does too.

Categories

Resources