Fermé

date time conversion for excel

I would like someone to create an XSLT style sheet that transforms my data in csv-xls-xml format into Carrot format , as shown below in the example on this page here([url removed, login to view]).

The extract is given below

Clustering documents from XML feeds

To try Carrot2 clustering on documents or search results fetched from a remote XML feed, you can use the Carrot2 Document Clustering Workbench. As an example, we will cluster a news feed from BBC:

In the Search view of Carrot2 Document Clustering Workbench, choose XML source.

Set URL to your XML feed in the XML Resource field. Optionally, the URL can contain two special place holders that will be replaced with the Query and Results number you set in the search view.

In our example, we will use the BBC News RSS feed.

Create an XSLT style sheet that will transform the XML feed into Carrot2 format. For the news feed we can use the stylesheet shown in Figure 4.2. To add more colour to our results, the XSLT transform extracts thumbnail URLs from the feed and passes them to Carrot2 in a special attribute. Attributes that are a sequence of values can be embedded as shown in Figure 4.3.

Provide a path to the transformation style sheet in the XSLT Stylesheet field in the Medium section.

Press the Process button to see the results.

Figure 4.2

News feed XML to Carrot2 format transformation

<?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet version="1.0"

xmlns:xsl="[url removed, login to view]"

xmlns:media="[url removed, login to view]">

<xsl:output indent="yes" omit-xml-declaration="no"

media-type="application/xml" encoding="UTF-8" />

<xsl:template match="/">

<searchresult>

<xsl:apply-templates select="/rss/channel/item" />

</searchresult>

</xsl:template>

<xsl:template match="item">

<document>

<title><xsl:value-of select="title" /></title>

<snippet>

<xsl:value-of select="description" />

</snippet>

<url><xsl:value-of select="link" /></url>

<xsl:if test="media:thumbnail">

<field key="thumbnail-url">

<value type="[url removed, login to view]"

value="{media:thumbnail/@url}"/>

</field>

</xsl:if>

</document>

</xsl:template>

</xsl:stylesheet>

Figure 4.3

Document attribute that contains a list of values.

<field key="key">

<value><wrapper class="[url removed, login to view]">

<list>

<value value="value1"/>

<value value="value2"/>

</list>

</wrapper></value>

</field>

Compétences : CSS, HTML, PHP, Architecture Logicielle, XML

Voir plus : excel cluster date time, time conversion excel, excel carrot2, wrapper application, style head, string match, remote excel, media match, match string, extract number string, excel special, application wrapper, application template excel, carrot2 excel, xml date conversion, manual style, xslt xml, xml excel, xml conversion, time sheet, mrss, java excel, index media, getting started, extracts

Concernant l'employeur :
( 0 commentaires ) Chennai, India

N° du projet : #1671793

3 freelance ont fait une offre moyenne de 412 $ pour ce travail

buraqtech

Check your PMB for details!!!

485 $ USD en 5 jours
(64 Commentaires)
7.5
ferenckv

Hello! I have very much experience in xslt transformations. Please see pmb for details.

450 $ USD en 7 jours
(6 Commentaires)
4.7
thaongocnguyen

With experience in processing XML and an ability to work with Carrot, I believe I can do your project well.

300 $ USD en 5 jours
(0 Commentaires)
0.0