{"id":7246,"date":"2017-03-03T13:44:42","date_gmt":"2017-03-03T12:44:42","guid":{"rendered":"http:\/\/www.b.shuttle.de\/hayek\/hayek\/jochen\/wp\/blog-en\/?p=7246"},"modified":"2017-03-03T13:44:42","modified_gmt":"2017-03-03T12:44:42","slug":"sofico-miles","status":"publish","type":"post","link":"https:\/\/wp.jochen.hayek.name\/blog-en\/2017\/03\/03\/sofico-miles\/","title":{"rendered":"Sofico Miles: &#8220;auto &amp; asset finance, leasing, fleet and mobility management software&#8221;"},"content":{"rendered":"<ul>\n<li><a href=\"http:\/\/www.sofico.be\/solutions\/benefits\/finance\">http:\/\/www.sofico.be\/solutions\/benefits\/finance<\/a><\/li>\n<li><a href=\"http:\/\/www.sofico.be\/solutions\/markets\/vehicle-leasing-rental\">http:\/\/www.sofico.be\/solutions\/markets\/vehicle-leasing-rental<\/a>\u00a0: &#8220;<em>Managing the entire leasing process efficiently<\/em>&#8220;<\/li>\n<\/ul>\n<p>They are using Oracle DB as RDBMS and JasperReports for creating PDF documents.<\/p>\n<p>Yesterday I attended a one day introduction to their data model, called <em>GALAXY<\/em>.<\/p>\n<p>They supply their customers with sample JaspersReports documents, actually &#8220;.jasper&#8221; files. &#8220;.jasper&#8221; files can be losslessly transformed to JRXML files. JRXML files can get operated on and inspected in iReport, a GUI editor \u2013 but in fact you are not able to preview or even print these samples. For &#8220;running&#8221; a JRXML (or &#8220;.jasper&#8221;) file, you need to supply parameters and the framework will run a SQL query to retrieve data from the database. If you are just starting to explore the supplied samples, you don&#8217;t want to bother with those parameters and the data available in your database \u2013 you just want to print the sample documents with the fieldnames printed themselves (resp. something descriptive at least) instead of sample values. But Sofico do not supply you with any such documents or documentation.<\/p>\n<p>I guess I am going to prepare &#8220;a couple of&#8221; such documents &#8220;for myself&#8221; next week \u2013 &#8220;sample invoice&#8221; etc. look quite intriguing.<\/p>\n<p>I really wonder, how the SQL for filling this kind of documents looks like. Usually in the RDBMS context you are operating on a cursor, to retrieve &#8220;sister details&#8221; efficiently. But how would you deal with a kind of cursor in this context? (PL\/SQL?!?)<\/p>\n<p>For creating my &#8220;meta documents&#8221; I won&#8217;t use iReport \u2013 but rather my favourite text editor &#8220;in XML mode&#8221; (i.e. GNU Emacs with nxml-mode). I am really, really excited to start that \u2013 but this is Friday afternoon, just a little before <a href=\"https:\/\/en.wikipedia.org\/w\/Kabbalat_Shabbat\">Kabbalat Shabbat<\/a>, and no access to the sample documents \u2013 what a pity!<\/p>\n<p>In our Sofico Miles implemtation project my task is to create business documents \u2013 maybe similar to the sample documents \u2013 but I (we?) don&#8217;t really know. Searching the database views (the GALAXY) for the proper details (needed for filling the business documents) looks just too fatiguing \u2013 I rather learn and copy from these sample documents \u2013 actually that looks like the way, that Sofico teaches their customers to learn themselves how to deal with their data model.\t\t\t\t<\/p>\n","protected":false},"excerpt":{"rendered":"<p>http:\/\/www.sofico.be\/solutions\/benefits\/finance http:\/\/www.sofico.be\/solutions\/markets\/vehicle-leasing-rental\u00a0: &#8220;Managing the entire leasing process efficiently&#8220; They are using Oracle DB as RDBMS and JasperReports for creating PDF documents. Yesterday I attended a one day introduction to their data model, called GALAXY. They supply their customers with sample JaspersReports documents, actually &#8220;.jasper&#8221; files. &#8220;.jasper&#8221; files can be losslessly transformed to JRXML files. JRXML [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false,"_share_on_mastodon":"0"},"categories":[666],"tags":[],"class_list":["post-7246","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"share_on_mastodon":{"url":"","error":""},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paO0kP-1SS","jetpack_likes_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/wp.jochen.hayek.name\/blog-en\/wp-json\/wp\/v2\/posts\/7246","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wp.jochen.hayek.name\/blog-en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wp.jochen.hayek.name\/blog-en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wp.jochen.hayek.name\/blog-en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wp.jochen.hayek.name\/blog-en\/wp-json\/wp\/v2\/comments?post=7246"}],"version-history":[{"count":0,"href":"https:\/\/wp.jochen.hayek.name\/blog-en\/wp-json\/wp\/v2\/posts\/7246\/revisions"}],"wp:attachment":[{"href":"https:\/\/wp.jochen.hayek.name\/blog-en\/wp-json\/wp\/v2\/media?parent=7246"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wp.jochen.hayek.name\/blog-en\/wp-json\/wp\/v2\/categories?post=7246"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wp.jochen.hayek.name\/blog-en\/wp-json\/wp\/v2\/tags?post=7246"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}