{"id":183,"date":"2009-12-09T20:14:17","date_gmt":"2009-12-10T00:14:17","guid":{"rendered":"http:\/\/www.sofastatistics.com\/blog\/?p=183"},"modified":"2009-12-09T20:15:09","modified_gmt":"2009-12-10T00:15:09","slug":"0-8-14-much-more-flexible-management-of-data-table-design-inside-built-in-database","status":"publish","type":"post","link":"http:\/\/www.sofastatistics.com\/blog\/0-8-14-much-more-flexible-management-of-data-table-design-inside-built-in-database\/","title":{"rendered":"0.8.14 much more flexible management of data table design inside built-in database"},"content":{"rendered":"<p>The latest release not only has the usual bug fixes and usability enhancements, it has a few new pieces of functionality.<\/p>\n<ul>\n<li>Can modify the design of tables in the built-in SOFA database (variable names, types, order, table names).<\/li>\n<li>Able to insert and delete rows when editing value labels.<\/li>\n<li>Can delete tables in the built-in database.<\/li>\n<li>The sofa id field is now read-only when designing tables and the user gets useful messages if they try to delete it or insert a new field before it.<\/li>\n<\/ul>\n<p>The bug fixes were:<\/p>\n<ul>\n<li>CSV importer copes with inconsistent new line characters anywhere they are encountered.<\/li>\n<li>Fixed bug when a key is deleted in a value list and then OK is hit.<\/li>\n<li>Removed bug where focus would move erratically when entering long lists of value labels.<\/li>\n<li>Changing database or table when making table reports resets the column buttons as it should. <\/li>\n<li>Numbers like 1000000000000.2 are now displayed as simple numbers instead of as 1e+12 etc.<\/li>\n<li>Newly-created tables appear in the table dropdown list immediately.<\/li>\n<\/ul>\n<p>IMPORTANT FOR ALL UPGRADING USERS &#8211; you must delete the \/username\/sofa folder first (after storing anything you wish to save). And inside project files, change conn_dets to con_dets.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The latest release not only has the usual bug fixes and usability enhancements, it has a few new pieces of functionality. Can modify the design of tables in the built-in SOFA database (variable names, types, order, table names). Able to insert and delete rows when editing value labels. Can delete tables in the built-in database. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-183","post","type-post","status-publish","format-standard","hentry","category-general"],"_links":{"self":[{"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/posts\/183","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/comments?post=183"}],"version-history":[{"count":2,"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/posts\/183\/revisions"}],"predecessor-version":[{"id":185,"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/posts\/183\/revisions\/185"}],"wp:attachment":[{"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/media?parent=183"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/categories?post=183"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/tags?post=183"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}