Skip to main content

Kopia danych na serwer i aktualizacja w Excelu (EasyPrinter)

Streszczenie: Automatyczna aktualizacja pliku Excel z kopii danych wysyłanych przez HMI na serwer: w EasyPrinter włączenie konwersji kopii do CSV, import CSV do Excela i ustawienie automatycznego odświeżania.
EN: How to keep an Excel file updated from HMI data backups sent to a server via EasyPrinter (CSV conversion and auto refresh).

Dotyczy: EasyPrinter, EasyBuilder Pro (obiekt Backup)
Źródło: Weintek FAQ (materiały producenta), oryginalny tytuł: „How to Backup Data to Server and Update in Excel?”

To update data backup in remote backup server to an Excel file, please follow the steps below.

For details of Backup object settings in EasyPrinter and EasyBuilder, see Chapter 26 EasyPrinter and Chapter 13.24 Backup.


Step 1. In EasyPrinter, under Convert Batch File select [Enable] check box. This enables converting file backup into Excel file.

This enables converting file backup into Excel file.

image.png

Step 2. When backup file to server, a .csv file is generated.

image.png

Step 3. Create a new Excel file.

image.png

Step 4. Open the created Excel file, import the content in the .csv file by clicking [Data] \ [Get External Data] \ [From Text].

image.png

Step 5. During import, select [Comma] to be the delimiters

image.png

Step 6. When finished, the content in the .csv file can be viewed in Excel. Click [Data] and set [Properties].

image.png

Step 7. Set the time interval to refresh the Excel file, and select [Refresh data when opening the file].

image.png

 

Step 8. In this way, when backup file to server, the generated .csv file is automatically imported to Excel, therefore users can always view the updated data when opening the Excel fil

image.png

 

Słowa kluczowe

kopia danych, backup, serwer kopii, EasyPrinter, Convert Batch File, CSV, Excel, odświeżanie danych, Get External Data, obiekt Backup, How to Backup Data to Server and Update in Excel?