{"id":237,"date":"2020-02-02T09:30:03","date_gmt":"2020-02-02T09:30:03","guid":{"rendered":"https:\/\/zedinet.com\/?page_id=237"},"modified":"2020-02-04T10:26:57","modified_gmt":"2020-02-04T10:26:57","slug":"mappings","status":"publish","type":"page","link":"https:\/\/zedinet.com\/index.php\/mappings\/","title":{"rendered":"Mappings"},"content":{"rendered":"<div class=\"wpb-content-wrapper\"><section class=\"l-section wpb_row height_medium\"><div class=\"l-section-h i-cf\"><div class=\"g-cols vc_row type_default valign_top\"><div class=\"vc_col-sm-12 wpb_column vc_column_container\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\">\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<h1>Mapping Capabilities<\/h1>\n<p>Expand the headings below to see how different types of file can be mapped by ZEDI.<\/p>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<\/div><\/div><\/div><\/div><\/div><\/section><section class=\"l-section wpb_row height_medium\" style=\"margin-top: 0px !important;margin-bottom: 0px !important;border-top-width: 0px !important;border-bottom-width: 0px !important;\"><div class=\"l-section-h i-cf\" style=\"padding-top: 0px !important;padding-bottom: 0px !important;\"><div class=\"g-cols vc_row type_default valign_top\"><div class=\"vc_col-sm-12 wpb_column vc_column_container has-fill\"><div class=\"vc_column-inner  vc_custom_1580595962016\"><div class=\"wpb_wrapper\"><div class=\"w-tabs style_default switch_click accordion title_atleft icon_none vc_custom_1580665211008 \"><div class=\"w-tabs-list items_7\"><div class=\"w-tabs-list-h\"><div class=\"w-tabs-item\"><div class=\"w-tabs-item-h\"><span class=\"w-tabs-item-title\">EDI files<\/span><\/div><\/div><div class=\"w-tabs-item\"><div class=\"w-tabs-item-h\"><span class=\"w-tabs-item-title\">XML files<\/span><\/div><\/div><div class=\"w-tabs-item\"><div class=\"w-tabs-item-h\"><span class=\"w-tabs-item-title\">Separated (CSV) files<\/span><\/div><\/div><div class=\"w-tabs-item\"><div class=\"w-tabs-item-h\"><span class=\"w-tabs-item-title\">Fixed position (flat) files<\/span><\/div><\/div><div class=\"w-tabs-item\"><div class=\"w-tabs-item-h\"><span class=\"w-tabs-item-title\">Spreadsheets<\/span><\/div><\/div><div class=\"w-tabs-item\"><div class=\"w-tabs-item-h\"><span class=\"w-tabs-item-title\">SQL<\/span><\/div><\/div><div class=\"w-tabs-item\"><div class=\"w-tabs-item-h\"><span class=\"w-tabs-item-title\">HTML<\/span><\/div><\/div><\/div><\/div><div class=\"w-tabs-sections\"><div class=\"w-tabs-sections-h\"><div class=\"w-tabs-section\" id=\"1580592840818-0561580e-8391\"><a href=\"#1580592840818-0561580e-8391\" class=\"w-tabs-section-header\"><div class=\"w-tabs-section-header-h\"><div class=\"w-tabs-section-title\">EDI files<\/div><div class=\"w-tabs-section-control\"><\/div><\/div><\/a><div class=\"w-tabs-section-content\"><div class=\"w-tabs-section-content-h i-cf\">\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<p>EDI files can be processed by ZEDI and mapped to produce whatever file type is required by your business systems. ZEDI can also produce EDI files by mapping data exported by your business systems in any machine-readable format.<\/p>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<div class=\"smile_icon_list_wrap ult_info_list_container ult-adjust-bottom-margin  \"><ul class=\"smile_icon_list left square with_bg\"><li class=\"icon_list_item\" style=\" font-size:72px;\"><div class=\"icon_list_icon\" data-animation=\"\" data-animation-delay=\"03\" style=\"font-size:24px;border-width:1px;border-style:solid;background:#ffffff;color:#0092c8;border-color:#0092c8;\"><i class=\"Defaults-film\" ><\/i><a class=\"ulimate-info-list-link\" href=\"https:\/\/zedinet.com\/index.php\/mappingsvideo\/\" title=\"Mappings video\" ><\/a><\/div><div class=\"icon_description\" id=\"Info-list-wrap-1321\" style=\"font-size:24px;\"><div class=\"icon_description_text ult-responsive\"  data-ultimate-target='#Info-list-wrap-1321 .icon_description_text'  data-responsive-json-new='{\"font-size\":\"desktop:13px;\",\"line-height\":\"desktop:18px;\"}'  style=\"\"><p><big><big>Click here to watch a video that explains how this works in practice<\/big><\/big><\/p>\n<\/div><\/div><div class=\"icon_list_connector\"  style=\"border-right-width: 1px;border-right-style: dashed;border-color: #333333;\"><\/div><\/li><\/ul><\/div><\/div><\/div><\/div><div class=\"w-tabs-section\" id=\"1580592840818-9caf54f2-30a4\"><a href=\"#1580592840818-9caf54f2-30a4\" class=\"w-tabs-section-header\"><div class=\"w-tabs-section-header-h\"><div class=\"w-tabs-section-title\">XML files<\/div><div class=\"w-tabs-section-control\"><\/div><\/div><\/a><div class=\"w-tabs-section-content\"><div class=\"w-tabs-section-content-h i-cf\">\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<p>XML files can be processed by ZEDI and mapped to produce whatever file type is required by your business systems. ZEDI can also produce XML files by mapping data exported by your business systems in any machine-readable format.<\/p>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<\/div><\/div><\/div><div class=\"w-tabs-section\" id=\"1580592979002-146e2655-b650\"><a href=\"#1580592979002-146e2655-b650\" class=\"w-tabs-section-header\"><div class=\"w-tabs-section-header-h\"><div class=\"w-tabs-section-title\">Separated (CSV) files<\/div><div class=\"w-tabs-section-control\"><\/div><\/div><\/a><div class=\"w-tabs-section-content\"><div class=\"w-tabs-section-content-h i-cf\">\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<p>CSV files can be processed by ZEDI and mapped to produce whatever file type is required by your business systems. ZEDI can also produce CSV files by mapping data originating in any machine-readable format.<\/p>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<\/div><\/div><\/div><div class=\"w-tabs-section\" id=\"1580593045462-20cb4615-48ff\"><a href=\"#1580593045462-20cb4615-48ff\" class=\"w-tabs-section-header\"><div class=\"w-tabs-section-header-h\"><div class=\"w-tabs-section-title\">Fixed position (flat) files<\/div><div class=\"w-tabs-section-control\"><\/div><\/div><\/a><div class=\"w-tabs-section-content\"><div class=\"w-tabs-section-content-h i-cf\">\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<p>Fixed-position files can be processed by ZEDI and mapped to produce whatever file type is required by your business systems. ZEDI can also produce fixed-position files by mapping data originating in any machine-readable format.<\/p>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<\/div><\/div><\/div><div class=\"w-tabs-section\" id=\"1580593106897-5bb91b73-ddc5\"><a href=\"#1580593106897-5bb91b73-ddc5\" class=\"w-tabs-section-header\"><div class=\"w-tabs-section-header-h\"><div class=\"w-tabs-section-title\">Spreadsheets<\/div><div class=\"w-tabs-section-control\"><\/div><\/div><\/a><div class=\"w-tabs-section-content\"><div class=\"w-tabs-section-content-h i-cf\">\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<p>ZEDI can import data from spreadsheets and map it to produce whatever file type is required by your business systems. ZEDI can also produce spreadsheets by mapping data originating in any machine-readable format.<\/p>\n<p>Spreadsheets generated by ZEDI can be designed to include empty columns for the recipient to complete. That spreadsheet can then be returned to ZEDI for processing.<\/p>\n<p>A good example of this would be an order sent to a supplier. The spreadsheet would have a column containing the order quantity for each item, plus another empty column for the dispatch quantity. The supplier completes the dispatch quantity column and returns the spreadsheet to ZEDI. This information is then mapped so that the dispatch quantities can be passed back to your business systems.<\/p>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<\/div><\/div><\/div><div class=\"w-tabs-section\" id=\"1580593185451-43ae16ca-7d31\"><a href=\"#1580593185451-43ae16ca-7d31\" class=\"w-tabs-section-header\"><div class=\"w-tabs-section-header-h\"><div class=\"w-tabs-section-title\">SQL<\/div><div class=\"w-tabs-section-control\"><\/div><\/div><\/a><div class=\"w-tabs-section-content\"><div class=\"w-tabs-section-content-h i-cf\">\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<p>ZEDI can be configured to map an incoming file to produce an SQL script (sequence of SQL commands). These are typically used to insert data directly into an SQL database.<\/p>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<\/div><\/div><\/div><div class=\"w-tabs-section\" id=\"1580593245182-740bbb9f-4be5\"><a href=\"#1580593245182-740bbb9f-4be5\" class=\"w-tabs-section-header\"><div class=\"w-tabs-section-header-h\"><div class=\"w-tabs-section-title\">HTML<\/div><div class=\"w-tabs-section-control\"><\/div><\/div><\/a><div class=\"w-tabs-section-content\"><div class=\"w-tabs-section-content-h i-cf\">\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<p>ZEDI can map transactions originating in any machine-readable format to produce a human-readable HTML file. These are typically e-mailed directly to the recipient.<\/p>\n<p>This is commonly used when a transaction, such as a remittance advice, does not need to be imported into the business systems but simply e-mailed in a readable format to one of your colleagues.<\/p>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/section>\n<\/div>","protected":false},"excerpt":{"rendered":"Mapping Capabilities Expand the headings below to see how different types of file can be mapped by ZEDI. EDI filesXML filesSeparated (CSV) filesFixed position (flat) filesSpreadsheetsSQLHTMLEDI files EDI files can be processed by ZEDI and mapped to produce whatever file type is required by your business systems. ZEDI can also produce EDI files by mapping...","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-237","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/zedinet.com\/index.php\/wp-json\/wp\/v2\/pages\/237","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/zedinet.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/zedinet.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/zedinet.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zedinet.com\/index.php\/wp-json\/wp\/v2\/comments?post=237"}],"version-history":[{"count":4,"href":"https:\/\/zedinet.com\/index.php\/wp-json\/wp\/v2\/pages\/237\/revisions"}],"predecessor-version":[{"id":289,"href":"https:\/\/zedinet.com\/index.php\/wp-json\/wp\/v2\/pages\/237\/revisions\/289"}],"wp:attachment":[{"href":"https:\/\/zedinet.com\/index.php\/wp-json\/wp\/v2\/media?parent=237"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}