Export Excel from Cloud to OnPremise
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
Answers
-
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
0 -
thanks the az tool works. However, my Excel export always fails with Z: \ Export \ test.xlsx or% BSS% \ Export \ test.xlsx. Was I doing wrong?
Cannot find the path specified
0 -
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
0 -
I let the procedure run in the cloud. How should the path be here then?
0 -
Dear Philipp,
you mean your Server is in the Cloud ?! The procedure is done by a local Client ? Then the path must be a valid path for the Client (User of Client). You can test it with your local Client and the path %windir%\Temp. The file then must be on your local machine in C:\Windows\Temp.
0 -
but we want to run the procedure as described in the cloud? it also has to work, as Leone described it, or?
0 -
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.
0 -
I see step 1 in the procedure is a goto screen ? That isn't possible with the procedurelauncher. Maybe that is your error.
0 -
ah ok thanks, but how can I define which data should be exported? How can I create a DataView which is output in the Cloud Procedure as Excel?
There is currently no file in the export directory
0 -
You can extract a layout. the layout can be defined.
0 -
0 -
And don't forget the selection for the layout. At the best do it in the steps before the extraction.
0 -
ok thanks, but i can not export an excel file too? Otherwise, would I have to convert this back to Excel every time?
0 -
Correct. You can export as csv. Maybe it is better you explain what you want to achieve.
0 -
I want to provide the installers with an excel file in our network drive every night, so that the engineers get an insight into the project assembly hours
0 -
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.
0 -
oh cool yes how can I open a client automatically every night and let the file export?
0 -
Have a look at help: Opening a capsule from command line . You can then set up a Windows Task to do it everey night.
0 -
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"
0 -
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" ?
0 -
yes the capsule is in the home dir.
no the board client not open the capsule or screen is complete empty
0 -
In your string you wrote "Home.cpsx".
0 -
oh sorry this was a old test, but this is the same:
"C:\Program Files (x86)\Board\Board Client\BoardWinClient.exe" /host "sm-c1.board.com:9700" /ssl "true" /username "Administrator" /password "xxxx" /capsule "Export.cpsx"
0 -
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"
0
