PinPics Posted November 18, 2023 Author Share 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. 😄 Link to comment Share on other sites More sharing options...
Nathan Explosion Posted November 18, 2023 Share Posted November 18, 2023 Link to comment Share on other sites More sharing options...
teraßyte Posted November 18, 2023 Share 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 Link to comment Share on other sites More sharing options...
PinPics Posted November 18, 2023 Author Share 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. 🙂 Link to comment Share on other sites More sharing options...
Recommended Posts