Related
I have a new project I'm working on for an application that allows me to do quick checks on server availability from my AT&T Tilt. This is the first version of the software and I'm looking for suggestions on improvements, bugs, etc. The software has been tested on Windows Mobile 5, 6, and 6.1. More information available at http://www.liquidcaffeine.net/downloads/am2008f.htm
The application is available in a PC Installer version as well as a CAB file and is posted at:
http://www.liquidcaffeine.net/downloads/AlertMe2008FWE.zip (PC Installer)
and
http://www.liquidcaffeine.net/downloads/AlertMe2008FWE.CAB (The CAB installer also requires the OpenNETCF to be installed as well (http://www.opennetcf.com)
Point release update includes:
o Log Viewer Tab (see new screen capture)
o Option to email log (note - this requires Pocket Outlook to be configured with an account)
Please post any suggestions you may have.
Looks good I'll have a look at it and test it our servers.
Thanks
G
Yea looks really promising I'll give it a shot too. Something to do in my meetings.
its nice to see apps that cater to webmasters.. something ppc's lack. im *trying* to cook some sftp+ssh app myself.
i think a cool feature in your app would be to schedule automatic checks on the site ever X minute with status/log info. perhaps even an audio/visual alert option that notifies you when it's offline.
i see this checks for http, but does it check for the right http 200 code? reason i ask, is sometimes a website http can be "online" but throwing out http error, which should report back as "offline/problem"
tft said:
its nice to see apps that cater to webmasters.. something ppc's lack. im *trying* to cook some sftp+ssh app myself.
i think a cool feature in your app would be to schedule automatic checks on the site ever X minute with status/log info. perhaps even an audio/visual alert option that notifies you when it's offline.
i see this checks for http, but does it check for the right http 200 code? reason i ask, is sometimes a website http can be "online" but throwing out http error, which should report back as "offline/problem"
Click to expand...
Click to collapse
Initially this was meant to be a scheduled application. This release was to test viability. As soon as I can dig up the details on how to schedule the application, I'll release the point release with this feature.
I'll look at adding the parsing of the response to check for the 200 code. There is a log file that gets generated, and I will be adding a menu function to both view and email the log.
Download
The download link is asking for username and password...
Thanks,
Scott
Sorry about that
ZeroData said:
The download link is asking for username and password...
Thanks,
Scott
Click to expand...
Click to collapse
Gotta love Windows Permission settings - ugh. The downloads shoudl be working now.
Point release Available
The new version allows for viewing of the log file more than anything else. Also, both the CAB and PC installers include the required OpenNETCF CAB, so things are cleaner on the install.
The emailing of the log file requires a Pocket Outlook account to be setup. I have only tested this with an Exchange server setup, so anyone running IMAP/POP/etc, let me know if it works. It should default to the first email setting in POutlook.
Next version should hopefully have the scheduling ability.
You said you're working on implementing a periodical checker.
Good. Better yet is SMS on error, or E-Mail on error (or both.) and option to play audible alert.
That way you could SMS yourself to grab your attention, or just use the built-in feature to play a sound. You could also have it E-Mail someone in your organization or perhaps your data center (with a predefinable template no doubt!) that the server is off line.
I work at a datacenter as a sysadmin, and I do think these features could go to good use.
jon_k said:
You said you're working on implementing a periodical checker.
Good. Better yet is SMS on error, or E-Mail on error (or both.) and option to play audible alert.
That way you could SMS yourself to grab your attention, or just use the built-in feature to play a sound. You could also have it E-Mail someone in your organization or perhaps your data center (with a predefinable template no doubt!) that the server is off line.
I work at a datacenter as a sysadmin, and I do think these features could go to good use.
Click to expand...
Click to collapse
Yep. As soon as I get the scheduling piece down, then the fun begins. At that point, failures will be alerted via a choice of alarms (siren type MP3s requested <G>), vibration & SMS/MMS/Email.
I also want to do as the poster above suggested and actually parse the results for other, discrete errors (ie: Web server is online, but a 404 is received).
Also, if possible, color coding the log as well.
SQL Server CE or XML?
Got the scheduling portion down and now have a question for folks who would use the app.
Which would you prefer, the use of SQL Server CF or just a local XML file to store the list of servers and ports to scan?
I can see benefits of both, but would like your feedback.
I'm downloading it right now and will give it a try. As a Linux system administrator, I would urge you to avoid using a vendor specific file format for anything. Go with xml. Any administrator who can't deal with that should seek a new line of work, anyway.
"This application requires a newer version of the Microsoft .NET Compact Framework than the version installed on this device."
ogremagi said:
I'm downloading it right now and will give it a try. As a Linux system administrator, I would urge you to avoid using a vendor specific file format for anything. Go with xml. Any administrator who can't deal with that should seek a new line of work, anyway.
Click to expand...
Click to collapse
ogremagi said:
"This application requires a newer version of the Microsoft .NET Compact Framework than the version installed on this device."
Click to expand...
Click to collapse
Ah-hem, What ROM are you using, You might try to update to the newest NetCF
Apparently, The CAB installer also requires the OpenNETCF to be installed as well (http://www.opennetcf.com)
I tracked down the package I needed from Microsoft and now AlertMe is working. It seems a small but useful tool, though definitely not a replacement for Nagios.
The immediate thing I noticed is it doesn't remember the checkboxes selected when you pick the domain/ip from the history. That would be a nice little feature.
Looks nice. I haven't downloaded it yet, but on the second screenshot tab can you add a "custom" option to put in a port that isn't listed?
ogremagi said:
I tracked down the package I needed from Microsoft and now AlertMe is working. It seems a small but useful tool, though definitely not a replacement for Nagios.
The immediate thing I noticed is it doesn't remember the checkboxes selected when you pick the domain/ip from the history. That would be a nice little feature.
Click to expand...
Click to collapse
I'm adding a scheduling feature at the moment that will allow for the system to run at defined to monitor selected ports.
bengalih said:
Looks nice. I haven't downloaded it yet, but on the second screenshot tab can you add a "custom" option to put in a port that isn't listed?
Click to expand...
Click to collapse
Duh - don't know why I didn't think of that. It will be added to the next release. I'm fighting off a bout of bronchitis at the moment, but hopefully the next release will be in a week or so and include this along with the scheduling.
ogremagi said:
I'm downloading it right now and will give it a try. As a Linux system administrator, I would urge you to avoid using a vendor specific file format for anything. Go with xml. Any administrator who can't deal with that should seek a new line of work, anyway.
Click to expand...
Click to collapse
XML is the easier way to go. This should also allow you to bull the "jobs.xml" over to a PC for easier editing. Then push it back to the device.
did you foillow up with more developements such scheduling and alerts?
I looked at the website but it didn't seem to have een updated...
Can anyone recommend a person who could write an excel based program that could be copied to a WM devise? I am new to this forum and do not have the knowledge or the time to develop the program, but i am willing to pay for it.
Thanks
notthatcreative said:
Can anyone recommend a person who could write an excel based program that could be copied to a WM devise? I am new to this forum and do not have the knowledge or the time to develop the program, but i am willing to pay for it.
Thanks
Click to expand...
Click to collapse
Why not install office on your mobile. http://forum.xda-developers.com/showthread.php?t=310832
Or flash a ROM with office installed, most do
Ta
Dave
I agree, both are a great solution, but this project is not for myself. This project is more for job. This board has given me an idea for my customers, which do not own a Tilt. If this excel file was turned into a .cab file, my customers could add it to their PDA devise.
I'm not that familiar with program creation within a WM devise, but after lurking around this board for the past 6-9 months, I thought someone would know!
This is not a tilt specific CAB. It's a Window Mobile 6 version it cab go on WM6 any device.
Ta
Dave
I believe what you are saying is that a .cab can be installed on any WM devise. I agree. What i need to do is create the .cab file.
Yes you are correct. CAB files can go on any device.
I'm still unsure on what your requirements are. Do you want a copy of Excel to install on WM6 devices, then that's what I posted first time round? Nearly all standard WM and PDA's have a version of office installed, anyway.
Or, are you wanting a program like Excel Mobile but with "extra" features.
I think you need explain what your requirements are (without giving too much away, if you don't want to), so we can build a better picture of what you want.
Dave
You raise excellent questions as i'm not sure what is available. Unfortunatly, i cannot speak the language of this forum very well and am unsure of options available.
Currently, i have an excel spreadsheet with the calculations complete, but was unsure of how to create an "engine" to drive the program if the end user did not have excel available. This excel file i've created uses basic calculations which produce a number generated by data entered by end user. I am assuming an engine, or what i call a "cab" file is required!?!
Also, I'm not married to the idea of using excel and am open to using other programs if nessesary.
Am i making things a little clearer?
Thanks
like daveshaw said, most wm devices already come with excel in it. and if your customer does not have excel on their devices, then they can install it using the cab files
It sounds to me like you want to take a specific spreadsheet that was created using Excel, and somehow compile it as a program that doesn't need Excel to run. I don't think this is possible. You can't drive a car without its engine.
If you really wanted to pursue that route, I think what you'd need is someone who can dissect and analyze your spreadsheet, and rewrite it in another language (like C++ ), which can be compiled into a self-contained, executable file. Wish I could help you there.
I think your only realistic option is to install Excel on all the WM devices.
sensei909 said:
It sounds to me like you want to take a specific spreadsheet that was created using Excel, and somehow compile it as a program that doesn't need Excel to run. I don't think this is possible. You can't drive a car without its engine.
If you really wanted to pursue that route, I think what you'd need is someone who can dissect and analyze your spreadsheet, and rewrite it in another language (like C++ ), which can be compiled into a self-contained, executable file. Wish I could help you there.
I think your only realistic option is to install Excel on all the WM devices.
Click to expand...
Click to collapse
Everyone, thanks for you help. Sensei909 has figured me out. It sounds like i need someone to who can rewrite this in another language. Can anyone point me in that direction....Website, company, friend???
Re:
Hello, few questions:
1) What devices will your customers use?
2) If they are Windows Mobile-based, what versions are here?
3) Do you have Excel Mobile on your Tilt?
4) Did you try to open your spreadsheet using your Excel Mobile?
5) If your spreadsheet is created using Excel 2007 on desktop, did you install Office Mobile 6.1 from Microsoft site?
Build a java midlet? Almost all phones have java. I can see it doing basic calculations very easily.
Here we go:
I use a number of Microsoft Access Databases for my work, and each one is intensely coded and designed and basically run like actual programs. What I am looking for is to be able to take these databases with me. Now understanding that Microsoft and Android are two completely different beasts, what I really am looking for is the ability to take the tables (I use all Back-end database so all my tables are in a completely separate file then all my forms, queries, and reports) and the data with me and be able to run them in a program on Android that keeps the relationships and fields and all of that sort of stuff.
Now what would be great is the ability to use forms (even if special forms for android need to be made), run queries, and even be able to run reports and print as PDFs.
now I know how to code in VBA, hence the extensive coding I have done in Access, so anybody willing to WORK WITH in creating an Android Program to basically be an extension of Microsoft Access please contact me. Please not I use the words WORK WITH loosely, while I am trying to learn how to Program for Android, I currently do not have a computer that I can use to develop programs for android on, and well I would be only able to create the "Hello World" starter program and this project seems a slight bit more complicated. But what I can bring to the table is real world experience in testing and using the program day in and day out, a number of already existing Microsoft Access Databases ranging from Complex to Simple that I use every day. Really a program that can run Microsoft Access Tables on Android would be really useful to me and I am willing to do anything to help make this happen.
kronos82 said:
Here we go:
I use a number of Microsoft Access Databases for my work, and each one is intensely coded and designed and basically run like actual programs. What I am looking for is to be able to take these databases with me. Now understanding that Microsoft and Android are two completely different beasts, what I really am looking for is the ability to take the tables (I use all Back-end database so all my tables are in a completely separate file then all my forms, queries, and reports) and the data with me and be able to run them in a program on Android that keeps the relationships and fields and all of that sort of stuff.
Now what would be great is the ability to use forms (even if special forms for android need to be made), run queries, and even be able to run reports and print as PDFs.
now I know how to code in VBA, hence the extensive coding I have done in Access, so anybody willing to WORK WITH in creating an Android Program to basically be an extension of Microsoft Access please contact me. Please not I use the words WORK WITH loosely, while I am trying to learn how to Program for Android, I currently do not have a computer that I can use to develop programs for android on, and well I would be only able to create the "Hello World" starter program and this project seems a slight bit more complicated. But what I can bring to the table is real world experience in testing and using the program day in and day out, a number of already existing Microsoft Access Databases ranging from Complex to Simple that I use every day. Really a program that can run Microsoft Access Tables on Android would be really useful to me and I am willing to do anything to help make this happen.
Click to expand...
Click to collapse
I think we must have the same job
Android utilizes an sqlite database engine and it looks like sqlite already offers a conversion utility HERE. The real question would be how to get the data in and out of the phone. Regarding forms, they definitely would need to be custom built.
Thanks this is deffenetly a start, From what I can tell this This Looks to be the most promising, It looks like all you would have to do is put a MS Access Database file on your SD CARD and have a program access it. That way you copy it back and forth. Unfortunately it doesn't support Access 2003, but I can save down. I also got a lot of learning to do in programing Java programs.
Forms would be as simply as making a program, this is great thanks much
kronos82 said:
Here we go:
I use a number of Microsoft Access Databases for my work, and each one is intensely coded and designed and basically run like actual programs. What I am looking for is to be able to take these databases with me....
Click to expand...
Click to collapse
I would like to say, "yes, please!" to this idea. I currently use Smart List to Go (the descendant of ThinkDB) on my Palm TX. The TX is dying, and I've been shopping for a replacement. HanDBase exists for the iPhone, but I don't want an iPhone. So I've been focused on WinMo - not by choice as much as by necessity.
And android option would be very welcome around my computers.
benmyers2941 said:
I think we must have the same job
Android utilizes an sqlite database engine and it looks like sqlite already offers a conversion utility HERE. The real question would be how to get the data in and out of the phone. Regarding forms, they definitely would need to be custom built.
Click to expand...
Click to collapse
androids sqlite its for applications to access and store data using java code.
try the pocket office app
Freedomcaller said:
androids sqlite its for applications to access and store data using java code.
try the pocket office app
Click to expand...
Click to collapse
Exactly and we're talking about creating an app that would enable manipulation of an sqlite database. Essentially all that would be needed would be to create a ui framework wrapper for the existing api in android. Not the least monumental task I've heard of an individual taking on but not the most either.
The versions of pocket office that I've seen for android do not currently support Access databases as far as I'm aware. If I'm wrong could you post a link and save everyone some trouble?
aaaaaaaaaaaaaaaaaaa
kronos82 said:
Thanks this is deffenetly a start, From what I can tell this looks to be the most promising, It looks like all you would have to do is put a MS Access Database file on your SD CARD and have a program access it. That way you copy it back and forth. Unfortunately it doesn't support Access 2003, but I can save down. I also got a lot of learning to do in programing Java programs.
Click to expand...
Click to collapse
Jackcess library is now patched to support android (will be in 1.2.2 release). Also seems to support 2000, 2003 and 2007 formats now.
Works great for me.
View jackcess site. Couldn't find anything on support for android. I'm using htc desire and would really like to find program to view ms access file. Can you tell me how you do it?
As I remember reading worked as on PC, while writing had some problems.
This forum prevents me from linking directly, but if you click tracker/patches on Jackcess project, check Android Compatibility Fix - ID: 3101578
The changes are in trunk and will be in the 1.2.2 release. I've added some
notes which will eventually make it to the FAQ page on the website
detailing the compatibility steps:
- Set the system property "com.healthmarketscience.jackcess.broken
Nio=true"
- Set the system property "com.healthmarketscience.jackcess.resour
cePath=res/raw/"
- Copy the *.txt, *.mdb, and *.accdb files from the
"com/healthmarketscience/jackcess/" directory in the Jackcess jar to the
"/res/raw" Android application directory.
- Before executing any Jackcess code, set the current Thread's context
classloader, e.g.
"Thread.currentThread().setContextClassLoader(Database.class.getClassLoader())".
Click to expand...
Click to collapse
Until this version (1.2.2) is released you need to build lib yourself.
You also need commons-lang and commons-logging from apache commons.
Before you use Jackcess in Android code, you set
Thread.currentThread().setContextClassLoader(
getClass().getClassLoader());
System.setProperty(
"com.healthmarketscience.jackcess.brokenNio",
"true");
System.setProperty(
"com.healthmarketscience.jackcess.resourcePath",
"res/raw/");
Click to expand...
Click to collapse
and copy those resource files to res/raw
Then you can work as on PC, for example open /sdcard/yourprogram/file.mdb
Jackcess has no GUI, it's a library to read/write access files.
Getting an Access file into Android
I keep a lot of information on a Psion Revo, which has just turned its face to the wall and is giving up the ghost, and have always backed the information up on to my pc as an Access file. It looks easier to get this into a format acceptable to Android by converting the Access .mbx file into an Excel .xls file. This can be searched readily by Column and Values. Maybe this deals with too simple a need for most enquirers to the forum, but if it helps somebody then so much the better.
hi all i have beenlooking for something the same for some time now and just the other day i came accross this site cellica.com
the android app is free and the desktop application has a 5 day trial period or its $50 to buy it works great the only thing you can not do is create a report from the phone
i have emailed support team and they said they will be adding it on in the future.
Any Updates???
I currently build and use databases in MS Access and was wondering if there are any updates on this topic now that Tablets are in use now. Looking to get the Motorola Xoom (2nd version) in the future, but would love to be able to use a program that I would be able to access my MS Access databases while "on-the-go".
Anyone? This would be huge (I believe), since we now have tablets.
Thanks a bunch,
~Kilch~
Access to MS Access by Android
Hi,
I'm also looking to get on-the-go access to my Access databases on my Android HTC Tattoo.
The file is on it, I just need a tool to access it in read-only / search mode, but judging from the previous comments, there doesn't seem to be an oversupply in applications.
The "convert to Excel format" may be OK for me. I want to use a 3 language Access DB (dictionary) on my phone, so I'll try the Excel solution.
It would be nice if we had an ACCESS reader though...
John
Panacea Database
I know XDA frowns upon excessively hawking your own products here, but I do seem to be directly answering more than one of the reply questions, it just happens that the answer is an application my company released.
The Panacea Database application can handle Access from Access 2000 to Access 2007. It has also worked so far on every Access 2010 database we've tested, and we've received no complaints in that department yet. We release updates from time to time as we improve its functionality and features, often guided in our priorities by user e-mail and market comments. Our next update will be focused on improving screen layout for a variety of Android devices - from small QVGA smartphones, to large WXGA tablets. After that we may move onto other functionality.
In the interest of fairness, I'll point out arafa1209's post. He mentions Celicca Database, which is the only other application that I know of that deals with Access databases on Android. It has features Panacea does not have (yet) - ability to work with forms, ability to create and modify databases, ability to connect to your PC etc. Like us, they also send out updates improving their app regularly. So you can compare the apps, and use which one fits your needs better (or use both). If anyone knows of any others they can post here as well, but these are the only two I know of currently.
Just tried Panacea. Although it is more basic and annoyingly doesn't remember the last files you'be opened necessitating finding the file each time you open the app I prefer it for the simple reason you don't have to convert the Access database to another format.
amwebby said:
doesn't remember the last files you'be opened necessitating finding the file each time you open the app
Click to expand...
Click to collapse
If you update the app, this should be fixed, the last version should have this feature.
Got the update last week. Certainly goes a long way to making it more user-friendly. Keep up the great work!
Since the last update it seems to be broken. Although it remembers the last database I cannot open a table within any database.
Edit: It appears the file was corrupted. Loaded a new file and all working again.
Any news in this topic.
I tried panacea Database, works fine. But not very effective. Searching data is a must for me however I didnt manage to find a search option. When I search for tables, it cant even locate the tables by names.
Like so many of those great little apps and neat little softwares we find out there, Microsoft Live Mesh seems to be one of those personal favorites of mine that has been thrown to the wayside by what most likely is "Progress".
BACKGROUND
For those that find this application new to their world, Microsoft Live Mesh (http://www.mesh.com) is a Multi-Device Synchronization tool, also called a "cloud service", that creates and / or modifies a folder on either your Microsoft Windows PC, Apple PC, or Windows Mobile Device to allow synchronization of the content in that folder with other designated devices within the "cloud". Each folder can be set with specific permissions and can be allowed or denied access to other designated users. I've always felt as though this was a wonderful and amazing tool and had been using the service for a few years. As with many other members of this forum, I to find myself flashing many different ROM's on what can be a daily basis if the amazing chef's out there are hot in the kitchen!, and MS Live Mesh really made that process easier by allowing me to sync desired content that would have otherwise been tedious and allowed me to take my files I have on my PC with my on my WM PPC where ever I had an internet connection.
CURRENT STATUS
Sadly, as of the past year or so this wonderful software has become seriously underdeveloped, and I wanted to try and take a step toward a revival of this great application. One might argue that the reason for lack of development might be because of newer development in different and update phone software, or that there was not enough of a community outcry for this type of application. Whatever the case may be, one last cry for help on what has turned out to be a world renowned mobile device forum wouldn't hurt, right?
There is an already running MS Forum on the subject of development where if this sort of thing does perk your interest, you can find more information about what fixes have already been found. There is also already a forum on XDA Developers that has already been started... but the last thing mentioned in that forum was about getting access to the tech preview of the application.
MY RESULTS
So far, I have run into consistant failure in using the software using any of the new ROM's for my Fuze and am usually met with the same result... when I try to lauch the application on my Fuze, it crashes before finishing loading, or after I finish the login process, I am met with a setup error when trying to add my device to the cloud.
There you have it, that's my story and I'm sticking to it. If you have any idea's on how we might be able to get this up and running again, please feel free to post and let's really get some community development action going on! Hopefully it's not the case that MS has just pulled the plug on the whole thing and didn't tell anyone, right? :?
My understanding is that Mesh is being merged with Windows Live Sync (as part of Windows Live Wave 4). Hence data will be synced into Skydrive rather than the separate Mesh storage area. Hopefully this will mean a new winmo 6.5 client, although there is talk that this might be phone7 only
No release date for wave 4 yet either
Hi guys,
This is my first post in XDA and this question should be posted in "Windows Phone 8 Development and Hacking" but unfortunately, i don't have the minimum requirements of 10 posts for the Development and Hacking Section so i am hoping for someone to give me a push here.
I am looking for a way to access my shared folder on my LAN through Windows Phone Application. I have downloaded a sample from Microsoft which uses File Picker. When i run the project as a windows store application I select network, I type the UNC path and I can browse the folders, but when i run it in phone emulator the network option does not exists. I have searched Google for an example on how to enumerate shared folders in my LAN and i have not found any solution.
So if someone could help me it would be really appreciated.
Thank you
First of all, no, this thread *DEFINITELY* belongs where you put it. System working as intended. This is a Q, it goes in Q&A. It is neither something you've developed nor a hack to share, it does not go in D&H.
With that said, the problem is unfortunately simple: WP8 doesn't (seem to) support Windows networking (SMB) at all, so far as I can tell. This is somewhat odd, since it has both the LanmanServer and LanmanWorkstation services, which are responsible for providing Windows Networking support, plus all the relevant binaries appear to be present. This warrants further investigation!
You can, in theory, implement it using sockets (see Samba for an open-source implementation of SMB, though note that it is GPL code and if you use it you must open-source your application as well) in any case.