Module Dolimport - Revision history

Jtraulle at 14:20, 27 May 2020

2020-05-27T14:20:17Z

← Older revision		Revision as of 14:20, 27 May 2020
Line 1:		Line 1:
	<!-- BEGIN interlang links -->		<!-- BEGIN origin interlang links -->
	<!-- Do NOT edit this section		<!-- Do NOT edit this section
	Links below are automatically managed by PolyglotBot		Links below are automatically managed by PolyglotBot
	You can edit links on the English source page : Module_easy_dashboard -->		You can edit links on the English source page : Module_easy_dashboard -->
	~~[[en:Module_Dolimport]]~~
	[[fr:Module_Dolimport fr]]		[[fr:Module_Dolimport fr]]
	<!-- END interlang links -->		<!-- END interlang links -->

F.dufourg: /* Informations */

2020-05-27T11:49:22Z

Informations

← Older revision		Revision as of 11:49, 27 May 2020
Line 16:		Line 16:
	=Informations=		=Informations=
	{{TemplateModuleInfo		{{TemplateModuleInfo
	\|modulename=DOLIMPORT API		\|modulename=DOLIMPORT API & DOLIMPORT CSV
	\|editor=Florian DUFOURG		\|editor=Florian DUFOURG
	\|web=[http://dolitest.vps100069.mylogin.co/custom/bankimportapi/bankimportapiindex.php?id_bank=1&idmenu=6 demo]		\|web=[http://dolitest.vps100069.mylogin.co/custom/bankimportapi/bankimportapiindex.php?id_bank=1&idmenu=6 demo]

F.dufourg: F.dufourg moved page Dolimport to Module Dolimport

2020-05-27T11:48:52Z

F.dufourg moved page Dolimport to Module Dolimport

← Older revision

Revision as of 11:48, 27 May 2020

F.dufourg: /* Informations */

2020-05-27T10:16:45Z

Informations

← Older revision		Revision as of 10:16, 27 May 2020
Line 18:		Line 18:
	\|modulename=DOLIMPORT API		\|modulename=DOLIMPORT API
	\|editor=Florian DUFOURG		\|editor=Florian DUFOURG
	\|web=[http://dolitest.vps100069.mylogin.co demo]		\|web=[http://dolitest.vps100069.mylogin.co/custom/bankimportapi/bankimportapiindex.php?id_bank=1&idmenu=6 demo]
	\|webbuy={{LinkToPluginDownloadDoliStore\|keyword=dolimport_api}}		\|webbuy={{LinkToPluginDownloadDoliStore\|keyword=dolimport_api}}
	\|status=stable		\|status=stable
	\|prerequisites=		\|prerequisites=
	\|minversion=11.0.0		\|minversion=9.0.0
	\|note=		\|note=
	}}		}}

F.dufourg: F.dufourg moved page Dolimport api to Dolimport

2020-05-27T10:15:50Z

F.dufourg moved page Dolimport api to Dolimport

← Older revision

Revision as of 10:15, 27 May 2020

F.dufourg: Ajout wiki en Français

2020-05-27T10:10:03Z

Ajout wiki en Français

← Older revision		Revision as of 10:10, 27 May 2020
Line 1:		Line 1:
			<!-- BEGIN interlang links -->
			<!-- Do NOT edit this section
			Links below are automatically managed by PolyglotBot
			You can edit links on the English source page : Module_easy_dashboard -->
			[[en:Module_Dolimport]]
			[[fr:Module_Dolimport fr]]
			<!-- END interlang links -->

	[[Category:Complementary modules]]		[[Category:Complementary modules]]
	[[Category:Imports]]		[[Category:Imports]]

F.dufourg at 08:41, 8 May 2020

2020-05-08T08:41:34Z

F.dufourg at 08:39, 8 May 2020

2020-05-08T08:39:47Z

← Older revision		Revision as of 08:39, 8 May 2020
Line 52:		Line 52:
	*The period of time you want to show in the list of transaction		*The period of time you want to show in the list of transaction

	== Connect to QONTO API ==		==Connect to QONTO API==
	If you want to use the module with a csv file, you have nothing more to do.		If you want to use the module with a csv file, you have nothing more to do.
	To connect Qonto to Dolibarr, go to the bank account card in Dolibarr.		To connect Qonto to Dolibarr, go to the bank account card in Dolibarr.
Line 87:		Line 87:
	</div>The left section of this page allows to prepare the import of the CSV file. All the parameters are saved for the next import.		</div>The left section of this page allows to prepare the import of the CSV file. All the parameters are saved for the next import.

	# Select the date format as it is on the csv file		#Select the date format as it is on the csv file
	# Select how the amount (credit and debit) are shown in the csv file		#Select how the amount (credit and debit) are shown in the csv file
	# Select how the payment is defined in the csv file, if the payment mode is define so we need the translation between the Dolibarr payment mode and your bank statement csv file. The files below "translation" allow to explain how the payment mode are named in the csv file.		#Select how the payment is defined in the csv file, if the payment mode is define so we need the translation between the Dolibarr payment mode and your bank statement csv file. The files below "translation" allow to explain how the payment mode are named in the csv file.


Line 110:		Line 110:
	Sometime PHP limits the quantity of datas you can import, if a message shows that there is too much columns and rows, you should delete columns in the csv file or divide the csv file in many files.		Sometime PHP limits the quantity of datas you can import, if a message shows that there is too much columns and rows, you should delete columns in the csv file or divide the csv file in many files.

	== Generate Dolibarr elements from the list of transaction ==		==Generate Dolibarr elements from the list of transaction==
	If you already successfully load a csv file or if your QONTO bank account is connected to Dolibarr, you can see the list of the transaction doing click on the name of the bank account in the menu.		If you already successfully load a csv file or if your QONTO bank account is connected to Dolibarr, you can see the list of the transaction doing click on the name of the bank account in the menu.
	<br />		<br />
Line 121:		Line 121:

	</div>Select the icon depending of the type of element you want to generate.		</div>Select the icon depending of the type of element you want to generate.
	[[File:~~DOLIMPORT generation of vendor invoice~~.png]]<br />		[[File:DOLIMPORT_generation_of_vendor_invoice.png\|1200x1200px]]
			<br />

F.dufourg at 08:35, 8 May 2020

2020-05-08T08:35:27Z

← Older revision		Revision as of 08:35, 8 May 2020
Line 119:		Line 119:
	<div class="divforimgcentpercent">		<div class="divforimgcentpercent">
	[[File:DOLIMPORT List of transactions 2.png]]		[[File:DOLIMPORT List of transactions 2.png]]

	</div>Select the icon depending of the type of element you want to generate.		</div>Select the icon depending of the type of element you want to generate.
	[[File:DOLIMPORT generation of vendor invoice.png~~\|border~~]]<br />		[[File:DOLIMPORT generation of vendor invoice.png]]<br />

F.dufourg at 08:34, 8 May 2020

2020-05-08T08:34:50Z

← Older revision		Revision as of 08:34, 8 May 2020
Line 52:		Line 52:
	*The period of time you want to show in the list of transaction		*The period of time you want to show in the list of transaction

	==~~==Bank card==~~==		== Connect to QONTO API ==
	If you want to use the module with a csv file, you have nothing more to do.		If you want to use the module with a csv file, you have nothing more to do.

	To connect Qonto to Dolibarr, go to the bank account card in Dolibarr.		To connect Qonto to Dolibarr, go to the bank account card in Dolibarr.

Line 64:		Line 63:
	=====Extrafield ID API & KEY API setup=====		=====Extrafield ID API & KEY API setup=====
	Go to your QONTO account : [https://app.qonto.eu/ \| QONTO]		Go to your QONTO account : [https://app.qonto.eu/ \| QONTO]
			<br />
			[[File:QONTO_API_configuration_1.png\|alt=\|border\|left\|202x202px]]
	On the left menu of the QONTO web page, select "paramètres."		On the left menu of the QONTO web page, select "paramètres."
	~~[[File:QONTO API configuration 1.png\|200px\|QONTO paramètres]]~~
	~~<br clear=all>~~

			<br clear="all">
			[[File:QONTO_API_configuration_2.png\|alt=\|border\|left\|271x271px]]
	On the left menu select "intégration API".		On the left menu select "intégration API".
	~~[[File:QONTO API configuration 2.png\|200px\|QONTO intégration API]]~~
	<br clear=all>		<br clear="all">

	Now you can go back to Dolibarr and fill the ID and KEY API with the info found on the QONTO website.		Now you can go back to Dolibarr and fill the ID and KEY API with the info found on the QONTO website.

	===Menu===		==Menu==
	You can see this module in the left menu of the "bank" top menu.		You can see this module in the left menu of the "bank" top menu.
			If you choose the QONTO API option, only one link will appear in the menu, this is the list of transactions.

	If you ~~choose the~~ QONTO API ~~option~~, ~~only one link~~ will ~~appear~~ in the menu, ~~this is~~ the ~~list of~~ transactions.		If you are not using QONTO API (so you are using CSV import), 2 links will appears in the menu, one to import transaction from a csv file and an other to see and process the transactions.

	~~If you are not using QONTO API~~ (so you ~~are using~~ CSV ~~import~~)~~, 2 links will appears in~~ the ~~menu, one to import transaction from~~ a csv file ~~and an other~~ to ~~see and process~~ the ~~transactions~~.		==Import a file (only if you use CSV files)==
			Go to the page : "load a csv file".
			<div class="divforimgcentpercent">
			[[File:DOLIMPORT API Import csv page 2.png]]
			</div>The left section of this page allows to prepare the import of the CSV file. All the parameters are saved for the next import.

	~~===Import a~~ file~~===~~		# Select the date format as it is on the csv file
	Select a csv file ~~from~~ your bank ~~account and click upload button~~.		# Select how the amount (credit and debit) are shown in the csv file
	~~<div class=~~"~~divforimgcentpercent~~">		# Select how the payment is defined in the csv file, if the payment mode is define so we need the translation between the Dolibarr payment mode and your bank statement csv file. The files below "translation" allow to explain how the payment mode are named in the csv file.
	~~[[File:CaptureImportBankFromCsv3~~.~~PNG]]~~
	~~</div>~~
			The right section of this page show the csv statement already importes. You can delete the statement doing click on the trash bin icon.

	===Setting of the lines===		===Setting of the lines===
	Once your csv file is uploaded, select the category of each column (date of operation, date of value, amount, label, secondary label). ~~You can choose a category only once (except for~~ amount ~~categorie that can be credit and debit)~~. ~~Press~~ the ~~hide column button~~ to ~~make the view easier to read~~.		Once your csv file is uploaded, select the category of each column (date of operation, date of value, amount, label, secondary label).

			The fields operation date, label and amount are required, the other fields are optionnals.

			Uncheck the lines that you do not want to import (for example if there is a title line).
	<div class="divforimgcentpercent">		<div class="divforimgcentpercent">
	[[File:~~CaptureImportBankFromCsv1~~.~~PNG~~]]		[[File:DOLIMPORT API Import csv page 3.png]]
	</div>		</div>

	~~Choose for each line the categorie of the line (provider invoice, charge, VAT, salary, loan, customer invoice). Let the categorie blank for the line you don't want to import.~~

	Before to import give a name to the bank statement, it will help to reconcile.		Before to import give a name to the bank statement, it will help to reconcile.

	==~~=Select~~ the ~~statement=~~==		<br />
	In the ~~billing \| payment menu choose 'List~~ of ~~imported statements' and select~~ the bank ~~statement you want to transform as Dolibarr elements~~.		Sometime PHP limits the quantity of datas you can import, if a message shows that there is too much columns and rows, you should delete columns in the csv file or divide the csv file in many files.

			== Generate Dolibarr elements from the list of transaction ==
			If you already successfully load a csv file or if your QONTO bank account is connected to Dolibarr, you can see the list of the transaction doing click on the name of the bank account in the menu.
			<br />

	===Generate the elements (invoices, taxes, salaries,loan...)===		===Generate the elements (invoices, taxes, salaries,loan...)===
	~~In the process page you can now check the information and click import to~~ generate ~~the new~~ element (invoice, ~~VAT~~, ~~salary~~...).		To generate a Dolibarr element (invoice, expense report, payment, loan...) you have to make a click on an icon on the right of the click.

	<div class="divforimgcentpercent">		<div class="divforimgcentpercent">
	[[File:~~CaptureImportBankFromCsv2~~.~~PNG~~]]		[[File:DOLIMPORT List of transactions 2.png]]
	</div>		</div>Select the icon depending of the type of element you want to generate.
			[[File:DOLIMPORT generation of vendor invoice.png\|border]]<br />
	~~<br />If~~ you ~~prefer~~ to generate ~~a new file manually (without the help of the module), click the delete button~~.

	~~The customer invoices are not generate by this module, we considere the customer invoices are already made by the user and the user will help to link the~~ invoice ~~to the payment from the bank account~~.<br />

← Older revision		Revision as of 08:41, 8 May 2020
Line 52:		Line 52:
	*The period of time you want to show in the list of transaction		*The period of time you want to show in the list of transaction

	==Connect to QONTO API==		=Connect to QONTO API=
	If you want to use the module with a csv file, you have nothing more to do.		If you want to use the module with a csv file, you have nothing more to do.
	To connect Qonto to Dolibarr, go to the bank account card in Dolibarr.		To connect Qonto to Dolibarr, go to the bank account card in Dolibarr.
Line 58:		Line 58:
	Dolimport API automatically add 3 fields : ID API, KEY API and BANK API.		Dolimport API automatically add 3 fields : ID API, KEY API and BANK API.

	=====Extrafield BANK API setup=====		===Extrafield BANK API setup===
	Select QONTO as BANK API value (for now it is the only option).		Select QONTO as BANK API value (for now it is the only option).

	=====Extrafield ID API & KEY API setup=====		===Extrafield ID API & KEY API setup===
	Go to your QONTO account : [https://app.qonto.eu/ \| QONTO]		Go to your QONTO account : [https://app.qonto.eu/ \| QONTO]
	<br />		<br />
Line 75:		Line 75:
	Now you can go back to Dolibarr and fill the ID and KEY API with the info found on the QONTO website.		Now you can go back to Dolibarr and fill the ID and KEY API with the info found on the QONTO website.

	==Menu==		=Menu=
	You can see this module in the left menu of the "bank" top menu.		You can see this module in the left menu of the "bank" top menu.
	If you choose the QONTO API option, only one link will appear in the menu, this is the list of transactions.		If you choose the QONTO API option, only one link will appear in the menu, this is the list of transactions.
Line 81:		Line 81:
	If you are not using QONTO API (so you are using CSV import), 2 links will appears in the menu, one to import transaction from a csv file and an other to see and process the transactions.		If you are not using QONTO API (so you are using CSV import), 2 links will appears in the menu, one to import transaction from a csv file and an other to see and process the transactions.

	==Import a file (only if you use CSV files)==		=Import a file (only if you use CSV files)=
	Go to the page : "load a csv file".		Go to the page : "load a csv file".
	<div class="divforimgcentpercent">		<div class="divforimgcentpercent">
Line 110:		Line 110:
	Sometime PHP limits the quantity of datas you can import, if a message shows that there is too much columns and rows, you should delete columns in the csv file or divide the csv file in many files.		Sometime PHP limits the quantity of datas you can import, if a message shows that there is too much columns and rows, you should delete columns in the csv file or divide the csv file in many files.

	==Generate Dolibarr elements from the list of transaction==		=Generate Dolibarr elements from the list of transaction=
	If you already successfully load a csv file or if your QONTO bank account is connected to Dolibarr, you can see the list of the transaction doing click on the name of the bank account in the menu.		If you already successfully load a csv file or if your QONTO bank account is connected to Dolibarr, you can see the list of the transaction doing click on the name of the bank account in the menu.
	<br />		<br />