Custom App with Imported Data

David Lewis asked on October 31, 2023 17:36

Hey all, I am just starting out with Kentico and am writing a couple of custom apps (Only the building of the first app is discussed). I wanted to bounce requirements and the approach off of you to get feedback.

Here are the requirements

  • Ability for a user to create an account. Upon registration, they will be put into a role.
  • A new page that lists available applications. Applications are available depending on what roles have been assigned.
  • The application has three sets of data that will be provided through CSV that will need to be loaded into the system
  • Admins need the ability to Add/Edit the data
  • The Application will be built as a page in Kentico and utiize the data sets to create a reports for the user. The criteria for the report can be saved by the user to regenerate the report as needed.

Here is how I am thinking of handling the requirements

  • User Store
    • Configure an Azure Active Directory Instance as the User Store​
    • Build an OpenID connection from Kentico to Azure AD​
    • Create pages for Login and Registration ​
    • Users who register will be put into Roles based on some sort of criteria
  • Custom Data
    • Each data import will be similar in nature​
    • Create an Admin page to import the data.​
    • Use the Custom Table Data feature of Kentico to store data. ​
    • The Custom Table Data feature creates forms that can be used for listing, adding, and editing data.​
  • Applications Listing Page
    • The application listing page will be a page within the CMS.
    • Applications will be presented to the user based on the user’s roles​
    • A Custom Table Data will be used to store information about the various applications available and what roles are needed to view those applications.
  • First Application
    • The application will consist of two pages. A page to list reports created by the user and a page to generate reports
    • The generate reports page will utilize the custom data tables for the imported data to create a report based on the user-selected criteria.
    • When a report is generated the user can save the report. If saved, that report criteria data will be stored in a custom data table.
    • The listing page pulls data from the table just mentioned

Please poke holes and tell me where this approach is missing

Recent Answers


Brian McKeiver answered on November 2, 2023 14:24

Which version of Kentico are you planning to use for this?

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.