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":"Auf Abacus kann entweder über einen WebService oder direkt auf die Datenbank zugegriffen werden. Die Verwendung der Indices liefert nicht in allen Anwendungsfällen die optimalen Ergebnisse. Wir empfehlen, die Suche per ","type":"text"},{"text":"Generic SQL","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/PDT/pages/34537542"}}]},{"text":" zu realisieren.","type":"text"}]},{"type":"rule"},{"type":"heading","attrs":{"level":1},"content":[{"text":"abaconnect 2014","type":"text"}]},{"type":"paragraph","content":[{"text":"Ruft die Abacus Webservices Schnittstelle ","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":" auf. Über die abaconnect Schnittstelle können Addressdaten via Indices abgerufen werden. In primedocs können die Anzahl Indices und die Abfrage konfiguriert werden. Allerdings ist darauf zu achten, dass in Abacus die gleichen Indices ebenfalls vorhanden sind. Sonst schlägt die Suchabfrage fehl.","type":"text"}]},{"type":"paragraph","content":[{"text":"abaconnect fordert alle Felder an. Zum Beispiel, wird im Index 4 der Name weggelassen, werden alle Einträge ab AAAA ausgegeben.","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":"Der ","type":"text"},{"text":"Generic SQL Provider","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/PDT/pages/34537542"}}]},{"text":" versucht aufgrund des Vornamens zu erkennen, ob es sich um eine private oder geschäftliche Adresse handelt.","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}