{"type":"doc","content":[{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"91dc67f2-62db-4873-a53b-558103f12881"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"a55ec86e-0baf-498b-bb68-4ebdae19ecaa"}},{"type":"rule"},{"type":"paragraph","content":[{"text":"With this standardized format, mappings can be configured consistently throughout primedocs.","type":"text"}]},{"type":"paragraph","content":[{"text":"Examples:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n \n \n \n \n\n \n fname\n First name\n \n \n Jane\n Firstname\n \n \n Doe\n LastName\n \n \n \n \n 25*78\n Calculator\n \n \n","type":"text"}]},{"type":"rule"},{"type":"heading","attrs":{"level":1},"content":[{"text":"JavaScript","type":"text"}]},{"type":"paragraph","content":[{"text":"You can make a mapping with simple declarative statements or map a more complex logic via JavaScript. You can find a more detailed introduction on the ","type":"text"},{"text":"JavaScript page","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/PDTEN/pages/61410844"}}]},{"text":".","type":"text"}]},{"type":"rule"},{"type":"heading","attrs":{"level":1},"content":[{"text":"Properties as elements or attributes","type":"text"}]},{"type":"paragraph","content":[{"text":"All of the following element properties can be set both as an attribute and as an element according to the following pattern.","type":"text"}]},{"type":"paragraph","content":[{"text":"As attribute:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"javascript"},"content":[{"text":"\n further element content\n","type":"text"}]},{"type":"paragraph","content":[{"text":"As element:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"javascript"},"content":[{"text":"\n AttributeContent\n further element content\n","type":"text"}]},{"type":"paragraph","content":[{"text":"For the ","type":"text"},{"text":"If","type":"text","marks":[{"type":"code"}]},{"text":" element with ","type":"text"},{"text":"Condition","type":"text","marks":[{"type":"code"}]},{"text":" property, the following two configurations have exactly the same meaning:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"javascript"},"content":[{"text":"\n ...\n","type":"text"}]},{"type":"codeBlock","attrs":{"language":"javascript"},"content":[{"text":" \n source('LastName') === 'Doe' \n ... \n","type":"text"}]},{"type":"rule"},{"type":"heading","attrs":{"level":1},"content":[{"text":"Map element","type":"text"}]},{"type":"paragraph","content":[{"text":"A map element represents a single mapping operation. Exactly one source property and the target must be set.","type":"text"}]},{"type":"table","attrs":{"layout":"default","localId":"4df747fe-7869-42f2-a0c1-1e559d3c2a09"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[140.0]},"content":[{"type":"paragraph","content":[{"text":"Property","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[620.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[140.0]},"content":[{"type":"paragraph","content":[{"text":"Source","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[620.0]},"content":[{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In the default case: the name identifying the value, e.g. the column name of the database in the Generic SQL Provider.","type":"text"}]}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"For XML data source: see ","type":"text"},{"text":"XML","type":"text","marks":[{"type":"link","attrs":{"href":"#XML"}}]}]}]}]},{"type":"paragraph","content":[{"text":"If the value is not found,","type":"text"},{"text":"null","type":"text","marks":[{"type":"code"}]},{"text":"is passed.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[140.0]},"content":[{"type":"paragraph","content":[{"text":"SourceValue","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[620.0]},"content":[{"type":"paragraph","content":[{"text":"A constant value to be used.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[140.0]},"content":[{"type":"paragraph","content":[{"text":"SourceExpression","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[620.0]},"content":[{"type":"paragraph","content":[{"text":"A primedocs JavaScript expression that is evaluated.","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[140.0]},"content":[{"type":"paragraph","content":[{"text":"Target","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[620.0]},"content":[{"type":"paragraph","content":[{"text":"The target property for the mapping. The possible target fields in ","type":"text"},{"text":"Address providers","type":"text","marks":[{"type":"strong"}]},{"text":" are documented in ","type":"text"},{"text":"Standard contact mapping","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/PDTEN/pages/61408065"}}]},{"text":".","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[140.0]},"content":[{"type":"paragraph","content":[{"text":"When","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[620.0]},"content":[{"type":"paragraph","content":[{"text":"A primedocs JavaScript expression that allows the mapping to be executed conditionally.","type":"text"},{"type":"hardBreak"},{"text":"If the value evaluates to true, the mapping is executed.","type":"text"}]}]}]}]},{"type":"rule"},{"type":"heading","attrs":{"level":1},"content":[{"text":"If element","type":"text"}]},{"type":"paragraph","content":[{"text":"The If element allows the definition of conditions for whole blocks of mappings. If blocks can be combined and nested in any way.","type":"text"}]},{"type":"table","attrs":{"layout":"default","localId":"51975cf8-c3b8-4960-a9ed-7b1fb877c1bf"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[113.0]},"content":[{"type":"paragraph","content":[{"text":"Property","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[647.0]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[113.0]},"content":[{"type":"paragraph","content":[{"text":"Condition","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[647.0]},"content":[{"type":"paragraph","content":[{"text":"JavaScript condition – result is checked for ","type":"text"},{"text":"truthy","type":"text","marks":[{"type":"link","attrs":{"href":"https://developer.mozilla.org/en-US/docs/Glossary/Truthy"}}]},{"text":" value.","type":"text"}]}]}]}]},{"type":"rule"},{"type":"heading","attrs":{"level":1},"content":[{"text":"Conditions & Expressions","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Escaping","type":"text"}]},{"type":"paragraph","content":[{"text":"In XML, certain characters like & or < have a special designation. Therefore, these cannot be used directly. Mask them: ","type":"text"},{"text":"&","type":"text","marks":[{"type":"code"}]},{"text":" can be written as ","type":"text"},{"text":"&","type":"text","marks":[{"type":"code"}]},{"text":":","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n \n","type":"text"}]},{"type":"paragraph","content":[{"text":"Alternatively, the same can be done using ","type":"text"},{"text":"CDATA","type":"text","marks":[{"type":"code"}]},{"text":" and element notation:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n \n \n \n","type":"text"}]},{"type":"rule"},{"type":"heading","attrs":{"level":2},"content":[{"text":"Source","type":"text"}]},{"type":"paragraph","content":[{"text":"Using the ","type":"text"},{"text":"source","type":"text","marks":[{"type":"code"}]},{"text":" API object, the source values can be accessed from JavaScript analogously to the source property of the map element. If the value is not available, ","type":"text"},{"text":"undefined","type":"text","marks":[{"type":"code"}]},{"text":" is returned. The following example takes the last available phone number:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n \n \n","type":"text"}]},{"type":"paragraph","content":[{"text":"For compatibility, the ","type":"text"},{"text":"source","type":"text","marks":[{"type":"code"}]},{"text":" API object can also be accessed using ","type":"text"},{"text":"oo","type":"text","marks":[{"type":"code"}]},{"text":" or ","type":"text"},{"text":"OO","type":"text","marks":[{"type":"code"}]},{"text":".","type":"text"}]},{"type":"rule"},{"type":"heading","attrs":{"level":2},"content":[{"text":"Target","type":"text"}]},{"type":"paragraph","content":[{"text":"Using the ","type":"text"},{"text":"target","type":"text","marks":[{"type":"code"}]},{"text":" API object, previously mapped values can be accessed from the JavaScript. If the value is not available, ","type":"text"},{"text":"undefined","type":"text","marks":[{"type":"code"}]},{"text":" is returned. The following example assembles an address:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n \n \n","type":"text"}]},{"type":"paragraph","content":[{"text":"The result is as follows:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"none"},"content":[{"text":"Source\n----------\nstreet Test street\nhouseNr 42\nZipPlace 424242 Testburg\n\nResult\n----------\nStreet Test street 42\nCompleteAddress Test street 42\n 424242 Testburg","type":"text"}]},{"type":"rule"},{"type":"heading","attrs":{"level":2},"content":[{"text":"Main function","type":"text"}]},{"type":"paragraph","content":[{"text":"To execute more complex JavaScript methods, the function ","type":"text"},{"text":"main()","type":"text","marks":[{"type":"code"}]},{"text":" can be defined and then called.","type":"text"}]},{"type":"paragraph","content":[{"text":"The following example adapts a Swiss phone number to the international format:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"javascript"},"content":[{"text":"\n \n \n function main()\n {\n // normalizes all phone numbers\n // 0715110500 => +41 71 511 05 00\n // +41 71 511 05 00 => +41 71 511 05 00\n var input = source('phonenumber').replace(/ /g, '');\n var patt = /((\\+|00)41|0)([0-9]+)/;\n var matchArray = patt.exec(input);\n var number = matchArray[3];\n return \"+41 \" + number.substring(0,2) + \" \" + number.substring(2,5)\n + \" \" + number.substring(5,7)+ \" \" + number.substring(7,9);\n }\n \n \n","type":"text"}]},{"type":"rule"},{"type":"heading","attrs":{"level":2},"content":[{"text":"StartsWith function","type":"text"}]},{"type":"paragraph","content":[{"text":"Often in mappings you want to check if a text starts with certain characters, e.g. if the text in \"ZIP_Code\" (postal code) starts with \"CH-\".","type":"text"}]},{"type":"paragraph","content":[{"text":"Unfortunately, the JavaScript ","type":"text"},{"text":"startsWith","type":"text","marks":[{"type":"code"}]},{"text":" function does not yet exist in ES5.","type":"text"},{"type":"hardBreak"},{"text":"The expression ","type":"text"},{"text":"source('ZIP_Code').startsWith('CH-')","type":"text","marks":[{"type":"code"}]},{"text":" can thus ","type":"text"},{"text":"not (!)","type":"text","marks":[{"type":"strong"}]},{"text":" be evaluated.","type":"text"}]},{"type":"paragraph","content":[{"text":"Working alternative:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"javascript"},"content":[{"text":"source('ZIP_Code').indexOf('CH-') === 0","type":"text"}]},{"type":"rule"},{"type":"heading","attrs":{"level":2},"content":[{"text":"Notes","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In JavaScript, conditions are checked for a ","type":"text"},{"text":"truthy","type":"text","marks":[{"type":"link","attrs":{"href":"https://developer.mozilla.org/en-US/docs/Glossary/Truthy"}}]},{"text":" value. This means that non-boolean (true or false) values can also be evaluated. For example, positive numbers or non-empty strings are also evaluated as true.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"JavaScript can distinguish between ","type":"text"},{"text":"null","type":"text","marks":[{"type":"code"}]},{"text":" and ","type":"text"},{"text":"undefined","type":"text","marks":[{"type":"code"}]},{"text":". Note, that e.g., if a value is not available the ","type":"text"},{"text":"source","type":"text","marks":[{"type":"code"}]},{"text":" property of the ","type":"text"},{"text":"map","type":"text","marks":[{"type":"code"}]},{"text":" element returns ","type":"text"},{"text":"null","type":"text","marks":[{"type":"code"}]},{"text":" while the ","type":"text"},{"text":"source","type":"text","marks":[{"type":"code"}]},{"text":" API object returns ","type":"text"},{"text":"undefined","type":"text","marks":[{"type":"code"}]},{"text":".","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Comparisons: The ","type":"text"},{"text":"==","type":"text","marks":[{"type":"code"}]},{"text":" operator can also be used to compare different data types, e.g. ","type":"text"},{"text":"'55' == 55","type":"text","marks":[{"type":"code"}]},{"text":" evaluates to true. Practical tip: since ","type":"text"},{"text":"undefined == null","type":"text","marks":[{"type":"code"}]},{"text":" also evaluates to true, ","type":"text"},{"text":"source('name') == null","type":"text","marks":[{"type":"code"}]},{"text":" can be used to check for both empty (","type":"text"},{"text":"null","type":"text","marks":[{"type":"code"}]},{"text":") and unavailable (","type":"text"},{"text":"undefined","type":"text","marks":[{"type":"code"}]},{"text":") values. For more on comparing with JavaScript, see ","type":"text"},{"text":"here","type":"text","marks":[{"type":"link","attrs":{"href":"https://developer.mozilla.org/en-US/docs/Web/JavaScript/Equality_comparisons_and_sameness"}}]},{"text":".","type":"text"}]}]}]},{"type":"rule"},{"type":"heading","attrs":{"level":1},"content":[{"text":"Mapping data source","type":"text"}]},{"type":"paragraph","content":[{"text":"Depending on the data source, the access to the data is different, i.e. how the source value is passed in the ","type":"text"},{"text":"source","type":"text","marks":[{"type":"code"}]},{"text":" attribute or in the JavaScript of the ","type":"text"},{"text":"source()","type":"text","marks":[{"type":"code"}]},{"text":" function. There are the following sources:","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Default: key/value","type":"text"}]},{"type":"paragraph","content":[{"text":"Simple keys are specified – a direct mapping exists. Examples:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Column name for SQL Address provider","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Column name or column number for CSV/XLSX Address Provider","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"XML","type":"text"}]},{"type":"paragraph","content":[{"text":"For XML sources, an ","type":"text"},{"text":"XPath","type":"text","marks":[{"type":"link","attrs":{"href":"https://en.wikipedia.org/wiki/XPath"}}]},{"text":" (1.0) can be specified to identify the value.","type":"text"}]},{"type":"paragraph","content":[{"text":"The following returns are made:","type":"text"}]},{"type":"table","attrs":{"layout":"default","localId":"43bed5c3-9d0b-46ee-a421-de3a06292044"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[174.0]},"content":[{"type":"paragraph","content":[{"text":"Result of XPath","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[586.0]},"content":[{"type":"paragraph","content":[{"text":"Returned value","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[174.0]},"content":[{"type":"paragraph","content":[{"text":"Attribut","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[586.0]},"content":[{"type":"paragraph","content":[{"text":"Value of the attribute","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[174.0]},"content":[{"type":"paragraph","content":[{"text":"Element","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[586.0]},"content":[{"type":"paragraph","content":[{"text":"Content/value of the element","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[174.0]},"content":[{"type":"paragraph","content":[{"text":"Text","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[586.0]},"content":[{"type":"paragraph","content":[{"text":"The text","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[174.0]},"content":[{"type":"paragraph","content":[{"text":"CData","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[586.0]},"content":[{"type":"paragraph","content":[{"text":"If the result is wrapped in CData, it will be returned ","type":"text"},{"text":"without","type":"text","marks":[{"type":"em"}]},{"text":" the CData tag.","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"text":"Example","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"XML source file","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n PrimeSoft AG\n

\n 8360\n Eschlikon\n Bahnhofstrasse 4\n

\n \n \n \n \n","type":"text"}]},{"type":"paragraph","content":[{"text":"Mapping","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n \n \n \n \n \n source('//Company') + '\\r\\n' + source('//Street') + '\\r\\n' + source('//PLZ') + ' ' + source('//City')\n \n \n \n","type":"text"}]},{"type":"paragraph","content":[{"text":"Result","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","attrs":{"language":"none"},"content":[{"text":"Zip: 8360\nCity: Eschlikon\nStreet: Bahnhofstrasse 4\nCompleteAdresse: PrimeSoft AG\n Bahnhofstrasse 4\n 8360 Eschlikon\nPhone: +41 71 511 0 500","type":"text"}]},{"type":"rule"},{"type":"heading","attrs":{"level":1},"content":[{"text":"Examples","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"If-Else","type":"text"}]},{"type":"paragraph","content":[{"text":"In the current version there is no Else section. For larger sections the condition can be negated:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n \n \n \n \n \n \n","type":"text"}]},{"type":"paragraph","content":[{"text":"To select a value from available elements, multiple map elements with the same target can be used:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n \n \n \n","type":"text"}]},{"type":"paragraph","content":[{"text":"Note the order","type":"text","marks":[{"type":"strong"}]},{"text":": the map elements are evaluated in order, i.e. the last number present is used.","type":"text"}]},{"type":"paragraph","content":[{"text":"Alternatively, a JavaScript expression can be used:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"javascript"},"content":[{"text":"\n \n \n function main()\n {\n if (source('Mobile') != null)\n {\n return source('Mobile');\n }\n else if (source('Office') != null)\n {\n return source('Mobile');\n }\n else\n {\n return source('Private');\n }\n }\n \n \n","type":"text"}]},{"type":"paragraph"}],"version":1}

Browser not supported