dox42 Pilot Tooltips



Plaintext_topic Synonym Key Value
WebService Data Source WebServiceInputValues Input Values (Please enter values directly, or choose a Data Field by clicking the button in the List)
Bulk Letter GenerateDocForEachTipp Choose a Data Source to generate one document for each record in the Data Source. When clicking Generate you will be asked to configure save and printing options. This gives you a Bulk Letter!
Automate Range Conditions TTBtnAutomateRangeTipp Click here to make the current selection a dox42 automated range > Set a condition to show/hide the range > Repeat the range for each row in a Data Source > Link and save the selection as a text block
Data Map Designer TTBtnEditDMTipp Click here to link data from different Data Sources to your document. You can also set Input Parameters, build Dynamic Fields and set Bulk Letter configurations. All settings will be saved in the Data Map and linked to your document.
Document Generation TTBtnGenerateTipp Click here to generate the document.
Data Field Explorer TTBtnInsertDFTipp Click here to open the Data Field Explorer. This lets you insert Data Fields. All Data Sources, Input Parameters and Dynamic Fields you defined in your data map will appear here. When inserting a Data Field you may also set a format such as Number, Header, Datetime, etc.
Text Blocks BtnInsertTBTipp Choose a Text Block and insert it at the selected position. Text Blocks are saved as Word Documents!
Refresh Template TTBtnRefreshTemplate Click here to reload all linked text blocks and datafields in your document. Use this function, if you made any changes to your text block files or changed the color of datafields, or if you want to highlight invalid Data Fields.
Text Blocks BtnSaveTBTipp Save the current selection as Text Block. Text Blocks are saved as Word Documents!
Automate Range ErrorEndIconNotFound dox42 end-icon not found! Please be sure to end all automated ranges with an end-icon.
Link Data Map to Document AskFullOrRelativeDMPath Link Data Map with full path? Otherwise the Data Map will be opened from the same folder as the document. (This allows for copying document and Data Map to a different location.)
Dynamic Field ToolTipDynamicFieldCode Please enter your Visual Basic Code here. To return the field value asign it to 'result'. Samples: 1) result = orders.quantity * product.price 2) result = customer.firstName + " " + customer.Name 3) if customer.sex = "f" then result = "Miss" else result = "Mister" end if 4) result = getValue("DataSourceWithUglyFieldNames.field$")
Text Blocks TTBtnLinkTextBlockRange Saves your selected range in the current document as a separate word document. Choose path and name for the new text block document. Hint: You can set the standard path for your linked text blocks in the data map designer.
Automate Range TTConditionRange Enter a condition to insert or hide. Use Data Fields and logical operators to do so. Literals must be put in quotation marks. Example: student.sex = “female”
Insert URLs TTDataFieldDirUrlImage Enter the directory or web address of the image, pdf or Word file. Alternatively, enter a Data Field as > Input Parameter, containing the path e.g. <% MyDirectory %> > same directory as document template: <%DocPath%> > Data Field, that contains the directory or URL e.g. <%datasource.name%>
HTML File TTDataFieldDirUrlHTMLFile Enter the directory or web address of the HTML File. Alternatively, enter a Data Field as > Input Parameter, containing the path e.g. <% MyDirectory %> > same directory as document template: <%DocPath%> > Data Field, that contains the directory or URL e.g. <%datasource.name%>
Image Map TTDataFieldDirUrlImageMap Enter the value with the according image, separated by a semicolon. Example: value1=c:\pics\icon1.jpg; value2=c:\pics\icon2.jpg;
Type Datetime Format TTDataFieldTypeDateTime Format your Data Field as date or time
Type Header TTDataFieldTypeHeader Format the style of your Data Field by using Word header styles. This will also make it easy to insert a table of contents.
Type HTML File TTDataFieldTypeHtmlFile Insert the content of a html file.
Type Hyperlink TTDataFieldTypeHyperLink Insert a hyperlink. This will open the respective file or web page.
Type Image TTDataFieldTypeImage Insert an image or pdf file into your document.
Type Image Map TTDataFieldTypeImageMap You can display status information easily by using image files.
Type Number Format TTDataFieldTypeNumber Format your Data Field as a number
Type Datetime Format TTFormatStringDateTime Enter standard date and time format strings. e.g. dddd, dd/MM/yyyy HH:mm:ss
Type Header Format TTFormatStringHeader Insert a number between 1 and 9. This will specify the header level.
Type Impage TTFormatStringImage Set your desired size using pixel measurement. Syntax: width;height, e.g.: 30;50. If you specify only one dimension, the second value will be computed proportionally. You may use the keyword "max" to specify maximum values, e.g.: max 50; max 30. To rotate an image enter the angle as last parameter e.g.: 50;30;90.
Type Number Format TTFormatStringNumber Enter custom numeric format strings.
Data Field Explorer TTInsertDataField Opens the Data Field Explorer enter a Data Field or Input Parameter
Text Blocks TTLinkedTextBlockPath The path of the text block, if the automated range is linked. Hint: You may use <%DocPath%> for the directory of the current document template.
Text Blocks TTLinkTextBlock Link the content of a text block (=word document).
Automate Range Repeated Section, Dynamic Tables TTRepeatForDataSource Specifying a Data Source will repeat the range for each data record in this Data Source.
Data Field Explorer TTTreeViewDataFields Double click (or click OK) to insert or update the selected Data Field at the current position in your document.
Dynamic Column TTBtnDynamicTableColumn Click here to automate a column of a table. You may specify a condition to insert/hide the column.
Excel Data Source TTBtnExcelDSAddInit Initialising rules allow for writing data to the chosen Excel. Formulas and Charts will be updated accordingly. The Excel will not be saved, but you can import the results back to your document!
Excel Data Source TTBtnSelectDataRange Select Data Range to be used as output of this Data Source.
Excel Data Source TTChooseExcelFile Choose Excel File. You can use <%DocPath%> for the directory of the template.
Bulk Letter TTBtnBulkLetter Click here to define the selected Data Source as the basis for generating your bulk letter. One document will be created for each data record in this Data Source. Set the default location and name for your output documents here.
Database Data Source SQL Data Source TTBtnConnection To enable access to your existing data base, enter the connection string here. You can look up common connection strings under www.connectionstrings.com In file paths (e.g. MS Access DBs or Excel workbooks) you can use <%DocPath> for the directory of the template.
Database Data Source SQL Data Source TTBtnDBDataSource Click here to insert and configure a new Data Source using an existing database (e.g. Microsoft Access). All columns of the database will be available in the Data Field Explorer, from where you can insert them as Data Fields into your document.
Dynamic Field TTBtnDynamicColumn Click here to add Dynamic Fields to the selected Data Source. Dynamic Fields can perform calculations based on your Data Sources. Use Visual Basic for configuring your Dynamic Fields. All Dynamic Fields will be available in the Data Field Explorer, from where you can insert them as Data Fields into your document.
Excel Data Source TTBtnExcelDataSource Click here to insert and configure a new Data Source by selecting an existing Microsoft Excel workbook. You can also write data from other dox42 Data Sources to the workbook. Insert the calculation results and actualized charts in your document as Data Fields.
Bulk Letter TTBtnExplorerBulkLetter Enter the location to save your documents manually, or choose the path directly in the explorer.
Input Parameter TTBtnInput Click here to configure Input Parameters. dox42 will prompt them, when you generate your document. Define the value of the Input Parameter by inserting plain text or selecting from a list of defined values or from a Data Source. The Input Parameter will be available in the Data Field Explorer, from where you can insert it as a Data Field into your document.
Data Field Explorer TTBtnInsertDFBulkLetter Insert a Data Field from the Data Field Explorer in order to design an unambiguous name for your documents.
Data Field Explorer TTBtnInsertDFInQuery Look up and insert existing Data Fields into your query.
SharePoint Data Source TTBtnSharepointDS Click here to insert and configure a new Data Source for a Microsoft SharePoint list.
Text Blocks TTBtnTBDirectory Click here to set the standard location for linked text blocks. When you automate a range and want to save the range as a new text block, this will be the default location.
WebService Data Source TTBtnWsDataSource Click here to insert and configure a new Data Source using WebService.
Database Data Source SQL Data Source TTConnectionString To enable access to your existing data base, enter the connection string here. TIP: You can look up common connection strings under www.connectionstrings.com In file paths (e.g. MS Access DBs or Excel workbooks) you can use <%DocPath%> for the directory of the template.
Bulk Letter TTDocPathBulkLetter Using <%DocPath%> , you do not need to enter the whole path for the bulk letter documents. All documents will be saved relatively to this template document. e.g. <%DocPath%>\output\report_<%lastname%>.docx
Excel Data Source TTInitXLSExtendRange If checked, the Data Field values from all records of the Data Source will be inserted. Even if there are more records, than rows in the target range. The range will be extended. if not checked, only the target range will be filled, even if there are more records available than rows in the target range.
Excel Data Source TTInitXLSTargetRange Where do you want to insert data in the workbook?
Input Parameter TTInputParComment Set the information text that will be shown in the Input Parameter wizard. You can insert any text or explanation here.
Input Parameter TTInputParType Choose the input type of your parameter here. “Text” will allow entering plain text in the “Generate Document”-Wizard when generating the document. “Select from Values” will allow choosing from a list of values you define here. “Select from Data Source” will allow choosing from records of a Data Source.
Lookup TTLookUpLink A lookup link can target a document, a website or an application (e.g. MS Access DB ). The user can click the look up link when entering the Input Parameter.
Lookup TTLookUpLinkCaption Set the caption of the look up link that will be shown in the “Generate Document”-Wizard.
Dynamic Field TTNameDynamicField Choose a name for the Dynamic Field that will appear in the Data Field Explorer. You can insert it as a Data Field into your document from there.
Bulk Letter TTSaveBulkLetter Choose the location and name for saving the bulk letter documents. Also select the file format (e.g. .docx, .pdf, .html, .txt, .jpg, etc.).
Excel Data Source TTXLSColStopRead If checked, the Excel column will be inserted until the first empty cell is found. If not checked, exactly the data range will be inserted.
Excel Data Source FirstRowContainsColHeaders First Row of selected Range contains Column Names
Tutorials TTBtnSampleTemplates Sample templates will show you how to use dox42 efficiently. You can download these templates for free.
Excel Data Source ErrorLinkedRangeOverTable Linked Ranges covering more than one cell of a table are not supported
Culture TTCulture Set the culture for specific formatting, e.g.: en-US, de-CH, fr,... To transform the culture format, you may use e.g. "EN => DE" to transform from English Format to German. The currency symbol ($, Fr.) is suppressed if the culture is specified.
Type PDF Attachment TTDataFieldTypePDFAttachment The PDF File(s) from the Data Field will be attached at the end of the generated document - only for PDF output
Automate Range TTBtnAutoSelect Automatically Select Automated Ranges. When working with complex documents including very many Automated Ranges, unchecking this box may improve performance during design time.
Type Bookmark TTDataFieldTypeBookmark Insert a dynamic bookmark. The value of the Data Field will be the name of the bookmark.
Data Map Designer DatamapLockedPopUp Your Data Map is locked. You can still edit and generate the template
Entra ID Login Azure AD Login btnAADConnectTT Enter your Entra ID AppReg Information to access dox42 templates directly from SharePoint Online
Type PowerPoint TTDataFieldTypePowerPoint Insert PowerPoint Slides as Image into your document
Type Barcode Type QR Code TTDataFieldTypeBarcode Insert your Data Field as QR-Code or Barcode
Type PDF TTDataFieldTypePDF Insert a PDF File as Image into your document
SQL Data Source SqlCheckFailed Failed to retrieve the data: {0}
Data Map Designer DatamapChanged Data Map changed
Error Error Error
SQL Data Source StoredProcedures Stored Procedures
ErrGettingData Failed to retrieve data: {0}
Text Blocks PleaseSelectTB Please select your Text Block!
Data Map Designer QEditNewDataMap Edit new Data Map?
SQL Data Source Tables Tables
SQL Data Source ConfirmClear Are you sure you want to clear this query?
Data Map Designer NoDatamapLinked No Data Map linked
Data Map Designer LinkDatamap Link Data Map to Document
SQL Data Source ErrConnectionString Failed to build connection string: {0}
SQL Data Source ErrDataLinks Failed to create Data Links. Please check that oledb32.dll is properly installed and registered. (the usual location is c:\Program Files\Common Files\System\Ole DB\oledb32.dll).
SQL Data Source SqlCheckSucceeded The SQL syntax has been verified against the Data Source.
PleaseSelectRange Please select a Range
Word Data Source FilterWordDocxs Word Docs (.docx;*.doc)|*.docx;*.doc|All Files (*.*)|*.*
SaveDocuments Save Documents
BtnConfigurePrinting Configure Printing
dox42 Ribbon BtnEditDM Data Map
dox42 Ribbon BtnGenerate Generate
dox42 Ribbon BtnInsertDF Insert Data Field
Data Map Designer BtnInsertTB Insert Text Block
Data Map Designer BtnNewDm Create new Data Map
Excel Data Source BtnPickDir Explorer
Excel Data Source BtnPickXLS Pick Excel File
Preview Data BtnPreviewData Test
dox42 Ribbon BtnRefreshDS Refresh Data Sources
dox42 Ribbon BtnReloadTB Reload Text Blocks
Text Blocks BtnSaveTB Save Text Block
Document Generation BtnStart Start!
Document Generation Cancel Cancel
Input Parameter CaptionLookupLink Caption Lookup Link:
Input Parameter Comment Comment:
Document Generation Completed Completed!
Bulk Letter ConfigBatchForm Configure Bulk Letter Generation
Data Field Explorer DatafieldExplorer dox42 Data Fields
Error DataSourceError Data Source not found, please check your Data Map:
DefaultVal Default Value
Text Block DirectoryForm Define Text Block Directory
DirectoryName Directory Name:
Input Parameter EnterInputParForm Enter Input Parameter
File File
Culture FormatStringDateTime dddd, dd/MM/yyyy HH:mm:ss
Culture FormatStringNumber 0.00
Bulk Letter GenerateDocForEach Generate a Document for each row in the Data Source
Document Generation GeneratorStatus Generating your Document(s)...
Document Generation GeneratorStatusInsertData Inserting Data...
Document Generation GeneratorStatusStart Starting to generate...
Data Map Designer GroupData Data
Data Map Designer GroupDesign Design
Data Map Designer GroupGenerate Generate
Data Map Designer GrpPrint Print Documents
Data Map Designer GrpSave Save {0} Documents as
GrpSkript Skript
Input Parameter InputParForm Input Parameter
Input Parameter InputParName Input Parameter Name:
Input Parameter LookupLink Lookup Link:
NoPrintConfig no printing configured
SQL Data Source OLEDbDataSourceDia Database
Path Path:
PrintingTo Printing to:
Type Type:
Excel Data Source WorkSheet Work Sheet:
Excel Data Source XLSDataSourceForm Excel
Close Close
Data Map Designer DatamapCouldNotBeSaved Data Map could not be saved
Data Map Designer DataMapEditorForm Data Map Designer
Data Map Designer Delete Delete
Data Map Designer Down Down
Data Map Designer Edit Edit
Input Paramater EnterParam Please Enter Parametervalue
Data Map Designer FilterDM Data Maps (.dm)|*.dm|All Files (*.*)|*.*
InputParCaption Input Parameter
Message Message
Open Open..
Data Map Designer OpenDatamap Open Data Map
Data Map Designer Save Save
Data Map Designer SaveAs Save As..
Data Map Designer SaveChanges Save Changes?
Data Map Designer SaveDatamap Save Data Map
Data Map Designer Up Up
Excel Data Source FilterXLS Excel (.xlsx;*.xls)|*.xlsx;*.xls|All Files (*.*)|*.*
Text Block PickTextBlockDir Pick Text Block Directory
Text Block SaveTBDia Save Textblock
Automate Range BtnAutomateRange Automate Range
Text Block OpenTBDia Please select a Text Block!
Views Views:
Automate Range AutomateRegionForm dox42 Automate Range
Automate Range Between Between
Text Block BtnSaveAsTB Save as Text Block
Clear Clear
Automate Range Condition Condition
Directory Directory:
Filter EditFilterForm Edit Filter
ErrorGetValueDF Error getting Value of Data Field
Automate Range ErrorInCondition Error in Condition
Save GrpSaveAsTB Save
Automate Range InsertLogicOP Insert Logic Operator:
Automate Range InsertOp Insert Operator:
Automate Range IntervalCriteria Between Criteria
Text Block KeepLinked Keep Linked
Text Block LinkedTB Linked Textblock:
Automate Range RepeatWithDataSource Repeat for Data Source:
Text Block SelectDirectoryForm Select Text Block Directory
SingleValueCriteria Single Value Criteria
BtnTaskPane Designer
WebService Data Source WSDataSourceCaption WebService Data Source
WebService Data Source WSError Error calling WebService:
WebService Data Source WSDataSourceForm WebService
WebService Data Source HelpUrl https://help.dox42.com/
WebService Data Source WSDSPath Data Source Path
WebService Data Source WSInputDF Data Field
WebService Data Source WSInputPath Path
WebService Data Source WSInputType Type
WebService Data Source WSInputValue Value
WebService Data Source WSInputValues Input Values
WebService Data Source WSLoadService Initialise Service
WebService Data Source WSResult Result
WebService Data Source WSTestWithValues Test
WebService Data Source ExcWSInputTypeNotSupported WebService Parameter type not supported:
WebService Data Source GrpConnect Connect
New New
Taskpane Taskpane
dox42 Help Videohelp Video
WebService Data Source ErrorLoadWebSercice Unable to load Service
Text Block BtnLinkTB Link Text Block
Data Map Designer DataSources Data Sources
GrpEdit Edit
GrpInsert Insert
SharePoint Data Source SharepointDataSourceCaption SharePoint
SharePoint Data Source Lists Lists:
Automate Range TTBtnAutomateRangeTipp Click here to make the current selection a dox42 automated range. You can > set a condition to show/hide the range, > repeat the range for each row in a Data Source > link and save the selection as a text block.
Data Map Designer TTBtnEditDMTipp Link data from different sources to your document. You can also set Input Parameters, build Dynamic Fields and set bulk letter configurations. All settings will be saved in a data map and linked to your document.
Refresh Template TTBtnReloadTBTipp Click here to reload all linked text blocks in your document. Use this function, if you made any chances to your text block files.
EncloseInQuotes Enclose in Quotes
Error ErrorStartIconNotFound dox42 region-icon not found
Add-in Activation BtnActivate Activate
Add-in Activation TTBtnActivateSuperTipp Activate your dox42 Add-In. Click here to claim your free key or buy your unlimited key.
Add-in Activation BtnHelp Help
Add-in Activation BuyNowUrl https://secure.avangate.com/order/checkout.php?PRODS=4541651&QTY=1&CART=2&CURRENCY=EUR&LANG=de&LANGUAGES=de,en style=\"color: #000000\"
Add-in Activation MailToFreeKey mailto:info@dox42.com?subject=dox42 free program&body=Yes, I would like to profite from the dox42 free programm. Please send me my free-key!!
Bulk Letter ErrorBulkLetterDataSourceEmpty 0 rows in Data Source for generating Bulk Letter:
Text Blocks ErrorTBRecursivlyLinked Linked Text Block links to itself:
Data Map Designer ErrorDuplicateNameInDataMap Duplicate Name:
DataFieldFormatString Format String:
Error ErrorDSNotInDM This Data Source is not defined in your Data Map!
Error ErrorTBDirNotInDM This Text Block Directory is not defined in your Data Map!
StyleFormat Style:
DirectoryURL Directory/URL:
HeaderLevel Level [1-9]:
FolderBrowser Choose Directory
Data Map Designer OpenFile Choose File
Data Map Designer Import Import
Filter FilterConfig Config (.config)|*.config|All Files (*.*)|*.*
Custom Data Sources ImportCustomDS Choose import file for custom Data Source
GrpAutomate Automate
Data Map Designer LinkDMAbsolute Link absolute Path
Data Map Designer LinkDMSameDir Data Map and Document in same Directory
BtnBack Back
BtnNext Next
ErrChooseDS_KeyAndValueColumn Please choose a Data Source, a value field and a display text field!
InputType Input type:
InputTypeDataSource Select from Data Source
InputTypeText Text
InputTypeValues Select from Values
BulkLetter Bulk Letter
Error ErrDoubleBulkLetterConfig Duplicate Bulk Letter Configuration found!
Bulk Letter BulkLetterInfo Generate one document for each record in Data Source
DisplayText Display Text
Value Value
DataSource Data Source
Configure Configure
Dynamic Field DynamicField Dynamic Field
ErrDuplicateDynamicFieldName Duplicate Dynamic/Group Calculator Field Name
Bulk Letter BtnGenerateOnlyFirstDoc Generate only first Document
Type Image TTDataFieldDirUrlImage Enter the directory or web address of the image or pdf file. Alternatively, enter a Data Field as > Input Parameter, containing the path e.g. <% MyDirectory %> > same directory as document template: <%DocPath%> > Data Field, that contains the directory or URL e.g. <%datasource.name%>
Type Image TTFormatStringImage Set your desired size using pixel measurement. If you specify only one dimension, the second value will be computed proportionally.
Automate Range TTRepeatForDataSource Specifying a Data Source will repeat the range for each data record in this Data Source. You do not have to specify a Data Source.
Dynamic Column DynamicTableColumnForm dox42 Dynamic Table Column
Dynamic Column BtnDynamicTableColumn Dynamic Column
Dynamic Column TTBtnDynamicTableColumn Click here to automate the Column of a table. You may specify a condition to insert/hide the column.
Excel Data Source BtnAddInitializer Add Initialising Rule
Excel Data Source BtnSelectDataRange Data Range:
Excel Data Source ChartsFormWorksheet Charts from Worksheet:
Excel Data Source Data Data
Excel Data Source DataField Data Field
Excel Data Source ExtendRange Extend Range
Excel Data Source GrpInitXLS Initialise Excel Data
Excel Data Source grpOutputXLS Data Source Output
Excel Data Source ReadUntilCellEmpty Read until first empty cell
Excel Data Source TargetRange Target Range
SharePoint Data Source TTBtnSharepointDS Click here to insert and configure a new Data Source for a Microsoft SharePoint list.
Excel Data Source TTInitXLSDF The Data you want to insert
Excel Data Source TTInitXLSTargetRange Where do you want to insert data in the workbook? If you want to create a new worksheet, add the name of the worksheet here. e.g. Product!A4
Excel Data Source TTXLSCulture The culture of the Excel can be set using this optional field (e.g. en-US, fr-FR, de-DE, etc.).
Excel Data Source SelectXLSRange Select Range
Excel Data Source ErrLoadXLS Could not load Excel file
Error ErrorDuplicateDataField Duplicate Data Field Name!
Cloning btnClone Clone
Excel Data Source ErrImportXLSFile Problem when importing Excel workbook
Add-in Activation FreeKeyPage http://www.dox42.com/FreeKey.aspx
dox42 Help BtnSampleTemplates Sample Templates
Type Image Quality Quality
BtnRemove Remove
Document Generation InfoSaveAndGenerate The template document will be saved prior go generating!
Format String LinkDateTimeFormatStrings http://msdn.microsoft.com/en-us/library/az4se3k1(v=vs.100).aspx
Format String LinkNumberFormatStrings http://msdn.microsoft.com/en-us/library/0c899ak8(v=vs.100).aspx
Excel Data Source UseAsOutputSpreadSheet Use the initialised Excel as Output File (dox42 for Spreadsheets only)
Filter FilterField Filter Field
Filter FilterValue Filter Value
BtnCooseBinDatField Choose Data Field
Excel Data Source LoadXLSFromBinDataField Load Excel File from Data Field
TTBtnFilterSorter Click here to Filter and Sort your Data Sources
Fields Fields
XML/JSON Data Source TTBtnXMLDataSource Click here to insert a Data Source to read XML or JSON Data. You can work with XML, JSON-files, Strings, REST WebServices and OData.
Docgen Data Source TTBtnDocGenDataSource Click here to insert a Data Source for document generation. You can choose a template path and a desired format. The template must use the same Data Map as your master template. The Data Source provides the generated document in the desired format and Base 64 encoded. With this data source you can generate a document from another dox42 template based on this data map. You can then integrate this document into your main document. This is suitable, for example, for e-invoices to create a PDF Base 64 coded to integrate it into an XML.
XML/JSON Data Source TT_XMLComplexType Tick Complex Type if this element consists of severval fields. You can use complex types to read nested XML or JSON
XML/JSON Data Source TT_XMLElement Enter the name of type you like to read. Sample: Arthur Dent Element = customer
XML/JSON Data Source TT_XMLSource Enter a path or Url to a XML or JSON file, or choose a Data Field which contains a XML or JSON as text value
XML/JSON Data Source XMLDataSource XML/JSON
Docgen Data Source DocGenDataSource DocGen
XML/JSON Data Source XMLSource URL/XML/JSON:
InputTypeForm Form
BtnPickForm Pick HTML Form
Type HTML FilterHTML HTML (.htm;*.html)|*.htm;*.html|All Files (*.*)|*.*
Type HTML HTMLFilePath File path of a HTML form, e.g. <%DocPath%>>MyForm.html
Data Map Designer BtnUpload2SharePoint Save Data Map to SharePoint
CalculationField Calculation Field
FieldName Field Name
Function Function
Group Group
Group Calculator GroupCalculator Group Calculator
SharePoint Data Source Error_SharePointDS_loadingColumns Error loading Columns from SharePoint
Group Calculator TTBtnGroupCalculator Click here to add group calculation fields to the selected Data Source. You can perform calculations like SUM, AVG, MIN, MAX, COUNT based on your Data Sources. Also use a group calculator to add a row number to you Data Source. The functions START_GROUP and END_GROUP can be used to control header and footer rows in repeated sections using conditions. All group calculation fields will be available in the Data Field Explorer, from where you can insert them as Data Fields into your document.
SharePoint Data Source URLSharePointDataSource https://www.dox42.com/Resources?filter=.SharePoint
dox42 Help URLXLSDataSource https://www.dox42.com/Resources?filter=.tutorialvideo&search=%2Fexcel%2Fi
Word Data Source TTBtnWordDataSource Click here to read Content Controls from exisiting Word documents.
WordDataSource Word
WordPath Path/URL
OverwriteHeaderFooter Overwrite Header/Footer
Crypto Data Source MasterPassWordHint Please Enter Masterpassword with at least eight characters. Use numbers and special characters!
Crypto Data Source CryptoDataSource Crypto
Crypto Data Source TTBtnCryptoDataSource Click here to encrypt and store credentials (e.g. Password / ClientSecret) in your data map. You can also use this Data Source to decrypt encrypted values from other Data Sources.
Crypto Data Source TT_EncryptValue Encrypt a Password / ClientSecret and copy the encrypted value to a config file. Store the encrypted values in a XML or Excel Data Source and use the Crypto Data Source to decrypt them.
Culture CultureLable Culture
Field Field
Field Formatter FieldFormatterForm Field Formatter
Field Formatter TBtnFieldFormatter Click here to define a Number or Date/Time format of a Data Field.
Visualizer TTBtnVisualizer Click here to Customise/Adjust/Hide/Nest the appearance of a Data Source. You can add custom Labels here.
Visualizer Visualizer Visualiser
Visualizer CBShowInDataSourceExplorer Show the Data Source in the Data Field Explorer
Visualizer lblColorPicker Field Colour:
Visualizer lblCustomIcon Datasource Icon
Visualizer lblSetParentElement Set Parent Element:
Visualizer VisualizerForm Visualiser
Culture TTGroupCulture Set the culture for the calculation field, e.g.: en-US, de-CH, fr,... To set a culture that differs from the system culture, you may use e.g. "en-us" if the culture in the Data Source is English. The currency symbol ($, Fr.) is suppressed if the culture is specified.
SQL Data Source TTDataBaseProvider Choose between different database providers. Connection and query designer may not yet be supported!
Error ErrGettingDataHint Hint: If you are using Input Parameters, make sure they have a default value.
Error ErrGettingDataMatch Extra ) in query expression
Error ErrGettingDataLabel If you are using Input Parameters in your query, make sure they have default values.
Error FieldType Field Type
Error ContinueOnError Continue on Error
Excel Data Source TTCopyWorksheet Copies the content and format of a specific worksheet to the worksheet specified in the target range.
Excel Data Source ShiftRowsDown Shift rows down
Excel Data Source CopyWorksheet Copy Worksheet
Excel Data Source TTShiftRowsDown Shifts rows down if selected
Excel Data Source Version Add-In Version:
Excel Data Source Lookup Lookup
Lookup LookupFormlblCondition Condition:
Data Map Designer DatamapName DM Name:
Lookup LookupFormlblDatasoruce Lookup from:
Excel Data Source ChkWorksheetFromDataField Take Worksheet from Data Field
Data Field Explorer tsDox42LabelsEnabledOnText dox42 Labels Enabled
LookupFormlblField Field:
Data field Explorer tsDox42LabelsEnabledOffText dox42 Labels Disabled
RibbonPageHelp Help & Settings
dox42 Add-in Logging BtnShowLogs Show Logs
dox42 Add-in Logging NlogConfig NLog.config
dox42 Add-in Logging NlogConfigFile ${shortdate}.log
dox42 Add-in Logging NlogConfigLocation Location:
dox42 Add-in Logging BtnToggleLogsOn Logging Enabled
dox42 Add-in Logging BtnToggleLogsOff Logging Disabled
Entra ID Login URLAAD https://www.dox42.com/Resources?search=%2FAAD%2Fi
DialogFilterOnlyConfigFiles Config Files (*.config)|*.config
Entra ID Login AADDialogImportEvent Importing will overwrite existing entries. Do you want to proceed?
Entra ID Login AADDialogTitleExport Export Entra ID Config
AADDialogTitleImport Import Entra ID Config
barToggleRememberWindowSize Remember Window Size
Visualizer Visualizer_GridDisabled Blocked by the Data Source
Data Map Password Protection PasswordFormUnlock Unlock Data Map
Data Map Password Protection PasswordFormSetPW Set a Data Map Password
Data Map Password Protection DMPasswordWrongFeedback Wrong Password! Please try again!
Data Map Password Protection DMPasswordTooWeak Password is too weak
Data Map Password Protection DMPasswordDoesNotMatch Password does not match
WebService Data Source ConfirmInitWebserviceCaption When Initializing the defined Operation & Parameters will be lost
WebService Data Source ConfirmInitWebserviceTitle Confirm Initialization
colType Type
Lookup TTBtnLookUp Click here to Lookup Data from another Data Source. This can be used to increase performance when filtering Table Data
dox42 Add-in Logging TTBtnLogsLocation Click here to define the Location where your Log-Files will be stored.
Data Map Password Protection TTBtnProtectWithPassword Click here to protect the Data Map with a Password.
dox42 Add-in Logging TTBtnShowLogs Click here to open the File Explorer leading to the dox42 Log-Files.
dox42 Add-in Logging TTToggleSwitchLogging Click here to enable Logging.
Entra ID Login AADAddInConfigForm Entra ID Login for SharePoint Online Authentication
Entra ID Login lblLogInBehavior Log In Mode
Entra ID Login lblLoginHelp Use "Always Ask" if you are working with multiple tenants
Entra ID Login lblAADLibrary Preferred Entra ID Authentication Library
Entra ID Login btnImport Import List
Entra ID Login btnExport Export List
btnSearch Search
Data Map Link btnLinkDMtoSharepoint Enter the SharePoint Path and Data Map name here. e.g. https://test.sharepoint.com/Sites/dox42/DataMapName.dm
Data Map Link SharePointForm Upload Data Map to SharePoint
Input Parameter BtnIdSample JSON IDs Sample
GrpDataSource Data Source
Excel Data Source TargetCell Select Target Range
Excel Data Source TTTargetCell Select the target range directly in Excel
Excel Data Source TTValue Which Data do you want to insert?
Excel Data Source GrpInitXML Initialisation & Fields
XML/JSON Data Source lblInitialize Initialisation:
XML/JSON Data Source btnInitXML Init from XSD/XML/JSON/WSDL
Crypto Data Source GrpEncryptValue Encrypt Values
Crypto Data Source GrpDataSourceOutputAction Allowed Data Sources & Output Actions
Crypto Data Source MasterPassword Master Password:
Crypto Data Source BtnShow Show
Crypto Data Source TT_EncryptKey With the Encryption-Key you define the Salt which will be used while encrypting
Crypto Data Source lblClearText Clear Text:
Crypto Data Source lblEncryptedText Entypted Text:
Crypto Data Source BtnEncrypt Encrypt
Crypto Data Source BtnCopy Copy to Clipboard
Crypto Data Source colIncludeDataSource Include
Crypto Data Source BtnAddCustomDS Add Custom Output Action
Visualizer colDFVisible Show Data Field
Visualizer TTcolDFVisible When selected, the Data Field will be shown in the Data Field Explorer
grpPreview Preview
FileType FileType
Entra ID Login btnAADConnect Entra ID Login
lblColor Colour:
TTImageMapDirectoryUrl Values + Images
Data Map Password Protection barBtnResetPassword Change Data Map Password
Data Map Password Protection barToggleSwitchItemProtectWithPassword Protect Data Map with Password
Data Map Password Protection lblEnterDmPw Please enter a Data Map Password
Data Map Password Protection lblPassword Password:
Data Map Password Protection lblRepeatPw Repeat:
Data Map Password Protection lblWarningPassword Attention! Your data map will be permanently locked if you forget your password!
Data Map Password Protection cbAcceptedWarning I confirm that I noted down my password
SpecialFormat Special Format
lblPickTemplate Pick Template
lblTemplatePath Template Path:
Data Map Password Protection DataMapDesignerProtectionTxt Data Map Protection
DataMapDesignerSupportTxt Support
DataMapDesignerHelpTxt Help
DataMapDesignerSettingsTxt Settings
DataMapDesignerCaptionName Data Map Designer
Data Map Password Protection lblWarningReload After setting up Data Map protection, please save and close the Data Map Designer. When you reopen the Data Map, it will be encrypted.
PowerPoint
BtnPreviewData Preview Data
Rferesh Template BtnReloadTB Refresh Template
Bulk Letter GenerateDocForEach Generate a Document for each row in the Data Source
SQL Data Source OLEDbDataSourceDia Database Data Source
Excel Data Source XLSDataSourceForm Excel Data Source
PowerPoint Automate Range BtnAutomateRange Control Slides
Views Views
PowerPoint Automate Range AutomateRegionForm dox42 Slide Controller
WebService Data Source WSDataSourceForm WebService Data Source
WebService Data Source WSInputValues Input Values (Please enter values directly, or choose a Data Field by clicking the button in the List)
WebService Data Source WSLoadService Initialize Service
SharePoint Data Source SharepointDataSourceCaption Sharepoint Data Source
Lists Lists
PowerPoint Automate Range TTBtnAutomateRangeTipp Click here to control the slides in the presentation. Set a condition to show/hide slides. Repeat slides for each row in a Data Source.
PowerPoint Automate Range TTBtnEditDMTipp Click here to link data from different Data Sources to your presentation. You can also set Input Parameters, build Dynamic Fields and set Bulk Letter configurations. All settings will be saved in the Data Map and linked to your presentation.
PowerPoint Automate Range TTBtnReloadTBTipp Click here to reload all linked text blocks in your presentation. Use this function, if you made any changes to your Data Fields, Control Slides or Linked Text Blocks
Add-in Activation TTBtnActivateSuperTipp Click here to activate your dox42 Add-In.
dox42 help BtnHelp Tutorials
Error Bulk Letter ErrDoubleBulkLetterConfig Dublicate Bulk Letter Configuration found!
Dynamic Field ErrDuplicateDynamicFieldName Duplicate Dynamic Field Name
BtnSelectDataRange Data Range
Excel Data Source GrpInitXLS Initialize Excel Data
Document Generation InfoSaveAndGenerate The template will be saved before generating!
Type RTF TTDataFieldTypeRTF Insert RTF Text
Type Worddoc TTDataFieldTypeWordDoc Insert a MS Word document
Type HTML TTDataFieldTypeHTML Insert HTML text
dox42 help Welcome2dox42 Welcome to dox42
dox42 help TTBtnHelp Watch videos and try sample templates to see how to automate documents with dox42!
dox42 help Welcome2dox4 Welcome 2 dox42
Culture TTCulture Set the culture for specific formatting, e.g.: en-US, de-CH, fr,... The currency symbol ($, Fr.) is suppressed if the culture is specified.
PowerPoint Automate Range NumberOfSlidesControlled Number of Slides controlled
dox42 Help LetsGoTitle dox42 Tutorials
GrpValidate Validate
PowerPoint Loop Table Rows LoopTableRows Loop Table Rows
PowerPoint Type UseHeaderFromTemplate Template Header/Footer
PowerPoint Type TTDataFieldTypePowerPoint Insert PowerPoint Slides into your presentation
PowerPoint Image Row TTFormatRowImage Define which row from the Data Source you want to insert
PowerPoint Loop Textbox LoopTextBox Loop within Textbox
PowerPoint Remove Shape if empty RemoveIfEmpty Remove if Data Field empty
Excel
Excel Data Map Designer TTBtnEditDMTipp Click here to link data from different Data Sources to your spread sheet. You can also set Input Parameters, build Dynamic Fields and set Bulk Letter configurations. All settings will be saved in the Data Map and linked to your spread sheet.
Excel Generate Document TTBtnGenerateTipp Click here to generate the spread sheet.
Data Field Explorer TTBtnInsertDFTipp Click here to open the Data Field Explorer. This lets you insert Data Fields. All Data Sources, input parameters and Dynamic Fields you defined in your data map will appear here. When inserting a Data Field you may also set a format such as Number, Header, Datetime, etc.
Type Image TTDataFieldDirUrlImage Enter the directory or web address of the image or pdf file. Alternatively, enter a Data Field as > input parameter, containing the path e.g. <% MyDirectory %> > same directory as document template: <%DocPath%> > Data Field, that contains the directory or URL e.g. <%datasource.name%>
Data Field Explorer TTInsertDataField Opens the Data Field Explorer enter a Data Field or input parameter
Input Parameter TTBtnInput Click here to configure input parameters. dox42 will prompt them, when you generate your document. Define the value of the input parameter by inserting plain text or selecting from a list of defined values or from a Data Source. The input parameter will be available in the Data Field Explorer, from where you can insert it as a Data Field into your document.
Input Parameter TTInputParComment Set the information text that will be shown in the input parameter wizard. You can insert any text or explanation here.
Input Parameter TTLookUpLink A lookup link can target a document, a website or an application (e.g. MS Access DB ). The user can click the look up link when entering the input parameter.
dox42 Help TTBtnHelp Watch videos and try sample templates to see how to automate documents with dox42!
DataDesigner