yashsingh1/xdaforums huggingface dataset:
[Android Apps and Games] mydatabase:
Example: Cars expenses

Objective

There are different kind of expenses, e.g.:

fuel

insurance

repairs

inspection

other (some accessories ...)

So we should make one category for car, to separate this project from others. In this category we'll generate 5 themes to divide the kinds of expenses. To build summaries, the paid value will be entered in the first numeric field.

The new category "Car"

Press "Queries" from the menu, in the queries screen select "Insert Category" and replace XXXXXX with Car and execute the query.

See attached image 1

Making the themes

Fuel

Press "New entry" from the menu. Select "Car" from category, enter "Fuel" in the theme field and give a description to the next field. We'll check at least one entry per theme to show at start to make it easy to add new entries. The date will be entered or taken from the date picker. The text field not necessary, so we'll use them as label for the numeric fields. In the first numeric field the paid value, in the second the liters and in the third the kilometers since last refuel will be entered. Store the entry with "Save".

See details in attached image 2/1

Repair

Press the entry Fuel from the list. Change the theme to "Repair", enter the reason in the next textfield, change date and change value for "Paid". Make the last two textfield and numerics empty and "Save as new".

See details in attached image 2/2

Insurance, Inspection, Other

Make the first entries for the themes Insurance, Inspection and Other analog to Repair.

The queries

Expenses by theme

The expenses will be summarized by theme. Press "Queries" from the menu, in the queries screen. Enter "Car by theme" in the name field and:

select theme, SUM(number_1) from Notes where category="Car" group by theme

in the sql field and "Save as new". Execute the new query.

See details in attached image 3/1+2

Fuel consumption

The average of fuel consumption will be reported. Press "Queries" from the menu, in the queries screen. Enter "Car fuel average" in the name field and:

select SUM(number_2)/SUM(number_3)*100 AS Average from Notes where category="Car" and theme="Fuel"

in the sql field and "Save as new". Execute the new query.

See details in attached image 4/1+2

Expenses per year

Make a new entry for the theme "Fuel". Select the entry Fuel from the list, change at least the date to one in 2011 and "Save as new".

The expenses per year will be reported. Press "Queries" from the menu, in the queries screen. Enter "Car per year" in the name field and:

select strftime("%Y",date) as Year, SUM(number_1) as Costs from Notes where category="Car" group by strftime("%Y",date)

in the sql field and "Save as new". Execute the new query.

Hint: strftime substracts the year from a date

See details in attached image 5/1+2

Done!

In future enter your expenses in the related themes and use your stored queries for reporting.
[Android Apps and Games] ajige:
Isn't this advertising for a commercial product? See rule no. 11. It would have been nice if you stated that this is not free software.
[Android Apps and Games] mydatabase:
Recent changes

v 2.1

Fixed: sql error at some devices by starting the app
[Android Apps and Games] Paparasee:
Would it be possible to link your software with barcode scanner?

Would then make this a lot more useful.

Once linked, it should be able to add to the database and / or search the database.
[Streak 5 Themes and Apps] sultan_somali:
Anyone got this live beach wallpaper running on their streak?

I tried downloading it on a site but it wont run for some reason.

http://img213.imageshack.us/i/snap20100904113544.jpg/
[Networking] Guitarfreak26:
Hey guys

Im having trouble connecting to gps, its only getting a 2900 metre lock on with o2 sim also its not collecting the date or time from the server.

It done this in my nexus s and galaxy tab. I asked o2 for the new sim and its still doing exactly the same

Any ideas? I can connect to net fine!
[Nexus S Q&A, Help & Troubleshooting] Mr_Zoidberg:
I always used swiftkey on my N1. Now I have a Nexus S and I really like the stock keyboard, but there is no Dutch dictionary on the Nexus S.

Is it possible to import a custon(Dutch) dictionary into the stock keyboard? That would be really nice :)
[Nexus S Q&A, Help & Troubleshooting] nickparrin:
You could try this package I created from CyanogenMOD 7 for Nexus S. It can however be installed on ModacoROM as I have and probably also stock nexus s.

It has the dutch keyboard/autocorrect hidden under 'Italian'. I didn't know how to get it under its own language. So I abused the Italian language for that.

I'm not sure if you need root either to install, anyway good luck with it.

If you have successfully installed it, you'll get another Android keyboard in your language and keyboard menu. Select the languages you want and Italian for the dutch dictionary. Please be aware you need to set them in both settings when you click "Input Languages" (it asks you to complete action using).

Should be fairly safe, you can remove it under manage applications and then choosing "Android keyboard". The stock keyboard that ships with the device itself and can't be removed afaik.

good luck.

gr. nick
[Nexus S Q&A, Help & Troubleshooting] ViLANDER:
Is it possible to add custom keyboard languages (that are defined in the SDK) without root?
[Nexus S Q&A, Help & Troubleshooting] nickparrin:
I think you would need to build/compile it from AOSP. What I'm doing is probably quick and dirty but it works (I'm still new to this android development). Think you need root though to install this.

If you like I could try and make another APK with Swedish keyboard/autocorrect hidden under the Italian language.

gr, nick
[Nexus S Q&A, Help & Troubleshooting] ViLANDER:
That would be awesome!
[Nexus S Q&A, Help & Troubleshooting] nickparrin:
Oke. Here is the Swedish APK. Select Italian 2 times when you try to select the input languages (for each action).

Might need a reboot to have it work, didn't need it here. Also I'm on a rooted nexus s and haven't tested it without root.

I'v tried removing it from application management, which works. After that you are back to the stock keyboard. Looks safe so far :)

have fun..

note: I used adb install LatinIME.apk to install this.
[Nexus S Q&A, Help & Troubleshooting] ViLANDER:
Thanks, I've tried but can't get it to work. What do you mean with: Select Italian 2 times when you try to select the input languages (for each action)?

EDIT: Okay, understood. Still doesn't work. Unrooted also. :confused:
[Nexus S Q&A, Help & Troubleshooting] nickparrin:
Hmm.. So it installs and you get another android keyboard in your settings menu right?

What might help is installing another keyboard (free from market). set that as default (select it as input method in browser for instance). go to settings and select the recently installed android keyboard i gave you. deselect all languages in the input languages menu (once for each action popup). close settings, open it up again. select english and italian in input languages (once for each action popup) and close settings.

now open text messaging or anything else that uses the keyboard. select the android keyboard as input method. hold the spacebar and select italian. it should now give you swedish predictions.

i'v seen it here also that it at times didn't give me dutch, but after redoing all the settings it fixed it.

just make sure you have enabled the keyboard in the settings menu and set the settings for it like i said. if it doesn't work i don't know.
[Nexus S Q&A, Help & Troubleshooting] jozilla:
Is there any other way to get, for example, the Dutch dictionary in the Gingerbread keyboard, without having to abuse one of the existing languages? Can't you just add additional languages?

I'm using a Nexus S, and I heard that there are versions of the phone that download additional keyboards during the initial setup, based on the location of the phone (network, country, ...), if they have an internet connection available, see for example this screenshot: h~t~t~p~:~/~/~plixi~.~com~/~p~/~67798426 (can't post a link, so just delete all ~ chars).

I'm also wondering if this method won't cause problems when you get an OTA upgrade (e.g. to 2.3.3). Will you need to do it all over again? :-s

Thanks!
[Nexus S Q&A, Help & Troubleshooting] theimpaler:
Has there been any progress on this? I don't know why android doesn't just include all languages possible. If an iPhone can do it, surely our phone should! :D
[Nexus S Q&A, Help & Troubleshooting] jozilla:
I heard that Android 2.3.3 adds support for a lot more languages, also on the US/UK Nexus S, including Dutch ...
[XPERIA X10 Q&A, Help & Troubleshooting] geraldkw:
Hi,

my X10i synchronises with the parrot Ck3100 but the listing is not what I was used to with my previous phones. For each telephone number of a person I have a new entry in the list in stead of only the name of the person and after clicking on it, the list of number belonging to that person.

I tried all groups separately and common, also enabling google using "my location".

I don't know if the problem is related to the parrot or to the X10i but because my previous phones didn't had this I assume it is related to a setting of the X10i?

Does anybody experience the same or has a solution for it?
[XPERIA X10 Q&A, Help & Troubleshooting] geraldkw:
Nobody who has the same problem?
[XPERIA X10 Q&A, Help & Troubleshooting] geraldkw:
For those who are interested:

If I switch bluetooth on and keep the display alive for about a minute it displays the list of people in the right way. If I then connect again in standby mode (switching on/off of parrot and phone in standby) it displays the the list of people in the wrong way....
[Vibrant General] tphone:
I can play videos stored on my dlna server on the vibrant nicely. However aspect ratio can't be adjusted. The videos are alway zoomed to full screen and so distorted. I can't find a way to adjust the aspect ratio. Does anyone know if aspect ratio can be adjusted and how?
[Vibrant General] PaiPiePia:
Assuming you are still on JDF? Upgrade the firmware to JI6, the aspect ratio is fixed, instead of zooming to full screen, it fills the screen while keeping at aspect ratio.
[Desire Q&A, Help & Troubleshooting] x3202:
I've read somewhere how to prevent the ext3 partition from being mounted when I connect my phone via USB, but i can't find it anymore. :(

When i choose Mount Storage I only the Fat partition should be mounted.

Does anyone know how to do this?
[Desire Q&A, Help & Troubleshooting] Bl@ck:
look here, there's a zip to flash in recovery to solve that problem :)

http://xdaforums.com/showthread.php?t=748793
[Desire Q&A, Help & Troubleshooting] x3202:
seems only to work with sense roms :/

I'm using the MIUI rom, maybe i'll find another way to get it work
[Desire Q&A, Help & Troubleshooting] Bl@ck:
Are you sure? i'm using that exact flashable zip with a miui rom and i no longer have problems with double partitions, lost files, etc.
[Desire Q&A, Help & Troubleshooting] x3202:
Yeah :/ I'm using MIUI 0.12.24 and I can still see the ext3 partition on my pc. And my Fat partition is the first partition on the SD card.

And i still can't see new files without reboot.
[EVO 4G Themes and Apps] bbostich:
How would I achieve this? Im fully rooted running the Sprint lovers rom. I have a custom font flashed along with my lcd density modified. The combo of the 2 makes the Sense bar look horrible. I managed to delete the sense lockscreen and it automaticly reverted to the vanilla one which is what I want. Can some one please help me to achieve this outcome on the incoming call screen. It is the only thing between me and having my Evo the way I want it.
[EVO 4G Themes and Apps] -viperboy-:
From what I understand, I don't think it can be done. I would LOVE if there was a way to do this but I believe it is coded into the framework and it can't be removed. That's my understanding of it. Too bad :(
[EVO 4G Themes and Apps] dadoc04:
That would be good... if its possible JS would prolly be the 1 to figure it out....

Sent from my HTC Evo
[EVO 4G Themes and Apps] Success100:
Not possible with sense..the lock screen can be changed to the aosp lock screen but that doesn't remove the Htc incoming lock screen, its tied to the dialer

sent from my DAMN EVO
[EVO 4G Themes and Apps] deathsled:
speaking of the sense incoming call screen, how many other people have the problem where maybe 20% of the time the screen won't respond to input and allow you to unlock or answer the call? This is pretty much the only thing that ever goes wrong with my phone lol. I end up having to just hit the power button, miss the call, and then call them back...a little annoying
[EVO 4G Themes and Apps] T3chn0crat:
I have the same issue. One of the only issues I have with my phone. The other being sliding out of my pocket answers/declines calls. Thus looking for a way to remove the slider. Guess we are stuck.
[EVO 4G Themes and Apps] titans10:
^^^ I have the same problem... doesnt happen too often, but it is annoying. Could this be due to a phone call coming in when CPU is running at a minimun setting?
[Android Software Development] Lacuna666:
Hello,

I was going to root my desire HD using the viosionary method, but it hangs up at temp-root part.

Then i saw (of course too late) the wanring stated somwhere about this problem.

Is there a way to root when you have the newest update installed ?

Thank you
[Android Software Development] georgeyeung:
i have no problem when update my desire.
[Galaxy S I9000 Q&A, Help & Troubleshooting] MacBryan:
Hi

is there any App for Android which can protect files like Truecrypt on PC ?

thx and bye :o
[Galaxy S I9000 Q&A, Help & Troubleshooting] kenpachizero:
this thread looks like it is coming along http://xdaforums.com/showthread.php?t=872297
[XPERIA X10 Q&A, Help & Troubleshooting] mhb161:
hi

force close error when in mobile banking program(java) recive sms from bank

plz help
[Galaxy Tab General] dattrax:
Hi,

I'm on my 2nd tab now (1st had a battery fault). Both have exhibited the same issue, so I'm pretty sure its firmware or some other influence. I've seen the problem with both 3G and Wifi, so I'm guessing its the network stack.

When connected to the internet or in the app store I get network errors, the most common is "Web page not available". Clicking retry a few times will often resolve the load. Rebooting the tab will correct the issue (its also snapper at loading pages after the reboot).

Anyone else seen this issue?

Cheers

Jim
[Galaxy Tab General] my_username:
I'm not sure I've had the problem with networking issues you describe but I can confirm the battery issue is legitimate having owned Sprint, VZW, and now the T-Mobile version of the tab. The are all extremely slow to charge, and also discharges (or at least it says it is) to 99% even when plugged in.
[Nexus One Q&A, Help & Troubleshooting] thejron:
My trackball is broken (parts on order) and my 2.3 rom is failing miserably. What recovery can I use that I can make selection with power button so I can use my phone again? Thanks!! Was on clockwork, tried Amon 2.0.
[Nexus One Q&A, Help & Troubleshooting] djn541:
Those are the only 2.
[Nexus One Q&A, Help & Troubleshooting] teh_lorax:
Are you asking someone to develop you one?
[Nexus One Q&A, Help & Troubleshooting] thejron:
Not at all.
[Nexus One Q&A, Help & Troubleshooting] fcisco13:
I use "reboot manager", once installed you can press and hold the "search" buton and select reboot manager to get reboot options, reboot, recovery, fastboot.

N1
[Nexus One Q&A, Help & Troubleshooting] Know-Fear:
He's not asking how to get to recovery, he needs a way to navigate it. Unfortunately, at this point there are no options for him.
[Nexus One Q&A, Help & Troubleshooting] thejron:
Damn. Thanks
[Nexus One Q&A, Help & Troubleshooting] PMGRANDS:
Can it be done with ADB?
[Nexus One Q&A, Help & Troubleshooting] codesplice:
Not directly.

I think you *should* be able to do it using fastboot flash to flash the individual file system images (*.img files, often inside a flashable *.zip), and then adb push to push remaining files to the appropriate directories.

I don't know 100% if this would work, but it might be something to try. Consult adb help and fastboot help for more information on the syntax of those commands.
[XPERIA X10 Q&A, Help & Troubleshooting] beefy314:
Is it possible to export contacts located at the Sony sync service as csv so I can transfer it to gmail contacts?
[HD2 General] kholk:
Hi all!

I've seen some guys here with my same problem: the HTC HD2 started to show wrong colors, yellowish display with blue stripes.

Mine started to have this problem when I've dropped it: first it was a temporary problem, pressing on the display would fix it for some hours, but then it became like PERMANENT... and my HD2 isn't over warranty anymore.

So, I've started to search and I've found many ppl with this problem.. I was about to buy another HTC HD2 but luckily mine was temporairily fixed for another time.. and UNTOUCHABLE!

Prior to the last temporary fix I've opened it to see if it was a wrong connection of the flex cable, but nothing.. it _really is_ a mainboard problem, maybe a broken connection of a point :D

Anyway, when it was temporairily fixed I thinked: well, it is already ****ed, I can only try my last chance...refluxing... so... this is what I've done:

1. Android booted

2. HTC HD2 on the bed, rolled in my duvet

3. Activated a native stability test using my CPU at 100%

4. Waited for 20 mins, my HD2 reached 54°C

5. Another minute at 54°C...

6. Okay, connections should have been refluxed..

7. Stop the benchmark, shutdown the device

8. After some hours I've taken it, and the display was okay.

I've made this 2 days ago and my display seems to be permanently fixed.

NOTE: This procedure is really risky: you've got a lithium battery in your device that MAY explode! Don't be a fool like me and don't make this thing on your bed!

Hope this helps someone :)
[HD2 General] fwfever:
Does it still fix the issue after 10 days? If it does, I'm gonna try to do the same tomorrow.

Other people who have already tried this?

Greetz, and thanks for sharing the info :)
[HD2 General] fwfever:
I have android installed now, but I don't know which application to use to run a cpu stress test. Which one did you use?

Thanks in advance.

Greetz
[Desire HD Q&A, Help & Troubleshooting] minibartdk:
Hi

Does anyone know when gingerbread will arrive on the European HTC desire hd?
[Desire HD Q&A, Help & Troubleshooting] Andy:
No-one knows of a release date for an official HTC Gingerbread update. I wouldn't imagine its too far away, Q1 2011.
[Captivate Q&A, Help & Troubleshooting] kschumake83:
i was trying to do this all day yesterday and i cant find a way to turn the protected .wmv file that came with despicable me to a format that will play on our phones or to find a player for android that will play it without converting it. any help will be appreciated
[Captivate Q&A, Help & Troubleshooting] 4got2g0:
have you tried poweramp or doubletwist player? I play wmv files with doubletwist all the time. You might try FVC video format changer, or just googling video format changer etc. or you can download vuze. It has a built-in format changer and option to sync music and videos directly to your android.
[Droid 2 Global General] mr.mike:
Hi every body,

I have a big problem with my phone.

I bought a brand new D2G yesterday and i flashed Fission 2.4.3 ROM . I really liked this rom.

Howerver now i want to unlock my phone but i can't find any where to enter the code.

And i tried to flash the rom D2_Global_OEM_RBDZ by using Fission ROM Manager (FRM).In this rom, i can enter my unlock code to unlock my phone.

But i can't do any thing in this rom,just can get the call.I can't obtain any program or setting in this rom.

So i turned back to Fission 2.4.3 ROM ....

BUT...In Fission 2.4.3 rom my phone was still locked...I tried come back D2 global OEM RBDZ again and saw that i didn't need to enter code because in this rom my phone was unlocked.........Finally i flashed to Fission 2.4.3 ROM again...

Nothing happens my phone is still locked.......

Strongly disappointed....

Pls help me solve this problem...Maybe i need to the original rom of this device...

Thanks you...
[Droid 2 Global General] droid2andyou:
did you wipe data / cache on the phone?
[Droid 2 Global General] mr.mike:
Yes, i wiped data/cache on the phone.

In my case, i think that i need to restore by using the backup file which created before flashing Fission 2.4.3. But i don't have this file ,so if you have it pls sharing for me.
[Droid 2 Global General] droid2andyou:
Your the only person that would have your phones backup file
[Droid 2 Global General] Angdroid:
SIM cards will not work on ROM, I thought it was on the thread post. Some sim card apps do not play nice without some blur resources. Those will be added in a next build or two ahead.
[Android Software/Hacking General [Developers Only]] Zomer:
I flashed my HTC Hero with the Elelinux rom, which is based on the CyanogenMod. One of the reasons for me to root and flash a new rom was to get a Bluetooth keyboard to work with my phone. Sadly, I dont get my bluetooth HID keyboard to work, even trough Cyanogen supposedly supports Bluetooth HID. I tried the app Blueimput in order to help things, but this doesn't seem to work either.

I really would like to have this on my HTC Hero, so therefore my question is:

Does anyone know a rom, radio, app or a combination of the latter to make my bluetooth keyboard interact successfully with my HTC Hero?
[Desire General] regua:
Is there any version of the Google News and Weather widget from Android 2.3 available for non-Nexus phones?
[Sony Ericsson XPERIA X10 Mini] tumler:
Hey everyone! First post here

I tried to root my x10 mini pro with z4root 1.3 and chose the temporary root just to test it out before permanently installing it. I went through with it and then I started getting all these popup's saying random applications are crashing until I got a message that the homescreen crashed.. after that I could do nothing but turn off the phone by taking out the battery and starting it up again. And so it booted and then it just got stuck in a loop of booting up as it seemed it had trouble loading the homescreen. Until finally the sony ericsson logo stayed on for a few minutes and then slowly the homescreen loaded up and the whole phone started to load up. With a few applications crashing along the way. And my applications being all over the place in the menu screens and my contacts dissapearing (my msgs are still there) and my phone forgetting my google account login..

So my question is where did I got wrong when I was rooting it?

And how do I change my homescreen? (as it use to be a gradient blue, but now is black on the top and fades into blue at the bottom. it's weird though as the settings menu still has the correct blue colour but the homescreen doesn't...)

And why did all these things get affected by z4root?

(turned out to be a few questions :) )

Thanks for reading this :)

tumler
[Sony Ericsson XPERIA X10 Mini] ozzy1212:
reflash/repair your phone with Sony Ericsson Update Service(SEUS)

if you're still on 1.6 after the repair, use Universal Androot instead...:)
[Sony Ericsson XPERIA X10 Mini] tumler:
Thanks for the reply.

Will try that :)

is SEUS part of PC companion? if not how can I get SEUS?

And how can I get that default wallpaper back, I tried searching through the whole sd card to no avail :/ I find it annoying having a different wallpaper to the background of the setting screens. Does anyone know where I can find it or how I can get this default image?

Thanks in advance
[Sony Ericsson XPERIA X10 Mini] pulang_lata:
Here you go... http://www.sonyericsson.com/cws/sup...ailed/updateservice/xperiax10mini?cc=gb&lc=en
[Sony Ericsson XPERIA X10 Mini] tumler:
Thank you, got it updated to 2.1 successfully :)
[Vibrant General] tonydatechnyc:
Can someone help me figure out this issue I'm having, when I plug the phone to the PC and connect mass storage the only one that pop up is the internal sd , so I goto my computer to click on the drive of the external sd it doesn't open any idea?