New Yearly Survey Discussions

[Ghislain Hachey]

Upload of surveys without a yearly record in table "Survey" fail. How do we make this use friendly. Currently I include the following in the initial data load.

INSERT INTO Survey (svyYear,svyPSAge,svyMonth,svyCensusDate,svyCollectionDate,svyClosed,svyDefaultPath) VALUES (2014,6,0,'2014-09-30 00:00:00.000','2014-11-30 00:00:00.000',0,NULL);
INSERT INTO Survey (svyYear,svyPSAge,svyMonth,svyCensusDate,svyCollectionDate,svyClosed,svyDefaultPath) VALUES (2015,6,0,'2015-09-30 00:00:00.000','2015-11-30 00:00:00.000',0,NULL);
INSERT INTO Survey (svyYear,svyPSAge,svyMonth,svyCensusDate,svyCollectionDate,svyClosed,svyDefaultPath) VALUES (2016,6,0,'2016-09-30 00:00:00.000','2016-11-30 00:00:00.000',0,NULL);

Not urgent but this needs an seamless approach to the users eyes.

[Ghislain Hachey]

Closing for now. Moving to workbook data collection.