iMagicSoft Support Forum Index iMagicSoft Support
iMagic Software Support
 
  SearchSearch   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Export missing zipcode

 
Post new topic   Reply to topic    iMagicSoft Support Forum Index -> iMagic Hotel Reservation
View previous topic :: View next topic  
Author Message
imagicsupport
Site Admin


Joined: 16 Dec 2006
Posts: 2110

PostPosted: Tue Dec 13, 2016 10:06 am    Post subject: Export missing zipcode Reply with quote

Hello,
We are exporting a customer mailing list to do a holiday mailing, but when we export to a CSV (and excel is the same),many of the zip codes
are listed with only 4 digits, yet they have 5 in the database....I have tried this three times.

Can you help with this?

New Milford CT 6776
Turnpike Woodbury CT 6798
Simsbury CT 6070
Winstead CT 6098
Absecon NJ 8201
Greenfield MA 1301
Kensington CT 6037
Haverhill MA 1832

David and Laura
Back to top
View user's profile Send private message Visit poster's website
imagicsupport
Site Admin


Joined: 16 Dec 2006
Posts: 2110

PostPosted: Tue Dec 13, 2016 10:10 am    Post subject: Reply with quote

Hi David and Laura,

Thanks for the post.

Without having the hotel reservation exported CSV file to look at it's difficult to be sure. But I would guess that Excel is seeing the zipcode column as a 'number' and then formatting it as number, this would remove the leading 0. A hotel guest's zipcode would be better formatted in Excel as a 'text' field.

If you require further help please email the CSV file so I can take a look.

Regards, John
_________________
iMagic Soft Support
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    iMagicSoft Support Forum Index -> iMagic Hotel Reservation All times are GMT + 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
iMagic Hotel Reservation home page


Powered by phpBB © 2001, 2005 phpBB Group