Examples of data files ready for uploading

Here is several examples of records in a formatted data file that are ready to be uploaded. Check the FDSR System Fields Table to see the description of each field.

 

To be uploaded correctly, the files must contain no spaces between the commas that separate fields, and no carriage returns.

 

You may save the formatted data files either in Notepad as a .txt file, or in Excel as a .csv file and be uploaded to the FDSR system.

 

Example of a formatted CIHR SoA data file:

1,A,Baker,Lorie,H,234567,2005-03-15,2005-03-31,BCD234,123456,13.13,14.14,15.15,0,0,0,16.16,17.17,18.18,19.19,20.2,21.21,22.22,23.23,24.24,25.25,26.26,27.27,28.28,29.29,30.3,31.31,32.32,33.33,34.34,35.35,36.36,37.37,38.38

Example of a formatted NSERC SoA data file:

2,F,Aman,Abdur,F,123456,2005-03-15,2005-03-31,ABC123,RGPIN,1234567,2002,13.13,14.14,15.15,0,0,0,16.16,17.17,18.18,19.19,20.20,21.21,22.22,23.23,24.24,25.25,26.26,27.27,28.28,29.29,30.3,31.31,32.32,33.33,34.34,35.35,36.36,37.37,38.38

Example of a formatted NSERC GRF SoA data file:

2,F,Schmoe,Joe,F,995522,2006-03-15,2006-03-31,ABC123,GRF,0,2002,13.13,14.14,15.15,0,0,0,16.16,17.17,18.18,19.19,20.20,21.21,22.22,23.23,24.24,25.25,26.26,27.27,28.28,29.29,30.3,31.31,32.32,33.33,34.34,35.35,36.36,37.37,38.38

Example of a formatted SSHRC SoA data file:

3,A,Cross,Sylvie,J,345678,2005-03-15,2005-03-31,CDE345,410,1234,2001,13.13,14.14,15.15,0,0,0,16.16,17.17,18.18,19.19,20.2,21.21,22.22,23.23,24.24,25.25,26.26,27.27,28.28,29.29,30.3,31.31,32.32,33.33,34.34,35.35,36.36,37.37,38.38

Example of a formatted SSHRC GRF SoA data file:

3,F,Schmoe,Josepha,F,995522,2006-03-15,2006-03-31,CDE345,0,0,2006,13.13,14.14,15.15,0,0,0,16.16,17.17,18.18,19.19,20.2,21.21,22.22,23.23,24.24,25.25,26.26,27.27,28.28,29.29,30.3,31.31,32.32,33.33,34.34,35.35,36.36,37.37,38.38

Examples of a formatted NCE SoA data file:

5,A,LastName1,FirstName1,I1,6666,2008-09-02,2009-03-31,UNIVID1,NCE,10000,2009,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,CAN

 

NCE,A,LastName2,FirstName2,I2,7777,2008-01-13,2009-03-31,UNIVID2,NCE,7000,2009,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,MITACS