OPT YSC17902966XX timeline

现在6600-6699的状态是：
Summary:


Request for Initial Evidence Was Mailed-------------------------------------------------------------1

Correspondence Was Received And USCIS Is Reviewing It-----------------------------------------------1

Case Was Transferred And A New Office Has Jurisdiction----------------------------------------------2

Name Was Updated------------------------------------------------------------------------------------2

New Card Is Being Produced--------------------------------------------------------------------------24

Card Was Mailed To Me-------------------------------------------------------------------------------26

Case Not in System Yet------------------------------------------------------------------------------44

看到66xx的都已经mail了，而我这60XX的还是received，好忧桑！

dahoo 发表于 2017-9-30 07:16
现在6600-6699的状态是：
Summary:

求查一下：4800-4899

求楼主帮查一下17900058xx段~~谢谢

dahoo 发表于 2017-9-28 08:39
写了个脚本查了一下，基本上这附近的case不是card mailed就是还没更新到系统中。
YSC1790296600:Case Not  ...

求帮查一下17900058xx段~~谢谢

sheepmiemie 发表于 2017-10-3 02:39
求帮查一下17900058xx段~~谢谢

1. #!/usr/bin/python
   
2. 
   
3. """
   
4. Crawl data from USCIS website
   
5. https://egov.uscis.gov/casestatus/mycasestatus.do
   
6. """
   
7. 
   
8. import os
   
9. import time
   
10. import sqlite3
    
11. import random
    
12. import urllib2
    
13. from bs4 import BeautifulSoup, Comment
    
14. from mechanize import Browser
    
15. from dateutil.parser import parse
    
16. import pandas as pd
    
17. from datetime import datetime
    
18. import numpy as np
    
19. from pytz import timezone  
    
20. 
    
21. 
    
22. ADDRESS = 'https://egov.uscis.gov/casestatus/mycasestatus.do'
    
23. default_ua = 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36'
    
24. 
    
25. class Crawler:
    
26.     def __init__(self,start,end, prefix, address = ADDRESS):
    
27.         self.url = ADDRESS
    
28.         self.browser = Browser()
    
29.         self.start = start
    
30.         self.end = end
    
31.         self.headers= ['receivd','approved',
    
32.                 'produce','mailed','rejected','amended',
    
33.                 'transferred','exist','update']
    
34. 
    
35.         #self.Init(start,end,prefix)
    
36.         #self.Update(prefix)
    
37. 
    
38.     def __del__(self):
    
39.         pass
    
40. 
    
41.     def getcontent(self, id):
    
42.         '''Get contents from html page for given case id.'''
    
43.         # randomize headers
    
44. 
    
45.         #try:
    
46.         #    header = {"Connection": "close", "User-Agent": ua.random}
    
47.         #except:
    
48.         header = {"Connection": "close", "User-Agent": default_ua}
    
49. 
    
50.         # estabish connection
    
51.         request = urllib2.Request(self.url, None, header)
    
52.         self.browser.open(request)
    
53.         self.browser.select_form(nr = 0)
    
54.         self.browser['appReceiptNum'] = id
    
55. 
    
56.         # get response for a case
    
57.         response = self.browser.submit()
    
58.         content = response.read()
    
59. 
    
60.         return content
    
61. 
    
62.     def getstatus(self, text):
    
63. 
    
64.         if 'received your form i-765' in text:
    
65.             return 0
    
66.         elif 'approved' in text:
    
67.             return 1
    
68.         elif 'ordered your new card' in text:
    
69.             return 2
    
70.         elif 'new card' in text:
    
71.             return 3
    
72.         elif 'rejected' in text:
    
73.             return 4
    
74.         elif 'received your correspondence for form i-765' in text:
    
75.             return 5
    
76.         elif 'transferred your form i-765' in text:
    
77.             return 6
    
78.         else:
    
79.             return 7
    
80. 
    
81.     def gettext(self, s):
    
82. 
    
83.         try:
    
84.             return parse(" ".join(s.split()[1:4])).date()
    
85.         except:
    
86.             return None
    
87. 
    
88.     def getinfo(self, id):
    
89.         content = self.getcontent(id)
    
90. 
    
91.         tag = BeautifulSoup(content,'lxml').find_all('p')[0]
    
92.         text = tag.get_text().replace(',', '').lower()
    
93. 
    
94.         if id.lower() not in text: return id, None, None
    
95. 
    
96.         try:
    
97.             status = self.getstatus(text)
    
98.             date = self.gettext(text)
    
99.         except :
    
100.             status, date = None, None
     
101. 
     
102.         return id, status, date
     
103. 
     
104.     def Init(self,start,end,prefix):
     
105.         fname = 'book.csv'
     
106.         headers = ['receivd','approved',
     
107.                 'produce','mail','rejected','amended',
     
108.                 'transferred','exist']
     
109.         if os.path.exists(fname):
     
110.             self.df = pd.read_csv('book.csv',names=headers,skiprows=[0])
     
111.         else:
     
112.             self.df = pd.DataFrame(columns = headers)
     
113. 
     
114.         #print self.df
     
115.         for idx in range(start,end):
     
116.             if idx in self.df.index: continue
     
117. 
     .--
118.             id, status, date = self.getinfo(prefix+'{:06d}'.format(idx))
     
119.             if status is None:
     
120.                 self.df.loc[idx] = [None]*(len(headers)-1)+[False]
     
121.             else:
     
122.                 d = [None]*(len(headers)-1) + [True]
     
123.                 if status<(len(headers)-1): d[status] = date
     
124.                 self.df.loc[idx] = d
     
125. 
     
126.             #print id,status,date
     
127.             if idx%20==0: self.df.to_csv('book.csv')
     
128. 
     
129. 
     
130.     def Print(self,prefix,start,end):
     
131. 
     
132.         headers = self.headers
     
133.         for idx in range(start,end+1):
     
134.             id, status, date = self.getinfo(prefix+'{:06d}'.format(idx))
     
135. 
     
136.             if 0<status<len(headers)-2:
     
137.                 print prefix+'{:06d}'.format(idx),date,headers[status]
     
138.             else:
     
139.                 print  prefix+'{:06d}'.format(idx),'not available'
     
140. 
     
141. 
     
142. 
     
143. 
     
144. import os.path
     
145. 
     
146. if __name__ == "__main__":
     
147. 
     
148.     crawler = Crawler(start=290000, end=307000, prefix='YSC1790')
     
149.     crawler.Print('YSC1790',295800,295900)

复制代码

给你发段我的code

sheepmiemie 发表于 2017-10-3 02:39
求帮查一下17900058xx段~~谢谢

Summary:


Card Was Mailed To Me-------------------------------------------------------------------------------50

Card Was Delivered To Me By The Post Office---------------------------------------------------------22

Card Was Picked Up By The United States Postal Service----------------------------------------------13

Case Was Sent To The Department of State------------------------------------------------------------12

Case Was Approved-----------------------------------------------------------------------------------1

Card Returned Undeliverable-------------------------------------------------------------------------1

Correspondence Was Received And USCIS Is Reviewing It-----------------------------------------------1

xxlaipi 发表于 2017-10-3 02:22
求查一下：4800-4899

Summary:


Case Not in System Yet------------------------------------------------------------------------------82

Card Was Mailed To Me-------------------------------------------------------------------------------14

New Card Is Being Produced--------------------------------------------------------------------------4

我是YSC1790283***，7/28 received，然后一直查不到更新。。结果今天收到EAD卡了，寄出时间9/28，喜大普奔~