{"id":340,"date":"2017-12-31T20:20:27","date_gmt":"2017-12-31T20:20:27","guid":{"rendered":"http:\/\/www.logbook.org.uk\/?p=340"},"modified":"2018-01-01T11:35:33","modified_gmt":"2018-01-01T11:35:33","slug":"merging-logbooks","status":"publish","type":"post","link":"http:\/\/www.logbook.org.uk\/?p=340","title":{"rendered":"5 New Year tips on merging logbooks"},"content":{"rendered":"<h2>Tip #1<\/h2>\n<p>Unless you have to&#8230; don&#8217;t do it!<br \/>\nInstead move your up to date &#8216;logbook9.fmp12&#8217; file from one device to another as an email attachment. It will open if you put it in the relevant logbook folder to replace the existing file on a PC\/Mac, and it will open in FileMaker Go on an iOS device.<\/p>\n<h2>Tip #2<\/h2>\n<p>If your cases are coming from an older or different logbook version, you can import them on a Mac\/PC from one of the standard automatic text file backups (look in the logbook &#8216;backups&#8217; folder). The fields are automatically aligned if you use the top menu: &#8216;Scripts&#8217; &gt; &#8216;Importing Cases&#8217; &gt; &#8216;Update from a previous version&#8217; routine.<\/p>\n<h2>Tip #3<\/h2>\n<p>If you have already started a second version 9 logbook, you can only merge logbook files and cases on a Mac\/PC.<\/p>\n<ul>\n<li>Open your Mac\/PC logbook<\/li>\n<li>Go to the menu bar at the top of the screen: File &gt; Import Records &gt; File&#8230;<\/li>\n<li>Change the &#8216;Tab-Separated Text Files&#8217; option to &#8216;FileMaker Pro Files&#8217;<\/li>\n<li>Select your other &#8216;logbook9.fmp12&#8217; file with the additional cases in it<\/li>\n<li>Change the import order from &#8216;Last Used&#8217; to &#8216;Matching Names&#8217;<\/li>\n<li>Go for it! (you can still delete the imported cases if it all goes wrong)<\/li>\n<li>If the import results in duplicates of some cases, these can be safely eliminated later in the &#8216;Toolbox&#8217; section.<\/li>\n<\/ul>\n<h2>Tip #4<\/h2>\n<p>Get rid of old copies of logbooks on iOS devices, otherwise if you try to copy a new &#8216;logbook9.fmp12&#8217; file to the device, iOS will automatically rename it &#8216;logbook9 1&#8217; to prevent two files having the same name. This then causes confusion, especially with backups.<\/p>\n<h2>Tip #5<\/h2>\n<p>If you are trying to import cases from another source (e.g. Excel spreadsheet) the process is more complicated, and you will have to map the spreadsheet fields manually to the logbook fields during the import process.<\/p>\n<p>These are the names and format of the 24 core data fields within the logbook:<\/p>\n<ul>\n<li><span style=\"font-size: 8pt;\">Date (<em>in DD\/MM\/YYYY format<\/em>)<\/span><\/li>\n<li><span style=\"font-size: 8pt;\">Ref no (<em>optional<\/em>)<\/span><\/li>\n<li><span style=\"font-size: 8pt;\">DoB (<em>in DD\/MM\/YYYY format as an alternative to &#8216;age&#8217;<\/em> )<\/span><\/li>\n<li><span style=\"font-size: 8pt;\">Sex (<em>M\/F<\/em>)<\/span><\/li>\n<li><span style=\"font-size: 8pt;\">ASA (<em>1-5<\/em>)<\/span><\/li>\n<li><span style=\"font-size: 8pt;\">Priority<\/span><\/li>\n<li><span style=\"font-size: 8pt;\">Specialty<\/span><\/li>\n<li><span style=\"font-size: 8pt;\">Start (<em>in HH:MM format<\/em>)<\/span><\/li>\n<li><span style=\"font-size: 8pt;\">Finish (<em>in HH:MM format<\/em>)<\/span><\/li>\n<li><span style=\"font-size: 8pt;\">Anaesthetic 1 (<em>traditionally airway technique)<\/em><\/span><\/li>\n<li><span style=\"font-size: 8pt;\">Procedure 1<\/span><\/li>\n<li><span style=\"font-size: 8pt;\">Procedure 2<\/span><\/li>\n<li><span style=\"font-size: 8pt;\">Procedure 3<\/span><\/li>\n<li><span style=\"font-size: 8pt;\">Incident 1<\/span><\/li>\n<li><span style=\"font-size: 8pt;\">Incident 2<\/span><\/li>\n<li><span style=\"font-size: 8pt;\">Incident 3<\/span><\/li>\n<li><span style=\"font-size: 8pt;\">Supervision<\/span><\/li>\n<li><span style=\"font-size: 8pt;\">Operation<\/span><\/li>\n<li><span style=\"font-size: 8pt;\">Notes<\/span><\/li>\n<li><span style=\"font-size: 8pt;\">User 1 (<em>contents entirely up to you<\/em>)<\/span><\/li>\n<li><span style=\"font-size: 8pt;\">User 2 (<em>contents entirely up to you<\/em>)<\/span><\/li>\n<li><span style=\"font-size: 8pt;\">Anaesthetic 2 (<em>traditionally regional blocks<\/em>)<\/span><\/li>\n<li><span style=\"font-size: 8pt;\">Age (<em>alternative to DoB in years as a decimal e.g. &#8216;10.5&#8217;<\/em>)<\/span><\/li>\n<li><span style=\"font-size: 8pt;\">Trainee ID (<em>optional locator<\/em>)<\/span><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Tip #1 Unless you have to&#8230; don&#8217;t do it! Instead move your up to date &#8216;logbook9.fmp12&#8217; file from one device to another as an email attachment. It will open if you put it in the relevant logbook folder to replace the existing file on a PC\/Mac, and it will open in FileMaker Go on an &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.logbook.org.uk\/?p=340\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;5 New Year tips on merging logbooks&#8221;<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,19],"tags":[],"class_list":["post-340","post","type-post","status-publish","format-standard","hentry","category-hints","category-logbook-info"],"_links":{"self":[{"href":"http:\/\/www.logbook.org.uk\/index.php?rest_route=\/wp\/v2\/posts\/340","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.logbook.org.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.logbook.org.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.logbook.org.uk\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/www.logbook.org.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=340"}],"version-history":[{"count":0,"href":"http:\/\/www.logbook.org.uk\/index.php?rest_route=\/wp\/v2\/posts\/340\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.logbook.org.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=340"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.logbook.org.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=340"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.logbook.org.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=340"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}