Skip to content

Instantly share code, notes, and snippets.

View murtuzamvista's full-sized avatar

Murtuza Shabbir Lokhandwala murtuzamvista

View GitHub Profile
@murtuzamvista
murtuzamvista / customer-addresses.csv
Last active April 28, 2017 11:53
Customer Addresses for Geocoding
We can make this file beautiful and searchable if this error is corrected: It looks like row 6 should actually have 17 columns, instead of 12 in line 5.
"id","customer_id","city_id","neighbourhood_id","customer_name","contact_number","flat_number","street_name","landmark","pincode","sms_type","active","updated_at","dob","type","city_name","neighbourhood_name"
290394,362377,10,38758,"Yash shah",8401843822,"D/303 Dev archan Flats Nr. bonny travels","Nr. Kochrab ashram ","Paldi",380006,NULL,1,"2017-03-06 13:04:40",NULL,0,"Ahmedabad","Ambawadi"
237596,202839,1,44,"Parama Bhattacharya",9920799663,"C 908 oberoi splendor"," JVLR Jogeshwari East","Opp Majhas bus depot",400060,NULL,1,"2017-01-06 11:27:57",NULL,0,"Mumbai","Jogeshwari East"
216422,62515,5,38600,"test",9999999999,"test 1","test 1","Bengaluru",560029,NULL,1,"2016-11-28 10:27:27",NULL,2,"Bengaluru","Bannerghatta Road"
94017,95667,1,63,"Gurmit Aroraa",9820725010,"2C-706 Dreams CHS LBS Narg","bhandup west","near dreams mall",400078,NULL,1,"2016-04-27 13:18:35",NULL,2,"Mumbai","Bhandup West"
159849,180606,8,38722,"Mayuresh",9987586825,"Kalpataru, B-Wing, Room No.2","Road no.27","Ranjeet Chinese",400604,NULL,1
retailer_name retailer_city username password retailer_id Correct
Gupta Medical Delhi NCR 9312201189 123456 157 Yes
GURUKRUPA MEDICAL Mumbai 7303571751 123456 102 Yes
MEDITREAT Mumbai 9324540522 127873 130 Yes
MY CHEMIST Mumbai 9975234813 127874 106 Yes
Fairdeal Medical & General Stores Mumbai 9892374879 989237 101 Yes
Paras Medical CMS1 Mumbai 8655564640 127876 99 Yes
Borivali Darshan Medical Mumbai 9820925597 127877 32 Yes
BOSTON PHARMACY Mumbai 9324340853 123456 137 Yes
RAYWELLNESS MEDICAL Mumbai 9819991202 123456 147 Yes
name attendence mobile_number retailer_assigned_id active_status city_id
sohaib 1 12 1 NULL
matoshree 1 0222000848 12 1 NULL
sohaib 1 1 12 1 NULL
Ajay sakpal 1 2 12 1 NULL
driver1 1 2222222235 147 1 1
saddam 1 7045529792 12 1 NULL
Jatin Kambli 1 7208956662 12 1 NULL
Meet(liberty) 0 7208985172 12 1 NULL
Shadman 1 7506243876 12 1 NULL
name attendence mobile_number retailer_assigned_id active_status city_id
Carrier_DTDC_01 1 0000000001 184 1 10
Carrier_DTDC_02 1 0000000002 184 1 10
CARRIER_DTDC_03 1 0000000003 184 1 10
Carrier_DTDC_04 1 0000000004 184 1 10
123 1 0909070707 3 1 1
spartan1 0 5555555555 12 1 1
prejesh 1 7010569429 187 1 11
yuvraj 1 7010732278 187 1 11
Vikas Ghuge 1 7021189719 165 1 1
name attendence mobile_number retailer_assigned_id active_status city_id
Mukhtar Ansari 1 7021723781 106 1 1
Rajnish Ayyar 1 7021963889 104 1 1
Dummy 0 7039035943 18 1 NULL
Lahu 0 7039036295 92 1 NULL
Krunal Dsouza 0 7039194696 12 1 1
Vicky golar 1 7039419341 137 1 1
Sandesh Gavkar 1 7039588161 102 1 1
Abbas ali Shaikh 1 7039704080 165 1 1
rohan 0 7039912230 12 1 1