{"id":11890,"date":"2016-03-08T16:03:21","date_gmt":"2016-03-08T21:03:21","guid":{"rendered":"http:\/\/spaldingsoftware.com\/wp\/?page_id=11890"},"modified":"2021-06-08T11:54:45","modified_gmt":"2021-06-08T15:54:45","slug":"dataimport","status":"publish","type":"page","link":"https:\/\/spaldingsoftware.com\/wp\/dataimport\/","title":{"rendered":"DataImport &#8211; File \/ Data Import Utility"},"content":{"rendered":"<div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-1 nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: left top;background-repeat: no-repeat;padding-top:1px;padding-right:0px;padding-bottom:30px;padding-left:0px;margin-bottom: 0px;margin-top: 0px;border-width: 0px 0px 0px 0px;border-color:#eae9e9;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-0 fusion_builder_column_1_4 1_4 fusion-one-fourth fusion-column-first\" style=\"width:22%; margin-right: 4%;margin-top:0px;margin-bottom:10px;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;border-width: 0 0px 0 0;border-color:#909090;border-style:solid;padding: 10px 10px 10px 10px;\"><style type=\"text\/css\"><\/style><div class=\"fusion-title title fusion-title-1 fusion-sep-none fusion-title-center fusion-title-text fusion-title-size-one\" style=\"margin-top:5px;margin-right:0px;margin-bottom:5px;margin-left:0px;\"><h1 class=\"title-heading-center\" style=\"margin:0;\"><span style=\"color: #0b3d80;\"><strong>DataImport<\/strong><\/span><\/h1><\/div><div class=\"fusion-sep-clear\"><\/div><div class=\"fusion-separator fusion-has-icon fusion-full-width-sep\" style=\"margin-left: auto;margin-right: auto;margin-top:25px;margin-bottom:20px;width:100%;\"><div class=\"fusion-separator-border sep-single sep-solid\" style=\"border-color:#0b3d80;border-top-width:1px;\"><\/div><span class=\"icon-wrapper\" style=\"border-color:#0b3d80;background-color:rgba(255,255,255,0);font-size:18px;width: 1.75em; height: 1.75em;border-width:1px;padding:1px;margin-top:-0.5px\"><i class=\" fa fa-info-circle\" style=\"font-size: inherit;color:#0b3d80;\" aria-hidden=\"true\"><\/i><\/span><div class=\"fusion-separator-border sep-single sep-solid\" style=\"border-color:#0b3d80;border-top-width:1px;\"><\/div><\/div><div class=\"fusion-sep-clear\"><\/div><div class=\"fusion-align-block\"><style type=\"text\/css\">.fusion-button.button-1 .fusion-button-text, .fusion-button.button-1 i {color:rgba(255,255,255,1);}.fusion-button.button-1 .fusion-button-icon-divider{border-color:rgba(255,255,255,1);}.fusion-button.button-1:hover .fusion-button-text, .fusion-button.button-1:hover i,.fusion-button.button-1:focus .fusion-button-text, .fusion-button.button-1:focus i,.fusion-button.button-1:active .fusion-button-text, .fusion-button.button-1:active{color:rgba(255,255,255,1);}.fusion-button.button-1:hover .fusion-button-icon-divider, .fusion-button.button-1:hover .fusion-button-icon-divider, .fusion-button.button-1:active .fusion-button-icon-divider{border-color:rgba(255,255,255,1);}.fusion-button.button-1:hover, .fusion-button.button-1:focus, .fusion-button.button-1:active{border-color:rgba(255,255,255,1);border-width:0px;}.fusion-button.button-1 {border-color:rgba(255,255,255,1);border-width:0px;border-radius:25px;}.fusion-button.button-1{background: #0b3d80;}.fusion-button.button-1:hover,.button-1:focus,.fusion-button.button-1:active{background: #1a80bb;}<\/style><a class=\"fusion-button button-flat button-medium button-custom button-1 fusion-button-span-yes \" target=\"_self\" href=\"https:\/\/spaldingsoftware.com\/wp\/dataimport\/di-purchase-info\/\"><span class=\"fusion-button-text\">How to Purchase<\/span><\/a><\/div><div class=\"fusion-sep-clear\"><\/div><div class=\"fusion-separator fusion-full-width-sep\" style=\"margin-left: auto;margin-right: auto;margin-top:15px;margin-bottom:15px;width:100%;\"><div class=\"fusion-separator-border sep-single sep-solid\" style=\"border-color:#0b3d80;border-top-width:1px;\"><\/div><\/div><div class=\"fusion-sep-clear\"><\/div><div class=\"fusion-align-block\"><style type=\"text\/css\">.fusion-button.button-2 .fusion-button-text, .fusion-button.button-2 i {color:rgba(255,255,255,1);}.fusion-button.button-2 .fusion-button-icon-divider{border-color:rgba(255,255,255,1);}.fusion-button.button-2:hover .fusion-button-text, .fusion-button.button-2:hover i,.fusion-button.button-2:focus .fusion-button-text, .fusion-button.button-2:focus i,.fusion-button.button-2:active .fusion-button-text, .fusion-button.button-2:active{color:rgba(255,255,255,1);}.fusion-button.button-2:hover .fusion-button-icon-divider, .fusion-button.button-2:hover .fusion-button-icon-divider, .fusion-button.button-2:active .fusion-button-icon-divider{border-color:rgba(255,255,255,1);}.fusion-button.button-2:hover, .fusion-button.button-2:focus, .fusion-button.button-2:active{border-color:rgba(255,255,255,1);border-width:0px;}.fusion-button.button-2 {border-color:rgba(255,255,255,1);border-width:0px;border-radius:25px;}.fusion-button.button-2{background: #0b3d80;}.fusion-button.button-2:hover,.button-2:focus,.fusion-button.button-2:active{background: #1a80bb;}<\/style><a class=\"fusion-button button-flat button-medium button-custom button-2 fusion-button-span-yes \" target=\"_self\" href=\"https:\/\/spaldingsoftware.com\/wp\/dataimport\/di-usage-examples\/\"><span class=\"fusion-button-text\">Usage Examples<\/span><\/a><\/div><div class=\"fusion-sep-clear\"><\/div><div class=\"fusion-separator fusion-full-width-sep\" style=\"margin-left: auto;margin-right: auto;margin-top:5px;margin-bottom:5px;width:100%;\"><\/div><div class=\"fusion-sep-clear\"><\/div><div class=\"fusion-align-block\"><style type=\"text\/css\">.fusion-button.button-3 .fusion-button-text, .fusion-button.button-3 i {color:rgba(255,255,255,1);}.fusion-button.button-3 .fusion-button-icon-divider{border-color:rgba(255,255,255,1);}.fusion-button.button-3:hover .fusion-button-text, .fusion-button.button-3:hover i,.fusion-button.button-3:focus .fusion-button-text, .fusion-button.button-3:focus i,.fusion-button.button-3:active .fusion-button-text, .fusion-button.button-3:active{color:rgba(255,255,255,1);}.fusion-button.button-3:hover .fusion-button-icon-divider, .fusion-button.button-3:hover .fusion-button-icon-divider, .fusion-button.button-3:active .fusion-button-icon-divider{border-color:rgba(255,255,255,1);}.fusion-button.button-3:hover, .fusion-button.button-3:focus, .fusion-button.button-3:active{border-color:rgba(255,255,255,1);border-width:0px;}.fusion-button.button-3 {border-color:rgba(255,255,255,1);border-width:0px;border-radius:25px;}.fusion-button.button-3{background: #0b3d80;}.fusion-button.button-3:hover,.button-3:focus,.fusion-button.button-3:active{background: #1a80bb;}<\/style><a class=\"fusion-button button-flat button-medium button-custom button-3 fusion-button-span-yes \" target=\"_self\" href=\"https:\/\/spaldingsoftware.com\/wp\/dataimport\/di-resources\/\"><span class=\"fusion-button-text\">Downloads<\/span><\/a><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-1 fusion_builder_column_1_2 1_2 fusion-one-half\" style=\"width:48%; margin-right: 4%;margin-top:0px;margin-bottom:0px;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;background-color:#f0f0f0;border-width: 0px 0px 0px 0px;border-color:#8e8e8e;border-style:solid;padding: 10px 10px 10px 10px;\"><style type='text\/css'>.reading-box-container-1 .element-bottomshadow:before,.reading-box-container-1 .element-bottomshadow:after{opacity:0.7;}<\/style><div class=\"fusion-reading-box-container reading-box-container-1\" style=\"margin-top:0px;margin-bottom:0px;\"><div class=\"reading-box element-bottomshadow\" style=\"background-color:#ffffff;border-width:1px;border-color:#f6f6f6;border-top-width:3px;border-top-color:var(--primary_color);border-style:solid;\"><div class=\"reading-box-additional\">\n<p style=\"font-size: 18px; line-height: 29px;\"><span style=\"color: #0b3d80;\"><strong>DataImport<\/strong><\/span> 6 extracts data from reports of nearly any complexity and outputs it into spreadsheet, database and other useful file formats. This includes Microsoft Access, Excel, HTML tables, XML tables, delimited, dBase and <u>nearly 40 other file types<\/u>. With <span style=\"color: #0b3d80;\"><strong>DataImport<\/strong><\/span>, you can quickly and easily mine data from files such as mainframe reports, data dumps, print-to-disk files, downloaded information, or most any other type of text file.<\/p>\n<p style=\"font-size: 18px; line-height: 29px;\">If you have become frustrated with the meager import features found in Excel, Access and other applications, you need <span style=\"color: #0b3d80;\"><strong>DataImport<\/strong><\/span>. It specializes in giving you the tools needed to pull data from complex multilevel reports and forms. <span style=\"color: #0b3d80;\"><strong>DataImport<\/strong><\/span> unlocks the data trapped in page headings, section headings, multiple detail lines, total lines, footers, and summaries.<\/p>\n<p style=\"font-size: 18px; line-height: 29px;\">With <span style=\"color: #0b3d80;\"><strong>DataImport\u2019s<\/strong><\/span> easy, intuitive, point-and-click interface, you select just the data you want. Whether it is specific columns of data, rows, or sections of a report. A wealth of features are provided to give you complete control of the import process.<\/p>\n<p style=\"font-size: 18px; line-height: 29px;\"><span style=\"color: #0b3d80;\"><b>DataImport<\/b><\/span> recognizes and properly formats numbers, decimals, percents, dates, times, and the currency of any country. It parses names like &#8220;Dr. John A. Smith, Jr.&#8221; and places the parts into five separate fields or columns. It will even append to an existing database and output to a specific sheet in an Excel workbook.<\/p>\n<p style=\"font-size: 18px; line-height: 29px;\">All of the selections that you make are saved for repeated use with future versions of the same report. Multiple or repetitive translation jobs are easily automated. <span style=\"color: #0b3d80;\"><b>DataImport<\/b><\/span> has 15 years of experience solving tough report file translation jobs for thousands of users around the world.<\/p>\n<\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-2 fusion_builder_column_1_4 1_4 fusion-one-fourth fusion-column-last\" style=\"width:22%;margin-top:10px;margin-bottom:1px;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;border-width: 0 0 0 0px;border-color:#8e8e8e;border-style:solid;padding: 0px 0px 0px 0px;\"><style type=\"text\/css\"><\/style><div class=\"fusion-title title fusion-title-2 fusion-sep-none fusion-title-center fusion-title-text fusion-title-size-two\" style=\"margin-top:0px;margin-right:0px;margin-bottom:5px;margin-left:0px;\"><h2 class=\"title-heading-center\" style=\"margin:0;\"><strong>Supported File Types<\/strong><\/h2><\/div><div class=\"fusion-sep-clear\"><\/div><div class=\"fusion-separator fusion-has-icon\" style=\"margin-left: auto;margin-right: auto;margin-top:25px;margin-bottom:25px;width:100%;max-width:80%;\"><div class=\"fusion-separator-border sep-single sep-solid\" style=\"border-color:#0b3d80;border-top-width:1px;\"><\/div><span class=\"icon-wrapper\" style=\"border-color:#0b3d80;background-color:rgba(255,255,255,0);font-size:18px;width: 1.75em; height: 1.75em;border-width:1px;padding:1px;margin-top:-0.5px\"><i class=\" fa fa-chevron-down\" style=\"font-size: inherit;color:#0b3d80;\" aria-hidden=\"true\"><\/i><\/span><div class=\"fusion-separator-border sep-single sep-solid\" style=\"border-color:#0b3d80;border-top-width:1px;\"><\/div><\/div><div class=\"fusion-sep-clear\"><\/div><ul class=\"fusion-checklist fusion-checklist-1\" style=\"font-size:12px;line-height:20.4px;\"><li class=\"fusion-li-item\"><span style=\"height:20.4px;width:20.4px;margin-right:8.4px;\" class=\"icon-wrapper circle-no\"><i class=\"fusion-li-icon fa-check fas\" style=\"color:#1a80bb;\" aria-hidden=\"true\"><\/i><\/span><div class=\"fusion-li-item-content\" style=\"margin-left:28.8px;\">\n<p>Microsoft Excel 2.1, 3.0, 4.0, 5.0, 7.0, 97, 2000, XP, 2007 (.xlsx)<\/p>\n<\/div><\/li><li class=\"fusion-li-item\"><span style=\"height:20.4px;width:20.4px;margin-right:8.4px;\" class=\"icon-wrapper circle-no\"><i class=\"fusion-li-icon fa-check fas\" style=\"color:#1a80bb;\" aria-hidden=\"true\"><\/i><\/span><div class=\"fusion-li-item-content\" style=\"margin-left:28.8px;\">Microsoft Access 1.1, 2.0, 3.0, 97, 4.0, 2000, XP<\/div><\/li><li class=\"fusion-li-item\"><span style=\"height:20.4px;width:20.4px;margin-right:8.4px;\" class=\"icon-wrapper circle-no\"><i class=\"fusion-li-icon fa-check fas\" style=\"color:#1a80bb;\" aria-hidden=\"true\"><\/i><\/span><div class=\"fusion-li-item-content\" style=\"margin-left:28.8px;\">XML Table<\/div><\/li><li class=\"fusion-li-item\"><span style=\"height:20.4px;width:20.4px;margin-right:8.4px;\" class=\"icon-wrapper circle-no\"><i class=\"fusion-li-icon fa-check fas\" style=\"color:#1a80bb;\" aria-hidden=\"true\"><\/i><\/span><div class=\"fusion-li-item-content\" style=\"margin-left:28.8px;\">HTML Table<\/div><\/li><li class=\"fusion-li-item\"><span style=\"height:20.4px;width:20.4px;margin-right:8.4px;\" class=\"icon-wrapper circle-no\"><i class=\"fusion-li-icon fa-check fas\" style=\"color:#1a80bb;\" aria-hidden=\"true\"><\/i><\/span><div class=\"fusion-li-item-content\" style=\"margin-left:28.8px;\">dBase II, III, IV<\/div><\/li><li class=\"fusion-li-item\"><span style=\"height:20.4px;width:20.4px;margin-right:8.4px;\" class=\"icon-wrapper circle-no\"><i class=\"fusion-li-icon fa-check fas\" style=\"color:#1a80bb;\" aria-hidden=\"true\"><\/i><\/span><div class=\"fusion-li-item-content\" style=\"margin-left:28.8px;\">Lotus 1-2-3 1A, 2.0, 3.0, 4.0, 5.0<\/div><\/li><li class=\"fusion-li-item\"><span style=\"height:20.4px;width:20.4px;margin-right:8.4px;\" class=\"icon-wrapper circle-no\"><i class=\"fusion-li-icon fa-check fas\" style=\"color:#1a80bb;\" aria-hidden=\"true\"><\/i><\/span><div class=\"fusion-li-item-content\" style=\"margin-left:28.8px;\">ASCII<\/div><\/li><li class=\"fusion-li-item\"><span style=\"height:20.4px;width:20.4px;margin-right:8.4px;\" class=\"icon-wrapper circle-no\"><i class=\"fusion-li-icon fa-check fas\" style=\"color:#1a80bb;\" aria-hidden=\"true\"><\/i><\/span><div class=\"fusion-li-item-content\" style=\"margin-left:28.8px;\">Comma Separated Value<\/div><\/li><li class=\"fusion-li-item\"><span style=\"height:20.4px;width:20.4px;margin-right:8.4px;\" class=\"icon-wrapper circle-no\"><i class=\"fusion-li-icon fa-check fas\" style=\"color:#1a80bb;\" aria-hidden=\"true\"><\/i><\/span><div class=\"fusion-li-item-content\" style=\"margin-left:28.8px;\">Delimited Text<\/div><\/li><li class=\"fusion-li-item\"><span style=\"height:20.4px;width:20.4px;margin-right:8.4px;\" class=\"icon-wrapper circle-no\"><i class=\"fusion-li-icon fa-check fas\" style=\"color:#1a80bb;\" aria-hidden=\"true\"><\/i><\/span><div class=\"fusion-li-item-content\" style=\"margin-left:28.8px;\">User-Defined Delimited<\/div><\/li><li class=\"fusion-li-item\"><span style=\"height:20.4px;width:20.4px;margin-right:8.4px;\" class=\"icon-wrapper circle-no\"><i class=\"fusion-li-icon fa-check fas\" style=\"color:#1a80bb;\" aria-hidden=\"true\"><\/i><\/span><div class=\"fusion-li-item-content\" style=\"margin-left:28.8px;\">Tab Separated Variable<\/div><\/li><li class=\"fusion-li-item\"><span style=\"height:20.4px;width:20.4px;margin-right:8.4px;\" class=\"icon-wrapper circle-no\"><i class=\"fusion-li-icon fa-check fas\" style=\"color:#1a80bb;\" aria-hidden=\"true\"><\/i><\/span><div class=\"fusion-li-item-content\" style=\"margin-left:28.8px;\">Fixed Field Text<\/div><\/li><li class=\"fusion-li-item\"><span style=\"height:20.4px;width:20.4px;margin-right:8.4px;\" class=\"icon-wrapper circle-no\"><i class=\"fusion-li-icon fa-check fas\" style=\"color:#1a80bb;\" aria-hidden=\"true\"><\/i><\/span><div class=\"fusion-li-item-content\" style=\"margin-left:28.8px;\">Mailing Label<\/div><\/li><li class=\"fusion-li-item\"><span style=\"height:20.4px;width:20.4px;margin-right:8.4px;\" class=\"icon-wrapper circle-no\"><i class=\"fusion-li-icon fa-check fas\" style=\"color:#1a80bb;\" aria-hidden=\"true\"><\/i><\/span><div class=\"fusion-li-item-content\" style=\"margin-left:28.8px;\">Clarion<\/div><\/li><li class=\"fusion-li-item\"><span style=\"height:20.4px;width:20.4px;margin-right:8.4px;\" class=\"icon-wrapper circle-no\"><i class=\"fusion-li-icon fa-check fas\" style=\"color:#1a80bb;\" aria-hidden=\"true\"><\/i><\/span><div class=\"fusion-li-item-content\" style=\"margin-left:28.8px;\">Microsoft Word Merge<\/div><\/li><li class=\"fusion-li-item\"><span style=\"height:20.4px;width:20.4px;margin-right:8.4px;\" class=\"icon-wrapper circle-no\"><i class=\"fusion-li-icon fa-check fas\" style=\"color:#1a80bb;\" aria-hidden=\"true\"><\/i><\/span><div class=\"fusion-li-item-content\" style=\"margin-left:28.8px;\">Quattro Pro 5.0<\/div><\/li><li class=\"fusion-li-item\"><span style=\"height:20.4px;width:20.4px;margin-right:8.4px;\" class=\"icon-wrapper circle-no\"><i class=\"fusion-li-icon fa-check fas\" style=\"color:#1a80bb;\" aria-hidden=\"true\"><\/i><\/span><div class=\"fusion-li-item-content\" style=\"margin-left:28.8px;\">Sylk<\/div><\/li><li class=\"fusion-li-item\"><span style=\"height:20.4px;width:20.4px;margin-right:8.4px;\" class=\"icon-wrapper circle-no\"><i class=\"fusion-li-icon fa-check fas\" style=\"color:#1a80bb;\" aria-hidden=\"true\"><\/i><\/span><div class=\"fusion-li-item-content\" style=\"margin-left:28.8px;\">Symphony 1.0, 1.1<\/div><\/li><li class=\"fusion-li-item\"><span style=\"height:20.4px;width:20.4px;margin-right:8.4px;\" class=\"icon-wrapper circle-no\"><i class=\"fusion-li-icon fa-check fas\" style=\"color:#1a80bb;\" aria-hidden=\"true\"><\/i><\/span><div class=\"fusion-li-item-content\" style=\"margin-left:28.8px;\">WordPerfect Merge 5.0, 5.1<\/div><\/li><li class=\"fusion-li-item\"><span style=\"height:20.4px;width:20.4px;margin-right:8.4px;\" class=\"icon-wrapper circle-no\"><i class=\"fusion-li-icon fa-check fas\" style=\"color:#1a80bb;\" aria-hidden=\"true\"><\/i><\/span><div class=\"fusion-li-item-content\" style=\"margin-left:28.8px;\">Columnwise DIF<\/div><\/li><li class=\"fusion-li-item\"><span style=\"height:20.4px;width:20.4px;margin-right:8.4px;\" class=\"icon-wrapper circle-no\"><i class=\"fusion-li-icon fa-check fas\" style=\"color:#1a80bb;\" aria-hidden=\"true\"><\/i><\/span><div class=\"fusion-li-item-content\" style=\"margin-left:28.8px;\">Named Value<\/div><\/li><\/ul><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":6,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/spaldingsoftware.com\/wp\/wp-json\/wp\/v2\/pages\/11890"}],"collection":[{"href":"https:\/\/spaldingsoftware.com\/wp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/spaldingsoftware.com\/wp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/spaldingsoftware.com\/wp\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/spaldingsoftware.com\/wp\/wp-json\/wp\/v2\/comments?post=11890"}],"version-history":[{"count":6,"href":"https:\/\/spaldingsoftware.com\/wp\/wp-json\/wp\/v2\/pages\/11890\/revisions"}],"predecessor-version":[{"id":15174,"href":"https:\/\/spaldingsoftware.com\/wp\/wp-json\/wp\/v2\/pages\/11890\/revisions\/15174"}],"wp:attachment":[{"href":"https:\/\/spaldingsoftware.com\/wp\/wp-json\/wp\/v2\/media?parent=11890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}