{"id":151,"date":"2017-10-18T11:17:46","date_gmt":"2017-10-18T15:17:46","guid":{"rendered":"https:\/\/www.flagshipsoftware.com\/wordpress\/portal\/?page_id=151"},"modified":"2022-05-13T11:25:52","modified_gmt":"2022-05-13T15:25:52","slug":"merging-databases-single-job","status":"publish","type":"page","link":"https:\/\/www.flagshipsoftware.com\/fsweb\/merging-databases-single-job\/","title":{"rendered":"Merge into Job"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"151\" class=\"elementor elementor-151\" data-elementor-post-type=\"page\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3ead7b0 elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"3ead7b0\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;shape_divider_top&quot;:&quot;book&quot;}\">\n\t\t\t\t\t<div class=\"elementor-shape elementor-shape-top\" aria-hidden=\"true\" data-negative=\"false\">\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 1000 100\" preserveAspectRatio=\"none\">\n\t<path class=\"elementor-shape-fill\" d=\"M194,99c186.7,0.7,305-78.3,306-97.2c1,18.9,119.3,97.9,306,97.2c114.3-0.3,194,0.3,194,0.3s0-91.7,0-100c0,0,0,0,0-0 L0,0v99.3C0,99.3,79.7,98.7,194,99z\"\/>\n<\/svg>\t\t<\/div>\n\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-366ec7b\" data-id=\"366ec7b\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c7afbf7 elementor-widget elementor-widget-spacer\" data-id=\"c7afbf7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-730ed1f elementor-widget elementor-widget-heading\" data-id=\"730ed1f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h1 class=\"elementor-heading-title elementor-size-default\">Merge into Job<\/h1>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c7cc01f elementor-widget elementor-widget-spacer\" data-id=\"c7cc01f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/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<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7b05e0e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7b05e0e\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-7b4ce06\" data-id=\"7b4ce06\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d4033e6 elementor-widget elementor-widget-text-editor\" data-id=\"d4033e6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p class=\"p_Garamond_std\">iAddress\u2122 has a feature that allows you to combine two or more databases into a single mailing job. To merge databases, you must open the first database using the Create Job or Create ODBC Job command from the main menu and select the appropriate fields. When this has been completed for the first database, you can start adding files. \u00a0Merged files do not need to be the same file type (eg. Access or Excel) nor do they need to have the same layout. From the File menu, select \u201cMerge into Job\u201d.\u00a0<span class=\"f_Garamond_std\">You must set up every name field for a merge job since the field names in your input files may be\u00a0<\/span><\/p><p><strong><span class=\"f_Garamond_subtext\">The Merge Databases function must be performed prior to Validation.<\/span><\/strong><\/p><ul><li>Once you have selected Merge Databases, the Open window will appear. Select the database you wish to merge and click \u201cOpen\u201d. Follow the same steps as outlined for Create Job\/Create ODBC Job for selecting the table and assigning fields. Once this is complete, you can add additional files or proceed with correction\/validation and\/or sortation.<\/li><\/ul><p class=\"p_Garamond_subheading\"><strong><span class=\"f_Garamond_subheading\">Merging Additional Files<\/span><\/strong><\/p><ul><li>To add additional databases, simply select Merge Databases again from the main menu and follow the above steps.<\/li><li>\u00a0iAddress\u2122 \u00a0numbers the imported files 1, 2, 3, etc. If you wish to retain this field (MergeFile) on export, you must select Extra Control Fields on the Export Database screen.<\/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<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-be8c497\" data-id=\"be8c497\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1163193 elementor-widget elementor-widget-image\" data-id=\"1163193\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"646\" height=\"390\" src=\"https:\/\/www.flagshipsoftware.com\/fsweb\/wp-content\/uploads\/2022\/05\/Merge.png\" class=\"attachment-large size-large wp-image-5139\" alt=\"\" \/>\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":"<p>Merge into Job iAddress\u2122 has a feature that allows you to combine two or more databases into a single mailing job. To merge databases, you must open the first database using the Create Job or Create ODBC Job command from the main menu and select the appropriate fields. When this has been completed for the [&hellip;]<\/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-151","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.flagshipsoftware.com\/fsweb\/wp-json\/wp\/v2\/pages\/151","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=151"}],"version-history":[{"count":8,"href":"https:\/\/www.flagshipsoftware.com\/fsweb\/wp-json\/wp\/v2\/pages\/151\/revisions"}],"predecessor-version":[{"id":5145,"href":"https:\/\/www.flagshipsoftware.com\/fsweb\/wp-json\/wp\/v2\/pages\/151\/revisions\/5145"}],"wp:attachment":[{"href":"https:\/\/www.flagshipsoftware.com\/fsweb\/wp-json\/wp\/v2\/media?parent=151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}