Stand: 07.07.2009

EULANDA® ERP System Head Start thru Technology

You want to create Add-On's for the EULANDA® ERP system?

Back | Level back

 

EULANDA® ERP offers more possibilities than ever.

Almost all businesses run a variety of different software and the automation and interaction between them is a constant challenge. This is why external consultants are employed often. As Solution Partner, you can play a substantial role, creating customized and efficient add-on's to further enhance the overall program and more important, help your client to tailor the program to fit his needs. This, can be become a substantial source of income to you.

Using the iScript - Technology you can develop your solutions without ever leaving the EULANDA® ERP. Very often the necessary know-how already exists, but for all others, we initiated an open training course on our website. In addition EULANDA® ERP does have an integrated developmental environment.

 

What can be scripted ?

You can newly combine existing function within the EULANDA® ERP and via our own Object Model, access methods and field values from the EULANDA® ERP API, build into the SQL Server.

For example, you may have one menu action which starts printing a whole series of documents, such as labels, shipping papers, delivery documentation and the invoice.

Since the iScript technology allows accessing external programs, provided they have an own ActiveX Object,  you may submit data to a shipping systems or send data via interface to EDI system, while processing the sales order itself.

Newer versions of Microsoft® Excel, Word or the Internet Explorer do provide extensive object models. Entire processes can be reproduced and combined into one menu action. This for example can be the automatic import of a new pricelist including the following steps: Download the file thru the Internet, import the data into Excel, convert the data in Excel to fit the structure used in the EULANDA® ERP and as final step import the data into he article basic data.

 

What do you need to know?

You should be able to handle at least one of the many available script languages and you need to know how to access the software's methods via the object model.

For Newbie's, we start a training course on our webpage covering the aspects of automation using scripts.

 

Why having a developing environment within an ERP system ?

One of the mayor aspects of EULANDA ® ERP is its extensibility without altering the source code itself. This assures the customer's investment in customized Add-On's without the cost to update that tailor made programming with each EULANDA® ERP update.

Since the customer's needs are getting more and more complex, a modern program like the EULANDA® ERP should be able to cope with these demands. Since version 2.0 we offer a new technology - iScripts. A little word for a world of chances, meaning the possibility to extend the programs features using one or more programming languages.

This is why we included the developers environment into the EULANDA® ERP, thus allowing to create the script within the program, execute it and save the code.

All scripts are saved within the SQL Registry, as part of the database. The designer allows syntax highlights for easier script control. Remarks, code and functions are separated by colors. You can test and execute the code at all time. A build in syntax control and error handling show all problems. Script templates and a documentation helps you to get started.

You can develop your extensions for the program right in the software, without the need of external development tools.

 

Which Program Language ?

Basically you can use all script languages which are supported by the Windows® Scripting Host (WSH). We decided to use JScript for our templates as well as in our examples. Please refer to the respective documentation within the Developers Handbook, on our Website. There you'll find explanations as well as practical examples.

One advantage with JScript is, you can use the language as you wood in numbers in simple calculations. Our new calculator is 100% JScript interpreter, allowing to write a calculation, as you wood using pencil and paper.

// plant measurements first floor to project: 17, Mastermind Ave.
Oriel=0.25*1.5
Kitchen=4.5*5.1-Oriel
Living=7.5*6.65

Result=Oriel+Kitchen+Living

Right - this doesn't look like a source code  - but believe it, it is a programming language. Another advantage is, you can use special signs in program variables. In addition JScript offers a very good support for html which is useful, since various parts, like texts used in proposals, the notepad in the addresses basic data etc are available as html. Therefore,  all font styles eg. Italic, Bold etc. are usable in JScript.

Which other programming languages can I use ?

You can switch between several languages (PHP, Perl, C# etc) in the designer but as executable we support for the time being, JScript and VBScript only.

 

JScript - and what about the speed ?

The various Script language do hardly differ when it comes to speed. There is absolutely no difference between the executed source code, written in Pascal, and similar routines, using a Script language, because all queries are handled thru the EULANDA® ERP SQL API on in the SQL Server. Much on top, the iScripts are all used "in process", meaning they form part of the same process used from the main program, which results in much, much quicker processing, than for example VBS on file level (approx. 1.000 %).

 

What can be executed in JScript ?

Using the iScript Technology you can define own entry dialogues, result set for specific action, special calculations, new menu item, logging or scheduled jobs.

Access system resources, the file system, installed services and Microsoft® objects, as Excel®, Word® or the Internet Explorer. Using the before mentioned objects and methods you easily can exchange, convert and calculate data between the various, external objects and use the different program advantages for your Add-On.

More and more software developers include object models in their programs allowing JScript to connect. This way you can integrate such programs directly into EULANDA® ERP.

 

Example
The CRM flowfact ( http://www.flowfact.de  ), which centrally manages email, calls, documents etc. can be accessed thru JScript. With that in mind, you can create a procedure in JScript which sends a printed offer to be archived in flowfact.

 

Where can Scripts be used ?

You can create menu action which execute scripts. Such scripts could create an order or print multiple reports automatically. 

In the report designer, scripts can be called with the command "StartScript (commands, language)" and resulting data can be used in the report output or access any other ActiveX-Object available on the system.

You can attach script to certain events, such as program start or end, after a program update has finished, a phone call coming in or simply tim controlled.

We will extend the list of  script controlled events in the future. Among other it is planned to have the PiccoLink® Radio Scanner completely event controlled. This way you can create own functions, screens and batches for the radio scanner and have them executed on the Radio Server.

iScripts can be merged with html to create dynamic pages. For example you can use the build-in EULANDA® ERP homepage, add an iScript reading the due dates from the Sales Orders and have a due list at you fingertips.

 

Where can I find additional information on iScript or JScript ?

We started a training course on JScript, right here on our website.
Check that section to learn more on possible automation possible with EULANDA® ERP

JScript Homepage

The build-in calculator screen is used as development center. Switch to the advanced mode an active the script language you plan to use.

JScrip Editor (Calc Sheet)

 

You want to sell your scripts or created a solution you want to show ?

We'll help to publish information regarding your scripts. You can upload your scripts as freeware, using the EULANDA®-Knowledge Base on the web. We will add information about you. 

 

Where to load EULANDA® ERP ?

The program, including the development tools can be found at EULANDA®-Knowledge Base. Modules and extension ca even be created with the trial version of EULANDA® ERP. The required SQL Server is included.

Knowledge Base: http://forum.eulanda.de

 

What could a cooperation look like ?

Best way is to call us and we show you the possibilities on how become a Solution Partner for the EULANDA® ERP Software.

EULANDA Software GmbH
email: info@eulanda.de
Fax: +49 (6126) 9373-22

We are looking forward to an extensive cooperation with you and remain meanwhile with

 

best regards
Your EULANDA-Team

EULANDA® ERP - Head start thru technology

 

©Eulanda Software GmbH Made in Germany, 1989-2010. All rights reserved.