Jump to content
bluebook14

Igor's list improvements

1 post in this topic

Recommended Posts

I did a bit of a search for these issues, and some were mentioned a long time ago.

I use Igor's list to get an estimate of when people are getting approved, and how many people are still stuck at the 2+ month range at the CSC. I've noticed several issues:

Date Sorting

In the "Last 15" section, there are entries which are sorted incorrectly (for example, currently the 'latest' result is "2015-6-23", which is really meant to be "06-23" but since "6" lexically follows "06", it displays. This is probably fixable in the SQL itself (to normalize the date format before sorting).

Approval dates in the future

There are timelines which have approval dates in the future. This messes up the "Last 15" list. It should be possible to either prevent people from placing dates in the future in the timeline, or to modify the SQL accordingly so that dates in the future.

Inactive Timelines

As mentioned in other threads, some users no longer exist, while it's also evident that some users simply haven't logged in within a given timeframe. I suggest that by default, pending timelines (i.e. timelines which don't yet have an approval) should only be displayed if the associated account logged in within the past month (there should be an option to override this). This will make the graphs near closer to 100% for previous months, and clearly highlight those that are waiting actively.

Provide CSV Export

In lieu of making all these interface changes, allowing the possibility of exporting to CSV could be helpful for folks like me to import into a local database and filter locally.

I might be able to help with some of these changes, if y'all are interested (I'm fairly busy, but I'm hoping these are all fairly trivial things to implement).


 
Spoiler

AOS

10/23/2015: File for AOS, AP and EAD

10/31/2015: NOA1 for AOS, AP and EAD

11/16/2015: Biometrics Appointment Letter received
11/25/2015: Biometrics Appointment
12/16/2015: e-mail about Interview scheduled for 2/10/2016
12/18/2015: Physical Interview Appointment in mail

01/25/2016: EAD & AP cards received in mail

02/10/2016: Interview @ local USCIS

02/11/2016: Approval

02/17/2016: GC received!

09/27/2017: Moved to FL

ROC

01/27/2018: Filed I751

02/05/2018: NOA1 received, GC extended for 1 year

event.png

 
event.png
 
 

Share this post


Link to post
Share on other sites
 

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
- Back to Top -


Important Disclaimer: Please read carefully the Visajourney.com Terms of Service. If you do not agree to the Terms of Service you should not access or view any page (including this page) on VisaJourney.com. Answers and comments provided on Visajourney.com Forums are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Visajourney.com does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. VisaJourney.com does not condone immigration fraud in any way, shape or manner. VisaJourney.com recommends that if any member or user knows directly of someone involved in fraudulent or illegal activity, that they report such activity directly to the Department of Homeland Security, Immigration and Customs Enforcement. You can contact ICE via email at Immigration.Reply@dhs.gov or you can telephone ICE at 1-866-347-2423. All reported threads/posts containing reference to immigration fraud or illegal activities will be removed from this board. If you feel that you have found inappropriate content, please let us know by contacting us here with a url link to that content. Thank you.
×