Foundation Administrator Tasks
Goal of this page is to describe different tasks the foundation administrator must work on.
Web site or Social networks
Post news frequently
When: When a topic to post a news come. Good frequency is at least one post per week. How:
- When a news is possible, post a news onto dolibarr.org and dolibarr.fr by creating a new article into joomla admin console of portals.
-> This will post also news onto social networks with hootsuite scheduler.
Example of major news: - new stable version of dolibarr. - happy new years. - summary of major event.
- Or for minor information, just post directly news/link/image onto hootsuite to push it on social networks.
Example of minor news: - new version of a module - stats - article found into press
Add new surveys
When: When a new idea of survey is found (Maximum, once a month)
Add a new survey into Joomla backoffice and post a news onto communication networks (social networks, mailing-list) to invite to vote.
Accountancy
Each quarter, the foundation must provide information for book keeper. This is how to find/generate such documents.
Conciliation
When: Once a month
Conciliate into Dolibarr at end of month bank account. For this:
- You can use scan of bank receipts and export of Paypal transactions.
- Create an invoice at end of each month to enter amount earned from dolistore onto CEP using generic customer "Client DoliStore CEP".
Generate documents for book keeper
When: Once a quarter, we must send to Dolibarr foundation book keeper, documents to make accountancy. For this:
1) Run script rebuild_merge_pdf to create a PDF with all customer invoices (subscriptions) with payments during the quarter, on each bank account:
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 Caisse filter=excludethirdparties 962 lang=fr_FR regenerate=crabe
Rename all generated files (found onto server into /home/dolibarr/asso.dolibarr.org/dolibarr_documents/facture/temp) to replace "merged_payments_" with "Cotisations_"
Save all generated PDF (found onto server into /home/dolibarr/asso.dolibarr.org/dolibarr_documents/facture/temp) into directory
/compta/Cotisations CEP directement
2) Run script rebuild_merge_pdf to create PDF with customer invoices for generic Dolistore client, with payment during the quarter, on each bank account
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 Caisse filter=onlythirdparties 962 lang=fr_FR regenerate=crabe
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_"
Save all generated PDF into directory
/compta/Ventes Dolistore CEP directement
3) And to get invoices for subscriptions done onto paypal:
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
Rename all generated files (found onto server into /home/dolibarr/asso.dolibarr.org/dolibarr_documents/facture/temp) to replace "merged_payments_" with "Cotisations_"
Save all generated PDF (found onto server into /home/dolibarr/asso.dolibarr.org/dolibarr_documents/facture/temp) into directory
/compta/Cotisations via Paypal
4) Run export of bank receipt for month of quarter on each bank account
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 201302 excel2007 lang=fr_FR
scripts/bank/export-bank-receipts.php CEP 201303 excel2007 lang=fr_FR
scripts/bank/export-bank-receipts.php CEPEPARGNE 201301 excel2007 lang=fr_FR
scripts/bank/export-bank-receipts.php CEPEPARGNE 201302 excel2007 lang=fr_FR
scripts/bank/export-bank-receipts.php CEPEPARGNE 201303 excel2007 lang=fr_FR
scripts/bank/export-bank-receipts.php Caisse 201301 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
Save all generated Excel files (found onto server into /home/dolibarr/asso.dolibarr.org/dolibarr_documents/bank/temp) into directory
/compta/Relevés bancaires
Note: Receipt for Paypal account is not provided to book keeper.
5) Then open each files (one file per month), and for each line with
> Transfert vers CEP
replace line with
> Transfert vers CEP (Cotisations X + Ventes Y)
X is sum of all subscriptions found for month, onto PDF generated at step 3, Y is (amount of line - X).
6) Go into GED module of dolibarr, section supplier invoices. Sort on date. Then download each file and save it into directory.
/compta/Factures fournisseurs (si obtenues)
7) Once all of this is done, copy directory /compta into a USB drive or create a zip file to send it by email to the foundation book keeper (email address is available into the gmail contact account of the foundation).
Assistance Dolistore
When: Once every two days
Read frequently mailbox "DoliStore - Asssitance à traiter"
If a member ask the dolistore 20% discount
- First check user is a valid member (subscription is up to date)
- If no ask user information about its last subscription to be sure.
- If yes, go onto dolistore.com backoffice and check member as an account.
- If no, ask hom to create a dolistore account first
- If yes, edit its account and add "Foundation Members" to its groups, and modify default group to "Foundation Members"
If a customer has a not valid link
When: When a buyer has paid a module but link he received did not works:
- Go onto Dolistore admin - Orders - and read state of order.
- If status is "payment accepted", send customer the file.
- If status is "payment accepted":
- If confirm email was received by customer or if paypal account payment was recorded into paypal dashboard, modify status into dolistore to "Payment accepted".
- If not, answer to ask customer the paypal payment email that confirm transaction. Do previous point, once received.
If a paypal dispute email was received
Just read dispute and try to find a solution.
Other email
Keep them into the inbox. A member of the foundation office will process them.
Note: Once processed, EMails found into "DoliStore - Assistance à traiter" must be moved to "Dolistore - Assistance traitées"
Promos Dolistore
When: Once a month
Once a month, choose a product with editor allow to make a 50% promotion. Setup dolistore to add promotion and post a news onto facebook - twitter - mailing list foundation.
Assistance Wiki
Adding URL to pages
When: When a email is received to be included into partner/user list.
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). 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
- Edit the page to add URL (using regexp syntax).
- Answer EMail to tell user he can now add its URL into its card.
Specific development
When: When we can enhance this.
This is specific works. For example:
- dolibarr fix bugs or tasks
- enhancements into dolistore module
Specific task
When: When required by the foundation.
This is example of specific works. For example:
- upgrade of software tools (joomla, mediawiki, tuleap, ...)
Admin Proxmox
- To create a new VM, click on create CT and choose image *.tar.tgz into
/var/lib/vz/template/cache