digiblur

I'm on engineers tower on lte posting to here right now so maybe it's just an issue on just the sector that faces versabar.

 

Sent from my SPH-L710 using Tapatalk

The S3 isn't affected by Ericsson forgetting the CSFB patch on the new customer launched band 26 sites.  Only the newer devices that have the walmart logo feature on them. 

They don't know any better, they are rolling out things in their eyes testing with their aircards and EVO LTEs. Just keep calling in or email Dan@Sprint.com.

I'm on phone with a technician shes saying they thinks its a network issue.... but is any other sprint user having these same problems? Phone keeps saying roaming, not roaming, wont connect to 3g now .... basically the phone is now a paper weight

Someone is forgetting a step on the list. So now your phone along with many others are getting blocked from using LTE. Lots of phones end up on 3G and data issues then start.

Once Ericsson gets the CSFB configured correctly on their launched 800LTE there it will start working again.

I guess a good question to follow up the news that the update has been pushed back is how back to square one is the LTE issue

 

Sent from my Nexus 5 using Tapatalk

What?

If it is because of an e/CSFB issue then it should be fixed at some point. Did you get any type of error message when trying to make calls while on LTE? I know when i experienced CSFB problems i got the the "Mobile Network Not Available" message. I also have issues keeping LTE signal in my home and my office. Both have WiFi so it's not a huge deal.

 

Also, which radio are you using?

I never saw an error, just the call would be missed. Only time I saw an error is when I tried to text or call out. It would fail until I shut off LTE.

Okay, so what I did was pull the .db file locally onto my PC and then made the changes I desired. However, when I try to send (paste) the file back into the correct folder, I get a permissions error saying it cannot proceed with the operation.

 

I am very new to doing anything like this with my phone. Do you have any suggestions?

Not sure I just copied it to my storage root folder from my PC then on my phone I copied it to the right folder.

Just an update. This is working for me so far. Calls are stable after changing preferred network type to 3G. WiFi provides the data. Kind of annoying to have to switch when leaving though, I may see if Tasker or some other app can automate this.

 

Thanks for the help guys.

That's what I had to do due to marginal signal. Drives you nuts with the toggling and makes you hope for 800 LTE and 1x to make it to that area quickly.

Unfortunately however, many small towns (at least the ones around me) don't require building permits for site upgrades.

 

Sent from my Nexus 5 using Tapatalk

Same thing here even in our big metro area.  Permits aren't required for site upgrades.  I've only seen them on brand new sites that AT&T or Verizon put up.

Yeah I work with databases all the times as a developer. Mostly Oracle, but if I can just find the .db file then I'd be fine.

Copy the /data/data/com.blueline.signalcheck/databases/signalcheck_log.db file from one phone to the other

Won't be long....

 

insert into sites_lte

select null,null, null, null, null, null, null, null, user_note,null,import1.plmn as plmn,substr(gci,1,6)||sectornum AS gci,null,null,null

from sectornum1

inner join import1 on sectornum1.plmn = import1.plmn

where gci <> ''

order by import1.gci

 

 

Here are two posts that will help.

Mike - (or anyone that can answer this) How can I go about editing the logging database? I have done a little bit of work in a premier thread for my market where we have pretty much every GCI and corresponding notes for each site. I would like to import that data into the lte-sites table in the SignalCheck database.

 

Is that going to be possible? I think I read somewhere that the database is located in the data/data/ folder... Therefore, do I need root access? All I need to know for sure is where the database is located and if I need root access. I'm a software/web developer myself, so once I get my hands on the database I can certainly get the information inserted into it. (actually took a class a few years back on Android development, but it certainly isn't my cup of tea. I have a lot of respect for the work you do.)

Not sure if you need root to get it. It's just sqllite so you can do all sorts of imports mash ups or whatever. Pretty easy to import but I am an ETL/DBA person.

My phone doesn't pickup band 26 like some have said it will. Is 26 a guarantee without the update, and the band enabled? Or do we still not know. I'm stock with the .23 radio

 

Sent from my Nexus 5

Running the 23 radio and it was switching to B26 by itself. I did check to see if the band was enabled and it was along with B41.

im wondering... anyone else know if other networks have issues with the different radios? i.e. Did the .23 radio improve performance on GSM networks?

No difference when using it on band 4 or band 17.

New feature request... Sound/vibrate option on a LTE site that has no note.

 

I'm glad the app tells users to not make vertical videos. Apple needs to disable vertical video in their phones.

I wish they would do that too!!!  I could see those iphone users..  "what?  turn it side ways?  that would put me in the video?!?!  stupid apple!"

I loaded 1900+ sectors into the LTE sites table.  Look ups seem to be quick, I don't think I would notice a difference with an index on the GCI.  You can't really tell of course since you don't know when it changes from site to site down to the split second anyways.

Won't be long....

insert into sites_lte
select null,null, null, null, null, null, null, null, user_note,null,import1.plmn as plmn,substr(gci,1,6)||sectornum AS gci,null,null,null
from sectornum1
inner join import1 on sectornum1.plmn = import1.plmn
where gci <> ''
order by import1.gci

mikejeep, great update!  I read back a few pages and didn't see this addressed.  Perhaps there's already a method, but I've been adding tower notes on all my LTE towers.  Is there a way to export that, then import that into a new phone?  I'm going to upgrading to the S5 soon and don't want to lose all my work! 

Copy the /data/data/com.blueline.signalcheck/databases/signalcheck_log.db file from one phone to the other

Mike, 

 

I am getting some errors with GCI in the log. I'm not sure what exactly is going on but it should be 05610E02 and 05610E01. This is what comes up in the log.

5.61E+05

5.61E+04

 

Another 

4.90E+01

should be 49E00##

 

Another 

5.63E+05

should be 05628E02

 

Edit: I found the problem, Excel thinks that its an equation of some sort.

I believe there is an option in the settings to prevent this.

 

This is kind of tricky to explain and will probably make some heads spin, but I will try to be as clear as possible..

 

When you connect to an LTE site, the app queries the database looking for the first entry that matches the first (left) 6 characters of the GCI. As soon as it finds a match, it grabs that note and does not look any further. I believe by "first entry", it would be the entry that appears in the database first without any sorting/filtering applied.

 

No head spinning here, exactly how I thought it was designed;updates and select statements in SQL based on the first 6.  I do understand the wrestling with different things.  In order to cover this "what if" of one sector getting a name and not the other is, I would do something like this on your lookup:

select max(user_note) from sites_lte where substr(gci,1,6) = '02D2B2'

I think in my script for the CSV import I'm going to duplicate the three rows in order to have all the sites in there.  Curious to see the lookup speed with 1000+ rows.  Will test it with an index as well.

I can work with that.. I just want to make sure there are no band 25 sites with sectors labeled 0F or higher. That would be in direct conflict with band 26 sites elsewhere.

 

-Mike

Yes very different aspects on different OEMs.  On AT&T with Ericsson gear, they do the 0F, 10, 11 for Band 17, then 16, 17, 18 for Band 4.  The PCIs are in order, no 169 offset, (ex: 231, 232, 233).  If you drop the sector number, convert to decimal, add 4000, and convert back to hex this will give you the GCI for the Band 4 side of the site.  Interesting the different designs and such between companies and OEMs.

...said the Road Runner to the entire clan of Coyotes.

I have some testing to do myself, then I'll test it on a couple folks with Sprint phones to make sure I got their GCIs right, by that time mikejeep might have written something already though.  We will see..

Mike,

Questions on the database.  I'm writing some queries to convert some data over and thought of something.  Say for instance I've only attached to the alpha sector on a site.  I hit add note on that sector and put in my note.  Of course the app updates that row in the database, if I pass the alpha sector again it will of course show it.  Now say I pass on the beta or gamma side won't the application make two additional rows in the database?  Will it automatically copy the note from the previous north sector?  or will I end up with two rows for this site with no note?  Depending on how things fall in the database this might show up blank right?  I believe you said you were doing a select query just based on the left 6 of the GCI and MCC/MNC right?

I think I'm going to run an update query to automatically make the three rows for each site to cover all the bases but it was just one of those "what if" moments that someone might run into.

I haven't brought the N5 over to an international parties yet but I have used several domestic SIMs.  There really isn't a Sprint model per say but mine did come from Sprint with a Sprint SIM pre-installed.  There's no locking or unlocking.  Just pop out the SIM, put in the new SIM and reboot.  You will need to make sure and use the correct APN for your provider if it automatically does not populate.  The only issue I had was once or twice I had to go into the Radio info short cut to make sure it was on LTE/GSM mode, I'm sure it would have changed by itself but I was probably impatient.  You can easily go back to Sprint when you get back, just pop in your Sprint SIM.  No need to call Sprint or anything as long as it is still active on your account.

Let's so who's the quickest to make a script to import a little CSV file of GCI's and site notes into the Sqlite database  

One more thing...my gs4 got a strong LTE signal all over the metro area. So I don't get why my n5 can't get LTE in the exact same places.

You have to have a bad phone. I heard someone else that had the same issue.

The update will probably start to seed out tonight or early tomorrow unless someone posted the info on Sprint's version page really early.

Then we can queue up all the posts people saying they didn't get it yet and their location.

Take it from Google themselves when they said it, if you want it early in the rollout, load it yourself. It's super simple on an open phone.