Generate UUID MD5 checksum for IRS transmissions

Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
4 posts Page 1 of 1

Gcoxusa

Posts: 2
Joined: Tue Dec 15, 2015 9:42 am

Post by Gcoxusa » Tue Dec 15, 2015 10:48 am
I work on the IBM iSeries systems. In 2016 I will need to submit transmissions to the IRS for healthcare reporting. Part of that process involves generating an MD5 checksum for the file being sent, and also a UUID. I understand that GoAnywhere Director can handle the MD5 requirement. I need information on how to generate the UUID. Any suggestions will be appreciated.
Attachments
UUID_for_IRS.JPG
UUID for IRS reporting

Support_Rick

Support Specialist
Posts: 592
Joined: Tue Jul 17, 2012 2:12 pm
Location: Phoenix, AZ

Post by Support_Rick » Wed Dec 16, 2015 11:33 am
Gcoxusa,

Currently, we do not have a way to generate a UUID within GoAnywhere implicitly. We do allow you to utilize HTTP calls and retrieve values from a Web Service or connect to a Database and retrieve values.

One option is the following link:

http://www.fileformat.info/tool/guid.ht ... ormat=text

It will allow you to connect and return a UUID value. This can be done interactively within your GA Workflow, to use while defining your UTID needed for the IRS transfer.

If you are installed on Linux, this link:

http://linux.die.net/man/1/uuidgen

Will generate a UUID for you by calling a command line utility.

If you're using Windows and have Powershell:

http://blogs.technet.com/b/heyscripting ... shell.aspx

or MAC

https://developer.apple.com/library/mac ... gen.1.html

But, I believe you also have options to create these values using your DB. Since you work on the iSeries, you should have access to the DB2 database. This means, you could generate a DB2 Function to create the unique UTID (or just the UUID part) by selecting this from an SQL UserDefined Function.

IT Jungle has a nice write-up showing just how to do this:

http://www.itjungle.com/fhg/fhg082714-story01.html

So, as you can see, there are options to help you generate a UUID, either from HTTP, Command Line interfacing on your installed machine or through your Database.
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696

Gcoxusa

Posts: 2
Joined: Tue Dec 15, 2015 9:42 am

Post by Gcoxusa » Thu Dec 17, 2015 3:18 pm
OK - thanks for all the good information. I've got the UUID program resolved using the GENUUID API on the iSeries.

Would I be able to take advantage of the MD5-Checksum feature within Goanywhere by calling a Goanywhere function? I am working on an iSeries and would like to call a Goanywhere process within a CL program. We do have Goanywhere Director although I am not yet set up for that.

Support_Rick

Support Specialist
Posts: 592
Joined: Tue Jul 17, 2012 2:12 pm
Location: Phoenix, AZ

Post by Support_Rick » Thu Dec 17, 2015 6:13 pm
Gcoxusa,

You can access a file transfer from your iSeries easily by calling the RunProject API from the iSeries to transfer the file.

Checksum verification can be added to the FTPS task to ensure that the source file is exactly the same as the destination file after a transfer completes successfully. This option is available on the Put, Get, Mget, Manual Get, and Manual Put elements. Both the CRC32 and MD5 algorithms are supported with the default and recommended algorithm being MD5. Errors may occur if the transfer was performed in ASCII mode, if the FTPS server doesn’t support checksum verification or if the calculated values do not match.

So, by calling a GA Workflow task that does the file transfer for you, you can incorporate the MD5 automatically for transfer utilizing the FTPS transfer from within your iSeries CLP or RPG program.
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
4 posts Page 1 of 1