set starting member date

[andreon]

Hi,

how may I ingest a list of members, each one with its own starting membership date? Ingesting a list
is trivial, but how to set the starting memberships date (not by hand one by one!)?

Thanks, S.

[fasse]

Hi,

you can go to Own lists and there you can select the start date and end date of the membership. The following list will then show the start date of the selected role.

Fasse

[andreon]

Suppose you have 500 members, each one with a different starting date. Should I
make 500 lists and, for each of them, hand select the starting date? This is my
own case.

To me, it would be easier to write a (say csh) script that changes the value of the variable that
contain the date *if* I would know the variable name and the way to access (and modify) it! Is this possible?
In alternative, if you tell me how the date is recorded in the database backup, I can write a script,
change the dates, and the restore the backup (I suppose that this is possible).

Thanks, S.

[weissst]

Hello,

if you need to update the start dates, the best would be with an SQL statement.
you need to do the update in the Table: xxx_members

like:
Update xxx_members` set `mem_begin` = {d '2015-01-01'} WHERE `mem_rol_id` = 7 and `mem_usr_id` = 2
or
Update xxx_members` set `mem_begin` = {d '2015-01-01'} WHERE `mem_rol_id` = 7 and `mem_usr_id` in (2, 200, 203)

the mem_rol_id you need to find in the table xxx_roles
the mem_usr_id you need to find in the table xxx_users

xxx -> this is the prefix of you tables you set on install.

I hope this will help you a bit

br
Stefan