BusinessObjects Board

text file input into xcelsius

Here’s a puzzle for you…

I have a full-client program that interfaces with an off-site system. In the background, it generates a simple delimited text file in a specific location on C drive that appears to update whenever there is a change on the source system.

How can I capture this file and turn it into an input into xcelsius (preferably XML). It’s going to have to be via a data connection as I need it to be dynamic and I need it to refresh as often as the source system changes (or every 3 minutes at minimum).

debbie


Debbie :uk: (BOB member since 2005-03-01)

Can your background program produce an xml format file instead/as well as?


cdavies :uk: (BOB member since 2005-01-28)

Not without it costing money! It’s outsourced… Which looks like the option they are going for. It’s doable in-house (not by me!) to write something that monitors the status of the TXT file and creates an XML from it, but it’s not enough of a priority to allocate resources to do it.

I’ll just get on with something else then…

Debbie


Debbie :uk: (BOB member since 2005-03-01)