[GUIDE] Add custom city to HTC Sense Weather
 

1. Download SQLite Database Browser and unzip the folder to your desktop

2. On your phone, using either Root Explorer (Downloadable in Market) or ADB, copy/or pull the file WPDB.zip from /system/etc and place it on your desktop. (This file contains all weather databases for all languages)

3. Unzip the WPDB.zip file on your desktop and you will see several database files contained inside. The one we want to edit is WP_0409WWE

4. Inside of the SQLite folder, open SQLite Database Browser 2.0 b1
http://i158.photobucket.com/albums/t.../Capture-1.jpg

5. On the top of the window, click the open folder and open the WP_0409WWE from within the WPDB.zip folder you unzipped
http://i158.photobucket.com/albums/t...3/Capture2.jpg

6. Click on the "Browse Data" Tab

7. Click "Table:" and then on the drop down menu next to it select "locationlist" and it will populate all of your locations below
http://i158.photobucket.com/albums/t...cationlist.jpg

8. To add your location, go to www.accuweather.com and type in your local city and get the weather. What we are after is how Accuweather has the name spelled out in the web address. Here is an example of Seaside Heights, NJ for allof you first pumpers: http://www.accuweather.com/us/nj/seaside-heights/08751/city-weather-forecast.asp

9. Now in SQLite, on the top right, select "New Record"

10. You will now have an empty line at the bottom where we will enter our new location data. Double-click on the empty box under the "code" column and enter text in this format: NAM|US|<state>|<city> So, for example, NAM|US|NJ|SEASIDE-HEIGHTS (These will be ALL CAPS with no spaces or line breaks after the block of text (you can have spaces in the city name)
http://i158.photobucket.com/albums/t...83/SEASIDE.jpg

**Extremely Important** The city name you enter in the "code" column MUST be how it shows in the accuweather web adress.

11. Under the "name" column, put the desired city name without any spaces or line breaks after the block of text. Example would be "Seaside Heights"

12. Under the "state" column, put the state abbreviation, Example, "NJ"

13. Under the "timezone" column, the values are 300, 360, 420, or 480, depending on what your timezone is:

Eastern time - 300
Central time - 360
Mountain time - 420
Pacific time - 480

14. Under the "timezoneld" column, put either "America/New_York", "America/Chicago", "America/Denver", or "America/Los_Angeles" in, again, depending on the timezone you live in:

Eastern time - America/New_York
Central time - America/Chicago
Mountain time - America/Denver
Pacific time - America/Los_Angeles

15. Once you are finished adding locations, Go to "File" and "Save Database"

16. In the WPDB.zip folder, select all files and repack them into a .zip folder named WPDB.zip.

17. Paste/Push this file back into /system/etc (If you are using Root Explorer, remount the system in read/write mode to delete the old file)

18. Reboot your phone and you should now be able to add your custom cities within the weather app

**If you have any problem after rebooting, go to Settings>Applications>Manage Applications>Running>Weather Provider and "Clear Data" Then go into the Weather app and add your cities.

Re: [GUIDE] Add your custom city to HTC Sense Weather on your EVO 4G!
 

nice write up. i've been wondering about this. i'm lazy tho so im thinking i will just wait until someone comes out with a file of all us cities like they had for the tp2. lol

Re: [GUIDE] Add your custom city to HTC Sense Weather on your EVO 4G!
 

Working on it as we speak

Re: [GUIDE] Add your custom city to HTC Sense Weather on your EVO 4G!
 

nice. let me know. it may be worth writing an article about to call folks attention to it. it's something that we've had with winmo phones but not with our evos yet.

Re: [GUIDE] Add your custom city to HTC Sense Weather on your EVO 4G!
 

Trick is that the old file for Windows Mobile which had all of the databases for the US do not all contain the "code" table in the format we need.

Re: [GUIDE] Add your custom city to HTC Sense Weather on your EVO 4G!
 

that sucks.

Re: [GUIDE] Add your custom city to HTC Sense Weather on your EVO 4G!
 

May have found something that will work...I will do some testing

Re: [GUIDE] Add custom city to HTC Sense Weather | Attached file w/all US cities incl
 

Right on think we need to buy you some beer

Wirelessly posted (Mozilla/5.0 (Linux; U; Android 2.2; en-us; Sprint APA9292KT Build/FRF91) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1)

I asked this months ago. Great work. Will leave thanks when I get to my computer. ( I hate that certain functionality doesn't exist with the mobile version).

Re: [GUIDE] Add custom city to HTC Sense Weather | Attached file w/all US cities incl
 

I'm up early this morning and I noticed the title of the thread has changed. Nice! Only one question. Where is the file?

Re: [GUIDE] Add custom city to HTC Sense Weather | Attached file w/all US cities incl
 

lol, forgot to remove that from the title last night. I am still working on it so I uremoved it. I will update when complete. :D

Re: [GUIDE] Add custom city to HTC Sense Weather
 

That rocks! Worked great!

Kick ass, can't wait till you have that list done.

Sent from my PC36100 using Tapatalk

Re: [GUIDE] Add custom city to HTC Sense Weather | Attached file w/all US cities incl
 

GWell hell. Lol

Re: [GUIDE] Add custom city to HTC Sense Weather
 

A quick note.
Pay attention to the time zone for your locations.
For Arizona use America/Phoenix
Arizona doesn't conform to daylight savings and this might also screw up your clock. I believe the clock uses the same database for world time.
Just to be safe check a location close to the one your adding to the database for the correct timezoneid.

Re: [GUIDE] Add custom city to HTC Sense Weather
 

where do you find the Alaska and Hawaii time zone codes

Re: [GUIDE] Add custom city to HTC Sense Weather
 

Alaska 540 America/Anchorage
Hawaii 600 Pacific/Honolulu

Re: [GUIDE] Add custom city to HTC Sense Weather
 

where did you find them?

Re: [GUIDE] Add custom city to HTC Sense Weather
 

If you open the database and scroll through you can find locations for Honolulu and for Anchorage. Once you find the locations, just scroll across and find those settings.

Re: [GUIDE] Add custom city to HTC Sense Weather
 

I am having one issue. I am not sure how to get the zip back to device. I was able to get the WPDB.zip over by emailing to my computer but to get it back on the device I am stumped?

Wirelessly posted (Mozilla/5.0 (Linux; U; Android 2.2; en-us; Sprint APA9292KT Build/FRF91) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1)

Plug your phone into your computer and transfer the zip to the sd card.

Re: [GUIDE] Add custom city to HTC Sense Weather
 

Thanks Kevin but I got that far..How to get from sd card to that area? I cant seem to find a way to transfer it to that area?

Re: [GUIDE] Add custom city to HTC Sense Weather
 

i will wait for the APK, i need ASTORIA, NY lol...
Thanx

Wirelessly posted (Mozilla/5.0 (Linux; U; Android 2.2; en-us; Sprint APA9292KT Build/FRF91) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1)

With your phone rooted, open root explorer and copy the zip. Navigate to the directory and click on the icon "mount rw". Now you can paste the zip to the directory and overwrite the old one. From there make sure you clear the cache as stated in the OP.

Wirelessly posted (Mozilla/5.0 (Linux; U; Android 2.2; en-us; Sprint APA9292KT Build/FRF91) AppleWebKit/533.1 (KHTML, like Gecko) Version/4.0 Mobile Safari/533.1)

Don't hold your breath.

Re: [GUIDE] Add custom city to HTC Sense Weather
 

what if we dont have root explorer?
i've been trying to push it in shell, but i keep getting read only system file, and no chmod command works, or the mount -o rw,remount either, i'm rooted, and in su in the adb terminal
i've googled to hell and back and its all the same suggestions of chmod and/or mount-remount neither of which works for me for some reason i must be missing something critical obviously...
my linux-fu has only been occasionally exercised since it was strong a decade and a half ago...

Download root explorer from the market, its a free app.

Sent from my PC36100 using Tapatalk

Re: [GUIDE] Add custom city to HTC Sense Weather
 

the only root explorer i found wasn't free, it was like 5 bucks lol
i found another similar program that was free and that let me copy the file over, but for some reason my added city doesn't show up... so tryin the whole process over to make sure
and yes i rebooted after putting the new WDMB.zip file in

addendum
but i didn't do the clear data, and that fixed it lol

Re: [GUIDE] Add your custom city to HTC Sense Weather on your EVO 4G!
 

I've been waiting for the custom database too. Any progress on this?

Re: [GUIDE] Add custom city to HTC Sense Weather
 

I have not seen any development on this. Customizing your database is easy, just give it a try.

Re: [GUIDE] Add your custom city to HTC Sense Weather on your EVO 4G!
 

any luck with us only weather?

Re: [GUIDE] Add custom city to HTC Sense Weather
 

I added the cities I wanted using the directions from the first post. I know very little about SQL, but it seems like it should be fairly easy for someone knowledgeable to manipulate the fields of the full US database used on WM phones and modify it to work on Android.

Re: [GUIDE] Add custom city to HTC Sense Weather
 

Ok, guys and gals...

I've tried this 3-4 different times, following the instructions to the letter. The first time, it froze sense (thankfully I made a backup of the original file and reinstalled it). Each Subsequent time I've tried, sense worked fine, however, my cities never showed up. I've checked the file after confirming this and my entries are still there.

I have re-booted and cleared the weather data and still nothing.

Please help.

Thanks!!

Edit:

If someone is still working on an ALL United States Database, I would be very interested in it.

Re: [GUIDE] Add custom city to HTC Sense Weather
 

i was contemplating just deleting all the overseas weather locations but unfortunately there doesn't seem to be a way to bulk delete entries in the sql browser, and with several thousand total entries, that would be rather time consuming to have to do it one by one

Re: [GUIDE] Add custom city to HTC Sense Weather
 

here is a file for you threetima
Make sure you do a force close on weather and clear the cache for weather provider.

Re: [GUIDE] Add custom city to HTC Sense Weather
 

is that a stock database?

Re: [GUIDE] Add custom city to HTC Sense Weather
 

Thanks a lot, man... I'll let you know how it works out... :D

Edit:

It seems to work just fine man. I don't know what I was doing wrong.. but you have my eternal gratitude.

Re: [GUIDE] Add custom city to HTC Sense Weather
 

No... it's made from the stock.. but has a few additions....

I've done the process a few times with listtle luck so have asked help... hence the post.. :)

Re: [GUIDE] Add custom city to HTC Sense Weather
 

Yes its the stock with the cities threetima needed added.

Re: [GUIDE] Add custom city to HTC Sense Weather
 

Here's a weird one. I go to add Brentwood, CA and Danville, CA. When I click on get more info online, it gives me Brentwood, TN and Danville, VA respectively. I added the cities to the SQL editor exactly as instructed. :confused: