CSV Datasource Tool

1

I've upgraded my CSV datasource tool so csv file and JasperReports Server domain are in sync. If the csv file is copied to a folder, domain is created. If the csv file is deleted, domain is deleted from JasperReports Server.

hozawa's picture
51078
Joined: Apr 24 2010 - 4:31pm
Last seen: 4 months 1 week ago
Oh that's cool! Nice demo, thank you hozawa! I guess you disabled caching? Also, I guess the schema is fixed or it will find the schema for you? Thanks for sharing!
ernestoo - 4 years 3 days ago

Hi Hozawa, thanks for sharing! Please let me know if you'd like to share your code via the Exchange and I should be able to help you.

P.s. For your next video I'd suggest setting the UI locale to English so that more people will be able to understand ; )

kkumlien - 4 years 3 days ago

Scheme isn't fixed. A domain is dynamically generated when a csv file is copied to a folder.

hozawa - 4 years 3 days ago

1 Answer:

1

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.

hozawa's picture
51078
Joined: Apr 24 2010 - 4:31pm
Last seen: 4 months 1 week ago

Thanks Hitoshi! If you could share the code it would be perfect ; )

kkumlien - 3 years 12 months ago

Which client did you use in this case?

ashiwalv - 2 years 8 months ago
Feedback
randomness