{"id":45666,"date":"2026-09-14T02:56:00","date_gmt":"2026-09-14T02:56:00","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=45666"},"modified":"2026-09-16T03:53:15","modified_gmt":"2026-09-16T03:53:15","slug":"dbloader-3-6-released","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/pr\/dbloader-3-6-released.html","title":{"rendered":"DBLoader 3.6 Released: Fixed-Width Text, YAML &#038; Table Filter"},"content":{"rendered":"<p>September 14, 2026 \u2014 Withdata Software announces <strong><a href=\"https:\/\/www.withdata.com\/db-loader\/\">DBLoader 3.6<\/a><\/strong>, a cross-platform desktop tool for importing files into databases and exporting databases to files. This release adds <strong>fixed-width text<\/strong> and <strong>YAML<\/strong> in both directions, a new \u201cOptions \/ Output Settings\u201d page, and a table filter above the database object tree.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/db-loader\/db-loader.png\" alt=\"DBLoader 3.6 \u2013 fixed-width text, YAML, and a table filter for database import and export\" width=\"954\" height=\"714\" style=\"max-width:100%; height:auto; display:block;\" \/><\/p>\n<h2>What\u2019s New in DBLoader 3.6<\/h2>\n<h3>1. Fixed-Width Text, Both Ways<\/h3>\n<p>DBLoader can now <strong>import<\/strong> data from fixed-width text files \u2014 the column widths are detected from the data and can be adjusted before importing. It can also <strong>export<\/strong> to fixed-width text, again with widths detected from the data and editable, so the output lines up exactly the way a legacy system or mainframe expects.<\/p>\n<h3>2. YAML, Both Ways<\/h3>\n<p>On the import side, DBLoader reads the common YAML shapes: a list of mappings (each mapping is one record), a mapping whose values are lists (column-oriented), and a single mapping of scalar values. Nested mappings are flattened into dotted column names such as <code>meta.vip<\/code>, and large flat files are streamed in chunks to keep memory low.<\/p>\n<p>On the export side, you control the encoding, the indent, and block vs. flow style, and flattened columns can be written back as nested mappings. Values that contain line breaks become literal block scalars, and reading the file back gives the same columns and values.<\/p>\n<h3>3. Options \/ Output Settings &amp; Table Filter<\/h3>\n<ul>\n<li>A new \u201cOptions \/ Output Settings\u201d page collects the settings in one place, and the log filter and the finish notification are kept for the next run.<\/li>\n<li>A table filter now sits above the database object tree, so a large database is easy to search.<\/li>\n<\/ul>\n<h2>About DBLoader<\/h2>\n<p><a href=\"https:\/\/www.withdata.com\/db-loader\/\">DBLoader<\/a> imports files into databases and exports databases to files \u2014 fast and locally, without coding.<\/p>\n<ul>\n<li>Both directions in one tool: file to database, and database to file<\/li>\n<li>File formats: CSV, TSV, TXT, fixed-width text, Excel, JSON, XML, HTML table, YAML and SQL<\/li>\n<li>Databases: MySQL, Oracle, SQL Server, PostgreSQL, DB2, SQLite, Access, Redshift, Azure SQL, MariaDB, Percona, DBF and more<\/li>\n<li>1 file to 1 table, 1 file to N tables, N files to N tables; insert, update and upsert (including multi-column keys)<\/li>\n<li>Field mapping and preview; save and load sessions; table filter<\/li>\n<li>Batch processing, command line, and scheduled tasks for automation<\/li>\n<li>Cross-platform: Windows, Linux, macOS<\/li>\n<li>Fully local offline processing; no data uploaded to cloud servers<\/li>\n<\/ul>\n<h2>Upgrade Today<\/h2>\n<p><a href=\"https:\/\/www.withdata.com\/db-loader\/\">DBLoader 3.6<\/a> is ready for download: <a href=\"https:\/\/www.withdata.com\/db-loader\/download.html\">https:\/\/www.withdata.com\/db-loader\/download.html<\/a>. Existing users may update directly. New users can download a free trial to try the new fixed-width text and YAML support, and the table filter.<\/p>\n<p>Withdata Software continues optimizing DBLoader for real-world data import and export scenarios based on user feedback.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>September 14, 2026 \u2014 Withdata Software announces DBLoader 3.6, a cross-platform desktop tool for importing files into databases and exporting databases to files. This release adds fixed-width text and YAML in both directions, a new \u201cOptions \/ Output Settings\u201d page, and a table filter above the database object tree. What\u2019s New in DBLoader 3.6 1. [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[69],"tags":[2766,2765,13760,13775,13773,13754],"class_list":["post-45666","post","type-post","status-publish","format-standard","hentry","category-pr","tag-database-export","tag-database-import","tag-dba","tag-dbloader","tag-fixed-width","tag-yaml"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/45666","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/comments?post=45666"}],"version-history":[{"count":1,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/45666\/revisions"}],"predecessor-version":[{"id":45667,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/45666\/revisions\/45667"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=45666"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=45666"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=45666"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}