Abacus MYCOMPANY

{"type":"doc","content":[{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"eb36e6e9-ba5b-41e2-b013-3f9d1663b0ec"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"adb50710-2974-4fb7-9ec8-fdd4c101272a"}},{"type":"rule"},{"type":"paragraph","content":[{"text":"Abacus can be accessed either via a WebService or directly on the database. Using the indices does not provide the optimal results in all use cases. We recommend to realize the search via ","type":"text"},{"text":"Generic SQL","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/PDTEN/pages/61409919"}}]},{"text":".","type":"text"}]},{"type":"rule"},{"type":"heading","attrs":{"level":1},"content":[{"text":"abaconnect 2014","type":"text"}]},{"type":"paragraph","content":[{"text":"Calls the Abacus Webservices interface ","type":"text"},{"text":"http://www.abacus.ch/abaconnect/2007.10","type":"text","marks":[{"type":"link","attrs":{"href":"http://www.abacus.ch/abaconnect/2007.10"}}]},{"text":". Via the abaconnect interface, address data can be retrieved via indices. In OneOffixx the number of indices and the query can be configured. However, it must be ensured that the same indices are also available in Abacus. Otherwise the query will fail.","type":"text"}]},{"type":"paragraph","content":[{"text":"abaconnect requests all fields. For example, if the name is omitted in index 4, all entries starting from AAAA are returned.","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"marks":[{"type":"breakout","attrs":{"mode":"wide"}}],"content":[{"text":"\n http://[server]:[port]/abaconnect/services/Address_[version]_00\n 2014\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n","type":"text"}]},{"type":"rule"},{"type":"heading","attrs":{"level":1},"content":[{"text":"Generic SQL Provider","type":"text"}]},{"type":"paragraph","content":[{"text":"The ","type":"text"},{"text":"Generic SQL Provider","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/PDTEN/pages/61409919"}}]},{"text":" tries to detect if the address is private or business based on the first name.","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"marks":[{"type":"breakout","attrs":{"mode":"wide"}}],"content":[{"text":"\n Abacus MYCOMPANY\n \n iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAIAAACQkWg2AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAAZdEVYdFNvZnR3YXJlAHBhaW50Lm5ldCA0LjAuMTM0A1t6AAABtUlEQVQ4T5WRyy8DURSH/SF2SKzZW4tYsWKBsCHCwo6QiDTEwkIEoZHYoBHSaGhQ8SyCKtIgrXaqqq3SmU7n0bnzuuNULzoiEt9q7r2/7+ScM0XGP/lFSE86QqXNOIvI2YxZ0HTe7hZdl8y4PT2zLt8/kfsCTIIuomhNH+841V5ZqryVGVuFG/L2ybeArkMpywJ0ImxfPtcNqjGanXU+VnbirEwSHxABbrVUBl0F5duIEowLG2fClkd0eenR5czirux/zscAImTmt5SHGMyQaBuTzv1YkqO1/bz9WEtxVFlLyrKoc9l8Midwtn0DYzVOs3NOrGrIF34bmMciEne88cZh9emVndsMV3RAC0RQH5MwJVSFD4VKQAKakTwB5A2yVqfgPOeW9pJdE1CCCABr3dBZEStqvGUUXVOwnEhVT25dNBcqaYJl5GMAEQA5EEtPOwxdzx76kt1TOsNztoNodS/MpgsSCRUK0JWw6ZHvItKFH342DMCvusGEqUjig28BgErhinZu+VBj+GBxAz2yRB4KMAmA9sLwK0ex+iF0Q32tspCfAsCvnURr+jFSyNnML8JfGMY7nTO7bRIF1AcAAAAASUVORK5CYII=\n Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog={DataSource};Data Source={DB};\n System.Data.OleDb\n \nSELECT TOP (1000) \n\tCASE WHEN COALESCE(A.Vorname,'') = '' THEN A.Nachname ELSE '' END as CompanyName, \n\tCASE WHEN COALESCE(A.Vorname,'') = '' THEN A.Bezeichnung ELSE '' END as Department, \n\tCASE WHEN COALESCE(A.Vorname,'') = '' THEN '' ELSE A.Bezeichnung END as Position, \n\tCASE WHEN COALESCE(A.Vorname,'') = '' THEN K.Nachname ELSE A.Nachname END as LastName, \n\tCASE WHEN COALESCE(A.Vorname,'') = '' THEN K.Vorname ELSE A.Vorname END as FirstName, \n\tCASE WHEN COALESCE(A.Vorname,'') = '' OR A.Begruessung IS NULL THEN A.Begruessung ELSE K.Begruessung END as SalutationShort, \n\tCASE WHEN COALESCE(A.Vorname,'') = '' OR A.BegruessungsText IS NULL THEN A.BegruessungsText ELSE K.BegruessungsText END as Salutation, \n\tCASE WHEN A.Land IS NULL THEN 'CH' ELSE A.Land END as CountryCode, \n\tA.PLZ as Zip,\n\tA.Stadt as City,\n\tA.Adresse1 as Street, \n\tA.Adresse2 as PostOfficeBox, \n\tA.Email as EmailBusinessDirect, \n\tA.Telefon1 as PhoneBusinessDirect, \n\tA.Mobil as MobileBusiness, \n\tA.Fax as FaxBusinessDirect, \n\tA.Webseite as HomepageBusiness, \n\tK.Email AS EmailPrivat, \n\tK.Telefon1 as PhonePrivat, \n\tK.Mobil AS MobilePrivat, \n\tK.Fax as FaxPrivat\n\tFROM Adresse A \n\tLEFT OUTER JOIN Kontakt K ON A.ID = K.AdresseID\n\tWHERE \n\t('{company}' = '' OR A.Nachname Like '%{company}%' OR K.Nachname like '%{company}%') AND \n\t('{firstName}' = '' OR A.Vorname Like '%{firstName}%' OR K.Vorname like '%{firstName}%') AND \n\t('{plz}' = '' OR A.PLZ Like '%{plz}%') AND \n\t('{city}' = '' OR A.Stadt Like '%{city}%') AND\n\t('{addressid}' = '' OR Str(A.ID) Like '%{addressid}%' )\n\t\n \n \n \n \n \n \n \n \n","type":"text"}]},{"type":"paragraph"}],"version":1}

Browser not supported