I am not using AD for my users so I create them with email addresses. My question is where are the users stored at? I do not see them in the database anywhere.
You'll need to use COM API to connect to the EFT server. Lots of good info here https://help.globalscape.com/help/gs_com_api/#t=COM_Script_Examples.htm