Is this data coming from an actual spreadsheet, or a program that can export *.csv (comma seperated values)?
If so, you could use my new CSV Import options in my JsonMangler plugin. After importing the CSV tiddler, there is an option to re-Import each row as its own tiddler (auto-naming fields after the header row if present). https://joshuafontany.github.io/TW5-JsonMangler/ Best, Joshua Fontany On Sunday, February 9, 2020 at 12:47:55 AM UTC-8, Ruslan Popov wrote: > > I want to import spreadsheets from HTML files into TiddlyWiki. The files' > content looks like this: > > *<html> * > <head> <title>Search ....</title> > </head> > *<body> * > <div> > <div class="grid_9"> > <table> <tr><td colspan="3" width="400"><h1>..... List</h1></td></tr> > </table> <br> > > *<table* class="report-layout" border="1"> > <thead> > *<tr>* > <!-- <th > style="text-align:center;background-color:#BDBDBD;">Name</th> --> > <th > style="text-align:center;background-color:#BDBDBD;">Application No.</th> > <th > style="text-align:center;background-color:#BDBDBD;">Course Type</th> > <th > style="text-align:center;background-color:#BDBDBD;">Course Name</th> > <th > style="text-align:center;background-color:#BDBDBD;">First Name</th> > <th > style="text-align:center;background-color:#BDBDBD;">Middle Name</th> > <th > style="text-align:center;background-color:#BDBDBD;">Last Name</th> > <th > style="text-align:center;background-color:#BDBDBD;">Email</th> > <th > style="text-align:center;background-color:#BDBDBD;">Phone</th> > .... > </tr> > </thead> > *<tr *id="row_8797" class="odd"> > <td>P3.........</td> > <td>TEACHER TRAINING COURSE</td> > <td>200H</td> > <td>Natasha</td> > <td></td> > <td>K....</td> > ... > </tr> > .... > > In short, it is a basic table in basic HTML format. The first row has > column headers, and the following rows have the data. > > This file can be imported using the standard Import tool. As a result, a > new tiddler is created, which has the same HTML content from the file. So, > the data gets nicely displayed in the tiddler. > > What I'd like to do, however, is to add some wikitext decoration to these > data. For example, where there is "Application ID" in the first column, I > want to be a wiki link. Clicking on the link should create a new tiddler > titled with the Application ID. And that tiddler's fields should be > populated with values from that row. For example, there should be fields > such as "First Name", "Last Name", "Email", each containing corresponding > data from the table. > > I don't know how to approach this. But for a TiddlyWiki guru this may be > trivial. For example, > > > 1. is it better to process the data during import itself, or import it > first and then run a post-import script? (I don't need to keep the > original > HTML in the Wiki) > 2. whether there's a a DOM / SAX parser available, or I have to stick > with regex > 3. what is the best practice to pre-populate tiddler fields when it is > created? > > Thanks in advance for any suggestions > -- You received this message because you are subscribed to the Google Groups "TiddlyWiki" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/4d38a454-8efa-4a73-b8e3-b36b396af7ec%40googlegroups.com.
