Может ент поможет...
С офф сайта инфа..
page 1 of 17
TECDOC DDE Interface
DDE_Interface_TCD_v_8.0.doc
Version 8.0
10.01.2006
TECDOC Informations System GmbH
Ostmerheimer Str. 198
51109 Koeln
Fon: +49 (0) 221/66 00-112
Fax.: +49 (0) 221/66 00-100
email:
support@tecdoc.net
http: www.tecdoc.net
page 2 of 17
1 Table of Contents
1 TABLE OF CONTENTS............................................................................................................................. 3
2 GENERAL AND HISTORY.............................................FEHLER! TEXTMARKE NICHT DEFINIERT.
2.1 HISTORY OF THE DOCUMENT.................................................................................................................... 6
3 GENERAL INFORMATION ...........................................FEHLER! TEXTMARKE NICHT DEFINIERT.
3.1 ABBREVIATIONS ..................................................................................................................................... 9
3.2 DEFINITIONS ........................................................................................................................................... 9
3.3 IMPORTANT REGISTRATION ENTRIES ........................................................................................................ 9
3.4 PURPOSE OF THE DOCUMENT...................................................FEHLER! TEXTMARKE NICHT DEFINIERT.
4 BROAD VIEW OVER THE DDE – INTERFACE OF THE TECDOC-CD......................................... 13
4.1 THE USER SURFACE ............................................................................................................................... 14
4.1.1 Possible commands of the client to the TECDOC-CD................................................................. 14
4.1.2 Changed surface of the TECDOC-CD during an existing DDE- connection ............................... 16
4.1.3 Sending data from the TECDOC-CD to the Client ....................................................................... 17
4.2 THE DEVELOPER VIEW............................................................FEHLER! TEXTMARKE NICHT DEFINIERT.
4.2.1 Syntax of the commands to the TECDOC-CD............................................................................... 18
4.2.2 Form of the data sent by the TECDOC-CD .................................................................................. 24
4.3 DATA TABLES .........................................................................FEHLER! TEXTMARKE NICHT DEFINIERT.
4.3.1 Version information (from 4/2002) ............................................................................................... 29
4.3.2 1120 Vehicle table PC/CV (changed 1/2004)................................................................................ 30
4.3.3 1121 KBA-table (changed from 4/2002) ....................................................................................... 33
4.3.4 1200 Article (changed from 3/2005) ............................................................................................. 35
4.3.5 1201 Prices (changed from 1/2004).............................................................................................. 38
4.3.6 1205 Parts lists (changed from 1/2004) ........................................................................................ 40
4.3.7 1209 EAN-Numbers (new from 1/2004)........................................................................................ 41
4.3.8 1211 Generic Articles (changed from 4/2002).............................................................................. 42
4.3.9 1350 Labour time (changed from 1/2006)..................................................................................... 42
4.3.10 1355 Inclusive work (changed from 1/2006)................................................................................. 44
5 TRIGGERING OF THE TECDOC-CD ................................................................................................... 45
5.1 ESTABLISHING THE CONNECTION............................................FEHLER! TEXTMARKE NICHT DEFINIERT.
5.2 SENDING COMMANDS TO THE TECDOC-CD ......................................................................................... 46
5.3 SENDING OF DATA TO THE CLIENT.......................................................................................................... 47
5.4 ENDING THE CONNECTION ..................................................................................................................... 48
5.5 EXAMPLE IN MICROSOFT VISUAL BASIC................................................................................................ 49
page 3 of 17
2 General and History
With this version, the TECDOC-CD DDE interface was switched to the standard DDE method. Also, the data
table format was largely extended to prepare for future interface extensions and to receive new information. The
set lengths of the data tables were given up in favour of variable length. To be compatible with future versions,
the client should not carry out a lengths check whilst reading in these tables.
For these reasons, old client-implementations are not compatible with the new interface and need to be adapted.
2.1 History of the document
Version Date Author Comment
3.0 02.07.2002 Mr Langmann Adjustment to DDE-Standard,
extension of tables
3.0a 10.09.2002 Mr Langmann Adjustment of registry keys for licence
CDs
3.0b 07.11.2002 Mr Langmann Adjustment command
„EMPTYBASKET“
3.0c 18.12.2002 Ms Daum Adjustment of registry keys for licence
CDs
4.0 22.01.2003 Ms Daum Extension with labour times
4.1 05.02.2003 Ms Daum Extension with additional work and
maintenance services; adjustment send
process for labour times
4.2 07.02.2003 Ms Daum Change SA 1355: Column AW was
dropped as no separate labour time
available for inclusive work.
4.3 13.02.2003 Ms Daum Field AWBez in table 1350, 1351 and
1355 increased to 255 characters;
Change of field AWID in table 1355 to
type „C“
5.0 28.07.2003 Ms Daum Adjustment of all applicable tables to
the new TecDoc format definition
(changed columns are marked in bold):
- Added new table 1209 to sequence of
the exported tables
- 1120: columns MotArt, AntrArt,
BremsArt, BremsSys, KrStoffArt,
KatArt, GetrArt and AufbauArt 3
places; column FzgArt erased; new
columns Kraftstoffaufbereitungsprinzip
and Ventile/Brennraum
- 1200: Columns Zbez and EANr
erased; column ArtStat 3 places
- 1201: Column PENr, MENr and
PrArt 3 places; column Reserviert (2
times) erased
- 1205: added column PartGenArtNr
- 1209: new table
6.0 06.12.2004 Ms Daum Adjustment to the TecDoc data tables
page 4 of 17
in the version 2.1:
- 1200: new column MengeProVPE
7.0 21.07.2005 Ms Daum Adjustment of tables for labour times:
- SA 1350 and SA 1355 changed
- SA 1351 dropped
8.0 10.01.2006 Ms Daum Adjustment of table 1121:
- KBANr now alpha-numeric
- ABENr now with 25 spaces
page 5 of 17
3 General Information
3.1 Abbreviations
KTypNr the TECDOC- specific vehicle number
KBANr The vehicle number of the Kraftfahrtbundesamt
GenArtNr Number of the Generic Article
3.2 Definitions
Application – topic to characterise the server „TCD“
Initialisation - topic to initialize the connection „Parts“
Receiving – topic to receive the server data via hotlink „PartsSelection“
3.3 Important registration entries
The complete path name of the executable file is listed in the following entry of the Windows
registration database:
\\HKEY_LOCAL_MACHINE\SOFTWARE\TECDOC\TECDOC CD\exepath
This path is only valid for the TECDOC CD. Each licence CDs can be found under the following
paths (for example):
Behr
\\HKEY_LOCAL_MACHINE\SOFTWARE\BEHR\BEHR CD\exepath
Bosch
\\HKEY_LOCAL_MACHINE\SOFTWARE\BOSCH\BOSCH CD\exepath
Febi
\\HKEY_LOCAL_MACHINE\SOFTWARE\FEBI\FEBI CD\exepath
Luk
\\HKEY_LOCAL_MACHINE\SOFTWARE\LUK\LUK CD\exepath
Pierburg
\\HKEY_LOCAL_MACHINE\SOFTWARE\PIERBURG\PIERBURG CD\exepath
The value of the key contains the complete path inclusive file name.
3.4 Purpose of the document
This document describes the DDE-interface of the TECDOC-CD and addresses mainly software developers,
who wish to develop a DDE client.
page 6 of 17
4 BROAD VIEW OVER THE DDE – INTERFACE OF THE
TECDOC-CD
The DDE-interface of the TECDOC-CD enables the communication with other applications. On the
one hand, it enables programs to make a specific selection of vehicles or generic articles on the
TECDOC-CD by sending specific commands to this interface, and on the other hand, article numbers,
which are selected on the TECDOC-CD, can be sent to other programs.
In the DDE – terminology, the TECDOC-CD is in this case the server and the other programs is the
client.
4.1 THE USER SURFACE
4.1.1 Possible commands of the client to the TECDOC-CD
The following commands can be sent via DDE to the TECDOC-CD:
• The selection of a vehicle with KTypNr; KTypNr being the TECDOC- specific vehicle number of
the vehicle.
• The selection of a vehicle with KBANr; KBANr being the vehicle number of the
Kraftfahrtbundesamt.
• The selection of a generic article with GenArtNr (see SA320) (from 2/2001)
• Reset of the vehicle selection window.
• Reset of the search tree window (from 2/2001)
• Transfer of the name of the application, which represents the Client. This name is shown in the
TECDOC-CD on the send-data-button “Send to [name of application]”.
• Activation of the TECDOC-CD (bring to the foreground).
• Control of the display of the send-buttons (from 2/2001)
• Query of interface version (from 4/2002)
• Erasing of shopping basket (from 4/2002)
4.1.2 The changed surface of the TECDOC-CD during an existing DDE- connection
The menu of the TECDOC-CD lists a menu item DDE, which contains the menu points “send
shopping basket” and “send selection”.
As soon as a DDE- connection is made and the user is on the shopping basket screen, the menu point
“send shopping basket” can be chosen. The menu point “send selection” is possible as soon a vehicle
has been selected; optionally, a generic article can be chosen and sent.
4.1.3 The sending of data from the TECDOC-CD to the Client
If on the TECDOC-CD a vehicle (optionally also a generic article) has been selected and therefore is
contained in the history, it can be sent to the Client via the DDE interface. The sending is triggered by
chosing the menu point “send selection” or by pressing the applicable buttons from the toolbar. The
same is applicable for the sending of the contents of the shopping basket.
page 7 of 17
4.2 THE DEVELOPER VIEW
4.2.1 The syntax of the commands to the TECDOC-CD
A command is sent to the TECDOC-CD in form of a string.
There are a total of 6 commands, which select something on the TECDOC-CD:
1. [KTYPNR]
Reset of the vehicle selection window.
2. [KTYPNR(KTypNr)]:
KTypNr is numeric.
Selection of a vehicle with the number KTypNr. Should the KTypNr be applicable to several
vehicles (a PC and a CV), an additional user selection is carried out on the CD.
3. [KBANR]:
Reset of the vehicle selection window.
4. [KBANR(KBANr)]
KBANr is alpha-numeric.
Selection of a vehicle with the number KBANr. Should the KBANr be applicable to several
TECDOC- vehicles, an additional user selection is carried out on the CD.
5. [APPNAME("Name")]
Name is a string.
Text, which is lodged in the toolbar and in the menu as tool tip.
6. [GENART]
Reset of assembly group selection window (from 2/2001)
7. [GENART(GenArtNr)]
GenArtNr is numeric.
Selection of a generic article (from 2/2001)
8. [HIDEBUTTONS]
Deactivates the send-menu items and the send-button (from 2/2001)
9. [SHOWBUTTONS]
Reactivates the send menu items and the send button, after they have been hidden with
[HIDEBUTTONS] (from 2/2001).
10. [SETMODE(mode)] (from 2/2001)
mode is numeric and can only have the values 0 and 1.
mode = 0 => The tables 1201 and 1211 are not transferred (default setting)
mode = 1 => The tables 1201 and 1211 are transferred
11. [VERSION] (from 4/2002)
Triggers the sending of a block with the version number of the interface.
page 8 of 17
12. [EMPTYBASKET] (from 4/2002)
Triggers the erasing of the shopping basket of the TECDOC-CD. Caution: This command has to
stand alone!
On receiving these commands, they are stored in sequence by the TECDOC – CD in a command list,
but not yet executed.
Only the command
„[ACTIVATE]“
triggers the TECDOC-CD to execute all previously sent commands; the command, which was
received first will be executed first. The command list will then be erased. If the ACTIVATEcommand
is sent with an empty command list, the TECDOC-CD will only get the focus. The
commands do not need to be sent separately, but can be combined into a single string, like for
example:
„[KTYPNR(610)][GENART(1)][ACTIVATE]“
„[KBANR(123456)][GENART(1)][ACTIVATE]“
The commands need to be listed directly behind one another: there must not be a character between a
„]“ and a „[“ .
If the transfer of the tables 1201 and 1211 is requested, the following command string should be sent
directly after a successful initialisation:
„[SETMODE(1)][ACTIVATE]“.
The activate command should absolutely be listed at the end of the command string. An exception is
the command „EMPTYBASKET“, which is sent separately, i.e. without „ACTIVATE“ and without
further commands.
4.2.2 The form of the data sent by the TECDOC-CD
The Client received the data sent by the TECDOC-CD in form of an ASCII - string. It contains one or
several lines (named here as tables), which are separated through the line end ( CRLF = x0D0A ) .
The tables are sent in the following sequence:
Variant a) Vehicle selection was made
1120 Vehicle table
1121 KBA-table (if available)
If in addition article selected:
1200 Article table
1201 Article price table (only if [SETMODE(1)])
1205 Parts list articles of the article (if available)
1209 EAN-numbers of the article (if available)
1211 Generic article (only if [SETMODE(1)])
page 9 of 17
Variant b) Motor selection was made
- nothing is transferred -
Variant c) Shopping basket
Content of shopping basket is transferred. Depending on article:
Article selected via vehicle
1120 Vehicle table
1121 KBA table
Article selected via motor
- no table 1120, but the serial number is increased if a vehicle was assigned to the previous article -
Direct search
- no table 1120, but the serial number is increased if a vehicle was assigned to the previous article -
followed by
1200 Article table
1201 Article price table (only if [SETMODE(1)])
1205 Parts list articles of the article (if available)
1209 EAN-numbers of the article (if available)
1212 Generic article (only if [SETMODE(1)])
followed by vehicle information for labour times
1120 Vehicle table
1121 KBA-table
followed by labour times
1350 Labour time
1351 Follow-up and preliminary work
1355 Inclusive work
When changing the vehicle, the serial number of the tables is increased, also when changing
from a vehicle article to a direct search article.
page 10 of 17
4.3 Data tables
Changes to the previous version are marked in bold. This refers in all tables to the length and to a few new and
changed fields. Deleted fields are no longer listed.
To guarantee upward compatability, unknown tables should be ignored.
4.3.1 Version information (from 4/2002)
Content: DDE-format-version information
Length: 13
Name Length Type mandatory Denotation
LfdNr 3 N X Constant 000
SA 4 N X Constant "1000"
VKN_Art 4 N X Version number 99V99
CRLF 2 C X End of line (CRLF = x0D0A)
4.3.2 1120 Vehicle table PC/CV (changed 1/2004)
Content: Vehicle information
Length: 168
Name Length Type mandatory Denotation
LfdNr 3 N X Increase at change of vehicle, starting at 1
SA 4 N X Constant "1120"
VKN_Art 1 N X Type of link (PC=1,CV=2,Motor=3 1)
VKN_Value 6 N X Unambiguous TECDOC- Number of the vehicle
type
Bez 60 C X Description of the type
KHKZ 5 C X Vehicle manufacturer short code (e.g. "VOLVO")
Bjvon 6 N Year of construction from (YYYYMM)
Bjbis 6 N Year of construction to (YYYYMM)
KWvon 4 N X Motor capacity in KW from
KWbis 4 N Motor capacity in KW to
PSvon 4 N X Motor capacity in HP from
PSbis 4 N Motor capacity in HP to
CcmSteuer 5 N X Cubic capacity in ccm (tax related)
CcmTech 5 N Cubic capacity in ccm (technical)
1 Table Motor is not yet implemented
page 11 of 17
Lit 4 N X Cubic capacity in Litres (99V99)
Zyl 2 N X Number of cylinders
Tueren 1 N Number of doors
TankInhalt 4 N Volume of fuel tank
Spannung 2 N Voltage of vehicle electric system
ABS 1 N 0 = no, 1 = yes, 2 = optional, 9 = unknown
ASR 1 N 0 = no, 1 = yes, 2 = optional, 9 = unknown
MotArt 3 N Motor type (according to key table 080)
Kraftstoffaufb
ereitungsprinzi
p
3 N Fuel preparation (according to key table 097)
AntrArt 3 N Type of drive train (according to key table 082)
BremsArt 3 N Type of brakes (according to key table 083)
BremsSys 3 N Brake system (according to key table 084)
Ventile/Brennr
aum
2 N
Tonnage 5 N Tonnage
KrStoffArt 3 N Fuel type (according to key table 182)
KatArt 3 N Type of catalytic converter (according to key
table 089)
GetrArt 3 N Gearbox type (according to key table 085)
AufbauArt 3 N Body type (according to key table 086)
CRLF 2 C X End of line (CRLF = x0D0A)
4.3.3 1121 KBA-table (changed from 4/2002)
The KBA table exists exclusively for table 1120. All available KBA information if available is issued
in a KBA table. Should no information be available, the table 1121 will not be issued.
Content: KBA-information
Length: 47
Name Length Type mandatory Denotation
LfdNr 3 N X Increase at change of vehicle, starting at 1
SA 4 N X Constant "1121"
KBANr 7 C X German KBA-number
ABENr 25 C Number of type approval
ABEvon 6 N Month of type approval (YYYYMM)
CRLF 2 C X End of line (CRLF = x0D0A)
page 12 of 17
4.3.4 1200 Article (changed from 3/2005)
Content: Article data
Length: 152
Name Length Type mandatory Denotation
LfdNr 3 N X Increase at change of vehicle, starting at 1
SA 4 N X Constant "1200"
PosNr 3 N X Order position per vehicle, starting at 1 2
ArtNr 22 C X Article number as entered by supplier
EinspCode 10 C X Supplier short code (e.g. "BOSCH")
Bez 60 C X Description of article
VPE 5 N Packing unit
KZSB 1 N SS suited packing = "1"
KZMat 1 N Compulsory material certification = "1"
KZAT 1 N Remanufactured part = "1"
KZZub 1 N Mark accessories = "1"
ArtStat 3 N Article status (-> 073)
StatusDat 8 N Status valid from YYYYMMDD
LosGr1 5 N Lot size 1 (Multiple of VPE)
LosGr2 5 N Lot size 2 (Multiple of LosGr1)
EinspNr 4 N X Supplier number
LKZ 3 C Country code
Menge 6 N X Amount in format 9999V99 (= 1 if no shopping basket
article)
MengeProVPE 5 N Amount/piece per packing unit
CRLF 2 C X End of line (CRLF = x0D0A)
2 Matching article tables are identified with a same order position at the same LfdNr
page 13 of 17
4.3.5 1201 Prices (changed from 1/2004)
Content: Article prices (from 2/2001)
Length: 56
Name Length Type mandatory Denotation
LfdNr 3 N X Increase at change of vehicle, starting at 1
SA 4 N X Constant "1200"
PosNr 3 N X Order position per vehicle, starting at 13
LfdNr 3 N X Serial number of the prices within an order position,
starting at 1
LKZ 3 C X Country code
WKZ 3 C X Currency code
PrArt 3 N Price type according to key table 074
PENr 3 N Price unit according to key table 070
MENR 3 C Quantity unit according to key table 071
Preis 10 N Price 99999999V99
Datvon 8 N Price valid from YYYYMMDD
Datbis 8 N Price valid to YYYYMMDD
CRLF 2 C X End of line (CRLF = x0D0A)
4.3.6 1205 Part lists (changed from 1/2004)
Content: Part lists for single articles
Length: 42
Name Length Type mandatory Denotation
LfdNr 3 N X Increase at change of vehicle, starting at 1
SA 4 N X Constant "1205"
PosNr 3 N X Order position per vehicle, starting at 1
PartGenArtNr 5 N X Unambiguous number of the part generic article
PartNr 22 C X Article in the part list
Menge 3 N X Number of articles PartNr in the part list
CRLF 2 C X End of line (CRLF = x0D0A)
3 Matching article tables are identified with a same order position at the same LfdNr
page 14 of 17
4.3.7 1209 EAN-Numbers (new from 1/2004)
Content: EAN-Numbers for single articles (from 1/2004)
Length: 28
Name Length Type mandatory Denotation
LfdNr 3 N X Increase at change of vehicle, starting at 1
SA 4 N X Constant "1209"
PosNr 3 N X Order position per vehicle, starting at 1
LfdNr 3 N X Serial number of the EAN-Numbers within one order
position, starting at 1
EANNr 13 N X EAN-Number of article
CRLF 2 C X End of line (CRLF = x0D0A)
4.3.8 1211 Generic Article (changed from 4/2002)
Content: Generic Article (from 2/2001)
Length: 80
Name Length Type mandatory Denotation
LfdNr 3 N X C
SA 4 N X Constant "1211"
PosNr 3 N X Order position per vehicle, starting at 1
LfdNr2 3 N X Serial number within one order position, starting at 1
GenArtNr 5 N X Generic article number
Generischer
Artikel
60 C X Generic article (master text)
CRLF 2 C X End of line (CRLF = x0D0A)
4.3.9 1350 Labour times (changed from 1/2006)
Content: Labour times
Length: 293
Name Length Type mandatory Denotation
LfdNr 3 N X Increase at change of vehicle, starting at 1
SA 4 N X Constant "1350"
PosNr 3 N X Labour times position per vehicle, starting at 1
AWNr 20 C Number of labour time
AWBez 255 C X Labour time description
AW 5 N X Labour time (999V99)
page 15 of 17
Skillgroup 1 N Skill group to classify a value into an accounting tier.
Possible values:
1 = Mechanics
2 = Bodywork
3 = Electrics
4 = Upholstery
CRLF 2 C X End of line (CRLF = x0D0A)
4.3.10 1355 Inclusive work (changed from 1/2006)
Content: Inclusive work
Length: 267
Name Length Type mandatory Denotation
LfdNr 3 N X Increase at change of vehicle, starting at 1
SA 4 N X Constant "1355"
PosNr 3 N X Labour time position per vehicle, starting at 1
AWBez 255 C X Description of inclusive work
CRLF 2 C X End of line (CRLF = x0D0A)
page 16 of 17
5 Triggering of the TECDOC-CD
5.1 Establishing the connection
The TECDOC-CD offers a DDE interfact to other programs; the TECDOC-CD being the server, which is started
at the start of the application.
With the command DdeInitialize, a client application can register at the Dynamic Data Exchange Management
Library. The establishing of the connection is then initiated with the command DdeConnect. The following
values are used as parameters:
ApplicationName=“TCD“ (service name)
Topic=“Parts“ (topic name)
Context data = null
Should the CD not start, the connection command fails. In this case, the client has to start the TECDOC-CD,
which is possible through the read out of the registry (see 3.3 important registration entries). The triggering with
DDE is only possible after the complete start of the CD.
5.2 Sending of commands to the TECDOC-CD
After the establishing of the connection, the client can send commands (see 4.2 THE DEVELOPER
VIEW) to the TECDOC-CD via the function DdeClientTransaction. The transaction type must be
XTYP_EXECUTE. In high level languages, this function is usually encapsulated as DdeExecute or
similar.
5.3 Sending of data to the client
To enable the TECDOC-CD to send data to the DDE-client, a hotlink can be set up (Hot Advice Loop). Via this
hotlink, the TECDOC-CD can send for example the content of the shopping basket or the selected vehicle to the
client.
To start the hotlink, the function DdeClientTransaction needs to be called up with the transaction type
XTYP_ADVSTART and the DataItem “PartsSelection“.
The data is sent directly to the client via the hotlink; a query from the client is not necessary. When the
TECDOC-CD sends the data, a DDE-callback function is called up at the client, (with some high level
languages, an event is triggered), which can process the data.
5.4 Ending the connection
The server ends the connection on closing the TECDOC-CD – main window. The client can end the
connection at any point with the function DdeDisconnect.
page 17 of 17
5.5 Example in Microsoft Visual Basic
To establish a DDE- connection and the hotlink, it is sufficient to add a text element into a form and set the
properties as follows.
Private Sub Command1_Click()
Text1.LinkTopic = "TCD|Parts"
Text1.LinkItem = "PartsSelection"
Text1.LinkMode = 3
// select vehicle 10000, set mode to 1, activate TECDOC-CD
Text1.LinkExecute ("[SETMODE(1)][KTYPNR(10000)][ACTIVATE]")
/* Alternative procedure with same result:
// select vehicle 10000
Text1.LinkExecute ("[KTYPNR(10000)]")
// set mode to 1
Text1.LinkExecute ("[SETMODE(1)]")
// activate TECDOC-CD
Text1.LinkExecute ("[ACTIVATE]")
*/
End Sub
With the function Text1_Change changed data of the hotlink can be reacted to.
Private Sub Text1_Change()
List1.AddItem (Text1.Text)
End Sub
Please note that the text may contain several data tables separated by line breaks if several data tables are
transferred at the same time.
Сссорири...
