Manage Client Feed Settings MSA-220

Categories, and keywords for each client comes directly from XML file imported in the system via the “Feed Uploader”. Categories are retrieved from the parses pname field in the xml. Each client settings will be stored inside the database in following tables with following fields: Table name: client_settings

  • Id (int)
  • client_id(int)
  • Type ( category,keyword, or state)
  • setting id
  • Category(varchar) - Include comment in table definition that this is populated with pname.
  • IsFrontActive (tinyint)
  • isMailActive (tinyint)

Table name: user_settings

  • Id (int)
  • User_id(int)
  • Category(varchar) - Include comment in table definition that this is populated with pname.
  • IsFrontActive (tinyint)
  • isMailActive (tinyint)

By default, each profile match(category) or keyword that will be matched to each client, via feed parser, should be imported and always to be set active.

By default, all “states” will be set as active. This means that each client will see documents for all states. Once user requested for or staff member decide to, he can disable some of states, meaning that document associated with those states won’t be accessible for that particular client.

All bills (legislations, regulation and hearings) that comes with XML file have state “filed /column” are filled in with abbreviations of all the US states (including Alaska, Hawaii, District of Columbia and Puerto Rico) and plus they can have a value of US. Value of “US” means that this bill is federal level bill. The system feature will allow the staff role to enable or disable certain(categories), profile keywords and state by setting them inactive or active for each particular user. For each setting, a staff role will be able to set 2 possibilities of options:

  • Setting mail active/inactive – This setting is only used for the “daily” and “weekly” digest emails. It is not used for email notifications.
  • Setting frontend active/inactive – meaning that the bills will be presented inside the legislation dashboard view (map and list view). This setting also is used for deciding if a notification should be sent (by email), meaning that if frontend set to active a notification about
  • prioritizing,
  • notes added will be send to client about that category.