Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
November 18, 20231 yr Author Yeah. With 10k accounts, options #1 and #2 aren't really feasible. 😅 The only real option would be #3. A quick script to import a CSV file that contains only the account email and their joined date. It could quickly go through the data to update the date column in the members' table using the email. It should be easy enough for your developer in case you want to go ahead with it. Great! I've been chatting with him, and he totally thinks he can do that. Any chance to find out the field number for Registration Date that he would be importing? I'm not sure where to look for this, and the few places I've tried are obviously not it. 😄
November 18, 20231 yr Community Expert It's the joined column in the core_members table. The value must be a UNIX timestamp: https://www.unixtimestamp.com/ Example timestamp for the current time: 1700338973
November 18, 20231 yr Author It's the joined column in the core_members table. The value must be a UNIX timestamp: https://www.unixtimestamp.com/ Example timestamp for the current time: 1700338973 Thanks so much! Passing that on to him. 🙂
