WodGuru Data Migration

	A	B	C	D	E
1	Notes
2	1. Prepare an empty CSV file, with name of your subdomain. If your WodGuru url is testgym.wod.guru, your file should be named as "testgym.csv".
3	2. Decide which columns your file will consist of based on the explanations below.
4	3. Check the Example card to see the required data formats.
5	4. Go to Migration file card and copy it to your empty csv file.
6	5. Fill in the data carefully :)
7	6. Make sure all the pass names you use in the file exist in your WodGuru account with the exact same name.
8	7. Send the file to anetaimb@wod.guru for validation.
9
10	Column name	Notes	What if empty	Uwaga! Wszystkie nazwy kolumn muszą pozostać w języku angielskim.
11	first_name	Letters only	One of those 3 options is required: - first_name + last_name - first_last_name - last_first_name	ATTENTION: Migration will be done in 2-4 working days from the moment of receiving from you FINAL file for migration.	UWAGA: Czas migracji od momentu otrzymania ostatecznego pliku to 2-4 dni roboczych.
12	last_name	Letters only
13	first_last_name	Letters only, space as separator
14	last_first_name	Letters only, space as separator
15	email	Email format
16	phone	Only numbers, "+", "-" sign
17	gender	”male”, ”female” or "other"	If no match or empty we set "other"
18	pass_name	Has to exist in wodguru with the exact same name,	We create guest account (with no membership attached)
19	pass_expiration_date	For time based memberships	If time based membership, we will set today
20	sessions_left	For session based memberships	If session based membership, we set 0
21	sessions_used	For session based memberships, can be sessions_left OR sessions_used	If session based membership, we set 0 as sessions left
22	card_code	For scanner, to detect client	Empty
23	address_1		Empty
24	address_2		Empty
25	city		Empty
26	postal_code		Empty
27	birthday		Empty
28	country		Empty
29	note_some_text	In notes you will see: some_text: row value you can have multiple rows like this
30	vatId	VAT id number	Empty
31	contractInstallment	no of current installment	Empty
32	cancellationInstallment	no of last installment after which the contract expires / if empty, the contract expires at the contract installment no
33	wallet
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100