I was looking at the API the other day an saw a cool function exportDataToFile. This will allow you to export any grid object to a flat file!!! Here is a quick example where I am taking the current grid a user is working with and then saving it as a csv file.
//Get current Data Form
DataGrid curgrid = operation.getGrid()
String curruser = operation.User.getFullName()
def GridMap = curgrid.getSourceInfo()
String GridName=GridMap.get("name")
//Filename
String ExportFileName
//Format the time date
SimpleDateFormat timestamp = new SimpleDateFormat("MM-dd-yyyy");
String FormatTime
Date date
date = new Date()
FormatTime= timestamp.format(date)
ExportFileName = "$curruser-$GridName-pre-$FormatTime-.txt"
operation.exportDataToFile(curgrid, ExportFileName)
This function will save the file in the Inbox/Outbox where you can download it later. The file format is very nice to work with as you can see below.
I found this functionality extremely helpful when I am creating grids in groovy using the DataGridBuilder and DataGridDefinitionBuilder. Its a great way to check your work and to also save an archive of what was in memory at the time you execute a save of the grid. These files can clog up your inbox so use it as needed!
This is really helpful. thank 🙂
This is reqlly helpful, but only one question how many rows could i export using this rule