Database connection configuration - ESTIMATION

Configure the number of connections to the database

The default number of connections to the database is: Minimum 3 maximum 50

This number can be changed by putting this entry in the ConstructBuy Estimation.exe.config file in the bin directory on the server

....

</appSettings>

to check the number of connections

SELECT DB_NAME(dbid) as DBName, COUNT(dbid) as NumberOfConnections, loginame as LoginName FROM sys.sysprocesses WHERE dbid > 0 GROUP BY dbid, loginame

Procedure to update the prices in the database

1-Make a scheduled task on the executable "ConstructBuy Estimation.exe" with the parameters "Loader" and "Update"

2-The .csv file to import can have this format:

UniqueCode;ProductName;ItemStatus;ManagementUnit;RankingCodeFirst;RankingCodeSecond;RankingCodeLast;SupplierCode;SupplierUnit;BuyingPrice;Notes
*ABCD;BROCHURE STYLE2 STIRE;;CH ;PAIN;ACCE;AUTR;DETAILGEN;CH;22. 50;N/A
*EFGH;BROCHURE STYLE3 STIRE;;CH ;PEIN;ACCE;AUTR;DETAILGEN;CH ;22.50;N/A

3-In the directory where the .csv file is stored, we will put the following configuration file: Schema.xml

4-Import the prices into the catalogue by selecting the .csv file manually and indicating that it will be "the selected directory is saved as the directory for automatic price update" as shown below.