I have an old site running on DNN 5.06.02 that I'm in the process of upgrading to 7.4.1.  I never could get the old site staged locally on webmatrix and since there were so many changes to be made I decided to just rebuild it from scratch and import all the data from the old site.  Everything was going well until I got to trying to transfer over the users image data.  It appears that  each user has a folder created in the Portals/0/Users folder which contains a number, with one or more nested folders under that.  For example Users/002/02/2, with the final subfolder being where uploaded image files are actually stored.  The problem is how do you migrate this data to a new installation, given that DNN auto-generates the folder names and there does not appear to be any logic to the numbers that are used.  Since the folder numbers do not correspond to the UserID column of the Users table, how can I programmatically determine which folders are associated with which users?  I can not find any data in the tables which relate users to their respective upload folders.  This folder scheme really makes it hard to port data over, since now I have to write a program that creates folders with the appropriate names, which I can't even do without documentation on how these names are generated.

Another thing I don't understand is what the numbers stored in the PropertyValue column of the UserProfile table for photo uploads represents.  When the user adds a photo to their profile, the UserProfile entry just contains a number rather than the file name of the photo that was uploaded.  How does this map to the actual image file?