Hello,
how can i create in the cloud a procedure which exports an excel file and deposits onpremise? or how can users you access it?
Thanks
Philipp
Hello,
how can i create in the cloud a procedure which exports an excel file and deposits onpremise? or how can users you access it?
Thanks
Philipp
Dear Philipp Schraml,
every BOARD Cloud environment have a shared storage accessible from Board application like a standard legacy hard drive. We assign a drive letter Z: where Board data reader can load/extract files.
We also assign an environment variable called “BSS” (Board Shared Storage) that you can use referring it as %BSS% in the datareader, procedure etc.
In order to access it from your local network, you can use AZCOPY (a command line tool) or the Storage Explorer a GUI App provided from Microsoft and a shared access signature (SAS).
The SAS is a URI that encompasses in its query parameters all of the information necessary for authenticated access to a storage resource. SAS URI can be found within Cloud Admin Portal.
Regards,
Leone
Hallo Herr Schraml,
der Schritt der Dateiextraktion funktioniert immer aus Sicht des Client. Bedeutet der angegebene Pfad für die Datei muss vom Client aus erreichbar sein. Dieser Schritt ist im Web derzeit noch nicht unterstützt.
Hat denn Ihr Client Zugriff auf das angegebene Verzeichnis ? Bitte versuchen Sie doch einmal die Datei nach %windir%\Temp\ zu extrahieren. %WinDir% ist die Umgebungsvariable für C:\Windows\. Die Datei sollte sich dann dort befinden.
VG
Dietmar Jeschkeit
Ok, I understand. You want to run it with the procedurelauncher on the Server. The directory Export exists ? Can you check your shared storage. Maybe you can use a path from this.
Normally that's a case for the broadcasting function of BOARD. But for this you need a License. Export to Excel is only possible with a Client. Maybe you can open up a Client unattended in the night for creating the Excel.
The Client can run the procedure and export the file.
Have a look at help: Opening a capsule from command line . You can then set up a Windows Task to do it everey night.
unfortunately the command does not work? the board client only open blank
C:\Program Files (x86)\Board\Board Client>BoardWinClient.exe /host "sm-c1.board.com:9700" /ssl "true" /username "Administrator" /password "xxxxxxx" /capsule "Home.cpsx"
First Question: Is the Capsule in the Root Directory ? Otherwise you have to type the path beginning from the root
/capsule "Folder\MyCapsule.cpsx"
To open a capsule located on the server, where Folder is the path starting from Board\Capsules.
.
If you open the capsule it starts with it Homescreen, do mean this with "blank" ?
that's how it works now. "Cloud" must be created in the Board Client under Connect
"C:\Program Files (x86)\Board\Board Client\BoardWinClient.exe" /hostname "cloud" /ssl "true" /winEncryption "on" /username "administrator" /password "xxxx" /capsule "Export.cpsx"