Can anyone tell me how to get the CODE list of name? For example, as of August 7, I am in #68 in this CODE list... Thank you!!

Say what???

It's in this thread
http://www.visajourney.com/forums/index.php?showtopic=74459

Gillian

Hmm, that thread is a listing of people who have put in VisaJourney.com Timelines and are waiting for NOA2s, or have recently received a NOA2.

I try to update the thread three times a week, on Monday/Wednesday/Friday; as my schedule allows.

What are you looking for specifically? The latest list? Or the process on how I generate the list?

I don't know what the OP was after, but I wouldn't mind knowing how you generate the lists, if you didn't mind taking the time to tell

Its a very simple process.

#1. I do a VisaJourney.com Timelines query as follows:

http://www.visajourney.com/timeline/k1list...ll&dfile=No

#2. I set the number of results to something around 1500. (I check to make sure I have all data from 1/1/2007 and on; I adjust the number accordingly.

#3. I put that data in an XLS worksheet.

#4. I format the data, try to dedupe a bit, etc.

#5. I query the excel sheet using SQL to generate the lists.

#6. I post the lists.


Takes me less then 20 minutes to do nowadays. It used to take me much longer. Perhaps if I get savvy enough, I can find a way to streamline it.