yashsingh1/xdaforums huggingface dataset:
[Galaxy S II Q&A, Help & Troubleshooting] SeaFargo:
Help request with command

Hello.

I am trying to convert a recovered contacts database from contacts2.db to Google compatible cvs file with sqlite3.exe.

The recovered database came from a Samsung N7000 and it is composed as follow in the table data:

SELECT "_id", "package_id", "mimetype_id", "raw_contact_id", "is_primary", "is_super_primary", "data_version", "data1", "data2", "data3", "data4", "data5", "data6", "data7", "data8", "data9", "data10", "data11", "data12", "data13", "data14", "data15", "data_sync1", "data_sync2", "data_sync3", "data_sync4", "is_read_only" FROM "data";

There are 2 lines for a single contact. mimetype_id 6 is the line of the name in data1; mimetype_id 5 is the line of the number in data1

Is there a command to properly export that database? I have no skills in programming and scripting.

I have to complete an import of a database to a new android phone from a N7000 old contacts2.db :crying:
[Galaxy S II Q&A, Help & Troubleshooting] SeaFargo:
Just to say that the code

SELECT "_id", "package_id", "mimetype_id", "raw_contact_id", "is_primary", "is_super_primary", "data_version", "data1", "data2", "data3", "data4", "data5", "data6", "data7", "data8", "data9", "data10", "data11", "data12", "data13", "data14", "data15", "data_sync1", "data_sync2", "data_sync3", "data_sync4", "is_read_only" FROM "data";

gives something like that:

5406,,5,2335,0,0,0,349563erased for privacy,2,

5407,,6,2335,0,0,0,"federico agronomo",federico,agronomo

And so on...

Since I have no skills in developing and scripting, is there anybody how can help me extracting universal VCF from that N7000 sql contacts2.db specific database? I can send it to you by eMail if you write to me in pvt. I'll apprecciated.

I did a lot of tests, but I can not create a proper query or run a proper script.

I was able only to extract the database in a way like the one mentioned. I have quite 1000 contacts :crying:

Thank you in any way for help.

Kind regards.
[Galaxy S II Q&A, Help & Troubleshooting] E:V:A:
THREAD CLOSED!

There are now hundreds of contacts & backup Apps on Google Play, so I'm closing this old thread.

But here are a few free ones that I really like:

Contact Backup & Restore Gmail

Super Backup : SMS & Contacts

MCBackup - My Contacts Backup

They should be able to export to CSV, VCF and XML files...

ENJOY!
[Hardware Hacking General] dragos240:
Hello!!

I'm attempting to port my galaxy tab to ice cream sandwich. It's on froyo right now. But before I do, I want to know if the "download mode" is loaded into the BIOS or in the bootloader partition. The thing is, I need to flash the boot partition, the system partition and the user-data partition. If one of those contains the download mode, and it's not present in 4.0, or requires device specific settings, I may brick my device. I have the stock roms for my device in case I brick it, but I can't reupload them if I overwrote the download mode. I'm asking this beforehand so I won't have to panic later.

Thanks,

Dragos240
[Hardware Hacking General] pulser_g2:
On any device I've used, download mode is part of what I recall to be the SBL (secondary bootloader). It is writable, so it IS possible to brick, but only if you flashed a bad bootloader...

It's not contained in system or data, so don't worry about that. But I think bootloader partition does contain the download mode code.

You would probably be best to ask about this in general or Q&A of your device's forum.
[Hardware Hacking General] dragos240:
If that's so, then I needn't worry. I'm flashing something called normalboot.img which is partition 7. Looking at my PIT file. There's sbl.bin which is marked as the secondary boot loader. So it's in a completely different partition and won't be touched.

Just taking precautions as the dangers of flashing are real and can easily brick my device if done incorrectly.
[Hardware Hacking General] Rebellos:
Download mode is coded inside of SBL in SGS Tab, that's for sure. And yea, it can be compared to PC BIOS. In SGS series phones if you don't overwrite any of BootLoader stages (IBL+PBL or SBL) duing flashing, your phone is always easily recoverable.
[Hardware Hacking General] cdesai:
Also, if it's the OG Galaxy Tab you are porting, you'll be pleased to know we're porting it! :-D

Take a look at my cm9 thread ;-)

From my fingers to your eyez
[Atrix 4G General] sheva850:
I have a Motorola Atrix 4G... it's AT&T american but unlocked with code . (I'm italian, i stay in italy)

Yesterday i try to flash with RDS Lite the sbf 'OLYFR_U4_1.2.6_SIGNED_OLPSATTSPE_P012_HWolympus_1g_1FF'

But in a moment i read 'error' ...

I turn on my phone, but the screen is black and the green led is on only for a moment.

If i connect the phone to the PC or to the recharge home, i read this on my screen :

SVF : 105:1:2;

Failed to boot 0x1000;

Entering NvFlash Recovery mode;

Battery is too low to flash;

Only this and my phone stop on this screen, and the green led of recharge in off ...

Excuse me for the bad english and for write here, but i'm italian and i try post this message in the atrix developers zone, but i'm a new user and the system don't do that ...

Please help me :(

@mail : kosmissimo85@msn.com
[Atrix 4G General] -JFK-:
Hello,

Check there :

http://xdaforums.com/showthread.php?t=1159555&highlight=battery+too+low
[Atrix 4G General] sheva850:
Nothing ...

I see the post , but there is nothing for the problem i think :(

Can someone help me ?
[Atrix 4G General] sspa:
Most likely bricked: http://xdaforums.com/showthread.php?t=1160408

Were you in GingerBread (2.3.4/at&t 4.5.91) before? there's a big warning saying once you are in GB, you cannot downgrade by using RSD/SBF
[Atrix 4G General] ltdanno360:
this is your only hope now

not great success with it but just try it

http://xdaforums.com/showthread.php?t=1182871
[Atrix 4G General] Alaq:
Your hardbricked... I hate to see hardbricked phones, but atm nothing can be done. So far we are dead when it comes to nvflash.
[Atrix 4G General] sheva850:
Atrix

eh ......................

but a JIG like for Samsung galaxy not working on atrix ?

With a brick i must only send the phone to motorola assistance ?

They can mount the original firmware or they must change my atrix motherboard ?

My Atrix is not guarantee here, because it's an AT&T and now i'm in Italy ...
[Atrix 4G General] SirFork:
http://xdaforums.com/showthread.php?t=1081743

Unfortunately tegra has not released any SBKs so this is as far as you can go... if you can get that far...

Reasons i spent almost two weeks reading and researching before I risked bricking such a nice device.
[Atrix 4G General] plepply:
I'm in the same situation... Waiting for motorola SBK :(
[Galaxy Note GT-N7000 General] mikempower:
hi everyall

a little question about received sms...

if my phone is turned off and somebody send to me an SMS,when i turn on the phone i read the message with the time i received the sms and not the time it has been sent...is there a solution for this problem(for me is better knowing when the message has been sent and not when i read it)

thanks to all for the answer...
[Galaxy Note GT-N7000 General] mikempower:
nobody can help me?
[Galaxy Note GT-N7000 General] geek_riot:
I'm not sure that is fixable. I have noticed it on other phones, not just the Note.
[Galaxy Note GT-N7000 General] mikempower:
i've found the solution with "sms timestamper fix" on the market...
[General Questions and Answers] DonnaJ415:
Okay so, I have read a couple of threads that somewhat touch base on my issue, however are not specific to my phone so I thought I would drill down to the subject matter in a new thread.

I just got a new SGS2E4GT yesterday as a replacement for my EVO4G. So far I love it, however when I paired it into my vehicle's (2011 Hyundai Elantra) bluetooth system, It connected to phone & media with no problem, but did not download the contact book.

Is there a fix, setting, or something I am missing within the SGS24E4GT?

I guess the thing that is a bit perturbing to me is that my good ol EVO had no issues whatsoever with pairing up.....
[Acer Iconia A500] AsM0DeUz:
I'm really disappointed by the battery life of my a500. It lasts no more than 2 days with Wifi disabled when display is off. I use it only 1 hour a day ...

This tablet is just 6 month old ... do you have the same problems ?

Do you think it could be returned under warranty ?
[Acer Iconia A500] WereCatf:
If I don't use mine much and I have WLAN off it lasts for about 2 weeks. So no, I do not have that issue.

Have you installed a custom ROM?

Have you checked what applications you have running in the background?

If you're running stock ROM, is it still 3.0.1 or have you updated?
[Acer Iconia A500] almoore16:
That's not good:(

I get at least 6 hours continuous use from mine,I'd certainly take it back if you rule out something causing unusual battery drain.
[Acer Iconia A500] allthrottle:
I had similar problem with my a100. No matter how I had my sync settings set or what apps I removed it was still getting horrible battery life. Did	a factory reset and battery life went back to how it should have been.

On my a500 however, battery has been great. I usually get 2 and a half days without turning off wifi or changing a thing, and with moderate usage. You may want to check sync settings for all of your apps.
[Acer Iconia A500] AsM0DeUz:
It isn't rooted and with the last version of stock rom 3.2. I'll make a factory reset tonight and check it the battery lasts longer.

I wonder if the battery is covered by the warranty ...
[Acer Iconia A500] Moscow Desire:
Man, my iPad lasts for 2 weeks. Normal usage :p

Seriously, like was advised earlier.

Things that drain the battery'

Live Wallpaper

Display settings

Stupid apps like battery savers, task monitors/killers

GPS

WIFi, especially if it is constantly searching for a connection

Sync's (mail, fb, twitter, just about any social app. Google sync) all of these should be off, or set to a more reasonable time.

Apps that update automatically. Should be set to off in the app settings.

Video and games

Just because the tab is asleep, doesn't mean it stops checking these things when to time requires. Especially if you have an a501 with internal 3g.
[Acer Iconia A500] redguardsoldier:
Well, I'm also new to Android, but I got some experience. You should use an app call BetterBatteryStat (thread available here, just google that name and "xda developers").

I bet that your wifi is not off when screen off. That setting is useless. On stock 3.2.1, it works. But on both Honeylicious and Thor's ROM, wifi just stay on. Sometime, the tablet stay awake while screen off also.

I suggest using BetterBatteryStat to view detail log of your screen on time and wifi on time vs sleep time. That app also give you some idea about which app is preventing your tablet from sleeping.

Also try TitaniumBackup PRO to freeze some of the included app (like Photo Browser 3D, if you don't use it). I don't accept any app which I rarely use to have a running service (check in setting\application).
[Acer Iconia A500] allthrottle:
So far I have 2 days 11 hours off the charger and am at 65% remaining. This isn't just with no use... Ive used it quite a bit to web browse and check pulse / xda along with not turning wifi off, gps on(shouldnt use much battery anyway) and syncing apps set to 4-6 hours. It's not rooted and has a ton of apps loaded on it, though I try not to have any apps that look like they were made too quickly.
[Acer Iconia A500] AsM0DeUz:
You were right ! A software was using the battery. After the factory reset, the battery lasts much longer. Since sunday i'm still at 77%.
[Acer Iconia A500] WereCatf:
Aye, that's what I thought. Be more careful what you install and get one or another task manager application so you can check for such more easily.
[Samsung Galaxy Gio GT-S5660] marcin1147:
Hi, I have a question to you: which version of CyanogenMod i better, more stable, faster etc. for everyday use? CyanogenMod 7.2 RC1 or CyanogenMod 7.1 RC-3.0? Please help me!
[Samsung Galaxy Gio GT-S5660] kajjtan:
7.2 Rc 1 no bugs, 4 example led flash bug
[Samsung Galaxy Gio GT-S5660] marcin1147:
Soo, 7.2 will be better than 7.1?
[Samsung Galaxy Gio GT-S5660] kajjtan:
For me Its best rom, ofcourse you can try both :)
[Samsung Galaxy Gio GT-S5660] krymzy:
7.2 for me definetly
[Samsung Galaxy Gio GT-S5660] marcin1147:
On CyanogenMod 7.2 gameloft games are doesn't working :(

Does it works on CyanogenMod 7.1? If not - I will install stock rom...
[Samsung Galaxy Gio GT-S5660] marconmgm:
I have cm7 rc3 great rom

But cant download from tubidy

Instal tubemate was my only sulution

ps sorry for my bad english
[Samsung Galaxy Gio GT-S5660] shiftyHungary:
@ marcin: The problem only happens at you, for me they can be installed and played too. For example : asphalt 5 runs extremely smooth.

Otherwise, 7.2.0 works very smooth and stable, I could say that it's way better then 7.1.0

If you do a wipe data/factory reset before and after installation, you'll probably have no problem with the rom.

For all beginners and new guys around, it is strongly advised to stricktly follow the installation guide to avoid any problems while/after installing a rom!

Bricking and malfunctioning can be easily avoided with attention.
[Samsung Galaxy Gio GT-S5660] marcin1147:
Hmm, i'll try to install this Asphalt 5. For example another games like Minebuilder or Raging Thunder works good...
[Samsung Galaxy Gio GT-S5660] GreenChris:
I think too that 7.2 is better than 7.1.

Works fine and no bugs.

Written with Swype Beta on Cyanogenmod 7.2(GT-S5660)
[Samsung Galaxy Gio GT-S5660] marcin1147:
Hmm, it's strange. Today Gameloft games are working :D

Thanks for advice.
[Samsung Galaxy Gio GT-S5660] czkwg8:
Maybe cm 7.2 is the best choice now
[Samsung Galaxy Gio GT-S5660] nawar-t:
as all ppl said

us 7.2 it's the best

---------- Post added at 11:08 PM ---------- Previous post was at 11:07 PM ----------

oh i forget to tell

i have one bug

sometime Mobile go to silent mode

i don't know why, or how it happen

except that it's soooooooo good
[Samsung Galaxy Gio GT-S5660] mehdi_hz:
I though 7.2 RC1 is better than 7.1 RC3. I've used both of them and like RC1. It is bug free but is slower than RC3

You can test both.

Good luck
[Samsung Galaxy Gio GT-S5660] SpaceCaker:
The Serious mod 7.2rc1 fast and stable :)

very fast

and an awesome SGS II LOOK

======================

SGSII styled rom

for galaxy ace

======================

The Serious MOD V0

for galaxy gio

======================

made by Robinandroid
[Samsung Galaxy Gio GT-S5660] samydroid:
I have used GioPro 1.4, CM 7.1-RC 3.0 and CM 7.2-RC 1.0

All have been superb. Currently I'm using CM 7.2 and its pretty much smooth and stable. Very rare FCs and none if used with patience lol.
[Samsung Galaxy Gio GT-S5660] fauchon:
I'm currently using 7.1-rc3, which works perfectly well except for a little bug with FM radio (volume too loud during a few seconds after starting). And I think I'll stick with it until I manage to build CM9.
[Samsung Galaxy Gio GT-S5660] 184pin:
The CM9 build is out and they are working on it everyday. Im running it everyday and it works very well.
[Samsung Galaxy Gio GT-S5660] marcin1147:
Heh, I'm one of CM9 developers :-P
[Samsung Galaxy Gio GT-S5660] fred4o:
We know that and good luck with the rom
[Samsung Galaxy Gio GT-S5660] shiftyHungary:
I don't think it's preferable to use CM9 yet. At this stage the system is very incomplete and everyone should wait until an RC version comes out. ( except developers of course :) )
[Samsung Galaxy Gio GT-S5660] Walter1997:
In my opinion CyanogenMod 7.2 RC1 is better but some guys say 7.1 is more stable.
[Samsung Galaxy Gio GT-S5660] coccolino_dbro:
I was using CM 7.2 untill, out of nowhere, I don't receive incoming calls, the caller is getting a busy tone. The calls do show up in log afterwards. Blacklist settings contains no number... Any ideas?
[Samsung Galaxy Gio GT-S5660] bladio:
is there a 7.2 version for the htc inspire?
[Samsung Galaxy Gio GT-S5660] JustVass:
You seem to be using wrong forum section.

Ask this question into HTC section, preferably the section for your device.
[Samsung Galaxy Gio GT-S5660] voetbalremco:
im using cm9 for daily use.

wifi data etc works

some grapjic glitches

no camera

it s working fine, battery is getting drained, but devs are working on it
[Samsung Galaxy Gio GT-S5660] manpildo:
I found it's pretty hard to use CM9 (beta2) because of the lag and graphic glitches, and many options aren't yet incorporated by the CM team. All in all I think CM7.2 is the fastest and most stable of Cyanogens available now. Tbh I'm interested to see how our CM9 dev team will make ICS work smoothly on such weak hardware.. So far they're doing a great job.
[XPERIA X8 General] junghyun01:
anybody who can tell me how to get original lockscreen like stock Rom?
[XPERIA X8 General] Chris95X8:
Deleted- sorry, misunderstood post

Sent from my X8 that is soon going to be replaced with a Samsung Galaxy Nexus/S II
[XPERIA X8 General] n1kolaa:
you must pech fremowk-res.apk
[XPERIA X8 General] junghyun01:
k i will try :)
[HD2 Android Q&A, Help & Troubleshooting and Genera] splatters:
Hey guys,

New to these forums so a big hello from me!

I just have a few questions I would like to ask. I got myself an EU HD2 that had MIUI installed - I didnt like this so flashed it back to windows 6.5

I would like to install the Energy rom with HTC Sense so here are my questions..

When it says "EU needs CWR 5/210/5 is the minimum requirement with a 1GB ext2/3/4 partition on sdcard." What does this mean and how do I do it? I mean like what tools do I use? I did this through Clockwork Mod for the 1GB thingy but I have a feeling I am doing it wrong. What steps am I missing?

I manage to install it but it just gets stuck at the bootscreen, this is the same for any rom I install so I am guessing I am doing something wrong which I believe is the 2/210/5 bit. I have no idea what this is - would someone be kind enough to explain it to me and teach me what to do?

I have looked about the forums for a solution but I cant seem to find any guide that details how to do that 2/210/5 part.

Any help would be appreciated!
[HD2 Android Q&A, Help & Troubleshooting and Genera] samsamuel:
5 Meg boot partition ( default, you can ignore this)

210 system partition

5meg cache partition. You set these during flashing of cwm,,, use the "nand toolkit", select 210 on the left, put 5 in the cache box, and click repartition.

Yes use cwm to set the SD ext 1gb.
[HD2 Android Q&A, Help & Troubleshooting and Genera] kylew1212:
I've written a guide, its about how to install cLk but thhe first few paragraphs are about the layouts like you just mentioned. It may help you some.

Here is the link.
[Samsung Galaxy Nexus] gangstar:
how can i return to yakjuxw if i flash yakju using odin!

i thought i wil get an ota for 4.0.2 but nothing so i want to return to yakjuxw the same way i did for the yakju! where can i find an odin firmware yakjuxw?
[Samsung Galaxy Nexus] tigajr:
I am afraid you can't. For now. There is no yakjuxw image on Google that I know of. Even the 4.0.2 was pulled from the binaries of the "Nexus Phones and Flagship Devices" page. I can not put links yet, because I am new on XDA.

I have the yakjuxw and got the volume fix today, so I am on the path! I won't flash the yakju yet, because no one that I know of got the 4.0.2 after flashing yakju 4.0.1, and because no one knows for sure the future side effects of this action, even the google engineer Jean-Baptiste Queru do not know much yet.

Do not worry, I think you won't have any problems. Fortunately, Galaxy Nexus is a dev phone!

obs. English is not my native language.
[Samsung Galaxy Nexus] Simmo3D:
You would need to find someone using yakjuxw to perform a system dump of that ROM so you can flash it. In my opinion you are better off sticking with yakju. Google has pulled 4.0.2 from their servers and no one is receiving that update now. Google will most likely just release 4.0.3 soon for everyone instead. If you really want 4.0.2, you can download it from google code and flash it with fast boot. Like I said, your better off sticking with yakju since it will be updated first and moving back to yakjuxw won't get you 4.0.2 so there will be no point.
[Samsung Galaxy Nexus] BuddyJoe83:
+1 on this one.

Here is a link for the Google Nexus Images though if you decide to manually update to 4.0.2:

http://code.google.com/intl/nl-NL/android/nexus/images.html
[XPERIA X10 Themes and Apps] huzi7868:
Hello i found this app and wanted to share with everyone i find it really good also playing games on it like dungeon hunter and puss in boots etc. Am using leaf stock rom

https://market.android.com/details?id=com.smartprojects.RAMOptimization
[XPERIA X10 Themes and Apps] xdtiiz:
Niiice!!!

Sent from my X10i
[XPERIA X10 Themes and Apps] NuriJ:
Very nice!!!
[XPERIA X10 Themes and Apps] rokca33:
The apk. not be found.
[XPERIA X10 Themes and Apps] huzi7868:
the link works for me try google it
[XPERIA X10 Themes and Apps] rdk00:
i just instaled on my x10 i dont know if it really works, any test's u can share so i decide myself ?
[XPERIA X10 Themes and Apps] milton.bain:
Why create a thread when you already have one???

xdaforums.com/showthread.php?t=1305060

Yes it does.

________________________________________

CheerS!  

Milton

Wishing all a HaPpY NeW YeAr --> From Sony Ericsson Xperia™ on ROM : "ThGo2 v13"

using XDA premium

"  hit thanks if I'm nice to you!  "​
[Defy General] mpiekp:
From reading various forums it seems the defy is a little flaky in build quality. I thought it may be an idea to collect on a thread who has had what repaired/replaced and by whom.

I had a bayer model 9 months, stopped powering up. Sent to carrier for repair, camera module changed to soc, repair failed in seven days, returned they replaced motherboard, on collection phone would not power on, sent back new battery added. Phone had constant reboot issues, so carrier replaced handset soc model.

This one reboots too:/
[Defy General] maccboy2010:
My speaker has just gone not the loudspeaker the other one gutted :-( has anyone else had this problem.

sent from my cyanogen mod 2.3.7 defy running at 1ghz and I absolutely love it :-)
[Defy General] solomonhafer:
I have had my device replaced once with a bad rom flash and now once with a bad speaker buzz. Call T-Mobil up and after a lengthy process they will send you a new phone.
[Defy General] diamond_4g64:
The earpiece is a common problem on this phone and seems to come from the milestone that had the same defect but is repairable on garanty and is not something that seems to happen alot. I also exploded the cpu but i am running at 1.3Ghz so this is possible.

Overal i dont get alot of repairs for this model and the earpiece is easy to change if you lost your garanty.

I dont find the phone cheep and in fact i have dropped it alot, put it in water, overclocked ,overheated it etc, etc and it has very well endured the abuse... so i find this phone much more of quality than alot of models out there.
[Defy General] EsperSpirit:
A friend of mine also had a dead speaker. We just reflashed 2.1 and when it came back the speaker was repaired and they even updated to 2.2, which made reinstalling 2nd-init and CM7 even easier :D

I guess if you reflash your normal SBF with RSD-Lite, there should be no problem with warranty.
[Samsung Galaxy Nexus] phillybizzle:
Does the Verizon GN support 4EXT recovery or any other recovery styles?
[Samsung Galaxy Nexus] DonJuan692006:
You've got it backwards. The question should be: does 4EXT or any other recovery besides Clockwork mod support the Galaxy Nexus. Also, questions don't go in the development forum.
[Samsung Galaxy Nexus] jayharper08:
No questions in the development section, please. ;)

Sent from the MIUI powered E3D
[Motorola Droid RAZR] dj_spore:
So, now that Fastboot files are out, is there any advantage to running a "safe" system? Is safestrap any slower than bootstrap since the original system is still in place? I don't currently have either installed.

P.S. YAYYYYY, FASTBOOT FILES!!!!!!!!!
[Motorola Droid RAZR] TehWhale:
Safestrap does take longer because it switches between two systems. I just use Droid Razr Bootstrap