Database Develop

Looking for help with provisioning xml (or a tool)

I'm fiddling around with a provisioning xml for my UC setup.
I've gathered how to set up an e-mail account but I want to do some more stuff.
(More specifically I want to set region, my default windows live user/settings (or perhaps just my hotmail account) and user/adress info)
I've found bits and pieces of info here and there but it's not much to go by, can anyone lend a helping hand?
I'm also interested in knowing how to prep Coreplayer. Does anyone know how to automate the input of the serial? I can't find anything in the registry and I have no idea if it's possible to automate the input by scripting some sort of event..?

Yes this sounds interesting. I would definitely care to know how to set up my device so that I don't have to set everything up again and again and again after every hard reset. and again.

Android Access Database

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.

Need help regarding remote connection

Ok so this is the scenario i have 2 computer at 2 different locations (Home and Office). On my main computer there is software which i would like to use on my another computer simultaneously. Like i am using the software on my home computer(Main PC) and brother wants to use the same software at our office, so i have created 2 users on my main PC and i would like my brother to use 2nd user to login remotely and use that software. Let me tell software has capability to be used at 2 place simultaneously.
Waiting for your help
Thankyou

Omg is that so much difficult, ,, no reply yet.
Sent from my HTC Desire using XDA App

umm, yeah its possible. all you need is a citrix server ( or similar ), i think there area few bits of software that do work on desktop machines. but i can't remember any of the top of my head. i know i have iraap for my mac, i will take a quick look for you now. But a quick warning if you wanting to do this over the internet. its going to be much harder working out port forwarding ETC over doing it in a lan enviroment. so you possible could use hamachi. ok i'll get back to you in a bit.
and yes this is quite an advanced thing todo. what your technically trying to do is create a server in which multiple members can connect to and do things simultaneously. so your not going to want to do this very much as it will cause a reasonable amount of strain on your system and certainly slow it down. if you are going to do this alot i would recommend investing on a cheap server

ok check this out, fire me off a pm if you need any help. i'm happy to help

Unless your computer is setup as a server (or hacked to allow so) you're only allowed one desktop connection at a time?
Please someone correct me if I am wrong?
Edit: NM, people replied whilst I had the page open without refreshing....

captainstu72 said:
Unless your computer is setup as a server (or hacked to allow so) you're only allowed one desktop connection at a time?
Please someone correct me if I am wrong?
Edit: NM, people replied whilst I had the page open without refreshing....
Click to expand...
Click to collapse
just thought you might be intrested. i believe normally a windows machine will allow remote desktop connections, which means you can control the computer from another machine, very much similar as vnc. but a terminal server (citrix) allows multiple users to connect and run completely seperate sessions, but there are program that run the services needed to run terminal server witout a full blown server operating system.
just thought i would clear this up for you

I udnerstand that part, but as his PC is likely to be a standalone windows enviroment, and with him working on it, his brother will not be able to log in from the second location, as standard, due to that policy. I know there is a dll that can be hacked to allow it though. I have an understanding the RDP side, but he is using a windows machine not a terminal server/virtualised server etc, so from my perspective, his question was is it possible as is, not how do I make this possible by throwing money at it.

captainstu72 said:
I udnerstand that part, but as his PC is likely to be a standalone windows enviroment, and with him working on it, his brother will not be able to log in from the second location, as standard, due to that policy. I know there is a dll that can be hacked to allow it though. I have an understanding the RDP side, but he is using a windows machine not a terminal server/virtualised server etc, so from my perspective, his question was is it possible as is, not how do I make this possible by throwing money at it.
Click to expand...
Click to collapse
no these are completely free peices of software that require no dll hacking, they create there own server services that replicate terminal services.

Thanks for the help slamming, but i must tell you i am a noob concerning this.
I have checked out the link. Can you be more specific without all the jargons how should i go about achieving it,i would be really grateful.

samy.3660 said:
Thanks for the help slamming, but i must tell you i am a noob concerning this.
I have checked out the link. Can you be more specific without all the jargons how should i go about achieving it,i would be really grateful.
Click to expand...
Click to collapse
ok well, what your are wanting to create is a terminal server, this is used alot in enterprise and it allows multiple user to connect to the same machine and use all the same applications and share data. But in enterprise they will use a machine called a thin client, this machine will boot straight from the network and connect to the terminal server. but you aren't going to want to buy a thin client so you are going to have to download another application on the second computer. but we will come to that later. what i think would be a good idea is if you were to read up on terminal services, terminal servers and maybe even thin cleints, as i think you do need to be able to understand the majority of the jargon that is going to be used. i would recommend you don't under take this task if you don't have quite abit of time or aren't confident in your IT skills

slaming said:
ok well, what your are wanting to create is a terminal server, this is used alot in enterprise and it allows multiple user to connect to the same machine and use all the same applications and share data. But in enterprise they will use a machine called a thin client, this machine will boot straight from the network and connect to the terminal server. but you aren't going to want to buy a thin client so you are going to have to download another application on the second computer. but we will come to that later. what i think would be a good idea is if you were to read up on terminal services, terminal servers and maybe even thin cleints, as i think you do need to be able to understand the majority of the jargon that is going to be used. i would recommend you don't under take this task if you don't have quite abit of time or aren't confident in your IT skills
Click to expand...
Click to collapse
Ok i will learn it by tommorow all i could about terminal services, and do you think if there is a software available which will be able to this, preferably free, or if not i wont mind paying for it.
Thankyou.

samy.3660 said:
Ok i will learn it by tommorow all i could about terminal services, and do you think if there is a software available which will be able to this, preferably free, or if not i wont mind paying for it.
Thankyou.
Click to expand...
Click to collapse
alright then while your learning about terminal server, i will begin looking into software for you for both ends both server and cleint.

[APP] Crumbs (looking for a fellow developer!)

So I recently got very interested in Windows Phone 7 (mango) and I had been thinking about starting to create my own apps for a while. The result is the idea for an app that is as follows:
Name: Crumbs
Possible abbreviation: to send somebody a "crumb"
In short: An app that capable of: writing/creating, organising, sharing and following instructions, AKA crumbs.
What I want to achieve with this is a new option into social networking, but this time it's also very useful and not just fun to show off. What could these crumbs be? Well, I've thought of some categories already:
Routinely task:
like the stuff you do every morning, shouldn't forget, etc.
Work/study task:
some sort of study schedule, with certain points you should handle to complete the whole task.
Preparation/cooking task:
doesn't need any explanation.
Scavenger hunt/adventure:
wouldn't it be great if you can give a list of instructions to someone with some reward at the end?
Travelling:
similar to your adventure, but could contain various flight data or a couple of options (so you don't "finish" an item, but finish 1 item in a dillema.
Other: always have some other category..
User defined: if a user wants to make his/her own category.​So these are the categories, but as you've already seen, each category has different types of commands/operations one has to perform to complete the whole task. So when writing a new one, you could filter the entry-options by the ones most important for that category and give the users a seperate option to add another operation than the ones listed by default. Some possible operations and their integration ideas are as stated below:
Action: very straightforward, do something and when executing the crumb you simply check the box when done. Maybe some option with a timer that alerts you that you should be done with the operation soon (for example: cooking).
Navigate: go to a specific location and then you check the operation. Possible GPS integration/maps?
Input: give certain input to go on. For example useful when creating an adventure (go there, look for the church and read what's on it) or something else that should need a password or any other input.
Alert: to alert yourself/the executor OR (and this is important) some other user that you've arrived at a certain operation in your crumb.​
Yeah, you read it right, another user. Because one other important aspect of almost every app nowadays is SHARING. So ofcourse, there will have to be the option to share crumbs. People will be able to manage their crumbs on a phone ofcourse, but if there's a lot, wouldn't it be easy to have them stored online too? A place where you can rapidly type, organise and share your crumbs. So there should be a format to save them in (.crumb looks fantastic ). So, you simply send someone the crumb using a public link you create for your privately stored crumb. But what about something called instructors/friends? Wouldn't it be awesome if you can allow certain people to GIVE you crumbs straightaway, so you'll get alerted and know you have to do something (OK, "your mom" wouldn't be awesome, but useful nonetheless). To make things easier for this, the users will have to be able to manage these friends/instructors too and have their own cookie jar/cake box to receive their crumbs directly in (on the website and in the app). I sense some Facebook/social integration, don't you?
Then there's this weird habit of people: they've got calendars and tasks on them. Wouldn't it be great if the crumbs are linked to calendar and/or outlook-task items?
Sooo... This is my (already quite complex) idea. To conclude things once again: the outlook task system isn't capable of managing real tasks. You can give certain progress percentages, but that's just something that could be managed by this app, since it's much more in depth.
Problem is, I'm not that good at developing (yet)! So if any developer out there is willing to take this thing on with me (I just feel this could turn out great), please let me know. Meanwhile, I'll keep dreaming on and I'm a quick learner, so I hope to show a mockup of some sorts soon . I've already thought out some sort of menu structure/frame everything should be hung up in and that's what I'll be working on the time to come.
And keep in mind:
This idea is NOT for sharing by anyone but me right now. That it may be very clear that this idea is not for your own use!

Remote Apps on TP

Hi All,
I wanted to share with you something that I think could develop into something quite useful (and cool ). I have successfully managed to launch remote applications from my Linux server onto my TP (similar to Citrix). For those that might be somewhat skeptical I've attached a screenshot below. And yes, your eyes do not deceive you – it most certainly is Word 2007 running! But before everyone starts jumping up and down with excitement, it's not an TP application that I've developed – more proof of concept.
If people are interested in trying this out themselves please let me know and I'll put up some instructions. Just a wording of warning though, this is a little fiddly and requires the user to use CLI via Executah and also a Linux PC (not sure how to achieve this with a Windows PC).
Also, if there are any Xterm/XServer/WebOS Developer experts for the TP here that can help me, please come forward as I would like to push this to be more GUI based so I could really use some help.
Thank you.

How does this compare to splashtop remote?

Wow very neat!
Don't run Linux so not for me but i'd find this useful if someone knew a way to do this via windows?

idealz said:
How does this compare to splashtop remote?
Click to expand...
Click to collapse
it's not as advance as splashtop. It's merely just a remote application running on a linux server. The example I posted was of word running via wine on my ubuntu server. However, I've managed to get rdesktop installed on the touchpad which means there is a possibility of running a windows application. I will try this out and see if it works.
I will report back as soon as I have some info. I post a screenshot of a windows app running, asumming I can get one to run.