Introduction

I'm writing a DNN-module for accessing FogBugz that will pull issues from the group related to the currently logged in DNN user on a Fogbugz server.

Using this code snippet I have created a Module for adding the related users to my DNN database programmatically from an XML file stored on the server. 
(It adds about 180 Users to the database)

The Fogbugz groups are identified in Fogbugz as unique number.

Question:

Now my question is: What is the best way to associate the Fogbugz group id with the related DNN user for purposes of displaying Fogbugz Issues in the portlet/module?

The method should be one that is familiar to Module Developers so that if anyone else needs to use this module eventually, they can do so in a recognizable manner.

I have several ways I can think of associating the users and the groups and these are as follows:

• Using a Fogbugz-DNN-module related table and adding to it a foreign-key to the aspnet_Users table using the fields: Application_Id, and/or User_id.
• Using the DNN-API to store Personalization Information for each portlet/module used by a user.
  •  That said I'm not entirely sure how to add Personalization Information to a module instance for a user when I'm adding users

Thank you, Andrew J. Leer