====== Software collections ====== * [[http://alternativeto.net/|Alternatives to Windows, Mac, Linux and online software]] * [[http://www.opennet.ru/opennews/art.shtml?num=42718|Эксперимент по проверке, читают ли код открытых проектов ]] * [[https://github.com/Igglybuff/awesome-piracy|A curated list of Awesome Piracy software]] ====== Software license ====== [[http://www.billthelizard.com/2012/05/which-open-source-license.html|{{ http://3.bp.blogspot.com/--EfX5P6Ny7Q/T6aSO_LdpNI/AAAAAAAAAgY/v-QFMmbP5As/s640/OSS+License.png|Which Open Source License?}}]] * [[habrahabr>118457|Наглядно о популярных Open Source лицензиях]] * [[wp>Comparison of free software licenses]] * [[http://choosealicense.com/licenses/|Choosing an OSS license doesn't need to be scary]] * [[https://softwareengineering.stackexchange.com/a/314908/34314|Reports of GPLv3 and AGPLv3 "virality" are greatly exaggerated]] ====== Hard drive ====== * [[http://alldup.de/en_download_alldup.php|AllDup]] -- remove or hardlink duplicates on the hard drive * [[habrahabr>230383|Чем забит мой жёсткий диск]] -- рисует «подушечную» древовидную карту (cushion treemap) выбранного раздела жёсткого диска ====== Collaboration ====== * [[http://minutes.io/]] for taking minutes notes * [[http://bigbluebutton.org/overview|BigBlueButton]] -- desktop sharing / organizing presentations * [[http://synergy-foss.org/|Synergy]] lets you easily share your mouse and keyboard between multiple computers on your desk. IP address to block Skype from updates: * 204.9.163.158 * 204.9.163.247 ====== [[wp>List of concept mapping and mind mapping software|Concept/mind software]] ====== * [[http://freemind.sourceforge.net/wiki/|Freemind]] * [[http://www.xmind.net/|XMind]] * [[http://blog.mindmup.com/p/documentation.html|MindMup]] -- a free, opensource, online mindmapping canvas. * [[http://rumapping.ru/category/mindmanager|MindManager blog]] ====== UML diagrams ====== [[http://www-01.ibm.com/software/awdtools/developer/datamodeler/features/|Rational Rose UML]] alternatives: * [[http://uml.sf.net/|umbrello]] -- a part of KDE from v2.0 * [[http://www.topcased.org/index.php?idd_projet_pere=52&Itemid=60|TopCased]] * [[http://argoeclipse.tigris.org/documentation/download.html|ArgoEclipse]] -- its incarnations seems to be a part of [[http://www.myeclipseide.com/htmlpages-func-display-pid-19.html|MyEclipse]] * [[http://staruml.sourceforge.net/|StarUML]] * [[https://eclipse.org/modeling/emf/|Eclipse Modelling]] * [[http://msug.vn.ua/blogs/akrakovetsky/archive/2010/06/13/uml-tools.aspx|Инструменты для рисования UML-диаграмм]] ====== DB modelling software ====== [[http://erwin.com/products/detail/ca_erwin_data_modeler_community_edition/|ErWin modeller]] alternatives: * [[googlecode>p/power-architect/|SQL Power Architect]] (also [[http://www.sqlpower.ca/page/architect|here]]) * [[http://symmetricds.codehaus.org/|SymmetricDS]] -- web-enabled, database independent, data synchronization/replication software. * [[http://liquibase.org/|LiquiBase]], [[http://opensource.replicator.daffodilsw.com/index.html|Daffodil Replicator]] -- OpenSource solutions for data integration, management and migration. ====== Google ====== * [[https://productforums.google.com/forum/#!topic/gmail/QoesgaEVTbE|Contact entry has
in notes]] and [[https://productforums.google.com/forum/#!topic/gmail/0J2tzjeLPD8|Contact entry has
in notes – Part 2]] describe the problems that ''
'' is automatically added to notes of contacts * To print to Google Cloud enabled printer from non-Google applications, download [[https://tools.google.com/dlpage/cloudprintdriver/eula.html|Google Cloud Print Driver]] ====== Geo ====== * [[habrahabr>268643|Обратный геокодер – скажи мне, где ты, и я скажу тебе, где ты]] ====== Panorama software ====== * [[SourceForge>hugin|Hugin]] -- Panorama photo stitcher ====== Charting software ====== [[http://office.microsoft.com/en-us/visio/|Visio]] alternatives are: * [[http://www.koffice.org/kivio/|Kivio]], which comes as a part of Koffice, which can be downloaded as a part of KDE(([[http://windows.kde.org/|KDE for Windows]] or [[http://kde-cygwin.sourceforge.net/kde3/index.php|Cygwin]])) * [[http://dia-installer.de/index_en.html|Dia for Windows]] * [[http://graphics.openoffice.org/|OpenOffice Draw]] * [[habrahabr>312460|ONLYOFFICE или Libre: о битве форматов и совместном редактировании]] * [[http://creately.com/|creatly]] -- create and collaborate on //online// diagrams (I find it the best among [[http://www.techmixer.com/online-flowchart-tools-to-create-flowchart-diagram/|other competitive products]]). * [[https://www.draw.io/|draw.io]] -- a free online diagram drawing application for workflow, BPM, org charts, UML, ER, network diagrams * [[http://www.clker.com/|Online free vector clip art collection]] * [[http://www.gliffy.com/|Gliffy]] -- online diagram software and flowchart software ===== SketchUp ===== === [[https://forums.sketchup.com/t/problems-with-the-follow-me-tool-just-deleting-the-object/15925|"Follow me" tool just deleting the object]] === The surface your are trying to clone is too small. Scale it up togather with the path, then apply "Follow me" tool, then scale it down. ===== Fusion 360 FAQ ===== * [[https://www.autodesk.com/shortcuts/fusion-360|Hotkeys]] * [[youtube>1nhcKn7Kt8w|3 ways to model 3D printed threads in Fusion 360]] === [[https://knowledge.autodesk.com/support/fusion-360/troubleshooting/caas/sfdcarticles/sfdcarticles/Cannot-save-file-in-Fusion-360.html|Clicking on "Save" button does nothing in Fusion 360]] === * Press Ctrl + Shift + S to force a recovery save. * Backup/copy ''%APPDATA%\Autodesk\Autodesk Fusion 360\\CrashRecovery'' folder. * Exit Fusion 360. * Restore the folder. * Start Fusion 360. * Use //File → Recover documents// to recover the documents. === [[https://toglefritz.com/import-an-stl-into-fusion-360-without-scaling-issues/|Import STL files without a scaling issue]] === * //File → New Design// * //Insert → Insert Mesh...// on the toolbar See also: * [[youtube>trGmi6IS5w4|Редактирование STL во Fusion 360]] === How to create intersection of a mesh with a plane? === * Install [[https://apps.autodesk.com/FUSION/ru/Detail/Index?id=5742637258089280352|Intersect Mesh Body]] addon. * Create a plain, create a sketch on the plain. * Invoke //Create → Project / Include → Intersect Mesh Body// ====== Office ====== * [[habrahabr>136520|On-the-fly Spell checking in MS Excel]] * [[https://personal.teamlab.com/|Online word processor]] * [[habrahabr>269301|Подводные камни в облаках, или проваленный тест онлайн-редакторов на docx-файле]] ==== Word Questions answered ==== ^ Action ^ Hotkey ^ | Open //Quick Style// pane | //Ctrl+Shift+S//; one can also see styles in [[http://wordfaqs.mvps.org/DisplayStyles.htm|Draft or Outline view]], if //File -> Options -> Advanced -> Display section -> Style area pane width in Draft and Outline views// is set to some non-zero value (e.g. 2cm) | | Increase / decrease font | //Ctrl+Shift+>// / //Ctrl+Shift+ - Select document sections to be included into TOC. - Create a bookmark for them (e.g. ''sections''). - Insert a field (//Insert -> Quick parts -> Field...// on the toolbar), select TOC and press //Field Codes//. - In the entry field type ''TOC \b sections''. Other [[https://wiki.openoffice.org/wiki/Writer/TOC|useful options]]: * ''\h'' create hyperlinks from TOC to corresponding sections. * ''\n'' don't generate page numbers. * ''%%\o "m-n"%%'' consider only sections of levels m-n (e.g. ''%%\o "3"%%'' will include only section headers of 3rd level). === [[http://www.howtogeek.com/76142/navigate-long-documents-in-word-2007-and-2010-using-bookmarks/|How to make bookmarks visible?]] === Enable //File -> Options -> Advanced -> Show document content section -> Show bookmarks//. ==== LibreOffice Calc Questions answered ==== === [[superuser>935099|Count number of cells that match certain criteria]] === Count number of cells with dates with month is January: ''=SUMPRODUCT(1*(MONTH(A1:A20)=1))''. Due to the fact that empty cells are treated as dates in December, the correct formulae for December will be ''%%=SUMPRODUCT((A2:A22<>"")*(MONTH(A2:A22)=12))%%''. === Calculate average for non-zero cells === ''%%=AVERAGEIF(C2:C13,"<>"&0,C2:C13)%%'' === [[stackoverflowa>19313486/267197|How to check if cell has a specific background color?]] === There is no direct way to determine (in a formula) what formatting has been applied to a cell, however user can define a macro that returns this information: ''%%=IF(CELL_BACKCOLOR(SHEET(); ROW(); 1) = 0; "I am black"; "I have another color")%%'' ====== Archivers ====== * [[http://forum.ru-board.com/topic.cgi?forum=5&topic=8076&start=800#5|Сравнение архиваторов на уровень сжатия и на скорость сжатия/разжатия на образе VHD файле]] (Rar, 7z, FreeArc) * [[https://github.com/mcmilk/7-Zip-zstd|Custom 7-zip package]] featuring [[https://github.com/facebook/zstd/|Zstandard]], [[https://github.com/google/brotli/|Brotli]] and some others compressors. As to {{7z_compression_test.xlsx|my measurements}}, LZMA2 is still the best compressor from the perspective of compression rate, however others are interesting because they provide better compression speed with minimal compression rate loss, see [[https://mcmilk.de/projects/7-Zip-zstd/#id0efc2e6be4c23b9a513d7ce0dcff8ed80e8912e7|Compression ratio vs compression speed chart]]. ====== Other software ====== * [[http://gnuwin32.sourceforge.net/packages/tiff.htm|TIFF for Windows]] * [[http://www.dessci.com/en/products/MathType/default.htm|MathType]] * [[http://www.tagspaces.org/|TagSpaces]] is an open source personal data manager. It helps you organize files with tags on every platform. * [[habrahabr>213211|Навыки написания шаблонов и работы в hex-редакторе 010 Editor — Часть I]] ====== Cygwin ====== === How to learn all packages the given package depends on? === The easiest way is to start ''setup.exe'' and let it download e.g. ''...path-to-download-folder\x86\setup.ini''. In ''setup.ini'' one can find this information: @ git ... requires: bash cygutils cygwin less libcurl4 libexpat1 libgcc1 libiconv2 libintl8 libopenssl100 libpcre1 openssh perl-Error perl-Scalar-List-Utils perl-TermReadKey perl_base rsync zlib0 See also [[superuser>1355636|How to print list of packages for which a given package is required in Cygwin?]] === [[stackoverflow>18654162|Enable native NTFS symbolic links for Cygwin]] === ''%%export CYGWIN="winsymlinks:native"%'' or ''%%export CYGWIN="winsymlinks:ativestrict"%%'' ====== CMS ====== Comparisons: * [[https://websitesetup.org/cms-comparison-wordpress-vs-joomla-drupal/|WordPress vs Joomla vs Drupal (Comparison)]] * [[https://www.csschopper.com/blog/joomla-vs-magento-a-detailed-comparison-to-choose-the-best/|Joomla vs. Magento: a detailed comparison to choose the best]] * [[https://aionhill.com/magento-vs-virtuemart-by-joomla|VirtueMart vs. Magento ‒ Which is better?]] * [[https://support.rackspace.com/how-to/cms-comparison-drupal-joomla-and-wordpress/|CMS comparison: Drupal, Joomla, and WordPress]] * [[https://www.sktthemes.net/fyi/cms-comparison-wordpress-joomla-drupal/|Top 3 CMS comparison WordPress vs Joomla vs Drupal. Which one should you select?]] * [[https://www.chillcreations.com/blog/22-joomla/190-joomla-virtuemart-vs-magento.html|Joomla! extensions done right]] * [[https://medium.com/@priya_81784/magento-vs-joomla-c58275a86242|Magento Vs Joomla]] * [[https://www.getapp.com/website-ecommerce-software/a/wordpress/compare/joomla-vs-drupal-vs-magento/|Wordpress vs Joomla vs Magento vs Drupal Comparison Chart]] * [[https://www.paypal.com/businessprofile/mytools/apiaccess/firstparty|PayPal API key]]: //My Profile → My selling tools → API access → NVP/SOAP API integration (Classic) → Manage API credentials// Websites with free images: * https://www.unsplash.com * https://www.fotor.com * https://www.picmonkey.com * https://www.pexels.com * https://www.pixabay.com Optimizing and promiting the website: * [[https://developers.google.com/web/tools/lighthouse/|Google Lighthouse]] Color palette: * https://akulakreative.com/blog/2012/10/a-pumpkin-inspired-color-palette ===== Wordpress / WooCommerce ===== * :DEL: Requires [[https://wpml.org/purchase/|WPML ($59 annualy)]] for CMS / e-Commerce multilingual support * [[youtube>vKBSrdKWb4Y|How To Create An eCommerce Website With Wordpress]] ===== Joomla ===== * [[youtube>CShaybl4uhE&list=PL43bbfiC0wjgobqlY5FetKCKo6kLmlFDL|Create a Complete Online Store With Joomla (series)]] * [[https://github.com/joomla/joomla-cms/issues/20879|"Cannot use object of type stdClass as array" error due to incompatibility with helix3]] Templates: * [[https://www.astemplates.com/free-joomla-template/896-et-bakery|ET Bakery]] * [[https://www.astemplates.com/free-joomla-template/594-at-bakery|AT Bakery]] * [[https://ltheme.com/project/lt-donut-free-responsive-joomla-bakery-template/|LT Donut]] ===== Magento ===== * [[youtube>u81X-sjgmQ0&list=PLtaXuX0nEZk9eL59JGE3ny-_GAU-z5X5D|Magento 2 Beginner Tutorials]] * [[youtube>k_R3U0feKF4|Magento security]] * [[youtube>mT23Ct8PPA8|Tips to make Magento faster]] [[youtube>_bWeXl6kX5U&t=690|Magento installation steps]]: # adduser magento --uid 1100 --group www-data # apt-get install php-bcmath php-curl # mkdir /var/www/magento # chown magento:www-data /var/www/magento # su - magento $ wget -nv -O - https://getcomposer.org/installer | php # mv composer.phar /usr/local/bin/composer # chown root:root /usr/local/bin/composer $ cd /var/www/magento $ composer create-project --repository=https://repo.magento.com/ magento/project-community-edition . 2.2.7 $ find var generated vendor pub/static pub/media app/etc -type f -exec chmod g+w {} + $ find var generated vendor pub/static pub/media app/etc -type d -exec chmod g+ws {} + $ chmod u+x bin/magento $ ./bin/magento setup:install \ --base-url=http://www.site.com/magento/ \ --db-host=localhost \ --db-name=magento \ --db-user=magento \ --db-password=magento \ --backend-frontname=admin \ --admin-firstname=admin \ --admin-lastname=admin \ --admin-email=admin@admin.com \ --admin-user=admin \ --admin-password=admin123 \ --language=en_US \ --currency=USD \ --timezone=America/Chicago \ --use-rewrites=1 $ ./bin/magento cron:install [[https://www.mageplaza.com/kb/magento-2-language-pack/|Language pack(s)]] installation steps: $ composer require mageplaza/magento-2-russian-language-pack:dev-master $ composer require mageplaza/magento-2-dutch-language-pack:dev-master ... $ ./bin/magento setup:static-content:deploy ru_RU nl_NL $ ./bin/magento indexer:reindex $ ./bin/magento cache:clean $ ./bin/magento cache:flush Install [[http://www.venustheme.com/theme/bakerop/|Ves Bakerop]] or [[http://magedemo.solwininfotech.com/magento2/freego/|FreeGo]] theme: :?: ==== [[youtubelist>PLQQUd8xe2EWXdy1CzsObG52Z4_-IKib0T|Magento 2 Extensions]] ==== * [[youtube>cqJOq6CmWWU|Two-Factor Authentication]]: $ composer require msp/twofactorauth $ ./bin/magento setup:upgrade * [[youtube>XMvZPrBFYDk|Social Login by Mageplaza]]: $ composer require mageplaza/magento-2-social-login $ ./bin/magento setup:upgrade * [[github>mageplaza/magento-2-instagram-feed|Instagram Feed Extension]]: $ composer require mageplaza/module-instagram-feed $ ./bin/magento setup:upgrade * [[github>mageplaza/magento-2-facebook-plugin|Facebook Plugin Extension]]: $ composer require mageplaza/module-facebook-plugin $ ./bin/magento setup:upgrade * [[github>mageplaza/magento-2-twitter-widget|Twitter Widget Extension]]: $ composer require mageplaza/module-twitter-widget $ ./bin/magento setup:upgrade * [[github>mageplaza/magento-2-banner-slider|Banner Slider Extension]]: $ composer require mageplaza/module-banner-slider $ ./bin/magento setup:upgrade * [[youtube>s50xV8z4Bu4|GDPR solution for Magento 2]]: $ composer require mageplaza/module-gdpr $ ./bin/magento setup:upgrade * [[youtube>DTNn-zXVDwE|Email Attachments by Fooman]]: $ composer require fooman/printorderpdf-m2 $ composer require fooman/emailattachments-m2 $ ./bin/magento setup:upgrade * [[youtube>asMT8AFaCU0|SEO Free Edition by Mageplaza]]: $ composer require mageplaza/magento-2-seo-extension $ ./bin/magento setup:upgrade * [[youtube>rsieUslN90Y|Blog by Mageplaza]]: $ composer require mageplaza/magento-2-blog-extension $ ./bin/magento setup:upgrade If you are using Production Mode (''./bin/magento deploy:mode:set production'') also run: $ ./bin/magento setup:static-content:deploy or (for multi-view store) $ ./bin/magento setup:static-content:deploy en_GB ru_RU nl_NL and then $ ./bin/magento setup:di:compile as last two steps. === [[https://support.weltpixel.com/hc/en-us/articles/115006483588-How-to-uninstall-and-remove-a-Magento-2-extension-manual-vs-composer-|How to uninstall the extension?]] === - Find out the //ExtensionProvider_ExtensionName// (e.g. //Mageplaza_Blog//) from either ''./bin/magento module:show'' output or from e.g. ''vendor/mageplaza/magento-2-blog-extension/composer.json''. - Run $ ./bin/magento module:disable Mageplaza_Blog --clear-static-content $ composer remove mageplaza/magento-2-blog-extension $ ./bin/magento setup:upgrade ====== Calibre ====== Alternatives: * [[https://gitlab.gnome.org/World/OpenPaperwork/paperwork/|Paperwork]] -- scan or import your documents and find them back in a snap === How to kill section separators that contain "* * *"? === ''epub'' needs to be pre-processed using the following regex: (\s*\r?\n)?\s*\* \* \*<\/subtitle>(\r?\n\s*)?(\r?\n\s*<(p><(strong|emphasis)|subtitle)>[^<]+<\/((strong|emphasis)><\/p|subtitle)>(\r?\n\s*)?)* === How to customize odd/even footer? ===

_AUTHOR_   _PAGENUM_

_PAGENUM_   _TITLE_

See also [[https://manual.calibre-ebook.com/conversion.html#headers-and-footers|Headers and Footers]].
=== How force the note to be rendered as end-of-page note (in page footer)? === :HELP: body[name="notes"] { display: none; } ====== Bug reports ====== {{ http://www.fsfe.org/campaigns/valentine-2010/vd-i-love-fs-150x90.png|I love FOSS}} * Bugs on [[https://bugzilla.mozilla.org/buglist.cgi?emailcc1=1;emailreporter1=1;emaillongdesc1=1;field0-0-0=bug_status;type0-0-1=equals;columnlist=bug_severity%2Cpriority%2Cassigned_to%2Cbug_status%2Cresolution%2Cproduct%2Cversion%2Ctarget_milestone%2Cshort_desc;field0-0-1=reporter;emailtype1=exact;query_format=advanced;emailassigned_to1=1;value0-0-1=dma_k%40mail.ru;email1=dma_k%40mail.ru;type0-0-0=notequals;value0-0-0=UNCONFIRMED|mozilla]]: 13 (owner), 23 (voted) * Bugs on [[http://openoffice.org/bugzilla/buglist.cgi?email2=dma_k&emailassigned_to1=1&emailcc2=1&emaillongdesc2=1&emailreporter2=1&emailtype1=substring&emailtype2=substring&field-1-0-0=reporter&field-1-0-1=cc&field-1-0-2=commenter&type-1-0-0=substring&type-1-0-1=substring&type-1-0-2=substring&value-1-0-0=dma_k&value-1-0-1=dma_k&value-1-0-2=dma_k&columnlist=priority%2Cassigned_to%2Creporter%2Cbug_status%2Cresolution%2Cproduct%2Ccomponent%2Cshort_desc|openoffice]]: 10 (owner) * Bugs on [[http://jira.codehaus.org/secure/IssueNavigator.jspa?reporterSelect=specificuser&reporter=dma_k&reset=update|codehaus]]: 5 (owner), 3 (voted) * Bugs on [[https://issues.sonatype.org/secure/IssueNavigator.jspa?reporterSelect=specificuser&reporter=dma_k&reset=update|sonatype]]: 1 (owner) * Bugs on [[https://issues.apache.org/jira/secure/IssueNavigator.jspa?reporterSelect=specificuser&reporter=dma_k&reset=update|apache]]: 2 (owner), 1 (voted) * Bugs on [[http://jira.springframework.org/secure/IssueNavigator.jspa?reporterSelect=specificuser&reporter=dma_k&reset=update|spring]]: 2 (owner) * Bugs on [[https://hibernate.onjira.com/secure/IssueNavigator.jspa?reporterSelect=specificuser&reporter=dma_k&reset=update|hibernate]]: 4 (owner) * Bugs on [[http://java.net/jira/secure/IssueNavigator.jspa?reporterSelect=specificuser&reporter=dma_k&reset=update|JAXB/JAX-WS/Hudson]]: 4 (owner) 2 (voted) * Bugs on [[https://issues.jenkins-ci.org/secure/IssueNavigator.jspa?reporterSelect=specificuser&reporter=dma_k&reset=update|jenkins]]: 1 (owner) * Bugs on [[http://bugs.debian.org/cgi-bin/pkgreport.cgi?correspondent=dma_k%40mail.ru|debian]]: 11 (owner), 3 (voted) * Bugs on [[http://bugs.farmanager.com/view_all_bug_page.php?reporter_id[]=361|farmanager]]: 1 (owner) * Bugs on [[http://www.mygrid.org.uk/dev/issues/secure/IssueNavigator.jspa?reporterSelect=specificuser&reporter=dma_k&reset=update|Taverna]]: 3 (voted) * Bugs on [[http://newsgroup.xnview.com/search.php?author=dma_k&sr=topics&fid[]=36|XnView]]: 3 (owner) * Bugs on [[http://www.virtualbox.org/query?reporter=dma_k&order=id|VirtualBox]]: 1 (owner) * Bugs on [[https://sourceforge.net/apps/trac/sourceforge/query?reporter=dma_k&order=id|SourceForge]]: 2 (owner) * Bugs on [[http://sourceforge.net/search/index.php?group_id=40728&type_of_search=artifact&submitted_by=dma_k&form_submit=Search|Open Babel]]: 5 (owner) * Bugs on [[https://bugzilla.novell.com/buglist.cgi?GoAheadAndLogIn=1&query_format=advanced&emailreporter1=1&emailcc1=1&email1=dma_k%40mail.ru&emailtype1=exact|SuSE (Novell)]]: 1 (owner), 1 (voted) * Bugs on [[http://www.google.com/support/forum/p/picasa/user?userid=07170847012002999265&hl=ru|picasa]]: 1 (owner), 1 (voted) * Bugs on [[googlecode>u/@UxNTS1BUAxBAWgZ1/updates|googlecode]]: 6 (owner) * Bugs on [[https://bugs.launchpad.net/~dma-k|launchpad]]: 2 (owner), 1 (voted) * Bugs on [[http://dev.vaadin.com/query?cc=^dma_k&or&reporter=dma_k&group=component&col=id&col=summary&col=reporter&col=type&col=status&col=priority&col=milestone&order=id|Vaadin]]: 15 (owner), 2 (voted) * Bugs on [[http://newsgroup.xnview.com/search.php?search_id=egosearch|xnview]] 6 (owner) \\ \\ {{thunderbird_80x15.png}} {{tag>7-zip}}