I have been given an excel file by a client with upwards of 500 user records that was exported from another system. We need to create a farcry user for each record for access to a bulletin board and member's only section. I am going to create a script to read the file and insert the data but I wanted to check with other developers before doing so to make sure I'm on the right track. I included 2 attachments (members1.xls) which is the file I was given from the client. All records were removed for privacy reasons but the fields are there so you can see what I'm working with. The other file is farcry_user_import.xls which describes the 3 tables that I will be inserting data into. In the 2nd file, anything inside of a < > indicates data that will be coming from the members excel file. Anything else will either be left out if the field allows null values or will be inserted expressly.
I already have a group and group policy set up for this called Site Members which is a copy of Anonymous. This allows me to set branch specific permissions in the site tree without granting webtop access. The three tables I'm looking at inserting data into are dmUser, dmUserToGroup and dmProfile. If anyone can take a look at this and let me know if I'm the right track I'd really appreciate it. Also, if anyone has had to do this in the past and has any ideas that might help, I'd appreciate that as well. For reference my environment is the following: IIS, FC 3.0.2, MSSQL 2000 and CF 7.0.2 Thank you in advance! _____ Jake Churchill CF Webtools 11204 Davenport, Ste. 200b Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
farcry_user_import.xls
Description: MS-Excel spreadsheet
members1.xls
Description: MS-Excel spreadsheet
