Automic Workload Automation

Is there a way to copy a file from a local desktop(user desktop) to a remote desktop(where the UC4 application is hosted)

I tried using xcopy via windows job which runs in the remote desktop. But the issue is it cannot get hold of the file to be copied from the local desktop.

We are using UC4 Gui to connect to our config environment..

Also is there a way to open a local file location through script commands or through promptsets. Something like the window its pops out while exporting or importing an object xml from user's local desktop.

Please let me know if there is a way out for this?

Thanks,

Arun

this question is better asked in a windows or RDP forum.

or entered into google :-)

like here:
https://www.raymond.cc/blog/transfering-files-from-local-computer-to-connected-remote-desktop-session/
or here:
http://stackoverflow.com/questions/9304953/copy-files-from-remote-rdp-to-local-machine

so if you want to import an export or export an object to or from Automic UI you need the connection between your machine and the RDP server where the Automic Ui runs (as described above) .

Hello Wolfgang,

We are in middle of a script development where in we need an User Interface on execution of the script that will transfer a file as selected by the user in his local desktop to a remote shared server path where the UC4 is hosted.

"xcopy" works to transfer the excel file from the local desktop to the remote shared server path using the below command.

xcopy "C:\Users\ag83504\Desktop\Script\JC Project\Automic Batch Job Request Form.xlsx" "\\FDXUCM4\UC4_Script\Auto_JC" /C /Y

Want to get this same happen using an UC4 interface via a script or a job. Will that be possible?

Thanks,

Arun

As far as I understood you want to copy the Automic UI binaries from you local PC to the RDP Server where the UI should be started - correct?

Yes that will work - just copy the BIN / Temp directory of the UI to the RDP server and start the exe file of the UI.

Just for my understanding - what do you want to archive by this file copying?
For what reason do you want to copy the UI ?

We want a  file (.xlsx format) to be transferred from the users local desktop to another remote server.

The user will execute a script in UC4 and the UC4 prompt will give the user to input a file-path in his local machine where the file is situated. Once the input is taken and we hit Done for the script to process, the file will be transferred from the local desktop of the user to the remote desktop.

Note: The user local desktop can be any system from where he is opening the UC4 environment. The remote desktop is fixed where the file needs to be transferred.

Our Version of  UC4 is 11.2.2.

Local Path is : User's working system

Remote Path is : \\FDXUCM4\UC4_Script\Auto_JC\

File Format to be transferred : *.xlsx (Microsoft Excel format) 

Please let me know if this is possible.

Thanks,

Arun

We are trying to develop a script for automatic job creation as per our standards.

We have an excel format "Automic Batch Job Request Form.xlsx" that requestors fills up for their SAP jobs to be created in UC4.

We want this  file "Automic Batch Job Request Form.xlsx" to be transferred to the remote server, so that this will act as an input file for further creation of the xml. The XML once created will be imported to a path in the UC4 explorer for automated creation of multiple jobs as requested in the Automic Batch Job Request Form.xlsx. 

This is the entire vision of this program.

So long as you have methods in place to verify the request meets your standards it might be better to feed in the Job settings as parameters (or read in as xml) to an API that creates the Job(s) (and optionally Schedule[s]) automatically. If you are moving files around for some type of oversight prior to creation it may be better to do this outside of the tool as suggested above.

I think best way is to use FTP. May be you can explore with Automic RA FTP agent

I agree with Vidya..

Thanks for you inputs.

Though this is something different from my previous requirement, but it is somehow connected.

Is there way to pop-up a window to open a file from the users local desktop via scripting or promptset design?

Something like what happens when you try to export/import objects. The moment you hit import it pops-up a window to grab the xml file  from the users local desktop. The xml file is selected and the object comes in the automic environment.

Will that be possible of having a pop-up through a script?

Thanks,

Arun

I have used VARA.FILELIST objects to provide a drop down list of files in a folder to select from.  But I've never done this when I don't know the target machine before.

So to see if it could work, I set up a VARA.FILELIST object with this sort of specification;
     \\{VARA.NEW.1}\ShareName\t*

I then populated VARA.NEW.1 with the name of a valid network machine, and it worked.

So this might give you something to work with...(?)

https://us.v-cdn.net/5019921/uploads/editor/xw/q089tsolbtf3.jpg" width="1063">I was looking for something like this above.

Can I get a pop-up like this one, which I get when I hit on Import.

From this pop-up, I can select my input file.

I don't think it is possible with this product.

No, thats definitely not possible.

You can upload a file to a store object and attach this in a Job.  Then this file will be transferred to the agent defined in the job.

You can use a vara.filelist as Pete mentioned but for this you need the file to be located an a machine where an OS agent has access to this file.

Best way: any unc path or network drive

Thanks everyone. That works using a VARA.FILELIST.

I have one more similar issue with opening an internal Automic explorer windows from a prompset.

This is something similar to the UC4 explorer window that pops up when you hit on "..." for specifying the Location File-Path.

Is this something I can achieve in a prompset?

If the above is not possible, is there a way to do it?

I want to get this functionality in one of the scripts where in the users can input the file-path inside UC4 to get their XMLs imported in that particular folder.

Thanks,

Arun

 

 

 

 

 

No, such function is not available for job execution.

=> Vara.Filelist

There is also a dynamic promptset feature available that you might want to study.  I've never applied this trick, but I've bookmarked the conversation just in case I need it some day.  The idea is to have multiple pick-lists on a single promptset, but the customers response to the first item can dynamically populate the pick-list for the second item, etc...

The example used in the conversation only shows the use of SQL variable objects.  But the technique should be able to work for just about any type of variable object I would hope?

https://community.automic.com/discussion/1020/dynamic-promptset#latest

I used the dynamic option couple of times before and fetching the data from the VARA.FILELIST.

So whenever any files got added to the file-path associated with the  VARA.FILELIST, it used to get dynamically pulled out in the drop down of the input line item.

In the above case, I am not getting a way out to get the local file-paths populated through a SQL variable object.

Do you know the table/tables via which I can get the result of all file-paths available inside the UC4 environment.

"Folders" inside of the UC4 environment are virtual, not physical.  You can find the folders by running a query against the OH table where oh_otype = 'FOLD'.  And table OFS helps determine what is in each folder.

Thats the Problem, its not easily possible to create an input dialog that considers all files in all folders on your pc.
Even vara.filelist does not recognize folders.

possibly with a vara.backend it could work - performing a dir *.*/s on a win machine.

for my purposes its not necessary - all relevant files are ürovided on AE server or available via any agent.

Just played a bit with VARA.BACKEND - this works.
vara.backend:
https://us.v-cdn.net/5019921/uploads/editor/28/me6g84zp08s6.jpg" width="1031">

PRPT with combo box or checklist box
https://us.v-cdn.net/5019921/uploads/editor/5w/tk26kxvcrxnk.jpg" width="761">

scri report with the files selected:
2017-03-13 11:44:54 - U00020206 Variable '&CHECKLIST1#' was stored with value 'C:\uc4\sources\Automation.Engine_Image_11_2_17-02-27-1_SP4\db\general\8.0\uc_ini.txt;C:\uc4\sources\Automation.Engine_Image_11_2_17-02-27-1_SP4\db\general\8.0\UC_UPD_ESTIMATE_ERT.TXT;C:\uc4\sources\Automation.Engine_Image_11_2_17-02-27-1_SP4\db\general\9.0\ConvertResult.txt'.

2017-03-13 11:44:54 - U00020206 Variable '&COMBOBOX1#' was stored with value 'C:\uc4\sources\Automation.Engine_Image_11_2_17-02-27-1_SP4\db\general\11.2\uc_ini.txt'.

the only disadvantages:
- one has to take care about limits of the amount of lines (uc_system_settings)
- no directories sections are displayed

I was trying with the way Pete suggested. Could someone help me with a SQL server query to fetch the all the folders with their names.

Here is a very simple approach.  Finding all of the parent folder names is a very challenging thing to do in SQL because it is recursive, so I've never attempted it.  The integer value on the front of each folder name is the OH_IDNR for the parent folder.

select folders.oh_name as Folder      , members.oh_otype as Type      , members.oh_name as Member from  oh folders     , oh members     , ofs where folders.oh_idnr = ofs_oh_idnr_f and   members.oh_idnr = ofs_oh_idnr_o and   folders.oh_client = 0200