City codes not matching

Tagged:

Currently contains 8 posts

Avatar

September 26, 2015 11:42

Suchith

Whatever the city codes given in the data docs are not matching any results in server.
In the example shown in “https://developer.goibibo.com/docs” for get request the Bangalore city code = 6771549831164675055 but where as in the city_list.csv file the city_code=6771549831164670000.

Avatar

September 26, 2015 13:00

MANESARDEPOT

122105

Avatar

September 26, 2015 13:34

Suchith

what does 122105 mean?

Avatar

September 26, 2015 21:18

adarshdec23

Don’t open the CSV in Excel (or any other spreadsheet software like Libre Cacl). They will truncate your data as they cannot handle such large numbers.
Similarly in your DB store these as VARCHAR (or their equivalent) as INT cannot handle such large numbers.

Avatar

September 27, 2015 07:08

Suchith

Thanks adarsh

Avatar

September 27, 2015 07:22

adarshdec23

No problem :)

Avatar

September 27, 2015 17:40

vikalpsahni

+1 for Adarsh answer.

Avatar

February 01, 2016 10:07

mobibittech

Anyone found the solution?

Reply to thread