VD Windt ERP Installation Manual

(1)

PDF generated using the open source mwlib toolkit. See http://code.pediapress.com/ for more information. PDF generated at: Tue, 26 Aug 2014 14:31:17 CEST

VD Windt ERP Installation

Manual

(2)

Articles

1 Quick Check-List

₁

1 Quick Check-List 1

2 Installing Codeless Components

₂

2 Installing Codeless Components 2

2.1 Codeless Server 2 2.2 Codeless Client 4 2.3 Reporting Services 4 2.4 Task Scheduler 4

3 Data Configuration

₅ 3 Data Configuration 5 3.1 Plug-Ins Registration 5 3.2 System Settings 6 3.3 System Menu 7 3.4 Reports 7

3.5 Check company settings in f. 8000 7

3.6 Add HAP information in function 8827 (see function SYSO100, SYSS10E). 7

3.7 Install SSIS packages 8

3.8 Change connection & run SSIS packages 8

3.9 Update conversion batches & files 9

References

Article Sources and Contributors 11

(3)

1

1 Quick Check-List

Quick Check-List

1.

1. Install Codeless Server, Client, Reporting Services and Task Scheduler. 2.

2. For the Codeless Server MSLMode must be set to 2 (usually it is 5). 3.

3. Configure partial commit transition ids. 4.

4. Application pool for the Server set to 64 bit. 5.

5. Separate application pool for Reporting Services. 6.

6. Install and register VDWIndt Plug-In. 7.

7. Check System Settings. 8.

(4)

2

2 Installing Codeless Components

Installing Codeless Components

Any Codeless Environment must include the core Codeless components in order to run.

2.1 Codeless Server

Codeless Server

Follow the steps described in Codeless Server 3.1 IIS Installation document for installing the Codeless Server. When the installation is ready, perform the configurations bellow.

Open the web.config file, and set MSLMode to 2 (strict VB.NET MSL Engine):

Add the following setting (or update it, as appropriate):

Open IIS Manager and set Enable 32-Bit Applications to False (it is normally set to True during the Codeless Server installation).

(5)

2.1 Codeless Server 3

Check that the installation package contains the following plug-ins, and copy them to the Codeless Server’s bin\

folder:

A. VDWindt.PlugIn, with the following files: a. Codeless.Framework.Logging.dll b. Codeless.VDWindt.PlugIn.dll

(6)

2.2 Codeless Client 4

2.2 Codeless Client

Codeless Client

Follow the steps described in Codeless Client ClickOnce Release Maker 3.1 document for installing the Codeless Client.

2.3 Reporting Services

Reporting Services

Follow the steps described in Codeless Report Services 3.1 Installation document for installing the Reporting Services.

Select a distinct name for the application pool than the default one (which is shared with the Codeless Server), for example: <PackageName><EnvironmentType>ReportingServices. Because the application pool for the VD Windt Server has distinct settings.

2.4 Task Scheduler

Task Scheduler

(7)

5

3 Data Configuration

3.1 Plug-Ins Registration

Plug-Ins Registration

Check that the installation package contains the following script: VDWindtPlugIns.sql.

Execute the script against the database. The script should also clean the existing data, so you do not have to do this separately.

After registering the plug-ins, check the Server Version page to see if they have been registered correctly.

(8)

3.2 System Settings 6

3.2 System Settings

System Settings

(9)

3.3 System Menu 7

3.3 System Menu

System Menu

The system menu will be created/updated by the customer (during this project). SO PLEASE, DON’T OVERWRITE THE SYSTEMMENU AT THE RELEASE!

3.4 Reports

Reports

New reports will be released. See also function 678 in Codeless & release notes from IA.

3.5 Check company settings in f. 8000

Check company settings in f. 8000

Company settings in function 8000 need to be added/updated. We can use the same settings from vd Windt ERP Development.

3.6 Add HAP information in function 8827 (see

function SYSO100, SYSS10E).

(10)

3.7 Install SSIS packages 8

3.7 Install SSIS packages

Install SSIS packages

We should copy the generated SSIS packages from G:\Projects - Customers\Van der Windt verpakking\Codeless overgang\SSIS packages 26-11-2012 to a location on the database server.

3.8 Change connection & run SSIS packages

Change connection & run SSIS packages

To actually get the data from Unix imported into Codeless, we should Execute the generated SSIS packages. -> Double click on the saved SSIS package.

-> Make sure the connections are ok

-> The password should be added into the connection string. After the connection string is changed keep the TargetConnection checked.

-> Example: when you want to import into VdWindtTest environment: server=impiis4\SQL2008r2;User id=dotnet;Password=d0tn3t2008;initial Catalog=VDWindtERPTest;Application Name=VDWindtERPTest;Integrated Security=False;

(11)

3.8 Change connection & run SSIS packages 9

It is possible to execute multiple SSIS packages at 1 time.

3.9 Update conversion batches & files

Update conversion batches & files

Information in function 8738 & 8737 & 8721 must be copied to the customers vd Windt ERP environment. This needs to be done manually / with export&import from Excel.

(12)

3.9 Update conversion batches & files 10

Including batch files function 8721 (= 1st tab from 8737).

(13)

Article Sources and Contributors 11

Article Sources and Contributors

1 Quick Check-List Source: http://hosting1.codeless.com/CodelessDevelopmentWiki/index.php?oldid=7634 Contributors: AndreeaCroitoriu

2 Installing Codeless Components Source: http://hosting1.codeless.com/CodelessDevelopmentWiki/index.php?oldid=7638 Contributors: AndreeaCroitoriu

2.1 Codeless Server Source: http://hosting1.codeless.com/CodelessDevelopmentWiki/index.php?oldid=7652 Contributors: AndreeaCroitoriu

2.2 Codeless Client Source: http://hosting1.codeless.com/CodelessDevelopmentWiki/index.php?oldid=7655 Contributors: AndreeaCroitoriu

2.3 Reporting Services Source: http://hosting1.codeless.com/CodelessDevelopmentWiki/index.php?oldid=7656 Contributors: AndreeaCroitoriu

2.4 Task Scheduler Source: http://hosting1.codeless.com/CodelessDevelopmentWiki/index.php?oldid=7657 Contributors: AndreeaCroitoriu

3 Data Configuration Source: http://hosting1.codeless.com/CodelessDevelopmentWiki/index.php?oldid=7658 Contributors: AndreeaCroitoriu

3.1 Plug-Ins Registration Source: http://hosting1.codeless.com/CodelessDevelopmentWiki/index.php?oldid=7660 Contributors: AndreeaCroitoriu

3.2 System Settings Source: http://hosting1.codeless.com/CodelessDevelopmentWiki/index.php?oldid=7662 Contributors: AndreeaCroitoriu

3.3 System Menu Source: http://hosting1.codeless.com/CodelessDevelopmentWiki/index.php?oldid=7663 Contributors: AndreeaCroitoriu

3.4 Reports Source: http://hosting1.codeless.com/CodelessDevelopmentWiki/index.php?oldid=7665 Contributors: AndreeaCroitoriu

3.5 Check company settings in f. 8000 Source: http://hosting1.codeless.com/CodelessDevelopmentWiki/index.php?oldid=7666 Contributors: AndreeaCroitoriu

3.6 Add HAP information in function 8827 (see function SYSO100, SYSS10E). Source: http://hosting1.codeless.com/CodelessDevelopmentWiki/index.php?oldid=7667 Contributors: AndreeaCroitoriu

3.7 Install SSIS packages Source: http://hosting1.codeless.com/CodelessDevelopmentWiki/index.php?oldid=7668 Contributors: AndreeaCroitoriu

3.8 Change connection & run SSIS packages Source: http://hosting1.codeless.com/CodelessDevelopmentWiki/index.php?oldid=7674 Contributors: AndreeaCroitoriu

(14)

Image Sources, Licenses and Contributors 12

Image Sources, Licenses and Contributors

File:VD1.png Source: http://hosting1.codeless.com/CodelessDevelopmentWiki/index.php?title=File:VD1.png License: unknown Contributors: AndreeaCroitoriu

VD Windt ERP Installation Manual