Creating the "News Articles" list in Sharepoint and enabling "Content approval"
Let's start by creating a new Sharepoint list where we are going to enter our news articles. This is the list that we are later going to export to a SQL Server database using SQList. Please follow the instructions ansd screenshots below to complete this exercise.
If you are familiar with this process the following steps will be obvious to you, if you are new to Sharepoint you will surely notice how easy and quick it is to create a list. Note also that we already have created the Sharepoint site that we are going to use in this exercise.
1.1 - From the root folder of the site, Click and then ; you will be presented with the screen below. Click on to create a blank list.
1.2 - This is the screen where we choose the name of the list; for this exercise, let's choose News Articles. Then click the button.
Important: the name given to the list at this stage will be used by SQList to generate the SQL table names; renaming a list at a later stage will result in the previous table (and data) be dropped and a brand new one be created. For more information, please read our knowledge base article How SQList Generates Table and Column Names.
This is all is needed to create a new list in Sharepoint. By default, a new list only contains the "Title" column and does not require content approval. For the sake of this exercise, we are going to enable content approval on the list as follow.
1.3 - Click followed by , you will be presented with a screen where several list configuration options are available. Select
1.4 - Choose on the section and save the changes.
At this point, all is left for our list to be ready is to add the necessary columns to store our article's detail.
