City codes not matching

Tagged:

Currently contains 8 posts

Avatar

26 Sep, 2015 11:42AM

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

26 Sep, 2015 01:00PM

MANESARDEPOT

122105

Avatar

26 Sep, 2015 01:34PM

Suchith

what does 122105 mean?

Avatar

26 Sep, 2015 09:18PM

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

27 Sep, 2015 07:08AM

Suchith

Thanks adarsh

Avatar

27 Sep, 2015 07:22AM

adarshdec23

No problem :)

Avatar

27 Sep, 2015 05:40PM

vikalpsahni

+1 for Adarsh answer.

Avatar

1 Feb, 2016 10:07AM

mobibittech

Anyone found the solution?

Reply to thread