{"id":1601,"date":"2011-09-14T11:44:34","date_gmt":"2011-09-14T16:44:34","guid":{"rendered":"http:\/\/www.splasmata.com\/?p=1601"},"modified":"2011-09-14T11:47:03","modified_gmt":"2011-09-14T16:47:03","slug":"you-want-fries-with-that-text-export","status":"publish","type":"post","link":"https:\/\/www.splasmata.com\/?p=1601","title":{"rendered":"You want fries with that Text Export?"},"content":{"rendered":"

CheckBook Pro<\/a> 2.2 came with new features for interacting with Split Line Items, and we even include them when exporting to Text. We faced a tough question when we did this, though: \u00c2\u00a0How do we handle Parent Entry Amounts and<\/em> Split Line Item Amounts in a file that may be viewed in a spreadsheet?<\/strong>\u00c2\u00a0 What if the user wants to SUM or throw some other math on the Amount column? \u00c2\u00a0SUMming the Parent Entry Amounts should equal the total of the export. \u00c2\u00a0SUMming the Split Line Item Amounts should equal the same (unless there’s a QuickFilter or Smart Folder in there somewhere). \u00c2\u00a0SUMming both, then, would potentially equal up to twice the total of the export (not every Entry is a Split, and a Starting Balance could affect things, too).<\/p>\n

 <\/p>\n

We figured we’d throw out Parent Entry Amounts for Split Entries. \u00c2\u00a0If the user wanted to view things in a spreadsheet they would realize that the Amount column had to equal the total of the export. \u00c2\u00a0If they wanted the actual Parent Entry Amounts they could easily add functions to any empty Amount cells. \u00c2\u00a0Because everyone who exports to Text is a closet spreadsheet jockey, right?<\/p>\n

 <\/p>\n

Eh, not really. \u00c2\u00a0Now that 2.2 and 2.3 have been out for a while we’ve gotten some good feedback from some users that they just want to look at the numbers in a spreadsheet, without SUMming or other analysis. \u00c2\u00a0Like a report. \u00c2\u00a0So our one size doesn’t fit all in this case. \u00c2\u00a0Back to the drawing board for a little rework…<\/p>\n

 <\/p>\n

Here’s what we’ve got:<\/p>\n

 <\/p>\n

\"CheckBook<\/a>

CheckBook Pro 2.5's new Text Export options<\/p><\/div>\n

 <\/p>\n

Want Split Line Items? \u00c2\u00a0If so, what about those Parent Entry Amounts? \u00c2\u00a0Now you get to decide! \u00c2\u00a0The changes are in the upcoming CheckBook & CheckBook Pro 2.5, but we backported to a pre-release build of 2.3.1 just in case anyone needs these options now. \u00c2\u00a0Drop us a line at support@splasm.com if you’d like the latest build!<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

CheckBook Pro 2.2 came with new features for interacting with Split Line Items, and we even include them when exporting to Text. We faced a tough question when we did this, though: \u00c2\u00a0How do we handle Parent Entry Amounts and … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1601","post","type-post","status-publish","format-standard","hentry","category-development"],"_links":{"self":[{"href":"https:\/\/www.splasmata.com\/index.php?rest_route=\/wp\/v2\/posts\/1601","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.splasmata.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.splasmata.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.splasmata.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.splasmata.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1601"}],"version-history":[{"count":8,"href":"https:\/\/www.splasmata.com\/index.php?rest_route=\/wp\/v2\/posts\/1601\/revisions"}],"predecessor-version":[{"id":1611,"href":"https:\/\/www.splasmata.com\/index.php?rest_route=\/wp\/v2\/posts\/1601\/revisions\/1611"}],"wp:attachment":[{"href":"https:\/\/www.splasmata.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1601"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.splasmata.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1601"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.splasmata.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1601"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}