D3 and mvBase

 View Only
  • 1.  D3 to external Sales Tax calculator

    Posted 01-13-2023 15:02
    I have several customers who need real-time sales tax calculation. Has anyone integrated an online sales tax calculator with D3 and is willing to share the code?

    ------------------------------
    Richard Ginsburg
    President
    Ginsburg Consulting
    Manassas VA US
    ------------------------------


  • 2.  RE: D3 to external Sales Tax calculator

    PARTNER
    Posted 01-16-2023 14:58
    Richard,

    There are several REST based services that are trivial to call these days.  For example, zip-tax.com provides U.S. address-based tax calculations for a reasonable cost.  The giant in the industry is Avalara.com.  Let me know if you need assistance making REST calls from D3/mvBase or other MV platforms.

    Dick Thiot

    ------------------------------
    Richard Thiot
    President
    Maverick Systems
    Plano TX US
    ------------------------------



  • 3.  RE: D3 to external Sales Tax calculator

    Posted 01-16-2023 18:32
    Richard - sure. Whatever you can supply in terms of code will help. Thanks!

    ------------------------------
    Richard Ginsburg
    President
    Ginsburg Consulting
    Manassas VA US
    ------------------------------



  • 4.  RE: D3 to external Sales Tax calculator

    PARTNER
    Posted 01-17-2023 14:19
    Richard,

    Which version of D3 are you using?

    Dick

    ------------------------------
    Richard Thiot
    President
    Maverick Systems
    Plano TX US
    ------------------------------



  • 5.  RE: D3 to external Sales Tax calculator

    Posted 01-17-2023 14:35
    D3 Linux 10.3.3

    ------------------------------
    Richard Ginsburg
    President
    Ginsburg Consulting
    Manassas VA US
    ------------------------------



  • 6.  RE: D3 to external Sales Tax calculator

    PARTNER
    Posted 01-17-2023 15:10
    Richard,

    For D3, the most common way is to use cURL which has been around for a long time and is available for Linux and Windows and is FREE.  Execute curl and capture the results.  For example, the following curl request returns forecast data from the National Weather Service from the Ft. Worth office for grid square 30,115:

    curl https://api.weather.gov/gridpoints/FWD/90,115/forecast

    There was an article in Spectrum Magazine a few years ago about calling cURL that you can read at https://www.intl-spectrum.com/Article/r671/IS_HTTPCLIENT__Using_CURL_and_BASICs_EXECUTE which also includes source code.

    As mentioned previously, there are several services that you can subscribe to that help with sales tax calculation.  They range in price and features but once you subscribe to the service they are easy to integrate with your application.

    I hope this points you in the right direction.

    ------------------------------
    Richard Thiot
    President
    Maverick Systems
    Plano TX US
    ------------------------------



  • 7.  RE: D3 to external Sales Tax calculator

    Posted 01-17-2023 16:34
    Thanks.

    On 1/17/2023 4:30 PM, Richard Thiot via Rocket Forum wrote:
    > Richard, For D3, the most common way is to use cURL which has been
    > around for a long time and is available for Linux and Windows and is
    > FREE.??...
    > Invite your colleagues to join the Rocket Forum and grow our expert
    > network.
    > ------------------------------------------------------------------------
    > Rocket Software <https: community.rocketsoftware.com="">
    >
    >
    > D3 and mvBase
    > <https: community.rocketsoftware.com/forums/forum-home/digestviewer?communitykey="7cdcd1ff-6009-4df2-8b8c-e5ea4293200b">
    >
    >
    > Post New Message Online
    > <http: community.rocketsoftware.com/participate/postmessage?groupid="55">
    > Invite your colleagues to join the Rocket Forum and grow our expert
    > network. Share this link. <https: community.rocketsoftware.com/register="">
    >
    > Re: D3 to external Sales Tax calculator
    > <https: community.rocketsoftware.com/discussion/d3-to-external-sales-tax-calculator#bm94be5935-4356-45c5-a8a7-0185c1506e71="">
    >
    > Reply to Group Online
    > <https: community.rocketsoftware.com/forums/all-discussions/postreply?messagekey="94be5935-4356-45c5-a8a7-0185c1506e71&ListKey=365735ee-5669-4857-ac99-8f7ea2cb2c9d">
    > Reply to Group
    > <mailto:rocket_d3andmvbase_94be5935-4356-45c5-a8a7-0185c1506e71@connectedcommunity.org?subject=re:></mailto:rocket_d3andmvbase_94be5935-4356-45c5-a8a7-0185c1506e71@connectedcommunity.org?subject=re:>
    > D3 to external Sales Tax calculator>
    >
    > Richard Thiot
    > <https: community.rocketsoftware.com/network/members/profile?userkey="c96d0b0a-6f73-4363-8adc-5fbccc0942a9">
    >
    > Jan 17, 2023 3:10 PM
    > Richard Thiot
    > <https: community.rocketsoftware.com/network/members/profile?userkey="c96d0b0a-6f73-4363-8adc-5fbccc0942a9">
    >
    >
    > Richard,
    >
    > For D3, the most common way is to use cURL which has been around for a
    > long time and is available for Linux and Windows and is FREE. Execute
    > curl and capture the results.?? For example, the following curl request
    > returns forecast data from the National Weather Service from the Ft.
    > Worth office for grid square 30,115:
    >
    > curl api.weather.gov/gridpoints/FWD/90,115/forecast
    > <https: api.weather.gov/gridpoints/fwd/90,115/forecast="">
    >
    > There was an article in Spectrum Magazine a few years ago about
    > calling cURL that you can read at
    > www.intl-spectrum.com/Article/r671/...
    > <https: www.intl-spectrum.com/article/r671/is_httpclient__using_curl_and_basics_execute="">
    > which also includes source code.
    >
    > As mentioned previously, there are several services that you can
    > subscribe to that help with sales tax calculation.?? They range in
    > price and features but once you subscribe to the service they are easy
    > to integrate with your application.
    >
    > I hope this points you in the right direction.
    >
    > ------------------------------
    > Richard Thiot
    > President
    > Maverick Systems
    > Plano TX US
    > ------------------------------
    >
    > *Reply to Group Online
    > <https: community.rocketsoftware.com/forums/all-discussions/postreply?messagekey="94be5935-4356-45c5-a8a7-0185c1506e71&ListKey=365735ee-5669-4857-ac99-8f7ea2cb2c9d">*
    > *View Thread
    > <https: community.rocketsoftware.com/discussion/d3-to-external-sales-tax-calculator#bm94be5935-4356-45c5-a8a7-0185c1506e71="">*
    > *Forward
    > <https: community.rocketsoftware.com/forums/all-discussions/forwardmessages?messagekey="94be5935-4356-45c5-a8a7-0185c1506e71&ListKey=365735ee-5669-4857-ac99-8f7ea2cb2c9d">*
    > *Flag as Inappropriate
    > <https: community.rocketsoftware.com/discussion/d3-to-external-sales-tax-calculator?markappropriate="94be5935-4356-45c5-a8a7-0185c1506e71#bm94be5935-4356-45c5-a8a7-0185c1506e71">*
    > *Post New Message Online
    > <http: community.rocketsoftware.com/participate/postmessage?groupid="55">*
    > -------------------------------------------
    > Original Message:
    > Sent: 01-16-2023 18:32
    > From: Richard Ginsburg
    > Subject: D3 to external Sales Tax calculator
    >
    > Richard - sure. Whatever you can supply in terms of code will help.
    > Thanks!
    >
    > ------------------------------
    > Richard Ginsburg
    > President
    > Ginsburg Consulting
    > Manassas VA US
    >
    >
    >
    >
    > You are receiving this message because you followed the 'D3 to
    > external Sales Tax calculator' message thread. To unsubscribe from
    > this message thread, go to Unsubscribe
    > <https: community.rocketsoftware.com/higherlogic/common/unfollow.aspx?userkey="8d3faed8-e469-40ca-b38c-f4de4e799782&sKey=KeyRemoved&ItemKey=314dc79c-74d7-43b8-9c56-0185acb59976">.
    >
    >
    > Update your email preferences
    > <https: community.rocketsoftware.com/go.aspx?c="Preferences§ion=email">
    > to choose the types of email you receive
    >
    > Unsubscribe from all participation emails
    > <https: community.rocketsoftware.com/higherlogic/egroups/unsubscribe.aspx?userkey="8d3faed8-e469-40ca-b38c-f4de4e799782&sKey=KeyRemoved&mClass=Social">
    >

    --
    *Ricky Ginsburg*

    On the web, always open... <http: www.fawnridge.com/ricky="">


    --
    This email has been checked for viruses by AVG antivirus software.
    www.avg.com




  • 8.  RE: D3 to external Sales Tax calculator

    Posted 01-18-2023 08:31
    Morning,

    Just wanted to ask what scripting language are you familiar with?  For myself I am most comfortable using PHP so I would write a short php script to accept input from pick, make the curl call to get data and then echo that data back to pick.  You would just run command from pick -  !getStuff.php address

    I would be happy to share a base php code if you are interested.

    Craig

    ------------------------------
    craig curtis
    System Programmer
    Sevier Valley School District
    Richfield UT US
    ------------------------------



  • 9.  RE: D3 to external Sales Tax calculator

    Posted 01-18-2023 09:50
    I'm not familiar with any scripts. Just an old Pick Basic programmer.

    On 1/18/2023 8:33 AM, craig curtis via Rocket Forum wrote:
    > Morning, Just wanted to ask what scripting language are you familiar
    > with??? For myself I am most comfortable using PHP so I would write a
    > short...
    > Invite your colleagues to join the Rocket Forum and grow our expert
    > network.
    > ------------------------------------------------------------------------
    > Rocket Software <https: community.rocketsoftware.com="">
    >
    >
    > D3 and mvBase
    > <https: community.rocketsoftware.com/forums/forum-home/digestviewer?communitykey="7cdcd1ff-6009-4df2-8b8c-e5ea4293200b">
    >
    >
    > Post New Message Online
    > <http: community.rocketsoftware.com/participate/postmessage?groupid="55">
    > Invite your colleagues to join the Rocket Forum and grow our expert
    > network. Share this link. <https: community.rocketsoftware.com/register="">
    >
    > Re: D3 to external Sales Tax calculator
    > <https: community.rocketsoftware.com/discussion/d3-to-external-sales-tax-calculator#bm4ae30bc2-b5bb-48f0-8191-b94c3acc5582="">
    >
    > Reply to Group Online
    > <https: community.rocketsoftware.com/forums/all-discussions/postreply?messagekey="4ae30bc2-b5bb-48f0-8191-b94c3acc5582&ListKey=365735ee-5669-4857-ac99-8f7ea2cb2c9d">
    > Reply to Group
    > <mailto:rocket_d3andmvbase_4ae30bc2-b5bb-48f0-8191-b94c3acc5582@connectedcommunity.org?subject=re:></mailto:rocket_d3andmvbase_4ae30bc2-b5bb-48f0-8191-b94c3acc5582@connectedcommunity.org?subject=re:>
    > D3 to external Sales Tax calculator>
    >
    > craig curtis
    > <https: community.rocketsoftware.com/network/members/profile?userkey="7d9ce419-2280-4451-8cb9-9f8cdfa54c8d">
    >
    > Jan 18, 2023 8:31 AM
    > craig curtis
    > <https: community.rocketsoftware.com/network/members/profile?userkey="7d9ce419-2280-4451-8cb9-9f8cdfa54c8d">
    >
    >
    > Morning,
    >
    > Just wanted to ask what scripting language are you familiar with? For
    > myself I am most comfortable using PHP so I would write a short php
    > script to accept input from pick, make the curl call to get data and
    > then echo that data back to pick.?? You would just run command from
    > pick -?? !getStuff.php address
    >
    > I would be happy to share a base php code if you are interested.
    >
    > Craig
    >
    > ------------------------------
    > craig curtis
    > System Programmer
    > Sevier Valley School District
    > Richfield UT US
    > ------------------------------
    >
    > *Reply to Group Online
    > <https: community.rocketsoftware.com/forums/all-discussions/postreply?messagekey="4ae30bc2-b5bb-48f0-8191-b94c3acc5582&ListKey=365735ee-5669-4857-ac99-8f7ea2cb2c9d">*
    > *View Thread
    > <https: community.rocketsoftware.com/discussion/d3-to-external-sales-tax-calculator#bm4ae30bc2-b5bb-48f0-8191-b94c3acc5582="">*
    > *Forward
    > <https: community.rocketsoftware.com/forums/all-discussions/forwardmessages?messagekey="4ae30bc2-b5bb-48f0-8191-b94c3acc5582&ListKey=365735ee-5669-4857-ac99-8f7ea2cb2c9d">*
    > *Flag as Inappropriate
    > <https: community.rocketsoftware.com/discussion/d3-to-external-sales-tax-calculator?markappropriate="4ae30bc2-b5bb-48f0-8191-b94c3acc5582#bm4ae30bc2-b5bb-48f0-8191-b94c3acc5582">*
    > *Post New Message Online
    > <http: community.rocketsoftware.com/participate/postmessage?groupid="55">*
    > -------------------------------------------
    > Original Message:
    > Sent: 01-17-2023 15:09
    > From: Richard Thiot
    > Subject: D3 to external Sales Tax calculator
    >
    > Richard,
    >
    > For D3, the most common way is to use cURL which has been around for a
    > long time and is available for Linux and Windows and is FREE. Execute
    > curl and capture the results.?? For example, the following curl request
    > returns forecast data from the National Weather Service from the Ft.
    > Worth office for grid square 30,115:
    >
    > curl api.weather.gov/gridpoints/FWD/90,115/forecast
    > <https: api.weather.gov/gridpoints/fwd/90,115/forecast="">
    >
    > There was an article in Spectrum Magazine a few years ago about
    > calling cURL that you can read at
    > www.intl-spectrum.com/Article/r671/...
    > <https: www.intl-spectrum.com/article/r671/is_httpclient__using_curl_and_basics_execute="">
    > which also includes source code.
    >
    > As mentioned previously, there are several services that you can
    > subscribe to that help with sales tax calculation.?? They range in
    > price and features but once you subscribe to the service they are easy
    > to integrate with your application.
    >
    > I hope this points you in the right direction.
    >
    > ------------------------------
    > Richard Thiot
    > President
    > Maverick Systems
    > Plano TX US
    >
    >
    >
    >
    > You are receiving this message because you followed the 'D3 to
    > external Sales Tax calculator' message thread. To unsubscribe from
    > this message thread, go to Unsubscribe
    > <https: community.rocketsoftware.com/higherlogic/common/unfollow.aspx?userkey="8d3faed8-e469-40ca-b38c-f4de4e799782&sKey=KeyRemoved&ItemKey=314dc79c-74d7-43b8-9c56-0185acb59976">.
    >
    >
    > Update your email preferences
    > <https: community.rocketsoftware.com/go.aspx?c="Preferences§ion=email">
    > to choose the types of email you receive
    >
    > Unsubscribe from all participation emails
    > <https: community.rocketsoftware.com/higherlogic/egroups/unsubscribe.aspx?userkey="8d3faed8-e469-40ca-b38c-f4de4e799782&sKey=KeyRemoved&mClass=Social">
    >

    --
    *Ricky Ginsburg*

    On the web, always open... <http: www.fawnridge.com/ricky="">


    --
    This email has been checked for viruses by AVG antivirus software.
    www.avg.com