Exit Forms - Another Form of Support
A few months ago we created the Field
Exit Community Site which is used for BVSTools to better
communicate with my customers. We also invite anyone and
everyone to join and share their experiences as well.
For our customers we are finding it a much better medium to
share examples and answer Frequently Asked Questions.
We receive many emails a week and a lot of them are very
similar. So now instead of a quick answer we can take the
time to put together an nice example to share with you, the customers.
Feel free to take a look at the forums. If you're so
inclined, also feel free to sign up and share your experiences with our
software or the IBM i in general.
Also, please keep an eye on the BVSTools Announcement forum for news about new products and updates.
SQL for the Rest of Us
IBM i tool builder Bob Cozzi has developed a Command Entry-based SQL query tool for IBM i.
"Query File SQL"
allow users to run SQL statements from within CL and Command Entry.
This includes an automatic reporting tool that utilizes the SQL SELECT
By enabling SQL SELECT within CL and Command Entry,
Cozzi has unlocked the full power of SQL to IBM i users. You can now
build reports/listing, PDF, CSV, or outfiiles using the SELECT
Query File SQL is available for a trial download at www.cozTools.com/qryfile
Adds Google Drive Functionality!
The latest version of GreenTools for
Google Apps (G4G) now contains a
new addon for Google Drive (G4GGDRV).
As of this offering you are able to
upload files to Google Drive using a command or ILE functions.
You also are able to retrieve a list of files on your Google
An example of the command to upload a
file to your Google Drive would look
something like this:
G4GUPLOAD ID(email@example.com) STMF('/tmp/file1.zip')
You can see a full example of how we personally use this new feature to
backup our IBM i (AS/400, iSeries) to Google
See the G4G
documentation for more information.
JSON Parser Now Available
Because a lot of our applications now deal with the "cloud" and Web
Services we needed to be able to parse JSON data.
We created our own internal processes for this, and customers have been
asking for it as well, so we decided to make it available to the public.
The product is named JSONTOOL and can be downloaded
from this link.
Examples of using JSONTOOL can be found in this Field Exit post.