Post/Zip Code with 0,in csv file

rinki123 · 2012-05-22

Hi Experts,

I had ported some post codes into post codes table through dataport (using csv file).But after importing all the pincodes(ZIP), those Zip codes which contains '0'(zero) they skipped '0'(zero) and ported.

Just like; 0987655 but after porting into Navision through csv file it removes zero and ported only 987655.

Plz suggest me the solution to save & port '0'(zero) in database.

vijay_g · 2012-05-22

Check your csv file before importing is the column have same value that you want to import or check datatype of that column.

PS: Try to import with text file(convert your csv in text file and then check the value of column in text file).

Sog · 2012-05-22

Check your csv file in a texteditor like notepad(++) (not excel, if opened by excel, changes of losing your zero's is way to high)
Next, make sure you import CODE and not integers/decimals.
Lastly, check if the postcode table has indeed code as datatype for zipcode.

Chinmoy · 2012-05-22

Use double quotes (") delimiters in the text file and import again. It should work. The column probably is treated as a number value, it should be treated as character.

Savatage · 2012-05-22

Sog wrote:

Check your csv file in a texteditor like notepad(++) (not excel, if opened by excel, changes of losing your zero's is way to high)
Next, make sure you import CODE and not integers/decimals.
Lastly, check if the postcode table has indeed code as datatype for zipcode.

:thumbsup:

also if you need to open it in excel - don't just file->open in ->excel.

open excel & use the data import wizard so you can assign the fields type TEXT so you don't lose the leading zero

Post/Zip Code with 0,in csv file

Comments

Categories