Jump to content

CSV Datasource Tool

Go to solution Solved by hozawa,

Recommended Posts

  • Replies 6
  • Created
  • Last Reply

Top Posters In This Topic

  • Solution

I've attached a new video with JasperReports Server's locale set to English. The csv file can be located in user's pc instead of on JasperReports Server. In this case, a client software needs to be installed on user's pc to make the csv file available to JasperReports Server.

1. I'm copying a csv file into the drop folder, This creates a domain in JasperReports Server using the name of the csv file.

2. I'm creating an Adhoc View using the created domain.

3. I'm editing the csv file to have fewer rows and inserting a column "MIDDLENAME"

4. Refreshing the web browser to show data update. Domain won't be refreshed automatically so I'm reloading the domain. (I think I can make the Domain update so a field selection will be sufficient. The problem will be when the used column is deleted from the csv file.)

5. Viewing Adhoc View after reloading the domain

6. Finally, deleting the csv file from the drop folder. This also deletes the Domain.

I think this tool will make using Adhoc Views much easier to use.

Link to comment
Share on other sites

  • 1 year later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...