{"id":255,"date":"2018-05-09T09:36:29","date_gmt":"2018-05-09T02:36:29","guid":{"rendered":"http:\/\/dataexponent.com\/?p=255"},"modified":"2019-09-03T21:16:51","modified_gmt":"2019-09-03T14:16:51","slug":"lgl-giving-report-to-aplos-import-contributions-conversion-tool","status":"publish","type":"post","link":"https:\/\/dataexponent.com\/?p=255","title":{"rendered":"LGL Giving Report to Aplos Import Contributions Conversion Tool"},"content":{"rendered":"<p>Continuing to build up the accounting data set it is now time to start to move donation data to Aplos in real-time.<\/p>\n<p>As a bit of an aside, we contract with a company to handle our front-end donation processing. They work with another company that has a very old-fashioned donation management system called LGL. While it may be old-fashioned it works and we don&#8217;t think we can change accounting and donation management at the same time. This isn&#8217;t going to be easy but we&#8217;re going to have to run with the existing donation management system and use automation to enter donation data into the Aplos system.<\/p>\n<p>In the future I envision this to be the bread-and-butter application for our front-end contractor. This application starts the process of learning how to do this task well.<\/p>\n<ol>\n<li>Download the &#8220;LGL Giving&#8221;\u00a0 Report from LGL.<\/li>\n<li>Upload this report into the \u201cR\u201d Language Shiny webpage.<\/li>\n<li>Process the report to build the Aplos Manual Contributions Input file.<\/li>\n<li>Download the Aplos\u00a0Manual Contributions Input file.<\/li>\n<li>Upload the\u00a0Contributions Input file into Aplos.<\/li>\n<\/ol>\n<p><a href=\"https:\/\/dataexponent.shinyapps.io\/CedarstoneDonationConverter\/\" target=\"_blank\" rel=\"noopener noreferrer\">Here is the link to the \u201cR\u201d Language Shiny Webpage<\/a> that runs the application. Feel free to give it a try \u2013 of course you will need data so send me a note if you are interested.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Continuing to build up the accounting data set it is now time to start to move donation data to Aplos in real-time. As a bit of an aside, we contract with a company to handle our front-end donation processing. They work with another company that has a very old-fashioned donation management system called LGL. While &hellip; <a href=\"https:\/\/dataexponent.com\/?p=255\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;LGL Giving Report to Aplos Import Contributions Conversion Tool&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[52,57,10,42,41,46,48,51,9,23,33,49],"class_list":["post-255","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-aplos","tag-aplos-manual-contributions-import","tag-big-data","tag-consulting","tag-custom","tag-donation","tag-interactive","tag-quickbooks","tag-r","tag-r-language","tag-shiny","tag-software-consulting"],"_links":{"self":[{"href":"https:\/\/dataexponent.com\/index.php?rest_route=\/wp\/v2\/posts\/255","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dataexponent.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dataexponent.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dataexponent.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dataexponent.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=255"}],"version-history":[{"count":5,"href":"https:\/\/dataexponent.com\/index.php?rest_route=\/wp\/v2\/posts\/255\/revisions"}],"predecessor-version":[{"id":378,"href":"https:\/\/dataexponent.com\/index.php?rest_route=\/wp\/v2\/posts\/255\/revisions\/378"}],"wp:attachment":[{"href":"https:\/\/dataexponent.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=255"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dataexponent.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=255"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dataexponent.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=255"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}