<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">On 2015-03-30 10:29, Andrew 'Leny'
Lindley wrote:<br>
</div>
<blockquote
cite="mid:20150330.092938.425208418503334430.andrew@andrewlindley.co.uk"
type="cite">
<pre wrap="">From: David Englund/Hedlund <a class="moz-txt-link-rfc2396E" href="mailto:public@beloved.name"><public@beloved.name></a>
Subject: Re: [Trisquel-devel] Complete Trisquel web browser add-on repository upgrade
Date: Mon, 30 Mar 2015 09:23:44 +0200
</pre>
<blockquote type="cite">
<pre wrap="">Do you realize that asking me to add 300 add-ons by hand almost was
insulting after spending over a month to compile the list to Trisquel?
Its not complete yet, but in a few days it will be.
</pre>
</blockquote>
<pre wrap="">
_Sorry_ David, eyeballing it I thought it was a common set for both
Icecat and Abrowser as there are some already in the Abrowser list in
there. So I assumed the Abrowser delta was quite small, you already
knew the provenance and could extract it. Post the 300 when you have
them ready and someone will work out how to add the delta to the DB.
Leny
_______________________________________________
Trisquel-devel mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Trisquel-devel@listas.trisquel.info">Trisquel-devel@listas.trisquel.info</a>
<a class="moz-txt-link-freetext" href="http://listas.trisquel.info/mailman/listinfo/trisquel-devel">http://listas.trisquel.info/mailman/listinfo/trisquel-devel</a>
</pre>
</blockquote>
<br>
I apologize you, sure you got some point about that this project was
intended for IceCat in the first place. But I want to merge the list
back to Trisquel, hopefully this will be a very successful upgrade
for both Abrowser and IceCat users.<br>
<br>
Thank you for giving me support about the DB implementation. Can you
please let me know how how the SQL should look so I can format it
for you? Its very simple to do in LO Calc. These two formated lines:<br>
<br>
<br>
="{{Collection item|Package="&C6&IF(AJ6>0,"
("&6&")","")&"|Package note=<div style=""padding:
20px 20px 0px 20px;""><font style=""font-size:16pt;
font-style:italic"">"&C6&IF(AJ6>0,"
("&AJ6&")","")&" "&BE6&"</font><br
/>"&IF(AL6>0,"<font style=""font-size:8pt"">by
"&AL6&"</font><br /><br
/>","")&IF(E6>0,E6&"<br /><br
/>","")&IF(BA6>0,"["&BA6&" + Add to IceCat]<br
/><br
/>","")&"<ul>"&IF(AQ6>0,"<li>This add-on
has been preliminarily reviewed by Mozilla.
[<a class="moz-txt-link-freetext" href="https://addons.mozilla.org/en-US/faq#preliminary">https://addons.mozilla.org/en-US/faq#preliminary</a> Learn
more]</li><br
/>","")&IF(AR6>0,"<li>'''"&AR6&"'''</li>","")&IF(AK6>0,"<li>[<a class="moz-txt-link-freetext" href="https://addons.mozilla.org/en-US/firefox/addon/">https://addons.mozilla.org/en-US/firefox/addon/</a>"&AK6&"
Mozilla addon
page]</li>","")&IF(BB6>0,"<li>["&BB6&"
Ad-on
homepage]</li>","")&IF(BC6>0,"<li>["&BC6&"
Support
site]</li>","")&IF(BD6>0,"<li>[mailto:"&BD6&"
Support Email]</li>","")&IF(BE6>0,"<li>Version
"&BE6&"</li>","")&IF(BH6>0,"<li>Free
software license: ["&BH6&" "&BG6&"]</li>",
"<li>"&BG6&"</li>")&"<li>IceCat
notes:<ul><li>FSF inspected and approved software
version:
"&BJ6&"</li>"&IF(BM6>0,"<li>Add-on
version integrated in IceCat since version:
"&BM6&"</li>","")&IF(BN6>0,"<li>Notes:
"&BN6&"</li>","")&IF(BO6>0,"<li>Bugs
"&BO6&"</li>","")&IF(BP6>0,"<li>Wish
list:
"&BP6&"</li>","")&"</ul></ul></div>}}"&CHAR(10)<br>
<br>
<br>
="{{Collection item|Package="&C7&IF(AJ7>0,"
("&6&")","")&"|Package note=<div style=""padding:
20px 20px 0px 20px;""><font style=""font-size:16pt;
font-style:italic"">"&C7&IF(AJ7>0,"
("&AJ7&")","")&" "&BE7&"</font><br
/>"&IF(AL7>0,"<font style=""font-size:8pt"">by
"&AL7&"</font><br /><br
/>","")&IF(E7>0,E7&"<br /><br
/>","")&IF(BA7>0,"["&BA7&" + Add to IceCat]<br
/><br
/>","")&"<ul>"&IF(AQ7>0,"<li>This add-on
has been preliminarily reviewed by Mozilla.
[<a class="moz-txt-link-freetext" href="https://addons.mozilla.org/en-US/faq#preliminary">https://addons.mozilla.org/en-US/faq#preliminary</a> Learn
more]</li><br
/>","")&IF(AR7>0,"<li>'''"&AR7&"'''</li>","")&IF(AK7>0,"<li>[<a class="moz-txt-link-freetext" href="https://addons.mozilla.org/en-US/firefox/addon/">https://addons.mozilla.org/en-US/firefox/addon/</a>"&AK7&"
Mozilla addon
page]</li>","")&IF(BB7>0,"<li>["&BB7&"
Ad-on
homepage]</li>","")&IF(BC7>0,"<li>["&BC7&"
Support
site]</li>","")&IF(BD7>0,"<li>[mailto:"&BD7&"
Support Email]</li>","")&IF(BE7>0,"<li>Version
"&BE7&"</li>","")&IF(BH7>0,"<li>Free
software license: ["&BH7&" "&BG7&"]</li>",
"<li>"&BG7&"</li>")&"<li>IceCat
notes:<ul><li>FSF inspected and approved software
version:
"&BJ7&"</li>"&IF(BM7>0,"<li>Add-on
version integrated in IceCat since version:
"&BM7&"</li>","")&IF(BN7>0,"<li>Notes:
"&BN7&"</li>","")&IF(BO7>0,"<li>Bugs
"&BO7&"</li>","")&IF(BP7>0,"<li>Wish
list:
"&BP7&"</li>","")&"</ul></ul></div>}}"&CHAR(10)<br>
<br>
<br>
<br>
<meta http-equiv="CONTENT-TYPE" content="text/html;
charset=windows-1252">
<title></title>
<meta name="GENERATOR" content="LibreOffice 4.1.6.2 (Linux)">
<style>
<!--
BODY,DIV,TABLE,THEAD,TBODY,TFOOT,TR,TH,TD,P { font-family:"Liberation Sans"; font-size:x-small }
-->
</style>ouput:<br>
<br>
{{Collection item|Package=Add-on Compatibility Reporter|Package
note=<div style="padding: 20px 20px 0px 20px;"><font
style="font-size:16pt; font-style:italic">Add-on Compatibility
Reporter </font><br />Help make Firefox better. The
Add-on Compatibility Reporter enables you to report if the Firefox
add-ons that you're using are working properly.<br /><br
/><ul><li></li><li>IceCat
notes:<ul><li>FSF inspected and approved software
version: </li></ul></ul></div>}}<br>
<br>
{{Collection item|Package=Advanced Cookie Manager|Package
note=<div style="padding: 20px 20px 0px 20px;"><font
style="font-size:16pt; font-style:italic">Advanced Cookie Manager
</font><br />A must have tool for Web Developers and
Testers to Manage and monitor web cookies. Features List: Add,
Delete, Modify, Export / Backup, Import / Restore, Monitor
cookies<br /><br
/><ul><li></li><li>IceCat
notes:<ul><li>FSF inspected and approved software
version: </li></ul></ul></div>}}<br>
<br>
<br>
<br>
that I then add to the free software directory. So its piece of
pancake to make something similar to your needs.<br>
</body>
</html>