PyOnlineSpreadSheetEditing: Difference between revisions

From BITPlan Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
(13 intermediate revisions by the same user not shown)
Line 3: Line 3:
{{OsProject
{{OsProject
|id=pyOnlineSpreadSheetEditing
|id=pyOnlineSpreadSheetEditing
|state=active
|owner=Wolfgang Fahl
|owner=Wolfgang Fahl
|title=python Online SpreadSheet Editing tool with configurable enhancer/importer and check phase
|title=pyOnlineSpreadSheetEditing
|description=python Online SpreadSheet Editing tool with configurable enhancer/importer and check phase
|url=https://github.com/WolfgangFahl/pyOnlineSpreadSheetEditing
|url=https://github.com/WolfgangFahl/pyOnlineSpreadSheetEditing
|version=0.0.3
|version=0.3.0
|date=2021-12-12
|date=2024-03-18
|since=2021-12-12
|storemode=property
|storemode=property
}}
}}
=Freitext=
 
= Semantic MediaWiki Use Case =
== SMWCon Fall 2021 Presentation ==
<youtube>0zD4cSRDj-Q<</youtube>
== Workflow ==
<graphviz format='svg'>
digraph spreadsheetediting  {
  src [ label="source wiki" shape="box" ]
  target [ label="target wiki" shape="box" ]
  preview [ label="preview wiki" shape="box" ]
  wikiquery [ label="wikiquery" shape="octagon" ]
  Query1 [ label="ask query for 1 side of relation" ]
  QueryN  [ label="ask query for n side of relation" ]
  QueryCheck [ label="check plausibility of results" ]
  Query1 -> wikiquery [ label="ask" ]
  QueryN -> wikiquery [ label="ask" ]
  wikiquery -> QueryCheck [ label="LoD 1" ]
  wikiquery -> QueryCheck [ label="LoD n" ]
  src -> wikiquery
 
  QueryCheck->Pre
  subgraph cluster_service {
    label="SpreadSheet Editing Service"
    Edit [ label="Spreadsheet Editor" ]
    Pre [ label="Enhancement" ]
    Post [ label="Result Check" ]
  }
  Pre-> Edit
  Edit -> Post
  Post -> Publish
  Publish -> target [ label="wikipush" ]
  Preview -> preview  [ label="wikipush" ]
  Post-> Preview [ label ="optional" ]
 
}
</graphviz>
= Steps =
#Queries - multiple ones potentially via RESTful call giving e.g. CSV/JSON ... result , Simple Example: CSV export
#Enhance data - multiple RESTful calls (optional)
#manual check and edit with Spreadsheet
#Final data check - multiple RESTful calls (optional)
#Store data e.g. Wiki / Wikidata ... Simple Example: CSV import
 
= Issues =
= Issues =
#{{Ticket|1|List of Dict support|pyOnlineSpreadSheetEditing}}
#{{Ticket|2|List of Dict support for CSV|pyOnlineSpreadSheetEditing}}
#{{Ticket|3|allow enhancer Callback|pyOnlineSpreadSheetEditing}}{{Done}}

Latest revision as of 14:17, 18 March 2024

OsProject

OsProject
edit
id  pyOnlineSpreadSheetEditing
state  active
owner  Wolfgang Fahl
title  pyOnlineSpreadSheetEditing
url  https://github.com/WolfgangFahl/pyOnlineSpreadSheetEditing
version  0.3.0
description  python Online SpreadSheet Editing tool with configurable enhancer/importer and check phase
date  2024-03-18
since  2021-12-12
until  

Semantic MediaWiki Use Case

SMWCon Fall 2021 Presentation

Workflow

Steps

  1. Queries - multiple ones potentially via RESTful call giving e.g. CSV/JSON ... result , Simple Example: CSV export
  2. Enhance data - multiple RESTful calls (optional)
  3. manual check and edit with Spreadsheet
  4. Final data check - multiple RESTful calls (optional)
  5. Store data e.g. Wiki / Wikidata ... Simple Example: CSV import

Issues