NRDS

1. Try to keep the fields the same this will help with the queries
2. Rename The Copied Template
3. Make sure deactivated is unchecked

Add new fields you need in this example there is a community field

1. Copy an existing census template - 
 1. Try to keep the fields the same this will help with the queries
 2. Rename The Copied Template
 3. Make sure deactivated is unchecked
 
 
2. Add new fields you need in this example there is a community field

Add a column for the field - row and fill - copy and paste the value

Field - Row will be used to connect fields together

Create an aggregate of the field - row so that there is one field - row per line

1. You can use <a href="https://support.microsoft.com/en-us/office/about-power-query-in-excel-7104fbee-9e62-4cb9-a02e-5bfb1a6c536a" rel="nofollow noopener noreferrer" target="_blank">power query</a>
2. Copy and paste into the create table
3. 
 
4. 
 
5. 
 
6. 
 
7. 
 
8. 
 
9. 
 
10.

1. Open your excel sheet source
2. Add a column for the field - row and fill - copy and paste the value
3. Field - Row will be used to connect fields together

4. Save the sheet
5. Create an aggregate of the field - row so that there is one field - row per line 
 1. You can use <a href="https://support.microsoft.com/en-us/office/about-power-query-in-excel-7104fbee-9e62-4cb9-a02e-5bfb1a6c536a" rel="nofollow noopener noreferrer" target="_blank">power query</a>
 2. Copy and paste into the create table
 3. 
 
 4. 
 
 5. 
 
 6. 
 
 7. 
 
 8. 
 
 9. 
 
 10.

From NRDS Export the excel template from the new survey

1. Fill the project
2. Fill the Field-Row

1. Field row in the first column
2. Match other columns

1. From NRDS Export the excel template from the new survey

2. Fill the first page 
 1. Fill the project
 2. Fill the Field-Row
 
 
3. Copy and paste the second sheet
 1. Field row in the first column
 2. Match other columns

4. Save

Uncheck includes first repeating record

1. Uncheck survey id
2. Add field row
3. Uncheck columns that are empty on the import

1. Upload the sheet to the survey

2. 
 
3. Uncheck includes first repeating record

4. On the second sheet import 
 1. Uncheck survey id
 2. Add field row
 3. Uncheck columns that are empty on the import
 
 
5. Evaluate Import 

6. 
7. 
 
8. Import Surveys

Confirm the data has been imported

If you want to copy a census from one year to the next you can just copy the data

Click the edit button on the census you would like to copy 

Scroll down to the bottom of the form click copy

Update the form and remove any dates or other info to create a fresh form 

Confirm that there is a copy and the original

1. Navigate to the census list 

2. Click the edit button on the census you would like to copy 

3. You will be in edit mode

4. Scroll down to the bottom of the form click copy

5. Confirm Copy

6. 
    
7. Make sure you are on the copy 
    
8. Update the form and remove any dates or other info to create a fresh form 
   1. Start date
   2. End date
   3. QA/QC data

9. Save the copy
10. Confirm that there is a copy and the original


Prepare the template

Prepare the upload source document

Prepare the upload document

Import The Sheet

Copy Census from One Year to the Next