Automation of Currency data from the open source into TM1

[TM1New]

Dear Members,

We are basically trying to automate the Currency exchange data in TM1. we don't have any source for loading FX values in TM1, thus we need to rely on websites to feed the data into TM1.

But every day gathering information from website and manually create the excel files is a pain, so did any one has automated this process (Excel file will be generated every day by picking up values from website automatically and we can use this file to load values into TM1 cube on daily basis).

Cheers

[macsir]

Sounds like you need a web programmer to extract a fixed format of data file for you rather than a TM1 developer.

[nick_leeson]

I am sure there is plenty of ways to skin this cat but from the top of my head !!

Option 1
1) Use Powershell to call a Web Service and then load the CSV into TM1. http://blogs.technet.com/b/heyscripting ... -2009.aspx
2) Fetch Website data into Excel using VBA and then save it as a CSV and use TI into TM1.

I am sure others will have a few awesome suggestions.

Cheerio

[Mike Cowie]

As Macsir says there is likely some programming involved here - the data you're looking for can likely be extracted from the web pages you're currently using or through other web services that provide this data. Some examples here:
http://stackoverflow.com/questions/4873 ... webservice

Once you've chosen an option/source there are quite a few ways to get at that information, like Nick points out. There are many examples you can find out there for using web services and web content in your programming language of choice (including VBA). You can turn that data into a format that is Excel or TM1 friendly (like CSV) and even schedule it to happen automatically as often as needed.

One new option for getting that data that's more directly TM1-integrated would be Turbo Integrator Java Extensions (new to TM1 10.2.2). Java Extensions involve developing classes (basically a class with a function of the same name as the class that has to follow a rigid structure in order for TI to use) that can be called from TI (via ExecuteJavaS and ExecuteJavaN functions). You could make your web service calls in one of those classes (Java includes the building blocks to do this) and then either have your class return a specific exchange rate to TM1 or write all rates that you need to a file that you can load in a later step. Up-to-the minute info on Java Extensions is not in the official IBM documentation right now, but can instead be found here:
https://www.ibm.com/developerworks/comm ... 3c4a9c8010

Hope that helps.

Regards,
Mike

[TM1New]

May be I need to put my hands on programming as well look like..
Any way thanks for your solutions.

Cheers

[dan.kelleher]

http://www.xe.com/datafeed/

Costs money but you can get it delivered in any format