{"id":711,"date":"2013-10-11T19:02:07","date_gmt":"2013-10-12T00:02:07","guid":{"rendered":"https:\/\/danvanfleet.com\/?p=711"},"modified":"2013-10-11T19:14:13","modified_gmt":"2013-10-12T00:14:13","slug":"distance-to-partners-add-on-for-softpro-proform","status":"publish","type":"post","link":"https:\/\/danvanfleet.com\/index.php\/distance-to-partners-add-on-for-softpro-proform\/","title":{"rendered":"Distance to Partners Add on for SoftPro ProForm"},"content":{"rendered":"<p><a href=\"https:\/\/i0.wp.com\/danvanfleet.com\/wp-content\/uploads\/2013\/10\/image.png\"><img data-recalc-dims=\"1\" decoding=\"async\" style=\"margin: 0px 5px 0px 0px; display: inline; border: 0px;\" title=\"image\" alt=\"image\" src=\"https:\/\/i0.wp.com\/danvanfleet.com\/wp-content\/uploads\/2013\/10\/image_thumb.png?resize=204%2C46\" width=\"204\" height=\"46\" align=\"left\" border=\"0\" \/><\/a> When you are selecting partners, sometimes it&#8217;s nice to know their location in relation to the property location.\u00a0 ProUtil ZipDistance is the tool for the job. It displays a sorted lookup table of vendors by approximate air miles to that vendor.\u00a0 Double clicking on a vendor brings up a Browser window with live directions from the vendor to the property.<\/p>\n<p><!--more--><\/p>\n<p><a href=\"https:\/\/i0.wp.com\/danvanfleet.com\/wp-content\/uploads\/2013\/10\/image1.png\"><img data-recalc-dims=\"1\" fetchpriority=\"high\" decoding=\"async\" style=\"margin: 0px; display: inline; border: 0px;\" title=\"image\" alt=\"image\" src=\"https:\/\/i0.wp.com\/danvanfleet.com\/wp-content\/uploads\/2013\/10\/image_thumb1.png?resize=527%2C464\" width=\"527\" height=\"464\" border=\"0\" \/><\/a><\/p>\n<p>It&#8217;s that simple. The window takes a few seconds to select the records, the vendor&#8217;s address is the A pointer, with Property Address as B. ProUtil ZipDistance automatically adjusts for sparsely covered regions of the country. By default the search range is about 150 miles, if nobody is found in that area, the range is expanded to over 1000 miles. In this example ProUtil ZipDistance is talking to a user defined lookup table in the USRxxVAL section of ProForm for Windows Classic.<\/p>\n<h1>What&#8217;s it cost?<\/h1>\n<p>Usually it&#8217;s under a grand. To receive a three figure estimate for the lookup table you wish to sort we need a little information about the lookup table <a href=\"http:\/\/SoftProCorp.com\" target=\"_blank\">SoftPro<\/a> is using.<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/danvanfleet.com\/wp-content\/uploads\/2013\/10\/clip_image0011.png\"><img data-recalc-dims=\"1\" decoding=\"async\" style=\"margin: 0px 15px 0px 0px; display: inline; border: 0px;\" title=\"clip_image001\" alt=\"clip_image001\" src=\"https:\/\/i0.wp.com\/danvanfleet.com\/wp-content\/uploads\/2013\/10\/clip_image001_thumb1.png?resize=222%2C158\" width=\"222\" height=\"158\" align=\"left\" border=\"0\" \/><\/a><\/p>\n<p>Capture the text in a lookup table definition as well as the table name.\u00a0 A few rows of table data is nice also, even if just a screen shot. If User Defined fields are used, table data is a necessity.<\/p>\n<p>ProUtil ZipDistance will be customized to your <a href=\"http:\/\/SoftProCorp.com\" target=\"_blank\">SoftPro<\/a> System.\u00a0 It is currently available for ProForm Classic running a SQL database.\u00a0 If you run the Access MDB databases we&#8217;ll be into 4 digit numbers, but not far.\u00a0 Other than the distance column you will get to define the columns and their order during the implementation process.\u00a0 In the future you will easily be able to move the system to a new Sql Server.\u00a0 Column updates will require custom modifications.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When you are selecting partners, sometimes it&#8217;s nice to know their location in relation to the property location.\u00a0 ProUtil ZipDistance is the tool for the job. It displays a sorted lookup table of vendors by approximate air miles to that vendor.\u00a0 Double clicking on a vendor brings up a Browser window with live directions from [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","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":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[23],"tags":[28,21,29],"class_list":["post-711","post","type-post","status-publish","format-standard","hentry","category-softpro-2","tag-lookup","tag-proform","tag-utility","entry"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4wyVb-bt","jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/posts\/711","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/comments?post=711"}],"version-history":[{"count":4,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/posts\/711\/revisions"}],"predecessor-version":[{"id":715,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/posts\/711\/revisions\/715"}],"wp:attachment":[{"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/media?parent=711"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/categories?post=711"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/danvanfleet.com\/index.php\/wp-json\/wp\/v2\/tags?post=711"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}