[Trisquel-devel] Complete Trisquel web browser add-on repository upgrade

Mon Mar 30 10:44:30 CEST 2015

On 2015-03-30 10:29, Andrew 'Leny' Lindley wrote:
> From: David Englund/Hedlund <public at beloved.name>
> Subject: Re: [Trisquel-devel] Complete Trisquel web browser add-on repository upgrade
> Date: Mon, 30 Mar 2015 09:23:44 +0200
>
>> 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.
> _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
> Trisquel-devel at listas.trisquel.info
> http://listas.trisquel.info/mailman/listinfo/trisquel-devel

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.

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:

="{{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. 
[https://addons.mozilla.org/en-US/faq#preliminary Learn more]</li><br 
/>","")&IF(AR6>0,"<li>'''"&AR6&"'''</li>","")&IF(AK6>0,"<li>[https://addons.mozilla.org/en-US/firefox/addon/"&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)

="{{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. 
[https://addons.mozilla.org/en-US/faq#preliminary Learn more]</li><br 
/>","")&IF(AR7>0,"<li>'''"&AR7&"'''</li>","")&IF(AK7>0,"<li>[https://addons.mozilla.org/en-US/firefox/addon/"&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)

ouput:

{{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>}}

{{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>}}

that I then add to the free software directory. So its piece of pancake 
to make something similar to your needs.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listas.trisquel.info/pipermail/trisquel-devel/attachments/20150330/4284b9bf/attachment-0001.html>