Re: [topbraid-users] Exporting rich text definitions

2024-01-25 Thread Jan Campschroer
Hi Holger,

thank you for your actions. It's also good to know that ther isn't (yet) a 
solution to the problem. 

Regards, Jan

Op donderdag 25 januari 2024 om 12:39:20 UTC+1 schreef Jan Campschroer:

> Hello Holger,[image: Edg export excel 2.PNG]
> your right, the diacrits are handeld well. 
> This the source, the result using HTMLLtoText en the desired output
>
>
> Op donderdag 25 januari 2024 om 11:19:52 UTC+1 schreef Jan Campschroer:
>
>> [image: Edg export excel.PNG]
>>
>> Op donderdag 25 januari 2024 om 10:16:51 UTC+1 schreef Holger Knublauch:
>>
>>> Hi Jan,
>>>
>>> would you be able to clarify what feature you are referring to? I don't 
>>> think the Form panel has Excel export. Do you mean export from the results 
>>> of the SPARQL Query panel? That does not have Excel export, although it has 
>>> tab-separated values export.
>>>
>>> To make this precise I ran this query:
>>>
>>> prefix rdf: 
>>> SELECT *
>>> WHERE {
>>> BIND ("ldi"^^rdf:HTML AS ?shop) .
>>> BIND ((?shop) AS ?text) .
>>> }
>>>
>>> and exported it to TSV, producing
>>>
>>> ?shop ?text
>>> "ldi"^^ "Äldi"
>>>
>>> which at least indicates that convertHTMLToText has different output. 
>>> But it produces verbatim rendering of the first column, which looks 
>>> reasonable.
>>>
>>> Thanks
>>> Holger
>>>
>>>
>>> On 24 Jan 2024, at 3:15 pm, Jan Campschroer  wrote:
>>>
>>> Hello, i've got a related question. In the Excel-export from te 
>>> Form-panel there is stille some html-code (like xx  and 
>>>  instead of  *xx* and ë) is visible. Is there a WYSIWG Export to 
>>> Excel? 
>>> The function ui:convertHTMLToText has the same output. 
>>>
>>> Regards, Jan
>>>
>>> Op woensdag 3 maart 2021 om 18:42:11 UTC+1 schreef Kevin Guest:
>>>
 Hi Irene,
 I appreciate your taking the time to reply.
 I'll see if I can apply your suggestions.
 --Kevin

 On Tue, Mar 2, 2021 at 6:33 PM Irene Polikoff  
 wrote:

> Kevin,
>
> You can try the following SPARQL query
>
> SELECT ?term ?def
> WHERE {?term skos:definition ?d
> BIND (ui:convertHTMLToText(?d) AS ?def)   
> }
>
> Make sure to define the prefix for ui:
>
>
> Expand the area where prefixes are defined and start typing PREFIX 
> then space - you will get a list of known prefixes/namespaces to choose 
> from.
>
> Then, you could export results in TSV or XML.
>
> This conversion function is not perfect. It will remove bold text, 
> bullets, images, paragraph, but the hyperlink values will remain there. 
> There could also be some issues with the new lines in the TSV export.
>
> If we have time, we will see if we can improve it for 7.0.
>
> Regards,
>
> Irene Polikoff
>
> On Mar 2, 2021, at 2:33 PM, Kevin Guest  wrote:
>
> Hello,
>
> In one of our glossaries we use rich text format to populate 
> definition fields.  Sometimes I need to export a set of definitions, but 
> when I export to Excel or CSV the markup is included.  Is there a way to 
> export to Excel with just the text?  Some definitions are written in 
> paragraphs, have lists of values, some hyperlinks, bold text, etc., but I 
> don't need any of that -- just the text definitions.
>
> I haven't used SPARQL to do querying or other functions but I am open 
> to learning if that's the solution.
>
> Thanks,
> Kevin
>
> -- 
> You received this message because you are subscribed to the Google 
> Groups "TopBraid Suite Users" group.
> To unsubscribe from this group and stop receiving emails from it, send 
> an email to topbraid-user...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/topbraid-users/CAPQ9gY9vCq_BU1nZ7HJLzwzW%3Dh7dpHtYDADgJBPw32jXWO7TmQ%40mail.gmail.com
>  
> 
> .
>
>
>
> -- 
> You received this message because you are subscribed to the Google 
> Groups "TopBraid Suite Users" group.
> To unsubscribe from this group and stop receiving emails from it, send 
> an email to topbraid-user...@googlegroups.com.
>
 To view this discussion on the web visit 
> https://groups.google.com/d/msgid/topbraid-users/E61D2B96-3435-43D0-BA92-99A422DB3CAC%40topquadrant.com
>  
> 
> .
>

>>> -- 
>>> The topics of this mailing list include TopBraid EDG and related 
>>> technologies such as SHACL.
>>> To post to this group, send email to topbrai...@googlegroups.com
>>> --- 
>>>
>>> You 

Re: [topbraid-users] Exporting rich text definitions

2024-01-25 Thread Holger Knublauch
Ok, including the formatting such as the bold font is yet another requirement. 
I have added this to our ticket but I am not familiar with the code to see if 
that's realistic/easy with our Excel formatter.

Holger


> On 25 Jan 2024, at 12:39 pm, Jan Campschroer  wrote:
> 
> Hello Holger,
> your right, the diacrits are handeld well. 
> This the source, the result using HTMLLtoText en the desired output
> 
> 
> Op donderdag 25 januari 2024 om 11:19:52 UTC+1 schreef Jan Campschroer:
>> 
>> 
>> Op donderdag 25 januari 2024 om 10:16:51 UTC+1 schreef Holger Knublauch:
>>> Hi Jan,
>>> 
>>> would you be able to clarify what feature you are referring to? I don't 
>>> think the Form panel has Excel export. Do you mean export from the results 
>>> of the SPARQL Query panel? That does not have Excel export, although it has 
>>> tab-separated values export.
>>> 
>>> To make this precise I ran this query:
>>> 
>>> prefix rdf:  
>>> SELECT *
>>> WHERE {
>>> BIND ("ldi"^^rdf:HTML AS ?shop) .
>>> BIND ((?shop) AS ?text) .
>>> }
>>> 
>>> and exported it to TSV, producing
>>> 
>>> ?shop   ?text
>>> "ldi"^^  "Äldi"
>>> 
>>> which at least indicates that convertHTMLToText has different output. But 
>>> it produces verbatim rendering of the first column, which looks reasonable.
>>> 
>>> Thanks
>>> Holger
>>> 
>>> 
>>> 
 On 24 Jan 2024, at 3:15 pm, Jan Campschroer > wrote:
 
>>> 
 Hello, i've got a related question. In the Excel-export from te Form-panel 
 there is stille some html-code (like xx  and  
 instead of  xx and ë) is visible. Is there a WYSIWG Export to Excel? 
 The function ui:convertHTMLToText has the same output. 
 
 Regards, Jan
 
 Op woensdag 3 maart 2021 om 18:42:11 UTC+1 schreef Kevin Guest:
> Hi Irene,
> I appreciate your taking the time to reply.
> I'll see if I can apply your suggestions.
> --Kevin
> 
> On Tue, Mar 2, 2021 at 6:33 PM Irene Polikoff > 
> wrote:
>> Kevin,
>> 
>> You can try the following SPARQL query
>> 
>> SELECT ?term ?def
>> WHERE {?term skos:definition ?d
>> BIND (ui:convertHTMLToText(?d) AS ?def)   
>> }
>> 
>> Make sure to define the prefix for ui:
>> 
>> 
>> 
>> Expand the area where prefixes are defined and start typing PREFIX then 
>> space - you will get a list of known prefixes/namespaces to choose from.
>> 
>> Then, you could export results in TSV or XML.
>> 
>> This conversion function is not perfect. It will remove bold text, 
>> bullets, images, paragraph, but the hyperlink values will remain there. 
>> There could also be some issues with the new lines in the TSV export.
>> 
>> If we have time, we will see if we can improve it for 7.0.
>> 
>> Regards,
>> 
>> Irene Polikoff
>>> On Mar 2, 2021, at 2:33 PM, Kevin Guest > wrote:
>>> 
>>> Hello,
>>> 
>>> In one of our glossaries we use rich text format to populate definition 
>>> fields.  Sometimes I need to export a set of definitions, but when I 
>>> export to Excel or CSV the markup is included.  Is there a way to 
>>> export to Excel with just the text?  Some definitions are written in 
>>> paragraphs, have lists of values, some hyperlinks, bold text, etc., but 
>>> I don't need any of that -- just the text definitions.
>>> 
>>> I haven't used SPARQL to do querying or other functions but I am open 
>>> to learning if that's the solution.
>>> 
>>> Thanks,
>>> Kevin
>>> 
>>> -- 
>>> You received this message because you are subscribed to the Google 
>>> Groups "TopBraid Suite Users" group.
>>> To unsubscribe from this group and stop receiving emails from it, send 
>>> an email to topbraid-user...@googlegroups.com <>.
>>> To view this discussion on the web visit 
>>> https://groups.google.com/d/msgid/topbraid-users/CAPQ9gY9vCq_BU1nZ7HJLzwzW%3Dh7dpHtYDADgJBPw32jXWO7TmQ%40mail.gmail.com
>>>  
>>> .
>> 
>> 
>> -- 
>> You received this message because you are subscribed to the Google 
>> Groups "TopBraid Suite Users" group.
>> To unsubscribe from this group and stop receiving emails from it, send 
>> an email to topbraid-user...@googlegroups.com <>.
> 
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/topbraid-users/E61D2B96-3435-43D0-BA92-99A422DB3CAC%40topquadrant.com
>>  
>> .
 
 
>>> 
 -- 
 The topics of this mailing list include 

Re: [topbraid-users] EDG to other Graph/RDF Store sync

2024-01-25 Thread Holger Knublauch


> On 25 Jan 2024, at 12:20 pm, Akhilesh Kumar Chaurasiya 
>  wrote:
> 
> Hello,
> 
> I am trying implement the best way possible to sync EDG to down stream Neo4j 
> or RDF store
> using some automated trigger as soon as some one approves a change workflow.
> 
> I saw somewhere in documentation that there is some "Event Condition Action 
> Framework"
> 
> wondering how to leverage that.

If you're on 7.8 and later, there is now support to automatically map asset 
collections to SPARQL endpoints.

See 
https://archive.topquadrant.com/doc/latest/user_guide/remote/index.html#updating-remote-data
 and the whole page above it

This feature is on beta stage in 7.8 but will be final and stable in 8.0.

Which RDF store do you have in mind?


The alternative is, as you say, through ECA rules. You would need to define a 
dash:CommitScript as mentioned in

https://archive.topquadrant.com/doc/latest/ext/points.html#change-and-commit-scripts

This would allow you to write changes to Neo4J and I did an internal prototype 
of that a while ago.

Are these starting points sufficient? As usual, professional services or 
premium support could help you with technical details.

Holger


> 
> Any help will be highly appreciated
> 
> Thanks,
> Akhilesh
> This email may contain material that is confidential, privileged, or for the 
> sole use of the intended recipient.  Any review, disclosure, reliance, or 
> distribution by others or forwarding without express permission is strictly 
> prohibited.  If you are not the intended recipient, please contact the sender 
> and delete all copies, including attachments.
> 
> 
> -- 
> The topics of this mailing list include TopBraid EDG and related technologies 
> such as SHACL.
> To post to this group, send email to topbraid-users@googlegroups.com
> --- 
> You received this message because you are subscribed to the Google Groups 
> "TopBraid Suite Users" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to topbraid-users+unsubscr...@googlegroups.com 
> .
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/topbraid-users/62b3cd0a-3d63-4c83-9e8a-6b98850171ffn%40googlegroups.com
>  
> .

-- 
The topics of this mailing list include TopBraid EDG and related technologies 
such as SHACL.
To post to this group, send email to topbraid-users@googlegroups.com
--- 
You received this message because you are subscribed to the Google Groups 
"TopBraid Suite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to topbraid-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/topbraid-users/AA7EE34E-0403-4058-BCEF-C3C1BC729DB3%40topquadrant.com.


Re: [topbraid-users] Exporting rich text definitions

2024-01-25 Thread Jan Campschroer
Hello Holger,[image: Edg export excel 2.PNG]
your right, the diacrits are handeld well. 
This the source, the result using HTMLLtoText en the desired output


Op donderdag 25 januari 2024 om 11:19:52 UTC+1 schreef Jan Campschroer:

> [image: Edg export excel.PNG]
>
> Op donderdag 25 januari 2024 om 10:16:51 UTC+1 schreef Holger Knublauch:
>
>> Hi Jan,
>>
>> would you be able to clarify what feature you are referring to? I don't 
>> think the Form panel has Excel export. Do you mean export from the results 
>> of the SPARQL Query panel? That does not have Excel export, although it has 
>> tab-separated values export.
>>
>> To make this precise I ran this query:
>>
>> prefix rdf: 
>> SELECT *
>> WHERE {
>> BIND ("ldi"^^rdf:HTML AS ?shop) .
>> BIND ((?shop) AS ?text) .
>> }
>>
>> and exported it to TSV, producing
>>
>> ?shop ?text
>> "ldi"^^ "Äldi"
>>
>> which at least indicates that convertHTMLToText has different output. But 
>> it produces verbatim rendering of the first column, which looks reasonable.
>>
>> Thanks
>> Holger
>>
>>
>> On 24 Jan 2024, at 3:15 pm, Jan Campschroer  wrote:
>>
>> Hello, i've got a related question. In the Excel-export from te 
>> Form-panel there is stille some html-code (like xx  and 
>>  instead of  *xx* and ë) is visible. Is there a WYSIWG Export to 
>> Excel? 
>> The function ui:convertHTMLToText has the same output. 
>>
>> Regards, Jan
>>
>> Op woensdag 3 maart 2021 om 18:42:11 UTC+1 schreef Kevin Guest:
>>
>>> Hi Irene,
>>> I appreciate your taking the time to reply.
>>> I'll see if I can apply your suggestions.
>>> --Kevin
>>>
>>> On Tue, Mar 2, 2021 at 6:33 PM Irene Polikoff  
>>> wrote:
>>>
 Kevin,

 You can try the following SPARQL query

 SELECT ?term ?def
 WHERE {?term skos:definition ?d
 BIND (ui:convertHTMLToText(?d) AS ?def)   
 }

 Make sure to define the prefix for ui:


 Expand the area where prefixes are defined and start typing PREFIX then 
 space - you will get a list of known prefixes/namespaces to choose from.

 Then, you could export results in TSV or XML.

 This conversion function is not perfect. It will remove bold text, 
 bullets, images, paragraph, but the hyperlink values will remain there. 
 There could also be some issues with the new lines in the TSV export.

 If we have time, we will see if we can improve it for 7.0.

 Regards,

 Irene Polikoff

 On Mar 2, 2021, at 2:33 PM, Kevin Guest  wrote:

 Hello,

 In one of our glossaries we use rich text format to populate definition 
 fields.  Sometimes I need to export a set of definitions, but when I 
 export 
 to Excel or CSV the markup is included.  Is there a way to export to Excel 
 with just the text?  Some definitions are written in paragraphs, have 
 lists 
 of values, some hyperlinks, bold text, etc., but I don't need any of that 
 -- just the text definitions.

 I haven't used SPARQL to do querying or other functions but I am open 
 to learning if that's the solution.

 Thanks,
 Kevin

 -- 
 You received this message because you are subscribed to the Google 
 Groups "TopBraid Suite Users" group.
 To unsubscribe from this group and stop receiving emails from it, send 
 an email to topbraid-user...@googlegroups.com.
 To view this discussion on the web visit 
 https://groups.google.com/d/msgid/topbraid-users/CAPQ9gY9vCq_BU1nZ7HJLzwzW%3Dh7dpHtYDADgJBPw32jXWO7TmQ%40mail.gmail.com
  
 
 .



 -- 
 You received this message because you are subscribed to the Google 
 Groups "TopBraid Suite Users" group.
 To unsubscribe from this group and stop receiving emails from it, send 
 an email to topbraid-user...@googlegroups.com.

>>> To view this discussion on the web visit 
 https://groups.google.com/d/msgid/topbraid-users/E61D2B96-3435-43D0-BA92-99A422DB3CAC%40topquadrant.com
  
 
 .

>>>
>> -- 
>> The topics of this mailing list include TopBraid EDG and related 
>> technologies such as SHACL.
>> To post to this group, send email to topbrai...@googlegroups.com
>> --- 
>>
>> You received this message because you are subscribed to the Google Groups 
>> "TopBraid Suite Users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to topbraid-user...@googlegroups.com.
>>
>> To view this discussion on the web visit 
>> 

Re: [topbraid-users] Exporting rich text definitions

2024-01-25 Thread Jan Campschroer
[image: Edg export excel.PNG]

Op donderdag 25 januari 2024 om 10:16:51 UTC+1 schreef Holger Knublauch:

> Hi Jan,
>
> would you be able to clarify what feature you are referring to? I don't 
> think the Form panel has Excel export. Do you mean export from the results 
> of the SPARQL Query panel? That does not have Excel export, although it has 
> tab-separated values export.
>
> To make this precise I ran this query:
>
> prefix rdf: 
> SELECT *
> WHERE {
> BIND ("ldi"^^rdf:HTML AS ?shop) .
> BIND ((?shop) AS ?text) .
> }
>
> and exported it to TSV, producing
>
> ?shop ?text
> "ldi"^^ "Äldi"
>
> which at least indicates that convertHTMLToText has different output. But 
> it produces verbatim rendering of the first column, which looks reasonable.
>
> Thanks
> Holger
>
>
> On 24 Jan 2024, at 3:15 pm, Jan Campschroer  wrote:
>
> Hello, i've got a related question. In the Excel-export from te Form-panel 
> there is stille some html-code (like xx  and  instead 
> of  *xx* and ë) is visible. Is there a WYSIWG Export to Excel? 
> The function ui:convertHTMLToText has the same output. 
>
> Regards, Jan
>
> Op woensdag 3 maart 2021 om 18:42:11 UTC+1 schreef Kevin Guest:
>
>> Hi Irene,
>> I appreciate your taking the time to reply.
>> I'll see if I can apply your suggestions.
>> --Kevin
>>
>> On Tue, Mar 2, 2021 at 6:33 PM Irene Polikoff  
>> wrote:
>>
>>> Kevin,
>>>
>>> You can try the following SPARQL query
>>>
>>> SELECT ?term ?def
>>> WHERE {?term skos:definition ?d
>>> BIND (ui:convertHTMLToText(?d) AS ?def)   
>>> }
>>>
>>> Make sure to define the prefix for ui:
>>>
>>>
>>> Expand the area where prefixes are defined and start typing PREFIX then 
>>> space - you will get a list of known prefixes/namespaces to choose from.
>>>
>>> Then, you could export results in TSV or XML.
>>>
>>> This conversion function is not perfect. It will remove bold text, 
>>> bullets, images, paragraph, but the hyperlink values will remain there. 
>>> There could also be some issues with the new lines in the TSV export.
>>>
>>> If we have time, we will see if we can improve it for 7.0.
>>>
>>> Regards,
>>>
>>> Irene Polikoff
>>>
>>> On Mar 2, 2021, at 2:33 PM, Kevin Guest  wrote:
>>>
>>> Hello,
>>>
>>> In one of our glossaries we use rich text format to populate definition 
>>> fields.  Sometimes I need to export a set of definitions, but when I export 
>>> to Excel or CSV the markup is included.  Is there a way to export to Excel 
>>> with just the text?  Some definitions are written in paragraphs, have lists 
>>> of values, some hyperlinks, bold text, etc., but I don't need any of that 
>>> -- just the text definitions.
>>>
>>> I haven't used SPARQL to do querying or other functions but I am open to 
>>> learning if that's the solution.
>>>
>>> Thanks,
>>> Kevin
>>>
>>> -- 
>>> You received this message because you are subscribed to the Google 
>>> Groups "TopBraid Suite Users" group.
>>> To unsubscribe from this group and stop receiving emails from it, send 
>>> an email to topbraid-user...@googlegroups.com.
>>> To view this discussion on the web visit 
>>> https://groups.google.com/d/msgid/topbraid-users/CAPQ9gY9vCq_BU1nZ7HJLzwzW%3Dh7dpHtYDADgJBPw32jXWO7TmQ%40mail.gmail.com
>>>  
>>> 
>>> .
>>>
>>>
>>>
>>> -- 
>>> You received this message because you are subscribed to the Google 
>>> Groups "TopBraid Suite Users" group.
>>> To unsubscribe from this group and stop receiving emails from it, send 
>>> an email to topbraid-user...@googlegroups.com.
>>>
>> To view this discussion on the web visit 
>>> https://groups.google.com/d/msgid/topbraid-users/E61D2B96-3435-43D0-BA92-99A422DB3CAC%40topquadrant.com
>>>  
>>> 
>>> .
>>>
>>
> -- 
> The topics of this mailing list include TopBraid EDG and related 
> technologies such as SHACL.
> To post to this group, send email to topbrai...@googlegroups.com
> --- 
>
> You received this message because you are subscribed to the Google Groups 
> "TopBraid Suite Users" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to topbraid-user...@googlegroups.com.
>
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/topbraid-users/50579897-1cf5-4deb-9298-19184088f7acn%40googlegroups.com
>  
> 
> .
>
>
>

-- 
The topics of this mailing list include TopBraid EDG and related technologies 
such as SHACL.
To post to this group, send email to topbraid-users@googlegroups.com
--- 
You received 

[topbraid-users] EDG to other Graph/RDF Store sync

2024-01-25 Thread Akhilesh Kumar Chaurasiya
Hello,

I am trying implement the best way possible to sync EDG to down stream 
Neo4j or RDF store
using some automated trigger as soon as some one approves a change workflow.

I saw somewhere in documentation that there is some "Event Condition Action 
Framework"

wondering how to leverage that.

Any help will be highly appreciated

Thanks,
Akhilesh
-- 








This email may contain material that is confidential, privileged, 
or for the sole use of the intended recipient.  Any review, disclosure, 
reliance, or distribution by others or forwarding without express 
permission is strictly prohibited.  If you are not the intended recipient, 
please contact the sender and delete all copies, including attachments.

-- 
The topics of this mailing list include TopBraid EDG and related technologies 
such as SHACL.
To post to this group, send email to topbraid-users@googlegroups.com
--- 
You received this message because you are subscribed to the Google Groups 
"TopBraid Suite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to topbraid-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/topbraid-users/62b3cd0a-3d63-4c83-9e8a-6b98850171ffn%40googlegroups.com.


Re: [topbraid-users] Exporting rich text definitions

2024-01-25 Thread Holger Knublauch
Hi Jan,

would you be able to clarify what feature you are referring to? I don't think 
the Form panel has Excel export. Do you mean export from the results of the 
SPARQL Query panel? That does not have Excel export, although it has 
tab-separated values export.

To make this precise I ran this query:

prefix rdf:  
SELECT *
WHERE {
BIND ("ldi"^^rdf:HTML AS ?shop) .
BIND ((?shop) AS ?text) .
}

and exported it to TSV, producing

?shop   ?text
"ldi"^^  "Äldi"

which at least indicates that convertHTMLToText has different output. But it 
produces verbatim rendering of the first column, which looks reasonable.

Thanks
Holger


> On 24 Jan 2024, at 3:15 pm, Jan Campschroer  wrote:
> 
> Hello, i've got a related question. In the Excel-export from te Form-panel 
> there is stille some html-code (like xx  and  instead 
> of  xx and ë) is visible. Is there a WYSIWG Export to Excel? 
> The function ui:convertHTMLToText has the same output.
> 
> Regards, Jan
> 
> Op woensdag 3 maart 2021 om 18:42:11 UTC+1 schreef Kevin Guest:
>> Hi Irene,
>> I appreciate your taking the time to reply.
>> I'll see if I can apply your suggestions.
>> --Kevin
>> 
>> On Tue, Mar 2, 2021 at 6:33 PM Irene Polikoff > 
>> wrote:
>>> Kevin,
>>> 
>>> You can try the following SPARQL query
>>> 
>>> SELECT ?term ?def
>>> WHERE {?term skos:definition ?d
>>> BIND (ui:convertHTMLToText(?d) AS ?def)   
>>> }
>>> 
>>> Make sure to define the prefix for ui:
>>> 
>>> 
>>> 
>>> Expand the area where prefixes are defined and start typing PREFIX then 
>>> space - you will get a list of known prefixes/namespaces to choose from.
>>> 
>>> Then, you could export results in TSV or XML.
>>> 
>>> This conversion function is not perfect. It will remove bold text, bullets, 
>>> images, paragraph, but the hyperlink values will remain there. There could 
>>> also be some issues with the new lines in the TSV export.
>>> 
>>> If we have time, we will see if we can improve it for 7.0.
>>> 
>>> Regards,
>>> 
>>> Irene Polikoff
 On Mar 2, 2021, at 2:33 PM, Kevin Guest > wrote:
 
 Hello,
 
 In one of our glossaries we use rich text format to populate definition 
 fields.  Sometimes I need to export a set of definitions, but when I 
 export to Excel or CSV the markup is included.  Is there a way to export 
 to Excel with just the text?  Some definitions are written in paragraphs, 
 have lists of values, some hyperlinks, bold text, etc., but I don't need 
 any of that -- just the text definitions.
 
 I haven't used SPARQL to do querying or other functions but I am open to 
 learning if that's the solution.
 
 Thanks,
 Kevin
 
 -- 
 You received this message because you are subscribed to the Google Groups 
 "TopBraid Suite Users" group.
 To unsubscribe from this group and stop receiving emails from it, send an 
 email to topbraid-user...@googlegroups.com <>.
 To view this discussion on the web visit 
 https://groups.google.com/d/msgid/topbraid-users/CAPQ9gY9vCq_BU1nZ7HJLzwzW%3Dh7dpHtYDADgJBPw32jXWO7TmQ%40mail.gmail.com
  
 .
>>> 
>>> 
>>> -- 
>>> You received this message because you are subscribed to the Google Groups 
>>> "TopBraid Suite Users" group.
>>> To unsubscribe from this group and stop receiving emails from it, send an 
>>> email to topbraid-user...@googlegroups.com <>.
>> 
>>> To view this discussion on the web visit 
>>> https://groups.google.com/d/msgid/topbraid-users/E61D2B96-3435-43D0-BA92-99A422DB3CAC%40topquadrant.com
>>>  
>>> .
> 
> 
> -- 
> The topics of this mailing list include TopBraid EDG and related technologies 
> such as SHACL.
> To post to this group, send email to topbraid-users@googlegroups.com
> --- 
> You received this message because you are subscribed to the Google Groups 
> "TopBraid Suite Users" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to topbraid-users+unsubscr...@googlegroups.com 
> .
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/topbraid-users/50579897-1cf5-4deb-9298-19184088f7acn%40googlegroups.com
>  
> .

-- 
The topics of this mailing list include TopBraid EDG and related technologies 
such as SHACL.
To post to this group, send email to topbraid-users@googlegroups.com
--- 
You received this message because you are subscribed to the