Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
PinPics Posted November 18, 2023 Author Posted November 18, 2023 1 hour ago, teraßyte said: 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. 😄
teraßyte Posted November 18, 2023 Posted November 18, 2023 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 PinPics 1
PinPics Posted November 18, 2023 Author Posted November 18, 2023 11 minutes ago, teraßyte said: 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. 🙂
Recommended Posts