{"id":272,"date":"2010-03-30T06:02:47","date_gmt":"2010-03-30T10:02:47","guid":{"rendered":"http:\/\/www.sofastatistics.com\/blog\/?p=272"},"modified":"2010-03-30T06:14:13","modified_gmt":"2010-03-30T10:14:13","slug":"0-9-7-improved-data-design-report-tables-and-ods-importing","status":"publish","type":"post","link":"http:\/\/www.sofastatistics.com\/blog\/0-9-7-improved-data-design-report-tables-and-ods-importing\/","title":{"rendered":"0.9.7 Improved data design, report tables, and ODS importing"},"content":{"rendered":"

There are four big changes in the latest version. They’re not really new features as such – the changes are mainly focused on making SOFA Statistics more pleasant to use. We hope you like it :-).<\/p>\n

1) When designing or redesigning data tables, users now have visual feedback on the changes made in the form of a demonstration table:<\/p>\n

\"Data<\/a>

Data design form<\/p><\/div>\n

2) The Projects form has been made a bit more attractive and coherent. Hopefully, it will be easier to use:<\/p>\n

\"Project<\/a>

Project form refreshed<\/p><\/div>\n

3) Demonstration report tables are more visually distinct from actual report tables (i.e. those run off the data):<\/p>\n

\"Demo<\/a>

Demo tables more faint<\/p><\/div>\n

4) Better guidance when asking if a csv file or spreadsheet has a header or not:<\/p>\n

\"Import<\/a>

Import has header<\/p><\/div>\n

Here is the full list of improvements:<\/p>\n

    \n
  • When designing or redesigning a data table, users can see a demonstration table showing their changes as they go. It uses a few rows of real data where possible to be more realistic.<\/li>\n
  • When prompted to choose whether import source file has a header or not, example images appropriate to the type are shown and the options are ‘Has header row’, ‘No header’, and ‘Cancel’.<\/li>\n
  • Demonstration text data is now more varied in width and more sensible.<\/li>\n
  • The Projects form has an improved appearance and is more friendly and easy to understand.<\/li>\n
  • Styling of report tables improved, especially for the raw data list table.<\/li>\n
  • Demonstration tables are more visually distinct from report tables based on actual data (more faint).<\/li>\n
  • Better details left for user if unable to connect to a type of database.<\/li>\n
  • Can now use delete key when naming fields in data table design view.<\/li>\n<\/ul>\n

    And there are bug fixes:<\/p>\n

      \n
    • Fixed ods import bug where repeating columns with values were only treated as one data cell. Major cleanup of ods importing code.<\/li>\n
    • Copes with user having multiple versions of wxpython installed – explicitly uses correct version.<\/li>\n
    • Fixed bug when inserting new rows into a new data table design.<\/li>\n
    • Fixed small bug where renaming an odd table name in design view wouldn’t result in the original named table being deleted.<\/li>\n
    • \nEmpty strings not accepted as valid SQLite tables or fields.<\/li>\n
    • Fixed bug where enabling of Import button lagged changes to text for source name and SOFA Table Name.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

      There are four big changes in the latest version. They’re not really new features as such – the changes are mainly focused on making SOFA Statistics more pleasant to use. We hope you like it :-). 1) When designing or redesigning data tables, users now have visual feedback on the changes made in the form […]<\/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-272","post","type-post","status-publish","format-standard","hentry","category-general"],"_links":{"self":[{"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/posts\/272","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=272"}],"version-history":[{"count":7,"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/posts\/272\/revisions"}],"predecessor-version":[{"id":283,"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/posts\/272\/revisions\/283"}],"wp:attachment":[{"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/media?parent=272"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/categories?post=272"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/tags?post=272"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}