{"id":128,"date":"2017-10-18T10:49:06","date_gmt":"2017-10-18T10:49:06","guid":{"rendered":"https:\/\/www.flagshipsoftware.com\/wordpress\/portal\/?page_id=128"},"modified":"2025-05-15T10:46:54","modified_gmt":"2025-05-15T14:46:54","slug":"create-job","status":"publish","type":"page","link":"https:\/\/www.flagshipsoftware.com\/fsweb\/create-job\/","title":{"rendered":"Create Job"},"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

Create a Job<\/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

To start a new job, select \u201cCreate Job\u201d from the File menu.<\/p>

Select the database and click \u201cOpen\u201d or double click the database. Once your database has opened, a screen will appear to continue with the next steps.<\/p>

Multiple Tables in a Database<\/strong><\/p>

If multiple tables exist in the database, a window will appear listing the tables and the number of records in each table. Select the table you want to use, then double click or click \u201cDone\u201d.<\/span><\/p>

If you need to import multiple tables from the same spreadsheet, you will have to repeat this process using the Merge into Job feature for each table.<\/span><\/p>

Text Files<\/strong><\/p>

If you have selected a text database, the following window will appear:<\/span><\/p>

Choose the type of text file, select whether your first row is a header row and if you would like to load all columns as text columns (recommended) and click continue. \u00a0If you have chosen a fixed length file, a screen will appear showing you which fields iAddress\u2122 has autodetected. You can make changes to your file, and load or save templates. When you are satisfied with your changes, click \u201cCreate Job\u201d.<\/p>

\u00a0<\/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\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

Selecting Address Fields<\/span><\/strong><\/p>

iAddress\u2122 will automatically attempt to match the database fields to the appropriate iAddress\u2122 fields. You can override these entries and select fields iAddress\u2122 was unable to locate.\u00a0From the drop down list under each iAddress\u2122 field, scroll and select the database field that corresponds to the information required by the program.<\/span><\/p>

For example:<\/span><\/strong><\/div>
  1. Click the down arrow below the Last Name field to bring up the drop down list<\/span><\/li>
  2. Select the field that contains the Last Name information<\/span><\/li>
  3. You can assign a name to your job. If you do not assign a name, a default description for your job will be used.<\/li>
  4. Ensure you have filled in all required fields and any of the optional fields, then click \u201cOK\u201d.<\/li><\/ol>

    Single Field Data<\/span><\/strong><\/p>

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

    • City, Province and\u00a0Postal Code<\/span>OM<\/span>, you must check the \u201cOne Field: City Province Postal \/ ZIP\u201d box<\/span><\/li>
    • City and Province, you must check the \u201cOne Field: CityProvince\u201d box\u00a0<\/li><\/ul>

      \u00a0US<\/span><\/strong><\/p>

      • City, State, and\u00a0Zip Code<\/span>TM<\/span>, you must check the \u201cOne Field: City State Zip(Zip+4)\u201d box<\/span><\/li>
      • City and State, you must check the \u201cOne Field: City State\u201d box<\/li><\/ul>

        \u00a0You will then be prompted for the field name containing this information<\/span><\/p>

        Multiple Field Components<\/span><\/strong><\/p>

        • If your address is split into many field components (eg. apartment, street number, street name, etc.), click the button to the right of the first address line. Select all address line components in the order you want them to appear and click Done.<\/li><\/ul>

          Language Indicator (Canada)<\/span><\/strong><\/p>

          • If your database has a field that indicates whether the entry is French or English and you wish to use this information in your correction, select the appropriate field from the drop-down menu. Beside each language, enter the appropriate code.<\/li><\/ul>

            \u00a0
            To view your data<\/span><\/strong><\/p>

            • If you are unsure of the data contained in the fields, use the horizontal scroll bar below the database box to scroll left and right. This scroll bar will also allow you to see what will appear in the iAddress\u2122 fields. Fill in any field, then scroll left and right.<\/li><\/ul>

              Using Templates<\/span><\/strong><\/p>

              • If you frequently create jobs using the same data file, you can create a template. This template stores the field information so you do not have to select your fields when creating a new job.<\/li><\/ul>

                Character Set<\/span><\/strong><\/p>

                • This option tells iAddress\u2122 what type of system the data originated from so that it can \u201ctranslate\u201d various computer codes. The default is Windows; some users require OEM if their data did not originate from a Windows-based system.<\/li><\/ul>

                  Using Customer Information<\/span><\/strong><\/p>

                  • If you have entered information on your customers under Company Information, you can use the drop-down here to select them. This will display their name and their associated USPS or Canada Post account number on reports.<\/li><\/ul>

                    Remove Header Row<\/span><\/strong><\/p>

                    • If you are using an Excel File and the first row contains the column headers, select this option to use the first row as column headers.<\/li><\/ul>\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\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":"

                      Create a Job To start a new job, select \u201cCreate Job\u201d from the File menu. Select the database and click \u201cOpen\u201d or double click the database. Once your database has opened, a screen will appear to continue with the next steps. Multiple Tables in a Database If multiple tables exist in the database, a window […]<\/p>\n","protected":false},"author":2,"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-128","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.flagshipsoftware.com\/fsweb\/wp-json\/wp\/v2\/pages\/128","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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flagshipsoftware.com\/fsweb\/wp-json\/wp\/v2\/comments?post=128"}],"version-history":[{"count":19,"href":"https:\/\/www.flagshipsoftware.com\/fsweb\/wp-json\/wp\/v2\/pages\/128\/revisions"}],"predecessor-version":[{"id":4991,"href":"https:\/\/www.flagshipsoftware.com\/fsweb\/wp-json\/wp\/v2\/pages\/128\/revisions\/4991"}],"wp:attachment":[{"href":"https:\/\/www.flagshipsoftware.com\/fsweb\/wp-json\/wp\/v2\/media?parent=128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}