Skip to Content
0
Former Member
May 14, 2008 at 09:48 AM

Importing xml via a rss feed

25 Views

Post Author: SimonJ

CA Forum: Data Connectivity and SQL

Ok

what im trying to do is import a currency conversion xml file. But i dont it wont it sitting there stagnent waiting for a user to come along and manually change the exchange rates. Ive found heaps of rss sites that will feed me the xml file.,

but.. when i import the file into crystal using 'Create New Connection' -> 'XML' -> 'Use HTTP(S) Data Source' -> 'HTTP(S)XML URL' and type the url in. and uncheck the 'specify schema file' (there isnt one available) option. It comes up with this error msg... 'logon failed, schema is not defined in the xml file', this is after i put a blank login and password fields in.

how do i get around this? do i need to create the schema file myself?

thanking you in advance. Simon