Global Data Quality Sept 2011

To contact us Click HERE
Global Business demands higher level of efficiency with greater profit potential

Maintaining high quality data is critical to business success. Yet unreliable, outdated, or inaccurate data costs U.S. businesses more than $600 billion annually. With quality data, international organizations can know how many customers they have, detect duplicate customer data, correct addresses for most countries worldwide, correct contact information, correctly field data, personalize data, merge and validate data. All this saves both time and money. Maintaining accurate data quality also can accurately predict customers' interests and can prioritize marketing programs to more effectively cross sell or upsell products. Multinational businesses need to understand these metrics to determine the value and impact of current business process.

International business initiatives encounter a large variety of languages, names, address conventions and other culturally embedded business rules and habits. In systems unable to recognize international characters or international name and address forms, the inclusion of non-native data can cause unexpected results and undermine existing data integrity throughout the enterprise. An accurate address can mean the difference between profit earned from a successfully completed delivery or customer dissatisfaction and financial penalties accumulated due to misdirected mail and resultant postal costs.

Multi-national organizations face common obstacles as they work to consolidate disparate global data into meaningful information:

• Trade across multiple countries and borders yields different customer data quality issues with different languages and character sets.


• Decentralized business systems have a critical impact on reporting, daily operations, sales forecasting, and inventory.


• Significant record duplication hinders the creation of trusted, global enterprise views.

International Data Quality Software packages include address correction that cleanses, standardizes, parses, matches, and governs multi-national information across countries, languages, and character sets. Having high-quality data as the foundation of all your enterprise efforts delivers the benefits and competitive advantage that today’s global companies seek.

• Automatic processing of mixed country data (records) applies appropriate culture- and country-specific logic


• Country-specific business rules, corporate standards and processes consistently applied to global data


• Organizes and standardizes relationships among customers and vendors across regions


• Global data quality solution that is scalable to meet the demands of current and future data quality needs

Global Data Quality Software provides appropriate categorization of cultural differences in international data, such as name order, multiple last names, street and currency designations and formats, and preferred syntax, data translation from one code page to another, even mixed data within the same record, and can match validated and cleansed addresses to corresponding latitude and longitude coordinates.

FTI specializes in matching businesses with the cost-effective global data quality solutions. International Data Quality solutions can help you lower the costs of sales, marketing and customer service by cleaning your database of inaccurate or incomplete contact data. Here are just a few ways FTI can help your business with International Data Quality Software features:

• International address data intelligence


• Access to global address data


• De-duplication


• Merge-purge


• Geocoding


• Worldwide address management


• Address Correction to add missing elements and correct spelling


• Address Standardization to ensure conformance and deliverability


• Global Data Validation to confirm that the address exists in the appropriate database as a delivery point


• Data Fielding & Parsing allows a seamless transactions

Organizations that engage in business across international borders require an effective global data quality solution that ensures data is accurate and correct, no matter what language it’s in. FTI provides software solutions that parse, standardize and correct data for 240 countries using country-specific rules applied across language and character sets. We offer many international data quality options that can be tailored to meet your business needs:

• Loqate


• Global Locator


• Master Delivery Series


• Data Quality Suites

Call today for a free consultation to find out more information about international data quality software. Contact FTI at 888-970-9944 via email at fti@freelancetech.com.

What's more important on mail- the city or the zip code?

To contact us Click HERE
Long story short, I ordered a book but accidentally gave the wrong city. The zip code and address is correct, will it be returned to sender? Or will USPS go by the zip code?|||Zip code. You really don't even need the city on there since each city has it's own zip code. Those things are read by machines when sorted. The machines only read the zip code. The city is on there only if you mess up the zip code.|||I believe the Zip is more important. Hopefully, the mail folks will look at the address and find it under the zip and not the city. But then again, USPS workers are kind of lazy... lol|||they will use zip code and they will also use your telephone number as a back check, so don't worry.|||The zip code is most important.

What's more important on mail- the city or the zip code?

To contact us Click HERE
Long story short, I ordered a book but accidentally gave the wrong city. The zip code and address is correct, will it be returned to sender? Or will USPS go by the zip code?|||Zip code. You really don't even need the city on there since each city has it's own zip code. Those things are read by machines when sorted. The machines only read the zip code. The city is on there only if you mess up the zip code.|||I believe the Zip is more important. Hopefully, the mail folks will look at the address and find it under the zip and not the city. But then again, USPS workers are kind of lazy... lol|||they will use zip code and they will also use your telephone number as a back check, so don't worry.|||The zip code is most important.

What's more important on mail- the city or the zip code?

To contact us Click HERE
Long story short, I ordered a book but accidentally gave the wrong city. The zip code and address is correct, will it be returned to sender? Or will USPS go by the zip code?|||Zip code. You really don't even need the city on there since each city has it's own zip code. Those things are read by machines when sorted. The machines only read the zip code. The city is on there only if you mess up the zip code.|||I believe the Zip is more important. Hopefully, the mail folks will look at the address and find it under the zip and not the city. But then again, USPS workers are kind of lazy... lol|||they will use zip code and they will also use your telephone number as a back check, so don't worry.|||The zip code is most important.

What's more important on mail- the city or the zip code?

To contact us Click HERE
Long story short, I ordered a book but accidentally gave the wrong city. The zip code and address is correct, will it be returned to sender? Or will USPS go by the zip code?|||Zip code. You really don't even need the city on there since each city has it's own zip code. Those things are read by machines when sorted. The machines only read the zip code. The city is on there only if you mess up the zip code.|||I believe the Zip is more important. Hopefully, the mail folks will look at the address and find it under the zip and not the city. But then again, USPS workers are kind of lazy... lol|||they will use zip code and they will also use your telephone number as a back check, so don't worry.|||The zip code is most important.

What's more important on mail- the city or the zip code?

To contact us Click HERE
Long story short, I ordered a book but accidentally gave the wrong city. The zip code and address is correct, will it be returned to sender? Or will USPS go by the zip code?|||Zip code. You really don't even need the city on there since each city has it's own zip code. Those things are read by machines when sorted. The machines only read the zip code. The city is on there only if you mess up the zip code.|||I believe the Zip is more important. Hopefully, the mail folks will look at the address and find it under the zip and not the city. But then again, USPS workers are kind of lazy... lol|||they will use zip code and they will also use your telephone number as a back check, so don't worry.|||The zip code is most important.

What's more important on mail- the city or the zip code?

To contact us Click HERE
Long story short, I ordered a book but accidentally gave the wrong city. The zip code and address is correct, will it be returned to sender? Or will USPS go by the zip code?|||Zip code. You really don't even need the city on there since each city has it's own zip code. Those things are read by machines when sorted. The machines only read the zip code. The city is on there only if you mess up the zip code.|||I believe the Zip is more important. Hopefully, the mail folks will look at the address and find it under the zip and not the city. But then again, USPS workers are kind of lazy... lol|||they will use zip code and they will also use your telephone number as a back check, so don't worry.|||The zip code is most important.

Please help with link syntax to find a zip code definition on usps.com?

To contact us Click HERE
hi,


i need to include a link in a html page to a zip code so that when the user clicks the zip code it opens a browser and sends him to usps.com and looks up the zip code to give him the city. I have the link, but i cannot figure out the syntax to put the zip code in the link to do the lookup. Can someone please help? Here is the link:





http://zip4.usps.com/zip4/citytown_zip.jsp





thankx|||There are a few different options I could give you, but they might not be what you're looking for.


The first one is that if you just want to look up zip codes, you could create a page with google search box on it. The link is here: http://www.google.com/cse/





With the google search box, it just functions like you would be googling something on google, meaning you just enter a zip code, and that would open a new tab with the google search query giving them the location of the zip code.





The second way is almost similar but only that you would create that search on google on your own using a scripting langauge, or if not google, something like www.city-data.com/zips/90064.html


Where the zip code might be $zc = whatever users enter and the link would be www.city-data.com/zips/$zc.html





So every time the user hits the link, the $zc changes to whatever zip code the user had typed.





You might require a dynamic scripting language like PHP.





Here's quickly what you could try if you know a dynamic scripting language.





With PHP,





$zc = $_POST(zipcode);|||View the source for the page where you found that link to see what you are really clicking on that takes you to it. That's what I did once to create a perl script that would text me whenever a server had problems. My wireless carrier had a web form to send text. I used the source for that to figure the rest of it out.|||You'd have to append the following to your URI (link) above to populate the text box on the "citytown" page:





?zip5=94555


Note that "zip5" is the name of the text box which gets populated. (Yahoo annoyingly trims long strings, so here's what the full URI would look like, except you'd have to remove the spaces: http://zip4.usps.com/zip4/ citytown_zip.jsp ?zip5=94555 .)





But the user would still have to click the submit button, so if you want it to automatically show them the relevant city, you'd have to post a form to the same page being posted to from your link above. Viewing source shows this:





%26lt;form onsubmit="return validate(form1)" method="post" action="zcl_3_results.jsp" name="form1"%26gt;


Note that you'll have to use the fully qualified URI for the "action" value, i.e., "http://zip4.usps.com/zip4/ zcl_3_results.jsp" (remove space).





You'll have to also copy the %26lt;input%26gt; names they use in order to have the appropriate values be posted on form submit. Here are the %26lt;input%26gt; tags you'd need, again retrieved from viewing source:





%26lt;input type="text" name="zip5" maxlength="5" style="width: 75px;" id="zip5" value="" tabindex="1"/%26gt;


%26lt;input width="70" type="image" height="17" title="Submit" src="images/button_submit_akqa.gif" value="Find ZIP Code" tabindex="8" name="submit"/%26gt;





I removed the "onkeypress" attribute -- you'll have to do any event handling as you see fit.

What's more important on mail- the city or the zip code?

To contact us Click HERE
Long story short, I ordered a book but accidentally gave the wrong city. The zip code and address is correct, will it be returned to sender? Or will USPS go by the zip code?|||Zip code. You really don't even need the city on there since each city has it's own zip code. Those things are read by machines when sorted. The machines only read the zip code. The city is on there only if you mess up the zip code.|||I believe the Zip is more important. Hopefully, the mail folks will look at the address and find it under the zip and not the city. But then again, USPS workers are kind of lazy... lol|||they will use zip code and they will also use your telephone number as a back check, so don't worry.|||The zip code is most important.

What's more important on mail- the city or the zip code?

To contact us Click HERE
Long story short, I ordered a book but accidentally gave the wrong city. The zip code and address is correct, will it be returned to sender? Or will USPS go by the zip code?|||Zip code. You really don't even need the city on there since each city has it's own zip code. Those things are read by machines when sorted. The machines only read the zip code. The city is on there only if you mess up the zip code.|||I believe the Zip is more important. Hopefully, the mail folks will look at the address and find it under the zip and not the city. But then again, USPS workers are kind of lazy... lol|||they will use zip code and they will also use your telephone number as a back check, so don't worry.|||The zip code is most important.

USPS Delivery Confirmation states different zip code?

To contact us Click HERE
I sent two packages to the same address in 90840, but on both delivery confirmation statuses, USPS says it was sent to a different zip code? Can someone help me make sense of this before I have to go to USPS and sort it out?





Delivered, June 19, 2010, 9:39 am, LONG BEACH, CA 90809


Arrival at Unit, June 19, 2010, 5:21 am, LONG BEACH, CA 90809


Arrival at Pick-Up-Point, June 19, 2010, 3:24 am, LONG BEACH, CA 90840


Acceptance, June 18, 2010, 1:53 pm, IRVINE, CA 92602|||doesn't make sense to me and i worked there 28 years.

USPS Delivery Confirmation shows wrong Zip Code?

To contact us Click HERE
I sent an application to a potential employer two weeks ago via Priority Mail w/ DC. I didn't want to have them worry about signing for it, or I would have used certified. I have the receipt and it says the correct Zip Code and city on it. However, I checked DC yesterday, and it said that it was delivered to a Zip Code about 10 miles away in a different part of the city. (Both ZIP codes are in the same large city, and neither are in the outskirts). What should I do? The deadline to receive is the end of the month.|||contact the potential employer to see if they received it. then call the post office where the item was delivered in. Sometimes company have other pick up locations that is different from the zipcode it was intended on the envelope. calling the post office will find out if that is the case or not.





The sooner you call, the sooner they can start looking for it.|||Call the employer to find out if they received it.

My usps order was sent to wrong zip code, now what(mail)?

To contact us Click HERE
HI, my ebay order was sent to the wrong zip code so I was tracking and it says it was undeliverasble, the seller sent it to zipcode 89310 instead of 89031, so what will happen now? The package was undeliverable today, can I call and have them hold it for me? the zipcode is only a few miles away|||In looking at Mapquest, those two ZIP Codes ar almost 400 miles apart. At this point, the package may be rerouted to the correct ZIP Code. We will usually mark out a ZIP Code and try delivery to the town name if the two do not match.





There is nobody that you can try to call to hold the package. It is already on its way to the Processing Center and will be among hundreds of other packages to be sorted and dispatched.





If, by chance, it does get returned to the sender, they should reship to you at no charge since it was their error.

USPS item sent to wrong zip code?

To contact us Click HERE
I got something from ebay and the seller sent me a confirmation number. I think he wrote 91328 instead of 91325 and it said it was delivered today to 91328. My zip code is 91325 and I don't think the post office would have sent to 91328 because of the wrong address. the confirmation number is 0307 1790 0000 7991 0500





Thanks|||The seller is required to ship to the address on file. Check your address in both eBay and Paypal.





Did you use Paypal to pay? Did your seller ship through Paypal?





Both zipcodes are for Northridge CA. If the seller has the correct street address, it will probably get to you. If you do not receive it in a few days, contact your seller.





Unfortunately for you, if the item was shipped to the address on file and the seller can prove that the item was delivered, Paypal will most likely side with the seller in a dispute.

How do I find zip code for street address on excel?

To contact us Click HERE
I have a list of street addresses and cities (5,000), but without zip codes. Does anyone know of a way to get the zip code for each address on excel? I would like the program or formula or whatever be able to look at the street address and city and plug in the zip code for me. I would not like to go on the usps website and enter each address one by one. Thanks!|||Hey buddy !





I went on google and searched for a complete list of US zip codes. It seems like you can download for free from http://www.aggdata.com/free/zip-code . Looks like they give the city, zip code and some other data that you might or might not need.





You can put this on a seperate tab and then vlookup against the city.

USPS Unable to Locate Address?

To contact us Click HERE
The USPS zip code lookup is unable to locate the address I have entered, even though I've double-checked on Google Maps, which has successfully identified the address, hence, it is valid. I would like to order items online to be shipped to the address in question and unless this problem is resolved, I will be unable to do so. I've emailed USPS using their online email tool and received an inquiry id, however, it has already been over 3 days and I've received no feedback from them. Also, they never asked for my email address, which makes me wonder how they will contact me with an answer in the first place.. Could anyone please let me know what can be done about this? Thanks in advance!! :)|||Just because an address exists does not mean that the address can receive mail. The address has to be on the route of USPS in order for mail to be deliverable to that address. Some areas only have access to p.o. boxes, it just depends on the address. The fastest thing that you can do is to call USPS. Waiting around for them to e-mail you back (especially when you did not leave contact information is silly). They will be able to look up the address and tell you if it's an address that they serve. Their phone number is: 1-800-275-8777 or 1-800-ASK-USPS. Their hours are Monday-Friday 8am-8:30pm Eastern; Saturday 8am-6pm Eastern and they are closed Sundays and holidays.|||Call them if you have nagging doubts. However if you receive mail they can find you. Sometime a the search system isn't quite able to work out how you word your address (like if you include "apt 23" instead of "#23" or "St 23"). I've had similar issues with services like Comcast but they had no problem finding me in the end.

WHAT"S THE BIG MYSTERY WITH ZIP CODE 55212? why does it not register as a zip code and WHY WAS MY PACKAGE TH?

To contact us Click HERE
this is some postal black hole. i tracked a package that left this zip code (no city mentioned). so i ran the zip through USPS and it couldn't be found. i googled it and it doesn't come up. is this familiar to anyone? WHAT'S TE BIG WHOOP?|||it is a usps warehouse that supposedly has its own zip code or it was a typo something of the sort but it is in Eagan MN. Read the whole link and you will understand|||This is Happeing to me to! this is what is says. "Processed through Sort Facility, Jul-21-11, 23:11 PM, 55212" i ordered it on ebay.... this is some wierd stuff man! hope i get my package. its only a ring of light for my xbox 360! lol

Report Abuse

|||I'm not exactly sure, but the ZIP code 55212 refers to Area 51. Its only a government-known sight. That's probably why you won't get any results for searching it. Hope this helps =)|||So what was in the package?


Area 51 think I have heard of that but cannot remember what. it was.





http://en.wikipedia.org/wiki/Area_51|||You're not alone:





http://jeremy.qux.net/entries/2008/02/Tr鈥?/a>





Edit: LOL at the above poster just quoting from the referenced site, not realizing it was a joke.

If I add the last 4 numbers of a zip code will my mail get delivered to someone faster?

To contact us Click HERE
It's like the question asks, if I add the last 4 digits of a zip code that you can look up on the USPS website will my mail get delivered to someone faster if they are on a package? Or will it take the same amount of time?|||The last four allows the item to be automatically sorted all the way to the address. In theory this will make the delivery more efficient and faster. The fact is that with the 5 digit zip code, the item gets to the same post office at the same time, and it should be delivered on the same day.





The post office likes the +4 ZIP especially for businesses that send a lot of mail, but it is not necessary for an individual.





If your word processing program will print envelopes or address labels with the bar code, that does speed up the sorting.

Right address and zip code but wrong country usps?

To contact us Click HERE
Hi a letter was sent to me using royal mail with track and trace but it was sent to the wrong country it is not suppose to go to the ALaska USA.It was suppose to go to New Zealand.





I tracked it and it was in opa locka florida and it got processed through opa locka sort facility 3 times.Its been 10 days since the last update.


it says Your item was processed through and left our OPA LOCKA, FL 33054 facility on November 09, 2010. The item is currently in transit to the destination. Information, if available, is updated periodically throughout the day. Please check again later. do you think that they sent it to NZ.Because it didn't say undeliverable address.


Do you guys know if it is being sent to NZ|||USPS is trying their best. But they are assuming that the letter was meant for somewhere in the USA. There's not a snowball's chance in hell that they searched the entire globe and managed to find the same address in NZ. The letter has probably been 'returned to sender' or more likely has wound up in the 'dead letter' office of USPS.


----------------------


Whoever sent it to you incompletely addressed must have been high on something . . (No offense to your friend - but addressing a letter properly isn't exactly rocket science).

Does Russia have zip codes?

To contact us Click HERE
I wanted to send this package to my friend in Russia, she sent me the info but when I went to ship it via USPS, they then asked me if there was a zip code? I told them that was what I got. I emailed my friend but have not heard back so out of boredom at work I am asking this question lol|||Yes they do! And its super easy to find on google. Just like in USA, there is different zip codes for all cities. Just type in name "whats the zip code for (city), Russia and it will pop up. =)|||They don't call them zipcodes,they call them postal codes. Make sure you fill out the correct customs form (there are 2). The label number can act as a customs number. Also,consider added registered mail,it costs $11.50 extra but it's locked up and secured and has indemnity coverage (like insurance) of $45 and you can add more. Registered mail has a tracking number. When I mailed a package to Ukraine,I shipped it priority international flat rate small box,I filled out customs form 2976 (there is 2976 and 2976-A). I weighted each item and put the value of each item on the customs form,then I taped the box up and weighted the box and put the total wieght and value. If you don't do this,it may slow the shipping time and customs may open the package. Consider adding registered mail since packages get stolen in Russia and Ukraine.



http://pe.usps.gov/

http://ircalc.usps.com/CustomsFormsCalcu…|||ZIP codes are a system of postal codes used by the United States Postal Service. Since Russia is not a part of the USA, but a country on its own, it does not have zip codes.





The Russian postal service (Почта Ро��ии) uses its own code system. So, they have some kind of postal codes, but these codes do not fit the zip codes system.|||There are codes, but this is only a link via Wiki, have a look and select the section you need.


Russia zip codes etc.


http://en.wikipedia.org/wiki/Postal_code…|||Russia has 6-digit zip code system|||They have one zip code for one Russia.

Where does mail go with an incorrect zip code?

To contact us Click HERE
I bought a package of a website, but apparently I put in the wrong zip code (the address was in one zip code, I put the old zip code with the new address). According to the USPS tracking information, the package was delivered Saturday, January 15 at 5:54 AM (this was an error, apparently, supposedly was PM). However, the package never showed up. Will the package be sent back to the sender, or what will happen to it?|||There are alot of variables there. If there is a similar address in the other zip code it might get delivered there. If it's not a signature-required delivery (most aren't nowadays), the target address might have just kept it. if they are honest and report the misdelivery, it might eventually be returned to sender.





Report the problem to the vendor, the USPS and maybe your credit card company. Ask them for advice.|||To la la land dead letter post office. No seriously they will try and deliver it if they can not it will return to sender. Don't wait by the door it could take some time. You might also call ups and have them hold it at their facility. They can look it up with the tracking information.|||It will show up as being delivered, then you should get another status update that says forwarded due to incorrect zip code. I don't know why they scan it delivered first but they do. Then it will be returned back to the sender.|||It will go to the wrong Zip first and then be redirected once the mistake is noticed.|||It will be sent back to the sender.|||either to the address u sent or if your lucky back to post office

Where do i put the Zip Code while sending international mail?

To contact us Click HERE
I need to send an international mail via USPS. But I have no idea where to place the zip code. The zip code box is 5+4 boxes, should i put in there or put it next to the address|||Within your address - As you do normally


Their address - typically before the city name and before the country





Here is an example:


you: John Smith


123 Main Street


Any Town, CA 94121 USA





them: Jane Doe


123 Main Street


Paris 75008 FRANCE

What happens if you put a bad zip code on a letter?

To contact us Click HERE
A friend mailed me a small package last week via USPS Priority Mail. He used my correct home address with the zip code of my workplace, which is in the next suburb over. Will it go back to him, eventually come to me, or disappear into oblivion.|||Items are sorts using the zip code, these days often automatically and sent to the local post office.





When they arrive, and the address doesn't match the ZIP code they will processed to find the correct location. This may slow the mail down a little. So perhaps a delay of a few days would be expected.|||It will find its way to you..


No problem.|||The package will not disappear. It may be delivered to you anyways./

FTI at National PCC Day

To contact us Click HERE

Wednesday, September 15, 2010
7:30 AM - 3:30 PM


National PCC Day
Center for Innovative Technology
2214 Rock Hill Rd
Herndon VA 20170

FTI reps will be available to discuss the latest offers and developments in mailing software and data quality tools.

Take the FTI Mailers Challenge - WIN GOLD DOLLARS!
Grand Prize Drawing: Virginia Wine Basket!
Contact FTI to see which choice is the right solution for your business requirements.

Toll-Free: 888.970.9944
fti@freelancetech.com