Back

Topic

[KB1079]BUFTOEXCEL migration issue on version 12

Tags: Migration, Scada Basic

Upgrade issues
4 years ago
By LM
Options
Print
Applies to:

PcVue 12 onwards
Summary:

The Scada Basic BUFTOEXCEL instruction has appeared in version 11.1.

However in version 11.1 and 11.2 the APPEND mode is not a real APPEND mode, it works like a MERGE mode. You have to wait for version 12 to have a real APPEND mode.

This means that if you were using the APPEND mode of the Scada Basic BUFTOEXCEL instruction in a project developed with a version prior to PcVue 12 you will need to correct your script so that it works correctly with a recent version. Basically you will need to replace APPEND with MERGE.
Details:

Here are some examples of syntax and their possible equivalent after migration :

PcVue 11.1 or 11.2 From version 12
BUFTOEXCEL(lngbuffer1,”;”,”\t”,strFileName,”Sheet1″,”APPEND”); BUFTOEXCEL(lngbuffer1,”;”,”\t”,strFileName,”Sheet1″,”MERGE”);
BUFTOEXCEL(lngbuffer1,”;”,”\t”,strFileName,”Sheet1″,”APPEND”,4,3); BUFTOEXCEL(lngbuffer1,”;”,”\t”,strFileName,”Sheet1″,”MERGE”,4,3);

Of course this can vary from one project to another and it is up to you to check your script carefully. The examples are given here only as a rough guide.
 

Created on: 02 Nov 2020 Last update: 04 Sep 2024