Exporting/sharing data

Yes.  If you want to keep it fully inside the IFS framework I would suggest creating a Quick Report that is a SQL Query, then schedule that report to run and email the output.

There are other options but this is likely one of the simplest.

Nick

No problem; maybe you could just ‘like’ it in the meantime :)

Not possible to schedule (I don;t think), but you can also use Output channels for any data gathered into a grid (standard IFS screens and Quick Report output alike). So if you have, say a list of Customers, you can click :Output” at the bottom of the screen and “Add” a new output channel:

You can output to XML, and if you wanted you could create a dummy application that takes the filename and copies the file to a known location (advanced command line operations can use parameter @FILENAME). Or just open in Excel as a CSV and save it off wherever you like.

Once you have created the new Output channel, it shows up under the right-click Output menu:

Like I said, though, this would be interactive, and not schedule-able. Still, Output methods are a powerful way to send the data the user has assembled to an external application. We leverage that as one of our integration methodologies so that users can assemble data using IFS-native Searches and Quick Reports and an external application can then operate on the data without needing to construct search functionality of our own making.

These Output channels can be set up on a user-by-user basis so that the Output menu doesn’t become overwhelming (also a bit of “security via obfuscation” on that front, though a savvy user could easily see the calls you are making...).

Thanks,

Joe Kaufman