Foundation Administrator Tasks - Revision history

Eldy at 09:00, 17 January 2023

2023-01-17T09:00:43Z

← Older revision		Revision as of 09:00, 17 January 2023
Line 78:		Line 78:

	1) Run script rebuild_merge_pdf to create a PDF with all customer invoices (subscriptions) with payments during the quarter, on each bank account:		1) Run script rebuild_merge_pdf to create a PDF with all customer invoices (subscriptions) with payments during the quarter, on each bank account:
	<~~source~~ lang="bash">		<syntaxHighlight lang="bash">
	cd /home/dolibarr/asso.dolibarr.org/dolibarr		cd /home/dolibarr/asso.dolibarr.org/dolibarr
	scripts/invoices/rebuild_merge_pdf.php filter=payments 20130101 20130331 filter=bank CEP filter=excludethirdparties 962 lang=fr_FR regenerate=crabe		scripts/invoices/rebuild_merge_pdf.php filter=payments 20130101 20130331 filter=bank CEP filter=excludethirdparties 962 lang=fr_FR regenerate=crabe
	scripts/invoices/rebuild_merge_pdf.php filter=payments 20130101 20130331 filter=bank Caisse filter=excludethirdparties 962 lang=fr_FR regenerate=crabe		scripts/invoices/rebuild_merge_pdf.php filter=payments 20130101 20130331 filter=bank Caisse filter=excludethirdparties 962 lang=fr_FR regenerate=crabe
	</~~source~~>		</syntaxHighlight>

	Rename all generated files (found onto server into '''/home/dolibarr/asso.dolibarr.org/dolibarr_documents/facture/temp''') to replace "'''merged_payments_'''" with "'''Cotisations_'''"		Rename all generated files (found onto server into '''/home/dolibarr/asso.dolibarr.org/dolibarr_documents/facture/temp''') to replace "'''merged_payments_'''" with "'''Cotisations_'''"
Line 93:		Line 93:

	2) And to get invoices for subscriptions done onto paypal:		2) And to get invoices for subscriptions done onto paypal:
	<~~source~~ lang="bash">		<syntaxHighlight lang="bash">
	cd /home/dolibarr/asso.dolibarr.org/dolibarr		cd /home/dolibarr/asso.dolibarr.org/dolibarr
	scripts/invoices/rebuild_merge_pdf.php filter=payments 20130101 20130331 filter=bank Paypal filter=excludethirdparties 50 lang=fr_FR regenerate=crabe		scripts/invoices/rebuild_merge_pdf.php filter=payments 20130101 20130331 filter=bank Paypal filter=excludethirdparties 50 lang=fr_FR regenerate=crabe
	</~~source~~>		</syntaxHighlight>

	Rename all generated files (found onto server into '''/home/dolibarr/asso.dolibarr.org/dolibarr_documents/facture/temp''') to replace "'''merged_payments_'''" with "'''Cotisations_'''"		Rename all generated files (found onto server into '''/home/dolibarr/asso.dolibarr.org/dolibarr_documents/facture/temp''') to replace "'''merged_payments_'''" with "'''Cotisations_'''"
Line 105:		Line 105:

	3) Run script rebuild_merge_pdf to create PDF with customer invoices for generic Dolistore client, with payment during the quarter, on each bank account		3) Run script rebuild_merge_pdf to create PDF with customer invoices for generic Dolistore client, with payment during the quarter, on each bank account
	<~~source~~ lang="bash">		<syntaxHighlight lang="bash">
	cd /home/dolibarr/asso.dolibarr.org/dolibarr		cd /home/dolibarr/asso.dolibarr.org/dolibarr
	scripts/invoices/rebuild_merge_pdf.php filter=payments 20130101 20130331 filter=bank CEP filter=onlythirdparties 962 lang=fr_FR regenerate=crabe		scripts/invoices/rebuild_merge_pdf.php filter=payments 20130101 20130331 filter=bank CEP filter=onlythirdparties 962 lang=fr_FR regenerate=crabe
	scripts/invoices/rebuild_merge_pdf.php filter=payments 20130101 20130331 filter=bank Caisse filter=onlythirdparties 962 lang=fr_FR regenerate=crabe		scripts/invoices/rebuild_merge_pdf.php filter=payments 20130101 20130331 filter=bank Caisse filter=onlythirdparties 962 lang=fr_FR regenerate=crabe
	</~~source~~>		</syntaxHighlight>

	Rename all generated files (found onto server into '''/home/dolibarr/asso.dolibarr.org/dolibarr_documents/facture/temp''') to replace "'''merged_payments_'''" with "'''Ventes_Dolistore_via_CEP_ou_Caisse_'''"		Rename all generated files (found onto server into '''/home/dolibarr/asso.dolibarr.org/dolibarr_documents/facture/temp''') to replace "'''merged_payments_'''" with "'''Ventes_Dolistore_via_CEP_ou_Caisse_'''"
Line 120:		Line 120:

	4) Run export of bank receipt for month of quarter on each bank account		4) Run export of bank receipt for month of quarter on each bank account
	<~~source~~ lang="bash">		<syntaxHighlight lang="bash">
	cd /home/dolibarr/asso.dolibarr.org/dolibarr		cd /home/dolibarr/asso.dolibarr.org/dolibarr
	scripts/bank/export-bank-receipts.php CEP 201301 excel2007 lang=fr_FR		scripts/bank/export-bank-receipts.php CEP 201301 excel2007 lang=fr_FR
Line 131:		Line 131:
	scripts/bank/export-bank-receipts.php Caisse 201302 excel2007 lang=fr_FR		scripts/bank/export-bank-receipts.php Caisse 201302 excel2007 lang=fr_FR
	scripts/bank/export-bank-receipts.php Caisse 201303 excel2007 lang=fr_FR		scripts/bank/export-bank-receipts.php Caisse 201303 excel2007 lang=fr_FR
	</~~source~~>		</syntaxHighlight>

	Save all generated Excel files (found onto server into '''/home/dolibarr/asso.dolibarr.org/dolibarr_documents/bank/temp''') into directory		Save all generated Excel files (found onto server into '''/home/dolibarr/asso.dolibarr.org/dolibarr_documents/bank/temp''') into directory
Line 344:		Line 344:
	* To restore a VM after a corruption of server:		* To restore a VM after a corruption of server:

	<~~source~~ lang="bash">		<syntaxHighlight lang="bash">
	cd /var/lib/vz/dump		cd /var/lib/vz/dump
	vzrestore vzdump-openvz-200.tar 202		vzrestore vzdump-openvz-200.tar 202
	</~~source~~>		</syntaxHighlight>

	Once restoration is done, if this is a copy of an old VM, from Proxmox web interface, do:		Once restoration is done, if this is a copy of an old VM, from Proxmox web interface, do:

Eldy: /* Adding URL to pages */

2022-11-11T11:56:59Z

Adding URL to pages

← Older revision		Revision as of 11:56, 11 November 2022
Line 310:		Line 310:
	'''How:'''		'''How:'''

	There is some page to list companies that use Dolibarr or provide support on it (For example all subpages of page [[List of Dolibarr partners and providers]]. Visitor can add their record themself, except for their URLs because of antispam system (only white-list URLs are allowed).		There is some page to list companies that use Dolibarr or provide support on it (For example all subpages of page [https://partners.dolibarr.org List of Dolibarr partners and providers]. Visitor can add their record themself, except for their URLs because of antispam system (only white-list URLs are allowed).
	If a visitor send a mail to ask to add its URL, this is what to do:		If a visitor send a mail to ask to add its URL, this is what to do:
	* Go into the whitelist page: http://wiki.dolibarr.org/index.php/MediaWiki:Spam-whitelist		* Go into the whitelist page: http://wiki.dolibarr.org/index.php/MediaWiki:Spam-whitelist

Eldy: /* Send monthly report to the Dolibarr foundation team */

2020-01-28T08:33:17Z

Send monthly report to the Dolibarr foundation team

← Older revision		Revision as of 08:33, 28 January 2020
Line 363:		Line 363:
	...		...

	= ~~Send monthly report to~~ the Dolibarr foundation ~~team~~ =		= Report its time spent on the Dolibarr of foundation =
	'''When:''' At beginning of a new month for previous month		'''When:''' At beginning of a new month for previous month

Line 369:		Line 369:

	'''How:'''		'''How:'''
	Filling the reporting sheet of ~~actions:~~		Filling the reporting sheet of time spent.

	~~https://docs~~.~~google.com/spreadsheets/d/1UcCgPJQgg3BvQrn6TjjmUsvPkCyok2-lAm8Zzh1hurU/edit#gid=0~~

	= Annex =		= Annex =

Eldy: /* Admin Proxmox */

2020-01-28T08:32:34Z

Admin Proxmox

← Older revision		Revision as of 08:32, 28 January 2020
Line 330:		Line 330:

	= Admin Proxmox =		= Admin Proxmox =

			[[File::Warning]] There is no more Proxmox server.

	'''When:''' When there is a need for a new VM.		'''When:''' When there is a need for a new VM.

Line 355:		Line 358:
	* For wiki, if VM has a new url, go into database to set correct url into file LocalSettings.php		* For wiki, if VM has a new url, go into database to set correct url into file LocalSettings.php
	* If VM is a backup VM, disabled also root cron tasks		* If VM is a backup VM, disabled also root cron tasks

			= Admin Public Cloud =

			...

	= Send monthly report to the Dolibarr foundation team =		= Send monthly report to the Dolibarr foundation team =

Eldy: /* Specific development or taks on Dolibarr project */

2020-01-28T08:31:19Z

Specific development or taks on Dolibarr project

← Older revision		Revision as of 08:31, 28 January 2020
Line 316:		Line 316:
	* Answer EMail to tell user he can now add its URL into its card.		* Answer EMail to tell user he can now add its URL into its card.

	= Specific development or ~~taks~~ on Dolibarr project =		= Specific development or tasks on Dolibarr project =
	'''When:''' When there is time to work on this.		'''When:''' When there is time to work on this.

Eldy: /* Admin Proxmox */

2017-02-14T10:39:09Z

Admin Proxmox

← Older revision		Revision as of 10:39, 14 February 2017
Line 352:		Line 352:
	* Set memory of the new VM		* Set memory of the new VM
	* Log into ssh: Change apache virtual host to set new host name		* Log into ssh: Change apache virtual host to set new host name
	* For prestashop, if VM has a new url, go into database to set correct url into table '''ps_configuration''' and '''ps_shop_url'''		* For prestashop, if VM has a new url, go into database to set correct url into table '''ps_configuration''' (var PS_SHOP_DOMAIN, PS_SHOP_DOMAIN_SSL, CANONICAL_URL) and '''ps_shop_url'''
	* For wiki, if VM has a new url, go into database to set correct url into file LocalSettings.php		* For wiki, if VM has a new url, go into database to set correct url into file LocalSettings.php
	* If VM is a backup VM, disabled also root cron tasks		* If VM is a backup VM, disabled also root cron tasks

Eldy: /* Admin Proxmox */

2017-01-28T10:06:10Z

Admin Proxmox

← Older revision		Revision as of 10:06, 28 January 2017
Line 352:		Line 352:
	* Set memory of the new VM		* Set memory of the new VM
	* Log into ssh: Change apache virtual host to set new host name		* Log into ssh: Change apache virtual host to set new host name
	* For prestashop is VM has a new url, go into database to set correct url into table '''ps_configuration''' and '''ps_shop_url'''		* For prestashop, if VM has a new url, go into database to set correct url into table '''ps_configuration''' and '''ps_shop_url'''
			* For wiki, if VM has a new url, go into database to set correct url into file LocalSettings.php
			* If VM is a backup VM, disabled also root cron tasks

	= Send monthly report to the Dolibarr foundation team =		= Send monthly report to the Dolibarr foundation team =

Eldy: /* Admin Proxmox */

2017-01-28T09:41:11Z

Admin Proxmox

← Older revision		Revision as of 09:41, 28 January 2017
Line 351:		Line 351:
	* Change hostname on tab DNS of the VM.		* Change hostname on tab DNS of the VM.
	* Set memory of the new VM		* Set memory of the new VM
	* Change hostname with
	~~<source lang="bash">~~
	~~sudo hostname vmnewname~~
	~~vi /etc/hosts~~
	~~</source>~~
	* Log into ssh: Change apache virtual host to set new host name		* Log into ssh: Change apache virtual host to set new host name
			* For prestashop is VM has a new url, go into database to set correct url into table '''ps_configuration''' and '''ps_shop_url'''

	= Send monthly report to the Dolibarr foundation team =		= Send monthly report to the Dolibarr foundation team =

Eldy: /* Admin Proxmox */

2017-01-28T08:58:42Z

Admin Proxmox

← Older revision		Revision as of 08:58, 28 January 2017
Line 346:		Line 346:
	</source>		</source>

	Once restoration is done, if this is a copy of an old VM, from Proxmox web interface, do		Once restoration is done, if this is a copy of an old VM, from Proxmox web interface, do:
	* Add ip address on new VM with a new IP address		* Add ip address on new VM with a new IP address
	* Remove old ip address to avoid duplicate use by 2 different VMs.		* Remove old ip address to avoid duplicate use by 2 different VMs.
Line 356:		Line 356:
	vi /etc/hosts		vi /etc/hosts
	</source>		</source>
	* Change apache virtual host to set new host name		* Log into ssh: Change apache virtual host to set new host name

	= Send monthly report to the Dolibarr foundation team =		= Send monthly report to the Dolibarr foundation team =

Eldy: /* Admin Proxmox */

2017-01-27T21:56:50Z

Admin Proxmox

← Older revision		Revision as of 21:56, 27 January 2017
Line 356:		Line 356:
	vi /etc/hosts		vi /etc/hosts
	</source>		</source>
			* Change apache virtual host to set new host name

	= Send monthly report to the Dolibarr foundation team =		= Send monthly report to the Dolibarr foundation team =