From efba7fa663e613518fca3d9d973bf6b87d911edf Mon Sep 17 00:00:00 2001
From: Michael Hoennig <michael@hoennig.de>
Date: Fri, 28 Oct 2022 17:13:19 +0200
Subject: [PATCH] csv-test-import-files

---
 src/test/resources/migration/share-transactions.csv |    5 +++++
 src/test/resources/migration/sepa-mandates.csv      |    3 +++
 src/test/resources/migration/business_partners.csv  |    4 ++++
 src/test/resources/migration/contacts.csv           |    5 +++++
 src/test/resources/migration/asset-transactions.csv |    5 +++++
 5 files changed, 22 insertions(+), 0 deletions(-)

diff --git a/src/test/resources/migration/asset-transactions.csv b/src/test/resources/migration/asset-transactions.csv
new file mode 100644
index 0000000..d740af6
--- /dev/null
+++ b/src/test/resources/migration/asset-transactions.csv
@@ -0,0 +1,5 @@
+member_asstr_id;	bp_id;	date;		action;		amount
+33443;		7;	2000-12-06;	PAYMENT;	1280
+33451;		10;	2000-12-06;	PAYMENT;	128
+33701;		7;	2005-01-10;	PAYMENT;	2560
+33810;		10;	2016-12-31;	PAYBACK;	128
diff --git a/src/test/resources/migration/business_partners.csv b/src/test/resources/migration/business_partners.csv
new file mode 100644
index 0000000..f21cab8
--- /dev/null
+++ b/src/test/resources/migration/business_partners.csv
@@ -0,0 +1,4 @@
+bp_id;	member_id;	member_code;	member_since;	member_until;	member_role;	author_contract;nondisc_contract;	free;	exempt_vat;	indicator_vat;	uid_vat
+7;	10007;		mih;		2000-12-06;	;		Aufsichtsrat;	2006-10-15;	2001-10-15;		false;	false;		NET;		DE-VAT-007
+10;	10010;		xyz;		2000-12-06;	2015-12-31;	;		;		;			false;	false;		GROSS;
+12;	11012;		xxx;		2021-04-01;	;		;		;		;			true;	true;		GROSS;
diff --git a/src/test/resources/migration/contacts.csv b/src/test/resources/migration/contacts.csv
new file mode 100644
index 0000000..73a16af
--- /dev/null
+++ b/src/test/resources/migration/contacts.csv
@@ -0,0 +1,5 @@
+contact_id;	bp_id;	salut;	first_name;	last_name;	title;	firma;	co;	street;			zipcode;city;	country;	phone_private;		phone_office;		phone_mobile;	fax;		email
+71;		7;	Herr;	Michael;	Mellies;		;	;	;	Kleine Freiheit 50;	26524;	Hage;	DE;		;			+49 4931 123456;	+49 1522 123456;;		mih@example.org
+101;		10;	Frau;	Jenny;		Meyer;		Dr.;	JM e.K.;;	Waldweg 5;		11001;	Berlin; DE;		+49 30 7777777;		+49 30 8888888;		;		+49 30 9999999; jm@example.org
+102;		10;	Herr;	Andrew;		Meyer;		;	JM e.K.;;	Waldweg 5;		11001;	Berlin; DE;		+49 30 6666666;		+49 30 5555555;		;		+49 30 9999999; am@example.org
+121;		12;	;	Paule;		Schmidt;	;	Test PS;;	;			;	;	;		;			;			;		;		ps@example.com
diff --git a/src/test/resources/migration/sepa-mandates.csv b/src/test/resources/migration/sepa-mandates.csv
new file mode 100644
index 0000000..a97a875
--- /dev/null
+++ b/src/test/resources/migration/sepa-mandates.csv
@@ -0,0 +1,3 @@
+sepa_mandat_id;	bp_id;	bank_customer;	bank_name;	bank_iban;		bank_bic;	mandat_ref;	mandat_signed;	mandat_since;	mandat_until;	mandat_used
+234234;		7;	Michael Mellies;	ING Bank AG;	DE37500105177419788228;	INGDDEFFXXX;	MH12345;	2004-06-12;	2004-06-15;	;		2022-10-20
+235662;		10;	JM e.K.;	ING Bank AG;	DE49500105174516484892;	INGDDEFFXXX;	JM33344;	2005-06-282;	2005-07-01;	;		2016-01-18
diff --git a/src/test/resources/migration/share-transactions.csv b/src/test/resources/migration/share-transactions.csv
new file mode 100644
index 0000000..de5df6a
--- /dev/null
+++ b/src/test/resources/migration/share-transactions.csv
@@ -0,0 +1,5 @@
+member_share_id;bp_id;	date;		action;		quantity;	comment
+33443;		7;	2000-12-06;	SUBSCRIPTION;	20;		initial share subscription
+33451;		10;	2000-12-06;	SUBSCRIPTION;	2;		initial share subscription
+33701;		7;	2005-01-10;	SUBSCRIPTION;	40;		increase
+33810;		10;	2016-12-31;	UNSUBSCRIPTION;	22;		membership ended

--
Gitblit v1.9.3