yashsingh1/xdaforums huggingface dataset:
[Tilt, TyTN II, MDA Vario III Themes and Apps] newb5000:
@adamkimber: Thanks for posting. I'll give you a shout if I have any questions.

@acedish: Nice work! I'm glad that people are putting the app to good use. The possible error messages that one can get are the following:

RILException: This could mean that the device does not support the RIL layer. I get this error on emulators since they do not have a phone component.

RILApiException: The cell tower info could not be retrieved for some reason. This could be due to the fact that the app is not digitally signed and does not have sufficient permissions to perform its tasks (Smart Phones in particular).

WebException: The web update could not be completed. The host is not reachable using the current connection settings. Try access the URL in Pocket IE and see if that works. If it works in PIE, it must work in the app.

TypeLoadException: You shouldn't get this error because logging is disabled, but once it is enabled in a future update, you would get this error if SQL Server Compact 3.5 is not installed.

ThreadAbortedException: This will be fixed with the next update. Happens if you stop the service while a web update is happening.

A more detailed log of the last error is available in "Program Files\CellID Updater\cidlog.txt" or "Storage Card\Program Files\CellID Updater\cidlog.txt" depending on where you chose to install the app.

I'll send you an email shortly.

@LeeCHeSSS: Thanks for the trace file. I looked at it and think that after 25-7-08 17:49:41 the app was not registered for unattended mode any more. No idea why, but I can add some logic to possibly detect this.

Can you remember if your battery was critically low at some point? It could be that the OS does something extra when the battery is critically low (like force the device into suspend mode), but that is just a guess.

Also, it seems like you have another app running which wakes the device every (on average) 10 minutes or so. That could explain the three power transitions every so often after 17:49:41. I'll do some research and post an update which will hopefully fix the problem, but I'll need you to test it again, please :)
[Tilt, TyTN II, MDA Vario III Themes and Apps] newb5000:
@LeeCHeSSS (and any others who wish to test unattended mode): Here is a newer build of the debug version. Same procedure applies as previously - ensure the service is stopped, replace cidservice.exe with the attached one and then start the service.

I'll need the trace.txt file after you're done testing.

This time, the urls are not logged, so you do not need to edit the trace file at all. Also added a bit more info in the trace file.

What I changed in this version is if a resume event is encountered, the app registers itself once again for unattended mode (because a resume event should not be encountered if in unattended mode).

Thanks for testing.
[Tilt, TyTN II, MDA Vario III Themes and Apps] newb5000:
For any Smart Phone users who get a RILException or RILApiException error, could you try changing a registry value and see if that helps?

HKLM\Security\Policy\APIs\RILGSM\Default

The default should be 2.

Set it first to 1, then see if that helps.

I'm not sure whether a soft reset is required, I'd reset just in case.

If you still get the errors, try setting it to 0.

0 = OEM_CERTIFY_FALSE (Untrusted - No Trust Required)

1 = OEM_CERTIFY_RUN (User Trust Required)

2 = OEM_CERTIFY_TRUST (Kernel Trust Required)

This registry key isn't present on my TyTN II, so I presume it's Smart Phone only?

The necessary disclaimer: Changing registry settings on your device may mess things up :D

Source: http://www.teksoftco.com/forum/viewtopic.php?p=2586
[Tilt, TyTN II, MDA Vario III Themes and Apps] LeeCHeSSS:
I'm pretty sure the phone was not low on battery when I ran the service for that trace log. The program that woke my phone is probably push mail, can't think of anything else that might be responsible.

Anyway, I will run your new build tomorrow and post the log after about a day :)
[Tilt, TyTN II, MDA Vario III Themes and Apps] PizzaRoll:
newb5000,

Can you bring dwRxLevel in to the URL. I would like to work on some location approximating code. If I get something that is relevant, I will make sure I let you guys know. However developing any algorithm is much easier on a Linux box then on the phone itself.

Your program works very well and I would like to use it together data to analyze and to see if I can get more accurate results.
[Tilt, TyTN II, MDA Vario III Themes and Apps] newb5000:
dwRxLevel seems to always return 0 for me.

I'll try using the PhoneSignalStrength event
[Tilt, TyTN II, MDA Vario III Themes and Apps] LeeCHeSSS:
Here's my latest trace log. Sorry for the delay.

I'm still experiencing the occasional lack of updates (for several hours; even though I travel 50km, so switch cells regularly). Turning on the phone causes an update to take place almost immediatly.
[Tilt, TyTN II, MDA Vario III Themes and Apps] newb5000:
Hi guys,

I was out of town for a few days and got back today. Will work on the app as soon as I can.
[Tilt, TyTN II, MDA Vario III Themes and Apps] abat:
Run applications?

Thanks for the excellent, very much awaited app. I am wondering if it is easy to add a functionality ro run a program if cell/lac change, passing the cell and lac as params to the program?
[Tilt, TyTN II, MDA Vario III Themes and Apps] PizzaRoll:
I hope a new update is on the way. I am looking forward to see how the program works out while Im in Mexico.
[Tilt, TyTN II, MDA Vario III Themes and Apps] spen2:
Great App

Hi newb5000,

I've been looking for an app like this for ages, so many others available seem over bloated in my opinion. Thanks for all your hard work. I will use it for tracking our service engineers where i dont need the acuracy of a gps. I have been trying out on a palm 750 wm6 professional and it works perfectly. Active sync is always running on their phones for email anyway so your app has no real impact on the battery life as far as i can see. Thanks again and keep up the good work :)
[Tilt, TyTN II, MDA Vario III Themes and Apps] spen2:
Display tracks from cellidupdater on Google maps

Hi, Does anyone know of an application that I could run on my pc that would display cellid data etc from newb5000's application as gps tracks in google maps? It would be great if i could point the cellidupdater to this application using a static ip and port. The app would need to translate into gps cordinates using googles my location to be displayed in google maps in real time. Something like a plug in for the web browser? I have used www.baeeo.com which is great and does exactly what i need, but i'd like to be able to send the cell id info to my own PC and not have to rely on using someones web server. Does anything like this currently exist or would it be possible to do?
[Tilt, TyTN II, MDA Vario III Themes and Apps] xhozt:
got it working but baeeo.com is not receving the info apparantly .. i keep geting the searching page when i check .. using a blackjack 1 here with da_g's 6.1
[Tilt, TyTN II, MDA Vario III Themes and Apps] PizzaRoll:
There is another program very similar to this but it is not as simple. you might want to look in to it. if you search on the forum for Google maps GPS/Cellid Track me you should be able to find it.

Otherwise as for a program to convert you location in real-time to a KML. I have not heard of one. However, if you have a few hours and know Java/PHP/Perl, pick your poison, you should be able to produce something relatively easily. I don't need to state that is the beauty of this program is that it uses standard HTTP GETs to transfer the data. Thus, it is extremely easy to use the data with any server side scripts.

I currently just have a perl script which resloves the Cellid to Cords, caches the information, and then saves it to a running log. If you are intrested in it when i get back to the U.S., I can send it to you.
[Tilt, TyTN II, MDA Vario III Themes and Apps] spen2:
Yeah, i've tried that. Its very good but has lots of other functionality that i just don't need for my setup.

The above mentioned track me app offers a demo server that you can download, i have set that up on my own xampp server and it is exactly the sort of thing i'm looking for, but just using cellidupdater instead. I really like the simplicity of cellid updater, you dont even notice the thing running on your device.

That would be great, i dont have any experience writing scripts so anything that you have done for this purpose would be much appreciated. I take it i could use it on my xampp server?
[Tilt, TyTN II, MDA Vario III Themes and Apps] PizzaRoll:
Again when I get back to the US I can post the script or if I get enough free time ill just write a more robust version and post it up. Currently I am in Mexico and my Internet connection/router is having problems so that destroys the possibility of retrieving it :mad:

You would be able to run it on your server. I just have a Standard Debian (Linux) box which runs apache2. The HTTP server executes the script in Perl and dumps the time, cords, and cellid to a text file.

if you want to interface it with your xampp that will require a more in depth knowledge of that program. If anybody knows more about the program let me know and I might be able to make some cross connecting software.

Ultimately I would like to make some software to do this but at the moment just a text log file works for me

-------------------------------------------

Found the HTTP call for the xampp server

"http://luisespinosa.com/trackme/requests.php?action=upload&username=USER&password=PASS&lat=20.2482086166667&long=28.2732949&dateadded=2007-10-30 9:57:10&dateoccurred=2007-10-30 9:57:10&tripname="

Well time to set up a xampp server and start programming.
[Tilt, TyTN II, MDA Vario III Themes and Apps] khaytsus:
XAMPP has a Perl add-on. I am unfortunately tied to using a Windows server at work, but needed to write some CGI's, so XAMPP was the first thing I found and it works.. Have to do a little conversion between my own development environment (Linux) and it, but very little.
[Tilt, TyTN II, MDA Vario III Themes and Apps] spen2:
Use cellid updater with gpsgate.com

I've modified the php script towards the begining of this thread so that it echo's to gpsgate.com's free online location server. The http call for that if anyone is interested is http://online.gpsgate.com/GpsGate.aspx?longitude=$lon&latitude=$lat&imei=$imei

You just have to sign up to a free account and add the imei of your device to the preference section. Works very well:)
[Tilt, TyTN II, MDA Vario III Themes and Apps] newb5000:
Guys,

I really apologise for taking this long. Too many things have happened these past few weeks. That's no excuse, of course, since I did commit to this project from the start. So what I've decided to do is complete what I've been working on for some time, release an update, as well as release the source code in hope that someone with a bit more time will be able to improve on the app.

I will try to respond to every request that I've had either publicly, via PM or via email this week and will release everything this week as well. No use keeping everyone in suspense when I don't have nearly enough time to work on this project as much as I would have liked to, depite the fact that I really enjoy working on this.

So, expect a post from me this week - just cleaning up the code a bit.

This does not mean that I'm giving up on this project completely, but I feel it's time that those who have been following the progress of this app do receive an update.

Again, apologies for the delay.
[Tilt, TyTN II, MDA Vario III Themes and Apps] LeeCHeSSS:
I'll just provide the simple script I wrote for those who do not know how to create one of their own. You'll need to edit both files to include your Google Maps API key and your database configuration.

I'm open to suggestions/comments, but don't expect me to reply within a day :)
[Tilt, TyTN II, MDA Vario III Themes and Apps] katwork:
Do you have a sql script to create the database tables? I came up with this after playing around with the code.

CREATE TABLE `cell` (
`uid` int(10) unsigned NOT NULL auto_increment,
`cellid` int(11) NOT NULL default '0',
`mnc` int(11) NOT NULL default '0',
`mcc` int(11) NOT NULL default '0',
`lac` int(11) NOT NULL default '0',
`longitude` int(11) NOT NULL default '0',
`latitude` int(11) NOT NULL default '0',
PRIMARY KEY (`uid`),
KEY `I_cellid` (`cellid`),
KEY `I_allcellinfo` (`cellid`,`mnc`,`mcc`,`lac`),
KEY `I_latlon` (`longitude`,`latitude`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `log` (
`uid` int(10) unsigned NOT NULL auto_increment,
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`cellid` int(11) NOT NULL default '0',
PRIMARY KEY (`uid`),
KEY `I_timestamp` (`timestamp`),
KEY `I_cellid` (`cellid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

For those with MySQL 4.x the code has some queries that only work with MySql 5.x. I had to change the following in whereami.php to work with 4.x.

Change line 47 from
$strQuery = "SELECT *, TIMESTAMPDIFF(MINUTE, timestamp, NOW()) AS age
to something like:
$strQuery = "SELECT *, TIMEDIFF(NOW(), timestamp) AS age

Note: the above change doesn't give you minutes it gives you the
time difference in h:mm:ss form. If someone knows how to get just
the number of minutes in MySQL 4.x please share.

and change purgeLog() from
$strQuery = "DELETE FROM log
WHERE TIMESTAMPDIFF(DAY, timestamp, NOW()) > 0";
to something like:
$strQuery = "SELECT * FROM log
WHERE DATE_ADD(timestamp, INTERVAL 24 HOUR) < NOW()";
[Tilt, TyTN II, MDA Vario III Themes and Apps] katwork:
Is it normal for all cell entries to have the same mnc, mcc, and lac values?

I installed 0.4 fixed yesterday and between home and work I picked up 24 different cellids, but the mnc, mcc, and lac values were the same for all the HTTP requests sent to my web server. Only the cellid was different.

I installed the latest debug service a little while ago and the one tower it has logged so far still has the same mnc, mcc, and lac values as before. I have an AT&T Tilt running the latest stock AT&T WM 6.0 ROM and the program is installed on the SD card.

Edit: I did a little searching and found out what mnc, mcc, and lac mean. The Network Code and Country Code won't change and I'm guessing the Location Area Code is for a large area and that won't change either. So I guess I just need to figure out why all 24 cellids get the same latitude and longitude from Google (using LeeCHeSSS's code) and why the lat and lon is 25+ miles away from me...
[Tilt, TyTN II, MDA Vario III Themes and Apps] spen2:
I guess not many people in your area have been using google maps for mobile. Googles database is updated by users of that i believe.
[Tilt, TyTN II, MDA Vario III Themes and Apps] khaytsus:
newb5000,

I have one question that's always bugged me, but wasn't quite sure what context to ask it in..

Why does CellID take 3M of ram? It seems like it's a fairly 'simple' program in that there aren't a bazillion options, graphics, etc..

I'm sure there's some reason, so I've held off on asking, but figured I might as well. :)
[Tilt, TyTN II, MDA Vario III Themes and Apps] katwork:
Google Maps (mobile) has no problem finding a cell tower close to me when I am not using the GPS. Plus I live in the bay area (about 45 minutes away from Google) so I'm pretty sure the problem is not due to lack of users using it in my area. :) I have 63 cellids in the database now and they all have the same latitude and longitude. I'm pretty sure the problem is with the script getting the values from google or my database. Without a script to create the tables I had to guess the fields and types. I haven't had time to debug the problem yet. I need to double check my google maps key and print out the data coming back from google to see if what is in the database matches what is coming back from google.
[Tilt, TyTN II, MDA Vario III Themes and Apps] katwork:
I dumped what google was sending back and it was sending floats back for lat and lon. I had tried doubles for those fields originally and didn't get any data so I changed them to integers and got data (though truncated). I changed those fields to floats in the database and now I get the correct values. So it's working now. The updated script to create the cell table is:

--
-- Table structure for table `cell`
--
CREATE TABLE `cell` (
`uid` int(10) unsigned NOT NULL auto_increment,
`cellid` int(11) NOT NULL default '0',
`mnc` int(11) NOT NULL default '0',
`mcc` int(11) NOT NULL default '0',
`lac` int(11) NOT NULL default '0',
`longitude` float NOT NULL default '0',
`latitude` float NOT NULL default '0',
PRIMARY KEY (`uid`),
KEY `I_cellid` (`cellid`),
KEY `I_allcellinfo` (`cellid`,`mnc`,`mcc`,`lac`),
KEY `I_latlon` (`longitude`,`latitude`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
[Tilt, TyTN II, MDA Vario III Themes and Apps] LeeCHeSSS:
Nice work on getting the databasestructure available, I should've thought of that myself :)

For what it's worth, this is my database structure (which is actually flawed because the maximum values for longitude won't fit correctly):

--
-- Database: `DBtst`
--

-- --------------------------------------------------------

--
-- Tabel structuur voor tabel `cell`
--

CREATE TABLE `cell` (
`uid` int(11) NOT NULL auto_increment,
`cellid` int(11) NOT NULL,
`mnc` int(11) NOT NULL,
`mcc` int(11) NOT NULL,
`lac` int(11) NOT NULL,
`latitude` decimal(8,6) NOT NULL,
`longitude` decimal(8,6) NOT NULL,
PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabel structuur voor tabel `log`
--

CREATE TABLE `log` (
`uid` int(11) NOT NULL auto_increment,
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`cellid` int(10) unsigned NOT NULL,
PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

I also should have mentioned that you should use the script with the url http://yourdomain/whereami.php?do=log&cid={cellid}&mnc={mnc}&mcc={mcc}&lac={lac}

If you open the script in your browser (http://yourdomain/whereami.php?do=read OR http://yourdomain/whereami.php?do=readall) you'll get a nice map of your "current" cell, or all the cells in your database. I have thought about making the map figure out its' zoomlevel automatically, but was too lazy :P
[Tilt, TyTN II, MDA Vario III Themes and Apps] spen2:
Hi newb5000,

Any chance you can grab the imei number of the device so it can be added to the url with {imei}? Don't worry if its not possible i can just type it out, thought it could be useful to others as well though. Looking forword to the next update :)

Thanks
[Tilt, TyTN II, MDA Vario III Themes and Apps] spen2:
Hi newb5000,

I guess you are very busy at the moment but i dont suppose you know when you will be able to release an update do you? It already works really well when I use the updated cidservice.exe for unattended mode, so would be great if you could release a cab update that uses that version of cidservice.exe. I really appreciate all your work so far on this program and understand that you must have other commitments, but i hope you can finish it of and release the source code so other can continue what you started.

Thanks Again:)
[Tilt, TyTN II, MDA Vario III Themes and Apps] dzalbo:
thread is dead? :)

anybody done something similar for Symbian?
[Tilt, TyTN II, MDA Vario III Themes and Apps] spen2:
Looks like it unfortunately. Check out Viking Informatics locator 2.20 http://www.viking.tm/product.php?id=11

This serves a similar purpose on the symbian platform.
[Tilt, TyTN II, MDA Vario III Themes and Apps] khaytsus:
What does this thread, or this entire forum, have to do with Symbian??

Anywho, I honestly don't know what else this program could do without expanding its scope.. I still think it uses too much ram, memmaid reports it using 1.4 to sometimes 3m of ram, which seems awfully high. Other than that, it just works and I never even have to think about it.

I leave it running 24/7 to do low accuracy tracking. When I want higher resolution tracking, I fire up TrackMe with my GPS. Eventually I'm going to write a web service that'll take data from Newb's program and put the data into TrackMe's database so the data is all in one place.

Although to be honest, some day in the future, I'd like to be able to run TrackMe as I currently do CellID and when I want higher resolution tracking I just turn on the GPS and things automatically happen. But until that happens, I'll continue to use Newb's program. I never even know it's there in the background quietly doing its job. :)
[Tilt, TyTN II, MDA Vario III Themes and Apps] spen2:
I agree, this app does the job it was meant to do, I'd just like to see it finished of with an installer that includes the updated cidservice.exe and like you say, maybe an improvement to the ram usage if possible. But really these are just small issues, apart from them, its spot on :)
[Tilt, TyTN II, MDA Vario III Themes and Apps] acedish:
Source

Hi Newb, An chance of releasing the source code? I think there is alot of interest from others including myself to continue on development on a great app.

ACE
[Tilt, TyTN II, MDA Vario III Themes and Apps] spen2:
Using WinCE cab manager I have updated the latest .cab in the thread so it installs with the latest cidservice.exe created by newb5000 for unattended mode. cab file attached.
[Tilt, TyTN II, MDA Vario III Themes and Apps] RiverRat812:
First time post from a long time lurker....

It looks like this project has slowed down but I thought I would add some interesting info...

I'm an AT&T subscriber located in the Northeast US and I have just downloaded this to try it out.

The program is giving me a 5 digit CELLID. Even though I am stationary, the CELLID is changing (actually, only the last digit is changing).

So, for those of you seeing multiple CELLID's at the same LAT/LON:

The 1st 4 digits of the CELLID are the same as the AT&T SITE #

The last digit could reference the radio/cabinet you are connected to at that time.

I verified this with data from the Cingular/AT&T Integration project as well as the data from my last UMTS Tracker database.
[Tilt, TyTN II, MDA Vario III Themes and Apps] khaytsus:
Now that is interesting news, and explains some things. I've only seen it on a few towers, but there's two near my house and one near work which I am constantly seeing multiple identifications from.

One near work has four CID's on it! Using OpenCellClient (search this forum) it's obvious that they're all coming from the same tower. So that 'splains that.

Thanks for the input! Not sure what exactly to do about it, but at least I know I'm not crazy or getting weird results ;-)
[Tilt, TyTN II, MDA Vario III Themes and Apps] mr.pohoda:
I was also interested in this topic and I'm working on application which would show all cell towers in range. The problem is that this issue is hardware-specific and can differ even with different rom. I still believe that I can make it. If someone has any tips, let me know.
[Tilt, TyTN II, MDA Vario III Themes and Apps] CLShortFuse:
I wrote a GPS application about a month ago. I actually took it one step further by getting the cell tower ID and cross referencing it with Google Maps' database to get the cell tower GPS position. The goal was to use that to help the GPS device get a quicker fix. I wasn't able to get all active cell towers so I couldn't do a signal triangulation.

I haven't worked on it in a while actually, but if you're interested, it's here: http://xdaforums.com/showthread.php?t=474582&page=5
[Tilt, TyTN II, MDA Vario III Themes and Apps] fboutevi:
Is it possible to have source code of this small application, it's working great for me :)
[Tilt, TyTN II, MDA Vario III Themes and Apps] fboutevi:
Is it possible to have source code of this small application "GetCellId.exe" ? It's working great for me :)
[Tilt, TyTN II, MDA Vario III Themes and Apps] croisez:
GetCellID.zip source code?

Hi,

could you be so kind to send me the source code of your GetCellID.exe binary you sent to xda-dev forum on 19th May 2008, 06:46 PM?

Thank you so much.

:Louis.