PUG

  • PUG News
  • PUG Forum
  • Shared documents
  • PUG Events
    • Scandinavian Conferences
    • Scandinavian Theme Days
    • D-A-CH Events
    • North American Events
  • PUG Info
    • PUG Board Info (Scandinavia)
    • PUG Rules
    • PUG Member Lists and Board Members
  • Contact Us

Reply To: Benutzerkalender automatisch aus fremdem SQL-System pflegen

  • Follow us on Twitter
  • Join our Facebook Group
  • RSS

Welcome to the POB User Group Online Community! › Forums › PUG DACH › Benutzerkalender automatisch aus fremdem SQL-System pflegen › Reply To: Benutzerkalender automatisch aus fremdem SQL-System pflegen

12/01/2016 at 11:21 #3246
ms
Keymaster

Hi,

das hört sich schon mal super an. Wir haben in beiden Systemen die gleiche Benutzer ID. In der SQL Datenbank vom Fremdsystem ist zwar eine andere Staff-ID drin, wobei in der Anwendung nachher die richtige Mitarbeiter-ID angezeigt wird. Da muß es also irgendwo ein Matching geben. Ich habe das Thema mal beim Herstellersupport des Systems angefragt und warte auf Antwort.

Die Datenbanktabelle des Fremdsystems sieht so aus (Export Auszug):

ID CYCLIC_ENTRY_ID REQUEST_ID ABSENCE_ID STAFF_ID DATE_FROM DATE_TO ABSENCE_QUANTITY STATE REASON REMARK TITLE DATE_CREATION REMARK_PRIVATE DURATION_MODE OVERTIME_HISTORY_ID
22099364 22099356 1 40 189595 1411941600000 1412027999000 1 3 NULL NULL Urlaub / Gleitzeit 1411025166506 0 1 NULL
22099386 22099376 2 40 189595 1412028000000 1412287199000 3 3 NULL NULL Urlaub 1411027388930 1 1 NULL
23271636 23271627 3 175831 189595 1411336800000 1411509599000 2 3 NULL Nürnberg Dienstreise 1411378354421 0 1 NULL
23271647 23271638 4 175831 189595 1412805600000 1412978399000 2 3 NULL Hamburg Dienstreise 1411378373718 0 1 NULL
23271659 23271649 5 175831 189595 1416178800000 1416437999000 3 3 NULL FI Forum Dienstreise 1411378401501 0 1 NULL
23271670 23271661 6 175831 189595 1416438000000 1416610799000 2 3 NULL Citrix Summit Dienstreise 1411378429035 0 1 NULL
23271682 23271672 7 175831 189595 1415746800000 1416178799000 3 3 NULL Hamburg (Umzug) Dienstreise 1411378453340 0 1 NULL
49676421 49676413 8 40 182765 1415142000000 1415228399000 1 3 NULL NULL Urlaub / Gleitzeit 1415269890282 0 1 NULL
49676430 49676423 NULL 40 182765 1419375600000 1420066799000 2 1 NULL NULL NULL 1415269921934 0 1 NULL

Login

Register | Lost your password?

Menu

  • PUG News
  • PUG Forum
  • Shared documents
  • PUG Events
    • Scandinavian Conferences
    • Scandinavian Theme Days
    • D-A-CH Events
    • North American Events
  • PUG Info
    • PUG Board Info (Scandinavia)
    • PUG Rules
    • PUG Member Lists and Board Members
  • Contact Us

Pages

  • Anmeldung zur PUG Konferenz 2018
  • Contact us
  • Forgot Password
  • Login
  • Lost password
  • POB Tip – Filtering lists to show only limited data
  • Profile
  • Registration
  • Registration for PUG 2019 in Scandinavia
  • Registration for PUG 2020 in Scandinavia
  • Skandinavisk PUG konference 2014 (Hurdal, Norge)
  • Skandinavisk PUG konference 2017 (Sundvolden, Norge)
  • Tilmelding til / Anmälan till PUG 2015 i Sollentuna
  • Tilmelding til erfamøde hos Frederiksberg Kommune
  • Tilmelding til PUG 2016 / Anmälan till PUG 2016
  • Tilmelding til PUG 2018 / Anmälan till PUG 2018
  • Udfyld nedenstående felter hvis du ønsker at melde jer ind i PUG
  • Welcome to the POB User Group Online Community!
  • Wendia North America 2018 Customer-Partner Conference Registration Form
  • Wendia North America 2019 Customer-Partner Conference Registration Form
  • You are not a member?
  • Webinar on the New Mobile Web Apps in POB G6 2.006/01/2021 - 13:41

    The POB G6 2.0 mobile interfaces for analysts and customers provide great new capabilities and features. The mobile interfaces have a new look and feel and they allow utilization of most areas of POB from a mobile platform. On January 19th, Kevin Goertzen will show and demonstrate the new mobile interfaces in POB G6 2.0 […]

  • December Webinar on Triggers in POB27/11/2020 - 12:10
  • PUG 2021 – Redesigned for a Virtual Setting (Scandinavia)13/11/2020 - 11:29

    The PUG board has decided to have next year’s Scandinavian conference in a virtual setting. So, mark your calendar for April 20th, 2021, where PUG will host a one-day virtual conference. The decision was made based on the feedback the PUG board got when they asked how participants would feel about attending a physical conference, […]

© Copyright - PUG - All rights reserved by PUG © 2012
  • Send us Mail
  • Follow us on Twitter
  • Join our Facebook Group
  • Subscribe to our RSS Feed