Foundation Administrator Tasks: Difference between revisions

m
no edit summary
Tag: 2017 source edit
mNo edit summary
Tag: 2017 source edit
 
(2 intermediate revisions by the same user not shown)
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 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
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:
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 =