Differences

This shows you the differences between two versions of the page.

--- en:infra-convert:add-in:customize [2016/08/12 11:06]
mw created
+++ en:infra-convert:add-in:customize [2019/09/06 11:12]
me
@@ Line 1: / Line 1: @@
-====== Create and integrate your own templates ======
+~~NOTOC~~
+<WRAP noprint>
+> Excel Report Add-In
+</WRAP>
+====== Create and integrate templates ======
+----
 All files you need to embed your own templates into the Excel Add-In can be found at:
   %ProgramData%\ELIAS GmbH\ELIASExcelReport
+<WRAP noprint>
+<WRAP group>
+<WRAP column 30%>
+//**__Inhalt__**//
+ • [[en:infra-convert:add-in:customize#Structure of the Excel templates]]\\
+ • [[en:infra-convert:add-in:customize#Specific features of our templates]]\\
+ • [[en:infra-convert:add-in:customize#Integrate your template into Excel]]\\
+ • [[en:infra-convert:add-in:customize#The template "---"]]
+\\
+</WRAP>
+</WRAP>
+</WRAP>
 ===== Structure of the Excel templates =====
@@ Line 40: / Line 67: @@
 <WRAP alert 750px>Due to the complexity of the data sheet we strongly recommend not to change it! If you add columns to the data sheet you have to adjust the cells which evaluate the measurement data!</WRAP>
+===== Integrate your template into Excel =====
+You need an Excel template file, if you wish to integrate it into our Report Add-In. This file has to be added into the [[de:infra-convert:add-in:reportlist|ReportList.xml]] file.
+This file contains all templates, which can be selected inside the Add-In. The order of the entries decides the list order inside the Report Add-In.
+Each entry starts with <Reports> and end with </Reports>. Copy such a block and insert it above the </XMLSchemaReportList> entry to integrate your own template. The fields of the new entry have to be adjusted (see below). <wrap important>Important fields</wrap> are marked. This file is a XML database, so every field starts with a "< >" and ends with a "</ >".
+^ Field name       ^ Meaning                                                  ^
+| Reports   | Every template starts with this entry. The following fields define the functions of the Add-In (see bellow). At the end of the definition block this entry must be closed.  |
+| ID   | The <wrap important>identification number</wrap> of the entry. The identification numbers have to be in sequence. The first entry has to be "0000". If the sequence is broken ("0002" before "0001") the Add-In won't work!   |
+| Name   | The <wrap important>name</wrap> under which this template is listed in the Add-In.   |
+| Path | The <wrap important>complete file path</wrap> of the template. The path [CommonApplicationData] is equal to the windows variable %ProgramData%. |
+| TableName | The name of the table or work sheet where the data is imported to. |
+| FirstRow | The number of the first row to be filled. |
+| ColID | The column which will be filled with the internal identification number of infra-CONVERT for the feature. \\ "-1" means: Don't use. |
+| ColAttributType | The column which will be filled with the attribute type of the feature.\\ "-1" means: Don't use. |
+| ColClass | The column which will be filled with the feature class.\\ "-1" means: Don't use. |
+| ColLabel | The column which will be filled with the feature description.\\ "-1" means: Don't use. |
+| ColText | The column which will be filled with feature text.\\ "-1" means: Don't use. |
+| ColValue | The column which will be filled with the nominal value of the feature.\\ "-1" means: Don't use. |
+| ColToleranceHigh | The column which will be filled with the upper tolerance of the feature.\\ "-1" means: Don't use. |
+| ColToleranceLow | The column which will be filled with the lower tolerance of the feature.\\ "-1" means: Don't use. |
+| ColPassung | The column which will be filled with the fit (e.g. H7) of the feature.\\ "-1" means: Don't use. |
+| ColStampText | The column which will be filled with the stamp text of the feature.\\ "-1" means: Don't use. |
+| ColGraphicFile | The column which will be filled with the complete path and file name of the graphic file of the feature.\\ "-1" means: Don't use. |
+| ColComment | The column which will be filled with the comment of the feature.\\ "-1" means: Don't use. |
+| ColToleranceTable | The column which will be filled with the tolerance table of the feature.\\ "-1" means: Don't use. |
+| ColDrawingQuadrant | The column which will be filled with the drawing quadrant of the feature.\\ "-1" means: Don't use. |
+| ColPositionX | The column which will be filled with X-position of the stamp.\\ "-1" means: Don't use. |
+| ColPositionY | The column which will be filled with Y-position of the stamp.\\ "-1" means: Don't use. |
+| ColDestinationPositionX | The column which will be filled with the X-position of the stamps target point.\\ "-1" means: Don't use. |
+| ColDestinationPositionY | The column which will be filled with the Y-position of the stamps target point.\\ "-1" means: Don't use. |
+| ColDiameterStamp | The column which will be filled with the radius of the stamp.\\ "-1" means: Don't use. |
+| ColAttributFeatureTypeText | The column which will be filled with feature type as a text.\\ "-1" means: Don't use. |
+| ColAttributFeatureType | The column which will be filled with the feature type as a number.\\ "-1" means: Don't use. |
+| StartMakro | The name of the macro which should be startet after the import.\\ The entry "" means: Don't start a macro. |
+| FormatFileName | The complete file path to the format file for the import. |
+| InfraConvertSettingFile | The complete path to the infra-CONVERT settings file. If you start infra-CONVERT from within the Add-In another settings file is used then the standard |
+Details for the feature property can be found at [[http://www.elias-gmbh.de/wiki/doku.php?id=en:ic:interface:interface#prf_format|Interfaces]]
+===== The template "---" =====
+The template "---" will be installed by default. This isn't a real template. It's used to import all data of the inspection plan to the table1 of the Excel worksheet. You can do it also by opening an infra-CONVERT CSV file in Excel.
+<WRAP noprint>
+----
+<WRAP group>
+<WRAP col2>
+<WRAP rightalign>
+**Go to previous page**\\
+Excel Report Add-in > [[en:infra-convert:add-in:use|Operation]]
+</WRAP>
+\\
+</WRAP>
+</WRAP>
+</WRAP>

ELIAS GmbHProduktdokumentationen

User Tools

Site Tools

Differences

Page Tools

ELIAS GmbH
Produktdokumentationen