Extension talk:TableEdit

From MediaWiki.org

Jump to: navigation, search

This page is for bugs, requests, and questions about Extension:TableEdit. Please add your item at the end of the page, and include your MediaWiki signature ("~~~~") at the end of your post.

Contents

[edit] Row Data spacing

I've noticed that when I save data in a cell, the way it applies to the page puts <p> tags around that data. The end effect causes the data to have extra spacing between rows.

Example :

<td><p>test</p></td>

It would appear this is caused by the way data is saved in wiki format from the editor.

|- bgcolor=#F7F9FA
|
test
|

Is it possible to force it to add the data to the same line as the start of the cell? Like this..

|- bgcolor=#F7F9FA
|test
|

Thereby removing the <p> tag.

<td>test</td>

Using Version 0.8 --Bandophahita 19:06, 17 September 2008 (UTC)

[edit] More Styling Information

Is there more styling information you can include? Like adding attributes to the other cells besides the header, add a border around the whole table? Or refer to a style class?

[edit] Rational for off page data

I was just wondering what the rational was for storing data off page. In a case like this it would seem that data entered would not be accessible to the standard wiki search. Is this true? --Dtsig 02:59, 21 April 2007 (UTC)

the text gets stored in the wiki as if it was a regular table. There are two reasons for storing it in the external database. The first has to do with asynchronous data mining of the table content. The idea is that middleware can be written to work on the external db without interfering with the wiki's db or having to go through the MW interfaces. I'm working on that kind of middleware right now, but it's in Perl, not PHP. The second is laziness/lack of imagination/coding skill on my part in terms of how to implement it if it was just saved in the wiki. In hindsight, I probably could have spent more time adapting whatever the parser already does with tables. -- JimHu 03:15, 21 April 2007 (UTC)
Is it possible to simply switch off the external storage? Possibly a variable set so the external db is not required.? --Dtsig 17:22, 24 April 2007 (UTC)
not yet. The table loads from the database, not from the wiki page. That could change in the future, especially with contributions from other coders (hint, hint) JimHu 23:59, 24 April 2007 (UTC)

[edit] Bulk load from a CVS or XML file

It would be great if you add the capability to read in a CVS or XML file

[edit] New TableEdit feature/enhancement --Dtsig 14:39, 6 August 2007 (UTC)

There should be a way to wrap it and have it create a table definition
2) If a user messes with the data or worse screws with the tag then we are really hosed <G>For those who don't need the data in a DB for other use, wouldn't it be possible for the routine to parse out a generic table and process just as if it came from the db? I think this would be a great enhancement. So a simple tage <tableedit/> on the page would have the parser put the appropriate 'link' before each table. I get that this wasn't the original purpose but would make MediaWiki much stronger.

[edit] --Dtsig 21:04, 14 February 2008 (UTC)

Jim, have put put any thought to this. Wouldn't it be a *simple* case of pulling out the table, its rows, columns and headings? Everything inside would stay the same I would think Though not sure how you are saving this off. Look forward to talking

[edit] Can't insert row in the middle neither

Hello it seems that I can't install neither a row in the middle of a table, is this correct? Oub 10:38, 7 November 2007 (UTC):

that's true in current versions. Note that the tables should be sortable, however. --JimHu 19:01, 14 November 2007
Re: JimHuthanks, but how can I sort, I mean I do not see any bottom for that functionality. Oub 09:20, 15 November 2007 (UTC):

[edit] Watchlist not working for me

Apologies for not noting changes on these pages - for some reason the watchlist emails are not reaching me --JimHu 19:01, 14 November 2007 (UTC)

[edit] Question about advanced templates

I have installed TableEdit successfully and have been enjoying the product to create our tables throughout our Wiki's. We're now interested in going further with the table and are trying to set up the advanced features - the drop down lists, etc, that is outlined in the documentation.

Our company has attempted to get these advanced tables to work, but nothing has been successful. The script example given in the documentation is:

  Qualifier||qualifier|select| |NOT
  GO ID||go_id|text
  GO term name||go_term|lookupcalc|SELECT page_title from go_archive.term WHERE go_id = '{{{go_id}}}' ORDER BY term_update DESC LIMIT 1|page_title|split|_!_|1Reference(s)||refs
  Evidence Code||evidence|select|IC: Inferred by Curator|IDA: Inferred from Direct Assay|NR: Not Recorded
  [...]

My question is, how or where, or at what point, do you insert these script commands? Are they in the portal itself, such as:

<newtableedit> [script commands] </newtableedit>

Or, do you create the table, using the <newtableedit> tag, then once you're in the table, somehow insert these script commands?

We have tried numerous different scenarios, different syntaxes, etc, but have come up with nothing. Going from the documentation, it seems to be related to the <headings> tag, but again, we don't know how or where to use these <headings> tags, if at all, to accomplish what we want.

If anyone has been able to get these advanced tables to work, please respond to this and let us know how you did it.

Thank you!

The advanced tables take their formatting from pages in the Template namespace. Create a page Template:MyTable, and put in the scripting. Then on the page where you want that kind of table, use

<newtableedit> MyTable </newtableedit> --JimHu 04:16, 11 February 2008 (UTC) (I really wish the watchlist would work.. It seems to work on my User:Talk page.)

Working fine now - thank you!

[edit] Lines in the table

Is there a way to show the lines in the table? In edit mode you see the lines between the cells, but when you save it you don't? It would look better for our tables to have the lines between the columns & rows to make it more visible.

Anyone know if this can be accomplished? Thanks!!

[edit] --Dtsig 21:06, 14 February 2008 (UTC)

Although I haven't looked it should be a css for the table style. It should be possible to modify this though it would be manual after each new table. I would think that this could be an option when creating a table. Jim?

I think it defaults to using the Prettytable template, which might not be in everyone's wiki. --JimHu 08:18, 16 February 2008 (UTC)

[edit] Nice Enhancements --Dtsig 16:38, 27 March 2008 (UTC)

  1. Quick Enter; it would be nice to define a character that someone could use to enter more than one row at a time. For example, if I go to ADD i can only enter i row,column at a time. If i entered something like 'data 1~data 2~data 3' then upon exiting table edit mod it would break that down to 3 rows of data for that column. If you have multiple columns you might in the second box put 'col2 row1~~col2 row3' which would associate with the first column of data.
  2. Modify Table Properties; this would allow adding a column or removing a column

[edit] another 'Clone a Row' --Dtsig 17:29, 27 March 2008 (UTC)

It would also be very nice to have the ability to clone 1 row of data to another. This allows quick and easy editing/creating. Especially since you only get 1 row of data at a time.

This one will be in the next release as copy row --JimHu 22:27, 8 April 2008 (UTC)

[edit] Followup to email --208.214.103.202 19:39, 8 April 2008 (UTC)

Okay, as a first task I would suggest the ability to ADD a column or DELETE a column. I would suggest that both of these button be at the bottom with the “save” data. Possibly 2 rows of controls? Add Column, Delete Columns, Delete Table on 1 row. Add Data, Save Data, Save Return and Cancel Changes on the second row.

-- Add column and delete column work via Edit Headings, but only on the last column, so far. --JimHu 22:37, 8 April 2008 (UTC)

---I do not get the 'Edit Headings' on my TableEdit. Currently version 0.5 Is there a newer version. Sorry for late reply but I am not getting 'watchlist' messages <sigh>. thanks --Dtsig 22:35, 19 May 2008 (UTC)

Cancel changes; from the overall table page, simply like the back arrow – returning to the wiki page. No harm no foul

This should be easy. On the todo list for the next release --JimHu 22:37, 8 April 2008 (UTC)

Save Data; from the overall table page, this would write it out but not return. Allow adding. I have found that at times, because of timing, meetings etc, I have come back adding rows and a few rows I had added earlier are gone. <sigh>

Hmm.... session data expires? So, you want save and return to page to be separate? --JimHu 22:37, 8 April 2008 (UTC)

Add Column would maybe prompt for column heading then add NULLs for that column as needed through all rows.

Delete Column would prompt for the column to delete. Go through the rows in the db deleting the positions.

We could go further with a “clear” for the TABLE and ROW

I think I know what you want here, but just to check... you want to keep the structure, but empty the data for existing row (clear row from row edit view) or all rows (clear table from table view). --JimHu 22:37, 8 April 2008 (UTC)
exactly --Dtsig 22:37, 19 May 2008 (UTC)

I still wonder if have this “non db” required wouldn’t be a big enhancement. But then that probably might not be so easy the way it is structured. I think once I looked and you build the page according to the DB. Of course if this is true then you could build a “sort” column into the db automatically without displaying. Then you could have “pop-up” page of all rows with this column on it. Allow the user to RENUMBER them and use that as your SELECT ORDER column.

I'm working on a version that extracts the table from the wikitext. Not fully db-free, though. I wrote this partly as an alternative to Semantic Mediawiki, where the table db is separately mineable from the main wiki db, so while I see what you mean, I don't think TableEdit is going to go there.--JimHu 22:37, 8 April 2008 (UTC)

[edit] Misc Table properties showing --Dtsig 16:38, 27 March 2008 (UTC)

id='5' class = 'sortable'

This information shows just above the table. If I look at the HTML for the table setup it looks like

{|{{Prettytable}} id='5' class = 'sortable'

Not really sure why it is showing in the page. Template error??

[edit] User Not Logged In Error

Hi,

I have recently split up my wiki and moved some of it to a new wiki and am having problems with the tableEdit extension. I have managed to move all my tableedit tables to the new working ang get them working fine. The only problem comes when I am not logged onto my wiki and I click the "edit table" link which then provides me with an error.

Internal error Detected bug in an extension! Hook TableEdit::loadMessages failed to return a value; should return true to continue  hook processing or false to abort. Backtrace: #0 /includes/MessageCache.php(684): wfRunHooks('LoadAllMessages') #1



Does anyone Know how to fix this or hide the "edit table" link when a user is not logged on?

[edit] Question about lines showing in the table

This was addressed somewhat (above), but I am seeking more clarification. When I click the "edit table" link, it displays the borders no problem. But when the table is saved/viewed on the portal, no borders are displayed. Is there a way to make the borders visible? Above, it references modifying CSS properties, but I am lost as to where/how to do that. Is that modification made in the portal code itself, after the table is generated? If so, what and where do I insert in the code to make the borders appear (and does it have to be done for each and every table)?

In addition, another comment relates to using the PrettyTable template. On my wiki (MediaWiki), when I edit the page containing the table, it uses the PrettyTable template, but it does not exist on my wiki (IE, when I click on it's link there is no content/page is not created).

Other than this minor visual issue, we love this table product and use it extensively on our intranets.

If anyone could assist us with this, we would appreciate it. Thank you very much!

[edit] Examples?

I could only find this page on your wiki where it's used in a template on a page (at the very top) and it's broken. This page has one example (in German, but it's something).

This extension looks very cool, but I can't get my head around it on my first look, and would like to see where it has been used. -- Chriswaterguy 08:35, 11 June 2008 (UTC)

[edit] Installation: beware of «update_schema.php»

update_schema.php (from «TableEdit.0.8») is useless, because:

  • Works only under Linux (it use PHP function «getopt», it use some UNIX utilities, …);
  • «ENGINE=MyISAM» and «DEFAULT CHARSET=latin1» are hardcoded in SQL texts.
  • TableEdit_tables.sql contains some syntax errors (L18, L33, …).

Instead of running «update_schema.php», users must critically review TableEdit_tables.sql, fix errors and parameters («ENGINE», «DEFAULT CHARSET») and run it manually. --StasFomin 12:37, 28 July 2008 (UTC)

Note added to the installation instructions to note problems with update schema. We let the schema SQL docs and the installer get out of sync, since we're trying to reproduce schema adjustments we made manually, and I screwed up in manually editing the SQL (left out some commas). We're working on a new version of update schema, but it's not there yet (because I made some additional modifications - adding a timestamp to the metadata). We can try to make it more platform independent if you can give us some help; it was actually tested on Macs, not Linux --JimHu 15:30, 28 July 2008 (UTC)

[edit] Installation error;

mediawiki 1.12 php5 phpmyadmin

I just can't run the file "TableEdit_tables.sql" , I kept receive this error message.

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'KEY `template` (`template`), KEY `page_name` (`page_name`) ) ENGINE=MyISAM DE' at line 13

working on a new release to fix this. In the meantime, here is a dump of the structure of those tables from EcoliWiki, where it's running live - note that this is already slightly changed from the 0.8 release; but it should be compatible and will prepare you for the 0.81 release:
-- phpMyAdmin SQL Dump
-- version 2.10.2
-- http://www.phpmyadmin.net
-- 
-- Host: trimer.local:3306
-- Generation Time: Jul 30, 2008 at 05:14 PM
-- Server version: 5.0.41
-- PHP Version: 5.2.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `colipedia`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `ext_TableEdit_box`
-- 

DROP TABLE IF EXISTS `ext_TableEdit_box`;
CREATE TABLE IF NOT EXISTS `ext_TableEdit_box` (
  `box_id` int(10) unsigned NOT NULL auto_increment,
  `template` varchar(255) NOT NULL,
  `page_name` varchar(255) NOT NULL,
  `page_uid` varchar(255) NOT NULL,
  `box_uid` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `headings` varchar(255) NOT NULL,
  `heading_style` varchar(255) NOT NULL,
  `box_style` varchar(255) NOT NULL,
  `timestamp` int(11) NOT NULL,
  PRIMARY KEY  (`box_id`),
  KEY `template` (`template`),
  KEY `page_name` (`page_name`),
  KEY `page_uid` (`page_uid`),
  KEY `box_uid` (`box_uid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Table structure for table `ext_TableEdit_box_metadata`
-- 

DROP TABLE IF EXISTS `ext_TableEdit_box_metadata`;
CREATE TABLE IF NOT EXISTS `ext_TableEdit_box_metadata` (
  `box_metadata_id` int(10) unsigned NOT NULL auto_increment,
  `box_id` int(10) unsigned NOT NULL default '0',
  `box_metadata` varchar(255) NOT NULL default '',
  `timestamp` int(10) NOT NULL,
  PRIMARY KEY  (`box_metadata_id`),
  KEY `box_id` (`box_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Table structure for table `ext_TableEdit_row`
-- 

DROP TABLE IF EXISTS `ext_TableEdit_row`;
CREATE TABLE IF NOT EXISTS `ext_TableEdit_row` (
  `row_id` int(10) unsigned NOT NULL auto_increment,
  `box_id` int(10) unsigned NOT NULL,
  `owner_uid` int(10) default NULL,
  `row_data` text NOT NULL,
  `row_style` varchar(255) NOT NULL,
  `row_sort_order` int(11) NOT NULL,
  `timestamp` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`row_id`),
  KEY `box_id` (`box_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Table structure for table `ext_TableEdit_row_metadata`
-- 

DROP TABLE IF EXISTS `ext_TableEdit_row_metadata`;
CREATE TABLE IF NOT EXISTS `ext_TableEdit_row_metadata` (
  `row_metadata_id` int(10) unsigned NOT NULL auto_increment,
  `row_id` int(10) unsigned NOT NULL default '0',
  `row_metadata` varchar(255) NOT NULL default '',
  `timestamp` int(10) NOT NULL,
  PRIMARY KEY  (`row_metadata_id`),
  KEY `row_id` (`row_id`),
  KEY `row_metadata` (`row_metadata`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
hope this helps --JimHu 22:18, 30 July 2008 (UTC)
      • It really does help, thanks you very much.

[edit] Work with Extension:ParserFunctions?

What is the data structure? Is all the data store somewhere else within database? Can we retrive it on another page? On the other hand, can we do some calculation with those data?

For example:
{{#expr: {{{Field1}}} * {{{Field2}}}　}}

I think Extension:WikiDB is an great idea but it's still very primitive.


[edit] Fix "Printable Version" page

I had a problem with the default skin of MediaWiki and TableEdit, when useing "Printable Version". In all of my tables the first column got way too wide, because MediaWiki displays "Edit Tanle" button with it's full URL.

I came up with a workaround:

  1. Edit file /path/to/mediawiki-root-dir/skins/common/commonPrint.css
  2. Add following to the end of file:
tr.sortbottom {
    font-size: 0px;
    display: none;
}

Done - the "Printable Version" page should now display without the "Edit Table" row at all. If you happen to wonder, "font-size: 0px;" is there to do the trick with some older browsers, in 99% of cases "display: none;" is all that is needed. Wyrmiyu 21:10, 14 October 2008 (UTC)


[edit] TableEdit stopped working

I had to migrate our wiki due to a server crash. Everything in the mediawiki seems fine except for the TableEdit. It won't allow me to create a new table nor edit an old table.

werd

Retrieved from "http://www.mediawiki.org/wiki/Extension_talk:TableEdit"
Personal tools