Can BIRT Get data from a CSV file on a server

If a text file is on a server, not on the local machine,

Can BIRT grab that file and parses it?

Thanks for any input.

Asmrani

Find more posts tagged with

Comments

mwilliams

Hi Asmrani,

If your computer is connected to that server, you should just be able to point to that directory when creating your dataSource.

If your computer is not connected to the server, you should be able to set up a URL for the text file and access it that way.

Hope this helps.

Asmrani

dear mwilliams,

Yes my computer is connected, and BIRT allows you to use CSV as a datasource, but it assumes that the CSV file is on the COmputer itself...It doesn't allow you to point it to a URL...

Thanks for your input -- waiting for details --

Asmrani

mwilliams

Asmrani,

Sorry about the URL thing. After I sent it, we realized that it doesn't have that option.

If you can get a network share set up, BIRT will recognize that as a file location, and you can go from there.

If you're unable to do that and have the coding ability to do the following... You could find the source code for the csv dataSource type and change the code to allow it to select text from a URL. That would probably be a last resort if you can't get the network share set up.

Asmrani

I can do a share drive now -- but that doesn't help since I actually want to parse through data -- extract the first line

I am doing a scripted data but getting errors when I try to do the importpackage line:

importPackage(packages.java.io);
importPackage(packages.java.net);