Question

Our company already holds our skills in an excel file. However, moving it to the wiki could be useful for us.

Is there a way to take a spreadsheet of categories, skills and values and import them into the skills plugin 'data'?

Environment

-- HelenJohnstone - 22 Sep 2008

Answer

If you answer a question - or have a question you asked answered by someone - please remember to edit the page and set the status to answered. The status is in a drop-down list below the edit box.

Did you try ExcelImportExportPlugin yet?

-- FranzJosefGigler - 22 Sep 2008

Franz, that is the way to get the spreadsheet data into twiki, but where does that data go for the Skills plugin? I can't find a single topic that holds the skills, so where are they held, and how can I get the imported spreadsheet data into the skills plugin format?

-- HelenJohnstone - 22 Sep 2008

The skills are stored in the work area in a text file. The format is category:skill1,skill2,..., with categories seperated with a new line. For example:

MsOffice:Word,Excel,PowerPoint,Outlook,Project

The values are stored in the users home page (i.e Main.AndrewRJones) as meta data in the format %META:SKILLS{name="Word" category="MsOffice" rating="2"}%. You can see the meta data of the topic by appending ?raw=debug to the url.

As far as i know nothing exists that will do what you want, so you will either have to create all the the skills manually or write a custom script to do it for you if you are ok with Perl. Hope this helps.

-- AndrewRJones - 23 Sep 2008

Thanks Andrew.

-- HelenJohnstone - 23 Sep 2008