Importing Exchange Rates

Discussion:

(too old to reply)

GPDavid

2009-02-04 21:12:09 UTC

There is a sample Exchange Rate integration in Integration Manager. You
should review the source file and destination mapping details in this
integration to gain a sense of what data will be required for the
integration. If your RSS feed can provide some of the data, I can't imagine
it'd be too difficult to make a few extra modifications to the data from the
feed to get it into the format required by Integration Manager.

We currently enter currency exchange rates manually into Dynamics GP9. Now
we are looking for a FREE automated option. Someone suggested we use a RSS
feed to get the info- we would then have to convert/prepare the data and use
Integration Manager to import the info into GP (not sure yet how to automate
all that).
Has anyone else done this before or have any other suggestions?

NJTech

2009-02-05 06:51:04 UTC

Permalink

Hi,

We have developed a solution for automatically importing Exchange rates via
web service. If you are interested please drop a email to learn more.

Regards,

c***@gmail.com

2013-10-17 19:27:18 UTC

Permalink

Post by NJTech
Hi,
We have developed a solution for automatically importing Exchange rates via
web service. If you are interested please drop a email to learn more.
Regards,

Hi NJTech,
I'm currently supporting GP v.10 and need to import currency rates. Our company already has an account with xe.com to pull exchange files. I need to know how/what to do in order to use the web services which is a hands off process from what I know.
Thank you,
Clark

GPINC

2009-02-23 19:37:02 UTC

Permalink

Here is what we ending up using: Dynamics GP9, Integration Manager, Windows
Scheduled Tasks, GP macro, VBScript, MS-DOS batch files, Excel Spreadsheet,
XML links- details below...

- Excel Spreadsheet: has xml links to exchange rates, a tab converts to
useable data for Integration Manager, a macro pulls recent data
+ used xml links from this site to pull free rates:
http://www.currencysource.com/rss_currencyexchangerates.html

- VBScript file: this runs the macro above and saves the file [scheduled it
to auto-run as a windows Scheduled Task]
dim File_name
dim Macro_name
dim ExcelObject
File_name="C:\Program Files\Microsoft Dynamics\GP\Auto Exchange
Rates\Exchange Rates.xls"
Macro_name="UpdateRates"
Save_Flag=True
Set ExcelObject=Createobject("Excel.application")
ExcelObject.Workbooks.Open File_name
ExcelObject.Run (macro_name)
if Save_Flag then
ExcelObject.Workbooks(1).Save
Else
ExcelObject.Workbooks(1).Close (Save_Flag)
End if
if err.number<>0 then
ExcelObject.Workbooks(1).Close (False)
End if
ExcelObject.Application.Quit
Set ExcelObject=nothing
Main = DTSTaskExecResult_Success

- for opening GP and running Integration Manager, we used the files and tips
provided here:
http://msdynamicsgp.blogspot.com/2007/08/weekly-dynamic-automating-integrations.html

- we are still working on getting GP to close successfully

Mohammad Daoud

2010-10-03 13:18:27 UTC

Permalink

I have developed a tool to import exchange rates into Dynamics GP and published this tool for free, please take a look to the following article:

http://mohdaoud.blogspot.com/2010/07/currency-exchange-rates-importer-for.html

Regards,

Mohammad R. Daoud

Post by GPDavid
There is a sample Exchange Rate integration in Integration Manager. You
should review the source file and destination mapping details in this
integration to gain a sense of what data will be required for the
integration. If your RSS feed can provide some of the data, I can't imagine
it'd be too difficult to make a few extra modifications to the data from the
feed to get it into the format required by Integration Manager.

Post by NJTech
Hi,
We have developed a solution for automatically importing Exchange rates via
web service. If you are interested please drop a email to learn more.
Regards,

Post by GPINC
Here is what we ending up using: Dynamics GP9, Integration Manager, Windows
Scheduled Tasks, GP macro, VBScript, MS-DOS batch files, Excel Spreadsheet,
XML links- details below...
- Excel Spreadsheet: has xml links to exchange rates, a tab converts to
useable data for Integration Manager, a macro pulls recent data
http://www.currencysource.com/rss_currencyexchangerates.html
- VBScript file: this runs the macro above and saves the file [scheduled it
to auto-run as a windows Scheduled Task]
dim File_name
dim Macro_name
dim ExcelObject
File_name="C:\Program Files\Microsoft Dynamics\GP\Auto Exchange
Rates\Exchange Rates.xls"
Macro_name="UpdateRates"
Save_Flag=True
Set ExcelObject=Createobject("Excel.application")
ExcelObject.Workbooks.Open File_name
ExcelObject.Run (macro_name)
if Save_Flag then
ExcelObject.Workbooks(1).Save
Else
ExcelObject.Workbooks(1).Close (Save_Flag)
End if
if err.number<>0 then
ExcelObject.Workbooks(1).Close (False)
End if
ExcelObject.Application.Quit
Set ExcelObject=nothing
Main = DTSTaskExecResult_Success
- for opening GP and running Integration Manager, we used the files and tips
http://msdynamicsgp.blogspot.com/2007/08/weekly-dynamic-automating-integrations.html
- we are still working on getting GP to close successfully
Submitted via EggHeadCafe - Software Developer Portal of Choice
Mocking WCF Services Using Moq
http://www.eggheadcafe.com/tutorials/aspnet/b76105f1-f832-4b52-82ba-d5a61d435d81/mocking-wcf-services-using-moq.aspx