eBiss 3 en:howtos

File as attachment

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

File as attachment The following FrameVariables can be used to include a file as an attachment in the current message when containerizing: Feld/Eigenschaft Variablenname Hinweis AddAttachmentFileName eBiss.DocumentVars.AddAttachmentFileName Path and name of the file.

Alternative containerization

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Alternative containerization Normal The eBiss containerization component has the following four characteristic properties, which determine how documents are containerized into messages: * Global: all documents go into one message. * Individual: For each new document a message is created

Alternative communication

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Alternative communication alternativ adressing Task: Messages to alternative eGate account Messages of type XYZ should be sent to an alternative address Solution * Determine the alternative communication address and store it in addition to the existing one with the trading partner of the original recipient.

EntitySelector Alternatives for Flatfiles

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

EntitySelector Alternatives for Flatfiles Problem: Incoming Flatfiles with identical structure should be differentiated based on the file name and converted into various target types with the help of different mappings. Standard Solution: Define and name the different entity types

Archiving of messages in eBiss 3

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Archiving of messages in eBiss 3 eBiss 3 offers the possibility to archive x days old messages into a database as well as a file directory. For the database all databases also supported by eBiss are possible, see system requirements. For creating the tables, scripts for MySQL and the MS SQL server are located in the installation directory under Tools in the files:

Manual Supplier Article Selection

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Manual Supplier Article Selection With this eBiss web page you can send PRICATs for selected articles. On the web page, you select articles from the article pool, select the partner, and start the predefined job to send the PRICATs. Requirements eBiss 3

Automatically add key/value pairs

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Automatically add key/value pairs Introduction When transforming incoming or outgoing documents, we often need a so-called recoding or translation of proper or foreign keys. For this purpose, value tables and value providers are usually created. Normally a trader does this when receiving PRICATs

Messages from external systems

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Messages from external systems The interface IBackendObjectSenderCommit is available for jobstep BackendObjectRetriever. With the implementation of this interface, a new BackendType is available. Method CommitCurrent This method is used before the message is written to the database. This allows for the possibility to make changes before the message starts to

Build a hierarchy using function SplitToArray()

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Build a hierarchy using function SplitToArray() To derive a hierarchy from a given structure there is ideally a parent-child relationship of the individual tuples. In such a case, the function BuildHierarchy can be used to create the hierarchy. If a direct parent-child

Apply business logic

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Apply business logic eBiss offers a number of technical possibilities to implement specific logical conditions in the process. The main possibilities are: * Variable definitions can be instantiated in different forms at partners and queried in mappings or processes.

Cleaning up in eBiss

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Cleaning up in eBiss Over time, depending on the transaction volume, many messages, process instances and tasks can accumulate in eBiss. These should be periodically cleaned up or deleted as with House Keeping or Cleanup. This is because eBiss is not recommended as an archive system

Cloning eBiss systems

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Cloning eBiss systems Preparations in the existing system * disable all eBiss automations and stop the eBiss service. * Make sure you have a backup and dump the database) and move it to the new location. * Upgrade to the latest version. * Dump all

Queue messages for later processing

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Queue messages for later processing Request For example, one of your trading partners has a requirement that accompanying PRICATs collected by the day may only be delivered once per day in one message. Solution To collect messages for later processing you can proceed as follows:

Copy & Paste

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Copy & Paste Note: See also Drag & Drop In the message box To test messages, they can be copied & pasted from a file into the message box. The prerequisite is that the client is logged in to the service (not a local session). Note: Whether the created message is incoming or outgoing depends on the setting on the message basket. If no direction is defined, then the value is

Set up a data link with conversion

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Set up a data link with conversion The following steps outline the procedure for setting up a data link with transformation to eBiss and show which elements are necessary and in which order the procedure is carried out. One works one's way through from back to front in order to be able to use all dependencies.

Drag & Drop

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Drag & Drop Note: See also Copy & Paste In the message box For the purpose of testing messages, they can be established by dragging & dropping a file into the message box. Precondition: eBiss client must be connected to the service (no local session). Note: Message direction is depending on the messag box setting. If the direction is not defined for the message box, the message direction will be set to

eBiss 3 system update

Anonymous (anonymous@undisclosed.example.com) — 2024-10-07T13:32:32+00:00

eBiss 3 system update The eBiss 3 system update includes the following steps: 1. Download current eBiss 3 version from the Pranke website * Download the current eBiss 3 standard version from ---------- 2. Stop eBiss server service * Stop the service

Using EntityStatusSetter in Jobs

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Using EntityStatusSetter in Jobs The EntitySatusSetter can be used to provide messages / documents with specific status depending on the processing step. These stati can be usedin jobsteps like EntitySelector, MessageSelector and MessageCollector to make a specific selection of messages or to narrow them down.

Modularise Jobs

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Modularise Jobs The EventRouteResultSetter returns the results of SubJobs to the MainJob. The use of the EventResultSetter allows the following:in Jobs, which can be gotten with the EventRouter as SubJobs , the results (ie: the converted objects)can be given back for processing

Locating messages/documents

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Locating messages/documents Ideally, a message or document can be found via * the document number, * the document date, * the sender or * the receiver or if necessary over * the file name. However, it also happens that you want to find a message according to other criteria

Formatting the task notification

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Formatting the task notification The use of the TaskNotificatorEx is provided for an individual design of the task notifications. This allows the selection of a specific text or HTML template which can be filled with various notification variables. Documentation under

FrameVariables

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

FrameVariables USE: A MapFrameContainer that contains these values is attached to each object from the time the object was loaded. These values include, among other things, statements about the sender and the recipient, as well as the Subject Filename

Select data element names using XPATH filter

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Select data element names using XPATH filter If you have data elements with the same name in a source type, you can use the XPATH function local-name() to iterate over all these data elements. Example: //*[contains(local-name(),'XYC')] Returns a list of all elements with

Configuration of the maintenance interface

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Configuration of the maintenance interface The maintenance interface (also called MaintenanceInterface) is an interface on the eBiss-PortEventListeners, which can be used to query information about the status of the system (for example, availability, utilization, etc.).

Fragment large messages

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Fragment large messages If a message cannot be processed by a receiving system due to the number of positions, then it is useful to split it into smaller fragments using a mapping. Here we access the XPATH native “predicate” function position()

Serialize messages

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Serialize messages Example scenario: Webshop integration to SAP Customers and webshop orders are to be transmitted to the host system in such a way that the correct serialization sequence is ensured. This means that for new customer installations or changes, the customer data should be processed first before the orders can be created.

Statistical distribution of messages over time

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Statistical distribution of messages over time The following SQL statements evaluate the distribution of incoming messages over time and thus give an indication of the times of greatest utilization. per hour SELECT DATEPART(hour,EntryDate) AS OnHour, COUNT(*) AS Totals FROM [eBiss3].[dbo].[Message] GROUP BY DATEPART(hour,EntryDate) order by OnHour asc

Managed File Transfer

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Managed File Transfer General By Managed File Transfer (short MFT) we understand the file transfer from point A to point B. Here the communication or exchange can consist of any combination of HDD and FTP. So all permutations of the two variants: *

Move messages

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Move messages Messages can be moved from one message box to another using a small helper job. All that is needed is a new job definition with a DelegatorJob. This DelegatorJob is then parameterized as follows: * Destination job: here you set the job that the messages would normally go through when they end up in the destination message box

Multi node communication via HTTP

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Multi node communication via HTTP A communication (or inter-node communication) between different eBiss systems or eBiss nodes can be displayed via HTTP. This looks like this in a flow chart: For the multicode communication, therefore, a distinction is made between a sending system and a receiving system / node. The receiving system needs a

Content based search for messages

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Content based search for messages Currently eBiss does not yet offer a content search . However, this can be accomplished with a workaround described below. Example: An incoming EDIFACT PRICAT message containing EAN 4058216227380 search. Requirements:

Naming conventions in eBiss

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Naming conventions in eBiss In order to create a naming system for the various objects that is as uniform, consistent and comprehensible as possible, the author recommends the following procedure. We orientate ourselves on the order, which results from the internal dependencies in

NHibernate Logging

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

NHibernate Logging To create a logfile with nHibernate you should use a FileAppender instead of TraceAppender Please proceed as follows: * The eBiss folder must contain the files log4net.dll and log4net.config.xml. * The log4net.config.xml should look like this:

Changing the nodes hierarchy

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Changing the nodes hierarchy In order to change the order of an eBiss node in the hierarchy, the specific entry in the table Edit dbo.Node. Relevant is the key in the field [ParentNode_oid]. If the [Oid] of any other existing node (which is not child of the node to edit) is entered into the field

Setting Up OAuth Client Authentication via Microsoft 365 with eBiss

Anonymous (anonymous@undisclosed.example.com) — 2026-03-13T14:18:20+00:00

Setting Up OAuth Client Authentication via Microsoft 365 with eBiss Part 1: Setup in the Azure Portal 1.1 Create App Registration In the Azure Portal, navigate to Entra ID and select Manage → App Registrations → New Registration. Configure the following settings:

Partner recognition

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Partner recognition To ensure that the partners involved in a message can be unambiguously identified in a defined process, corresponding identifications must exist in the messages. Exceptions are Channels with established partners. The identification of these partner identifications depends on the message type. With EDIFACT, AnsiX12 or other (standardized) messages, it is clearly defined by the corresponding data elements

Conversion of properties

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Conversion of properties Often it is necessary to convert the so called foreign key into own key values during transformation. This is usually done in eBiss via Value Tables. It is a matter of converting a foreign key into a known internal key . It is self-evident that the internal key is one-to-one and the cardinality foreign key to internal key can be equal

SAP IDoc Types

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

SAP IDoc Types Creating the Type with the Type Editor Once the IDoc XSD is created with transaction WE60 -> Menu Documentation -> XML Schema or DTD, one can build the new Type by creating a new System Managed Type inside an existing or a new Type Library

Shadow copy Plugins

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Shadow copy Plugins eBiss 3 allows replacing Plugin Dlls iat runtime. This accelerates the cycle: Create DLL -> End all clients -> Stop service -> Copy DLL to plugins -> restart everything. Now simply copy the new DLL into the eBiss Plugins directory which is no longer blocked due to the loading of the assemblies from another directory. Then, select

Quick search

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Quick search The eBiss Quick Search is used wherever content is displayed in tabular form. It can be parameterized individually or can be displayed with preset filters (for example, messageboxes)). Filter Editor The filter editor allows the selection of the respective possible attributes

Selective deletion of messages

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Selective deletion of messages Variant 1 If for certain reasons the messages should not be cleaned up with a Global or node specific CleanUp Job, then this method is useful. With a MessageCollector a specific message basket can be selected and the messages to be selected therein with Filter on the status and other filters can be selected.

SelectionBase (What is it?)

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

SelectionBase (What is it?) The SelectionBase is a “super” class that eBiss uses to hold all the details of a message in memory. Parts of this information are first determined for an incoming message at the receiving channel or backendobjectReceiver. Then later when applying the

Selective data switch

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Selective data switch Example of an additional forwarding of incoming messages to another system with selection by TradingPartner GLN. This variant can, for example, be used in migration scenarios to provide a new system to be set up with messages that enable a pilot operation with selected trading partners.

Start and stop eBiss service with user privileges

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Start and stop eBiss service with user privileges If users without administrator privileges should be allowed to start and stop the eBiss service. The rights to access Windows services are usually configured by means of security descriptors. There are different ways to configure the security descriptor of a service, one of them is e.g. the command line tool sc.exe:

Set document number in mapping (SetTargetFrameVariable)

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Set document number in mapping (SetTargetFrameVariable) To set the document number in the mapping, call the following function: SetTargetFrameVariable('eBiss.DocumentVars.DocNumber', 'Ihre Nr.')

Set file name and subject mapping (SetTargetFrameVariable)

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Set file name and subject mapping (SetTargetFrameVariable) Set the Filename and Subject in the mapping: * In the containerizer set the gene generation of the filename and the subject to default. * Call the following function in the mapping: SetTargetFrameVariable('eBiss.DocumentVars.FileName', 'Ihr Name')

Change/Set MessageDirection

Anonymous (anonymous@undisclosed.example.com) — 2024-06-14T11:41:01+00:00

Change/Set MessageDirection Requirement: The direction of the message should be changed or set. Solution: SetTargetFrameVariable('eBiss.DocumentVars.MessageDirection', 'Outbound' ) With SetTargetFrameVariable() you can set the MessageDirection. If this is set differently from the previously determined value, the sender and receipient are also automatically swapped, so that the resulting message can be sent back directly, including the correct settings for the sender / receipient IDs at UNB.

Simple file transfer

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Simple file transfer Also known as a simple variant of the MFT For a simple file transfer without transforming, only a few eBiss components are needed. * Message box It is advisable to also create a separate message box for a specific data link, because the files to be fetched from a receive channel must be stored somewhere in between.

Importing an SQL Server 2000 backup from the customer

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Importing an SQL Server 2000 backup from the customer To load an SQL 2000 Server Backup into an SQL server, proceed as follows: * Open the Enterprise Manager and create a new database (DB). “MyDB”. * Click on the new DB with the right mouse button.

SQL Trace

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

SQL Trace Sometimes it is helpful or necessary to see which SQL statements eBiss sends to the database. To enable the trace change the key OrmTraceDbOperations in the eBiss config file eBiss.WinClient.exe.config to True:

HowTos

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

HowTos With the HowTos we want to offer help with specific topics. This list may not be exhaustive. For specific questions not dealt with in this help, please contact a specialist at Pranke GmbH. Topics howtos index

System Revision

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

System Revision This Howto tries to show a proven, manual procedure for system analysis/revision. Practice shows that EDI landscapes are subject to frequent changes or adaptations to given situations. Therefore, the extensions tend to make a system confusing and often even contain obsolete artifacts, which then make the overview even more difficult.

Validate invoices

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Validate invoices In manufacturing systems, invoices are usually also converted and delivered to trading partners in EDIFACT format. In order to guarantee the completeness and correctness of the invoicing the eBiss.Industry.Invoice MiddleWare instance of an existing invoice can be with a mapping that can be found in the StandardTemplate directory

Link eBiss to a local computer

Anonymous (anonymous@undisclosed.example.com) — 2024-02-20T08:15:15+00:00

Link eBiss to a local computer Problem: The customer wanted to have a local link to eBiss. However, eBiss was installed on a server on the main network. Troubleshooting: Error Cause eBiss.WinClient can not find a dll file The dll is not on client machines