{"id":159,"date":"2017-10-18T11:21:23","date_gmt":"2017-10-18T15:21:23","guid":{"rendered":"https:\/\/www.flagshipsoftware.com\/wordpress\/portal\/?page_id=159"},"modified":"2022-05-12T16:39:04","modified_gmt":"2022-05-12T20:39:04","slug":"view-database","status":"publish","type":"page","link":"https:\/\/www.flagshipsoftware.com\/fsweb\/view-database\/","title":{"rendered":"View\/Export Database"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\n\t\n<\/svg>\t\t<\/div>\n\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t
<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

View Database & Export<\/h1>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t
<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

View Database<\/strong> permits you to view your iAddress\u2122 database in a table-style view. You may edit or delete records in this mode. From the File menu, select \u201cView Database\u201d.<\/p>

In this view, you may look at:<\/span><\/p>

  • All addresses<\/span><\/li>
  • Valid addresses only<\/li>
  • Corrected addresses only<\/span><\/li>
  • Uncorrectable addresses only<\/span><\/li>
  • Duplicates only<\/span><\/li>
  • Common records only<\/span><\/li>
  • All fields within the database<\/span><\/li><\/ul>

    You can print some or all of your addresses from the View Database screen, if you choose.<\/span><\/p>

    \u00a0<\/p>

    Note:<\/span><\/strong><\/p>

    Valid, corrected and uncorrectable addresses can only be viewed after validation\/correction has been run on the job. Duplicates and common records can only be viewed after duplicate extraction has been performed. \u00a0Uncoded records can be viewed after sortation.<\/span><\/p>

    \u00a0<\/span><\/p>

    Deleting Records<\/span><\/strong><\/p>

    Records can be deleted in this view. This is useful for selectively deleting duplicates after the \u201cPurge Duplicates\u201d operation. To delete records individually, click it, then click the \u201cDelete\u201d button above the database. To delete multiple records, hold down the \u201cCtrl\u201d key while selecting records, then press the \u201cDelete\u201d button on the screen.<\/span><\/p>

    You may also select an individual record by clicking on it. You can then manually check this record\u2019s address by clicking \u201cLook-up\u201d.<\/span><\/p>

    Export database<\/strong><\/p>

    You may now select the content and format of the export database. The options are as follows:<\/span><\/p>

    • Valid addresses:<\/span><\/strong><\/li><\/ul>

      All valid addresses from the original database are retained.<\/span><\/p>

      • \u00a0Corrected addresses:<\/span><\/strong><\/li><\/ul>

        All addresses corrected by iAddress\u2122 are retained.<\/span><\/p>

        • \u00a0Uncorrectable:<\/span><\/strong><\/li><\/ul>

          Addresses iAddress\u2122 was unable to correct are retained.<\/span><\/p>

          • Questionable addresses:<\/span><\/strong><\/li><\/ul>

            Addresses that are listed as Questionable by iAddress<\/span>\u2122<\/span><\/p>

            • Export in original order:<\/span><\/strong><\/li><\/ul>

              Keeps your database fields in the same order as the original file.<\/span><\/p>

              • Extra control fields:<\/span><\/strong><\/li><\/ul>

                Fields created by iAddress\u2122 during correction\/validation and presortation.<\/span><\/p>

                • Add original address fields:<\/span><\/strong><\/li><\/ul>

                  Permits you to see the original state of your address fields as well as any corrections or changes.<\/span><\/p>

                  • Include all other fields from original database:<\/span><\/strong><\/li><\/ul>

                    Permits you to export additional fields contained in the original database (for example: customer numbers, phone numbers, etc.).<\/span><\/p>

                    • Include audit log:<\/span><\/strong><\/li><\/ul>

                      Allows you to export the audit log in order to track manual changes made to your database.<\/span><\/p>

                      • Add leading zeros to list order:<\/span><\/strong><\/li><\/ul>

                        Helps retain numeric formatting for dBase files.<\/span><\/p>

                        • Add correction fields:<\/span><\/strong><\/li><\/ul>

                          Permits you to see the corrections that have been suggested or applied to your database.<\/span><\/p>

                          • Add status and comment:<\/span><\/strong><\/li><\/ul>

                            Allows you to enter information about individual records.<\/span><\/p>

                            • Add address components:<\/span><\/strong><\/li><\/ul>

                              Adds fields of your address separated into its components (for example: street number, street name, street type, street direction, etc.)<\/span><\/p>

                              • Choose export fields:<\/span><\/strong><\/li><\/ul>

                                Allows you to choose specifically which fields you would like to export.<\/span><\/p>

                                Once you have sorted your file, you can also export:<\/span><\/p>

                                • Uncoded records<\/span><\/li>
                                • Foreign records<\/span><\/li><\/ul>

                                  After selecting your options, click Export Database. On the Save As screen, enter a location and filename for the new database. Click Save.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t

                                  \n\t\t\t
                                  \n\t\t\t\t\t\t
                                  \n\t\t\t\t
                                  \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                                  \n\t\t\t\t
                                  \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                                  \n\t\t\t\t
                                  \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
                                  \n\t\t\t\t
                                  \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

                                  View Database & Export View Database permits you to view your iAddress\u2122 database in a table-style view. You may edit or delete records in this mode. From the File menu, select \u201cView Database\u201d. In this view, you may look at: All addresses Valid addresses only Corrected addresses only Uncorrectable addresses only Duplicates only Common records […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"no-sidebar","site-content-layout":"page-builder","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"disabled","ast-breadcrumbs-content":"","ast-featured-img":"disabled","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-159","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.flagshipsoftware.com\/fsweb\/wp-json\/wp\/v2\/pages\/159","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.flagshipsoftware.com\/fsweb\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.flagshipsoftware.com\/fsweb\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.flagshipsoftware.com\/fsweb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flagshipsoftware.com\/fsweb\/wp-json\/wp\/v2\/comments?post=159"}],"version-history":[{"count":5,"href":"https:\/\/www.flagshipsoftware.com\/fsweb\/wp-json\/wp\/v2\/pages\/159\/revisions"}],"predecessor-version":[{"id":5094,"href":"https:\/\/www.flagshipsoftware.com\/fsweb\/wp-json\/wp\/v2\/pages\/159\/revisions\/5094"}],"wp:attachment":[{"href":"https:\/\/www.flagshipsoftware.com\/fsweb\/wp-json\/wp\/v2\/media?parent=159"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}