Externe Daten in MS-Visio-Dateien

From Random Hacks of Kindness
Jump to: navigation, search


Contents

[edit] Abruf, Integration und Anzeige von externen Daten in Microsoft Visio-Dateien

[edit] Owner

Proposed by: Senatsverwaltung für Gesundheit, Umwelt und Verbraucherschutz – Gesundheitlicher Bevölkerungsschutz

Contact (name, email, phone, skype): Detlef Cwojdzinski <Detlef.Cwojdzinski@senguv.berlin.de>

Best way and times to contact during RHoK 2.0 Dec 4/5 2010: Detlef Cwojdzinski will be present in Betahaus

[edit] Summary

Allgemeine Prozessdiagramme:

  1. In Microsoft Visio (Version 2010) werden allgemeine Prozesse (etwa: „Alarmierung Krankenhäuser im Fall Massenanfall von Patienten/Großunfall“) gezeichnet.
  2. Bestimmte Prozess-Objekte/Entitäten („Shapes“, etwa: „nächstgelegene Krankenhäuser“) sind Bestandteil dieser Ablaufdiagranne. In diesen Entitäten werden als Metadaten Zuordnungen verwaltet (etwa Datenquellen und Abrufmuster).

Anlassfall:

  1. Ein Anlassfall eines allgemeines Prozesses tritt in einer bestimmten Region (Geo/Koordianten/Adresse) ein (etwa: Busunfall Autobahn A10, km 12,5).
  2. Der passende allgemeine Visio-Prozess wird geöffnet die Region im Visio angegeben/ausgewählt.
  3. Alle Prozess-Objekte/Entitäten mit enthaltenen Metadaten- Verknüpfungen (etwa Abfragen in XML-Datenbanken als URL) führen die Abfragen durch.
  4. Die Abfrage-Ergebnisse werden in den Prozess-Objekten („Shapes“) angezeigt.

Ziel:

Prozessdiagramme in Visio, die im Anlassfall etwa alle betroffenen Krankenhäuser mit Kontaktinformationen direkt im Visio anzeigen und ausdruckbar/weiterleitbar sind.

Zusatzanforderung (optional):

Ausgabe der mit dynamischen Daten angereicherten Diagramme in eine HTML-Darstellung.

[edit] Example

Beispiel fehlt noch

[edit] Use Case/User Story/Scenario

Outline one or more short (one paragraph) user stories/use cases/scenarios that describe how someone would use a solution to solve the problem. Alternately outline the scenario for someone confronted by a problem, and provide some options/thoughts for how technology or a hack might help them

e.g. Problem: Ana is at home when an earthquake strikes. Most of the building collapses and she is stuck inside, injured but mostly OK. She has a cellphone with her. She is terrified, and tries to call the police, and then her friends for help, but there's no reception. Eventually her battery runs down and she's worried she can't make any more calls.

[edit] User story 1: bluetooth connection to wallpaper antenna

After the earthquake stress sensors in the wallpaper of her living room trigger and activate a bluetooth receiver powered by a battery. Ana's cellphone senses via bluetooth and makes an automatic connection (she set it up beforehand). Antenna embedded in the wallpaper gives Ana greater reception and signal strength so she can reach a standing tower and her call goes through.

[edit] User story 2: What's next

You can also go ahead and produce detailed use cases for each user story (or on their own) if that's where you're at. e.g.

[edit] Use Case 1: setup phone connection to wallpaper

lorem ipsum....

[edit] Use Case 2: battery in wallpaper low sends signal to phone

ver den wie der kommen uns genzien uns....

[edit] Description and Constraints

What else do they need to know? What constraints

e.g. No AC power. Must cost less than $0.001/unit. Existing code is all 80288 assembler, so hack must use that.

[edit] Extra Credit

Fabulous extensions that would rock the world if completed

[edit] Similar projects and Resources

Links to similar projects, background reading, research, designs, existing work, data standards etc.

e.g.

  • Cellphone antenna research link
  • Bluetooth antenna extenders interop RFP standard W3C document
  • Wallpaper production standards and costs
  • Existing way too expensive solution only available to Florida retirees.

[edit] What next and Sustainability

How will this work be taken to real users, or further developed? Will this be an ongoing team? Is there a NGO/group that's sponsoring it as an ongoing project? Who/how/when?

[edit] Current State and Solutions

Link to RHoK and other solutions projects, including different groups, but particularly the Project pages from RHoK events

e.g. Was worked on by team in Malawi during RHoK 1.0 and they built a working proof of concept, (link to project page). But dev has stalled.

Personal tools