CircularLogic
Joined: Aug 22, 2003
|
  Posted:
Feb 28, 2009 - 09:36 |
|
I have the problem, that I`m tracking data in an excel sheet, but want to post that data in the FUMBBL wiki system.
Does anyone have an idea how to use copy&paste to easily transfer large tables into the wiki? |
|
|
Snorri
Joined: Jun 07, 2004
|
  Posted:
Feb 28, 2009 - 10:28 |
|
Just save as cvs and write a quick parser script (bash, perl, python...) to replace the ,'s and endline markers with wiki markup. |
|
|
CircularLogic
Joined: Aug 22, 2003
|
  Posted:
Feb 28, 2009 - 10:38 |
|
While I know my way around excel, 'quick parser scripts' are beyond my knowledge. Could someone help me there? |
|
|
CircularLogic
Joined: Aug 22, 2003
|
  Posted:
Feb 28, 2009 - 15:13 |
|
btw:
The data I`m tracking are the tour points of the FUMBBL tour, to make a page that shows the current ranking. |
|
|
Coreno
Joined: May 22, 2009
|
  Posted:
May 25, 2009 - 16:45 |
|
|
xcver
Joined: Mar 10, 2005
|
  Posted:
May 25, 2009 - 16:52 |
|
Coreno wrote: | http://people.fas.harvard.edu/~sdouglas/table.cgi |
did you test that? I tried it right now and it didn't work for me |
_________________ "Power without perception is virtually useless and therefore of no true value!" - Ryouken - Master of the Hokuto no Ken Martial Arts |
|
Coreno
Joined: May 22, 2009
|
  Posted:
May 25, 2009 - 17:14 |
|
Worked when I last used it which is 3 months ago or so. I copy pasted a 10x20 or so table from OpenOffice Spreadsheet and it parsed fine for use with Mediawiki. |
|
|
Shraaaag
Joined: Feb 15, 2004
|
  Posted:
Jun 15, 2009 - 09:38 |
|
You don't need a parser or script to do your work. I believe most textediting programs comes with a search/replace function, and some are even good. (personally I use vim (*nix editor), but that's down to taste). So as the first answer say, save as .cvs, open with your favorite editor, and do a search/replace to replace the ; with wiki markup. |
_________________
|
|
Rijssiej
Joined: Jan 04, 2005
|
  Posted:
Jun 15, 2009 - 09:53 |
|
I would use excel to concat the fields with the tags you need. |
|
|
|