Stand Alone Applications AtlasBatch AtlasBatch is a data cleansing tool which will verify and amend large quantities of address data. AtlasBatch will read a database of existing addresses and cross-match them against the Australia Post's Postal Address File (PAF) ensuring optimum accuracy of your data. AtlasBatch Features: Verifies existing address records against PAF. Adds missing address elements to ensure address accuracy. Can work with partial and badly formatted addresses. Ability to append Delivery Point Identifier (DPID) for barcoding. Can operate in Clean mode, enabling the user to manually correct unmatched addresses, using a powerful gazetteer system. Produces Reports which detail match rates and categorise non-matched records. Data cleansing engine is approved by AMAS Australia Post. Can handle most Standard Industry Database Formats (ODBC). Builds Deduplication keys at Address Level, Individual Level and Company Level enabling the identification of duplicates within AtlasDedupe. Analyses name information, correctly formatting and titling names. AtlasClean AtlasClean is the perfect complement to the AtlasBatch product, reading a database of non-matched addresses and cross-matching them against the Australia Post's Postal Address File (PAF) ensuring optimum accuracy of your data. AtlasClean Features: Enables the user to manually correct unmatched addresses, using a powerful gazetteer system. AtlasClean will report the problem with the input address and intelligently select one of four gazetteers (premise, street, locality, postcode) enabling the user to locate the correct address. Works with partial and badly formatted addresses. Produces Reports which detail match rates and categorise non-matched records. Handles most standard Industry Database formats (ODBC). Builds Deduplication keys at Address Level, Individual Level and Company Level enabling the identification of duplicates within AtlasDedupe. AtlasDedupe Duplication of information is a common issue for anyone maintaining a centralised corporate database or multiple departmental data sources. But the problem can range far beyond the Database Administrator. For those who mail, not only will duplicates represent a huge amount of unnecessary cost, but will also have a detrimental impact on your reputation with your customers. Why is duplication becoming an increasingly common problem? Typing and Casing Errors Misheard Names or Addresses Data-Warehousing. Mergers and Acquisitions or a new Corporate Strategy may require the merging of various disparate data sources, creating obvious potential for duplication. Web Data Capture. Whilst this mechanism of data collection has seen a massive uptake, the increase in customer contacts can sometimes be at the cost of accurate information. How can AtlasDedupe help you? AtlasDedupe is a sophisticated tool for eliminating unwanted duplicates. Whether it be consumer or business data, Australian or International, AtlasDedupe can intelligently identify duplicates at both individual and property level. AtlasDedupe categorises duplicates by Passes and Scoring. Each 'Pass' of the data places weighting on different elements of the input information. Percentage scoring can also be activated depending on the specific requirements of a given dataset. As a user you have the choice to act on AtlasDedupe's findings. Duplicate records can be deleted automatically, verified interactively, merged, purged, output to separate databases for update or archive. Alternatively make use of the resultant report to make amendments within your live systems. Whatever the preferred method AtlasDedupe empowers the user to undertake complex data processes that can bring real benefits to your business. AtlasDedupe will support the deduplication of up to 10 databases against one another in any one run. The flexible merging facility means that no valuable customer data has to be sacrificed following the removal of a duplicate, enabling the creation of a single customer view. AtlasDedupe Features: De-duplicate individual or multiple databases. Handles most Standard Industry Database formats (ODBC). Standard passes support de-duplication at Address Level, Individual Level and Company Level. Advanced passes support de-duplication based on additional user-defined criteria (e.g. date of birth, customerID, etc.) Merge Records based on user-defined criteria. Filter Records based on source and status. Report generation, listing all identified duplicate records. Interactive State Editor, enabling the interrogation and status amendment of each duplicate block. Pre-defined templates enable easy suppression, matching and new transactions. AtlasDedupe can take any file from any database and de-duplicate the data, without having to convert the data into a text file. AtlasDedupe also includes a user-friendly setup wizard, steering the user through all steps of the de-duplication process. Usability Despite the complex processes that AtlasDedupe offers, the user will be surprised at its ease-of-use and intuitive workflow. The AtlasDedupe engine is where the powerful phonetic matching techniques occur, meaning it only needs to present simple on-screen setup options to the user. This in no way detracts from the user's ability to regulate the parameters of a run. AtlasDedupe will import all common data formats, including ODBC. Furthermore, when undertaking a multiple file de-duplication activity the databases can be of varying format and structure, creating one common output data structure. AtlasList AtlasList is a tool for the creation of address lists according to a defined search. Particularly useful for marketing purposes in direct mailing campaigns, AtlasList allows you to target a particular geographic area. AtlasList Features and Benefits Save time and money by creating your own mailing lists. Ensure all your target mail is accurate and current by building directly from the Australia Post Postal Address File. Apply filters to positively identify particular addresses. Save time and money by ensuring that unwanted addresses are eliminated. Extremely simple to use AtlasList supports the following type of searches: Postcode, including partial (e.g. 30 for all postcodes starting 30) Towns Country Positive and Negative filtering Filtering through certain fields AtlasCapture AtlasCapture is the complete address and data capture tool. Based on the 11 million delivery points held in Australia Post's Postal Address File (PAF), Atlas Capture allows you to retrieve an accurate and complete address from a postcode or partial address. AtlasCapture provides an easy method of capturing addresses from only a postcode and premise number or name, or from an incomplete address which may exclude a postcode. This greatly speeds up the process of keying name and addresses while at the same time ensuring accurate address information is stored. AtlasCapture can also return other details, keys and codes associated with an address, and also enables the user to specify their own data capture fields. This facilitates the simultaneous capturing of addresses, names and additional required data. AtlasCapture uses a data capture engine approved by AMAS Australia Post. AtlasCapture Benefits SAVE MONEY Reduce the number of postal returns on mailings by verifying all addresses against the PAF, then use PreSort to receive further discounts. SAVE TIME AtlasCapture reduces keystrokes by up to 80%. Whatever address information is available a single line can be input in a continuous operation. The product itself immediately and intelligently identifies whatever details are available. When an accurate and complete address cannot be immediately identified, it provides a selection of closest matches at both street and premise level. MAINTAIN COMPANY PRESTIGE Keep all the addresses on your database up-to-date, minimising customer frustration. REDUCE FRAUD Ensure validity of customer addresses. AtlasCapture Features AtlasCapture is unique in the marketplace, offering the user a choice of address-lookup facilities: LIST based functionality, allows the user to input from a single-line and navigate through the potential address matches. Powerful gazetteer system, enabling the user to manipulate their search criteria to maximise scrutiny of addresses. In addition AtlasCapture: Returns full premise information (e.g. Flats, Apartments, Units, Lots) Allows Rapid Address retrieval from just a few keystrokes. Captures the correct address where data is incomplete or hard to read. Append Delivery Point Identifier (DPID) to addresses for barcoding. Provides single button data entry . send addresses directly to any ODBC database or Windows application. Allows user defined address formatting. Allows user to specify their own data capture fields. Includes a Developers Kit for Windows and Unix. AtlasRains (RAINS+) AtlasRains is Hopewiser's leading quality Rapid Address Input System, designed and developed to be the fastest, most accurate rapid address system on the market. AtlasRains is based on the 11 million delivery points held in Australia Post's Postal Address File and the 1.8 million delivery points held in New Zealand Post's Postal Address File, allowing you to retrieve an accurate and complete address every time. AtlasRains Benefits Provides full validation and confirmation of addresses, increasing the accuracy of any database. Reduces the costs of failed deliveries by returning full premise information (eg. Flats, Apartments, etc.). Saves capture time by producing a full address in moments. Improves and maintains company prestige by verifying all addresses against the PAF. Uses a data capture engine approved by AMAS Australia Post. (Australia only) AtlasRains Features Return a full address from just a postcode, first 3 characters of street and premise. Rapid address retrieval from just a few keystrokes. Use the wildcard feature to capture the correct address, where data is incomplete or hard to read. Append Delivery Point Identifier (DPID) to addresses for barcoding. (Australia only) Provides single button data entry . send addresses directly to any ODBC database or Windows application. Allows user defined address formatting. Includes a Developers Kit for Windows and Unix. Foreign Addresser Foreign Addresser is Hopewiser's Address Management tool for preparing and mailing international address files. Only Hopewiser can offer a complete package for handling mixed international address databases. Designed for flexible use, the product includes a complete setup wizard. Foreign Addresser uses the ATLAS International Locality File. ADDRESS PARSING Input Addresses are broken down into their component parts, allowing the storage of specific data in named fields, e.g. Paris in town field, which enables easier selection and analysis of data. ADDRESS MATCHING Improves addresses by adding missing locality elements (town, province/state, postcode, country etc.) Maintains Company prestige by reducing spelling and keying errors on district, town and country fields, and producing, where known, the national version, e.g. Firenze not Florence. International match-keys are generated from the parsed components taking into account such things as: Diacritical Characters (accented characters) Title codes (Mr, Herr, Monsieur) MATCH KEY GENERATION Match-keys facilitate the storage and maintenance of records within a database. When used in conjunction with Hopewiser's AtlasDedupe tool, the various keys aid the deduplication process. ADDRESS FORMATTING / PTT LABELLING Hopewiser's Address Format File contains all address label requirements defined by the relevant PTT.s (Postal Authorities) in the world. Parsed and matched address components are used to build an address label according to the PTT requirements. Foreign Addresser encompasses options to:- Drop the country name from the label when posting directly into a country's mail system. Present the country name on the label, in the language of the mailing country. Foreign Addresser is designed to process addresses for countries where: A postal address file is not available; The country's postal address file is not to a standard to provide quality results using a postcoding product; The user's number of address records for the country do not warrant the expense of purchasing the particular postal address file. FOREIGN ADDRESSER SPECIFICATIONS Windows 32BIT Graphical User Interface (GUI). Systems supported - Windows 95 or more recent, e.g. XP, 2000, etc. Databases supported - any ODBC database, inc. Access, Oracle, SQLServer. Text file support, inc. defined, fixed, line sequental. Supplied on CD-ROM. Typically require 1 Gigabyte of hard disk space for ATLAS locality file. ATLAS Modular Software Suite ATLAS is the culmination of 20 years of providing Address management solutions. For mainframe use, including IBM AS400 (iSeries) supply, ATLAS is provided as a series of COBOL modules that can be integrated into these highly customised scenarios. For Unix and Windows users, Atlas is provided as a series of callable libraries written in C. The available components in the ATLAS suite are described individually below. PAF Build for ATLAS This process is used to create the proprietary format PAF data files required for use with ATLAS. The process involves the reading of and conversion from the supplied Relational Database format Australia Post Files into a more efficient flat file format. The data is quality checked against both the previous version and the current Australia Post provided details. The files are then compressed at this stage to reduce size and increase efficiency, and the resultant compressed files are again checked against the original PAF for quality prior to release to the clients on the appropriate formatted media. The PAF build is essential for all modules of ATLAS. Alternative data sets, based on addresses, can be loaded through this process, allowing multiple data sets to be utilised if required. Full Address Matching Module This module forms the basis of the AMAS accreditation, and involves the comparison of clients raw address data against the PAF. The module accepts free format address fields, unparsed, which are then broken down internally and matched to the PAF records according to English Language rule-based logic. If the address is matched, then the relevant DPID can be output with the matched PAF address and other associated information. Also available for output are standardised error codes that allow further analysis of unmatched addresses, by indicating at what level the address was unable to be matched at, for example street not found in the locality, premise outside range and so forth. The ability to pass addresses to the module in this manner allows this to be integrated into both batch and online systems easily and quickly. Sample harnesses are provided, as well as the code for passing information to and from the module. Rapid Key Address Extraction This is a tool that allows a minimised number of keystrokes to extract data from the PAF, and is targeted towards address verification primarily. Two key fields, a rapid key and premise, are passed to the module. This then returns all the addresses, including sub-premise information, containing the data. The rapid key consists of the postcode plus the first three characters of the street name and can accept standard database wildcards. The premise key can also accept a wildcards, and is an optional field. This methodology has several advantages over alternative type down techniques, by reducing the network traffic/processor transactions and by ensuring that the full range of information containing these elements is returned. Often in type down techniques, inaccurate acceptance of a postcode/locality can lead to inaccurate address details being garnered from the operator. Gazetteers The gazetteers, effectively geographical dictionaries, are available in three different levels: Locality, Street and Premise. These are designed to allow users to search the PAF for addresses using standard database wildcards when investigating addresses. The Premise Gazetteer The Premise Gazetteer allows searches upon the PAF with various wildcards for premises and streets within a state or the country as a whole. The module returns a list of available PAF addresses with these components. The Street Gazetteer The Street Gazetteer allows wildcard searches on the PAF to street level. This allows for more rapid searches to return streets in either state or nationally, allowing easy address correction. The Locality Gazetteer The Locality Gazetteer allows wildcard searches on the PAF of localities & synonyms and returns all the relevant localities as well as the State they are situated in. Address Formatting Module This module formats the individual address components output from AH23CODE into approved label formats for printing, as well as allowing the address labels to be produced with intelligent Upper and lower case lettering. It is built to handle variable situations such as O'Connell Street accurately. Barcode String Generator This module produces the relevant, compliant barcode string for generating the 4-State barcode for Australia Post discounting. It accommodates the 7 approved types allowed by Australia Post. DeDuplication This module is provided as source code, and accepts keys generated from the Full Address Matching module. The deduplication keys allow for flexible, reliable deduplication with minimised resource requirements, included multiple passes and efficient processing. The keys that are generated are highly developed and include the ability to deal with synonym localities for example. Full assistance is provided in utilising the potential of deduplication. PreSort PreSort support for address lodgement with Australia Post is also provided, including generating the necessary lodgement documents.