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.
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.
Thanks Hitoshi! If you could share the code it would be perfect ; )
Which client did you use in this case?
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 ; )
Scheme isn't fixed. A domain is dynamically generated when a csv file is copied to a folder.