How to use webuser mail adresses from GAS

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

How to use webuser mail adresses from GAS

Postby Joerg » Wed Dec 11, 2013 10:41 am

Hi,

I have to solve a tricky problem, but i think it is not altogether a rarity..
We have some webuser organized in webusergroups in GAS.
With a GAD projekt we want to send a mail to this user (webgoup by webgroup). The send mail task should use a dynamic var for the 'to' field. If the webuser admin change the GAS webuser as member of webuser group the script should still work for all new and updated users too.
Now I have develop a 'dirty' solution. Because we use the embbeded derby db,

- we copy the derby files with OS task
- then we have access to the user tables from GAS within a GAD database ressource
- then we can pick up the wished mailadresses with a query into a rowset
- with a 'ForEachLoop' and the rowset data we can add the mailadresses to a var for 'Sendmail'

My question is. see you a more elegantly way to do so? Or it is better to use a external db for the config data of GoAnywhere?

with regards
Joerg
Joerg
 
Posts: 21
Joined: Wed Dec 19, 2012 9:57 am

Re: How to use webuser mail adresses from GAS

Postby Joerg » Thu Dec 12, 2013 5:10 am

Additional info,

the dirty solution (copy the embedded GAS derby files) is not so easy like we think. The db is linked into JVM of GAD and so the data are not updated by copy the files
Joerg
 
Posts: 21
Joined: Wed Dec 19, 2012 9:57 am

Re: How to use webuser mail adresses from GAS

Postby Support_Rick » Thu Dec 12, 2013 8:49 am

Joerg,


You can't make connections to the Derby DB from GAD while GAS is running or active.

Your best solution here is to switch DB from Derby to External (Oracle, MSSQL, MySQL, DB2, etc) then you can connect and generate the Rowset as needed.

Otherwise, you would have to restore the latest backup (from Midnight) of the GAS Derby Database into another folder outside of GAS (as a working copy), then connect to that Derby DB (which would be inactive) and process based on the "latest" version available. When finished, you could delete that Copy of the DB.
Rick Elliott
Sr. Product Specialist
(402) 944.4242
(800) 949-4696
Support_Rick
Support Specialist
 
Posts: 149
Joined: Tue Jul 17, 2012 2:12 pm

Re: How to use webuser mail adresses from GAS

Postby Joerg » Tue Dec 17, 2013 2:07 am

Hello Rick,

Thank you for your informations.

Yes we've noticed already this facts. And we have found another solution...we have the import files for user import to GAS and use this to scan the mail adresses from there.

Merry Christmas :-)

Joerg
Joerg
 
Posts: 21
Joined: Wed Dec 19, 2012 9:57 am


Return to Community Forum

Who is online

Users browsing this forum: No registered users and 2 guests