Difference between revisions of "PyOnlineSpreadSheetEditing"

From BITPlan Wiki
Jump to navigation Jump to search
 
(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 15: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