Database Related Questions - Why are more records counted then I expected?

When importing records, EZSurvey keeps track of the number of times users submit records. This is seen on surveys that have the user ID and password fields in the form. Fields IFMUID and IFMUID1 are used for tracking respondents and enabling the save and quit feature. Check the form for these fields, they are usually located at the end of the question list, and are a Hidden question type. When these fields are on the form, but not used to collect data, they remain blank in the database. EZSurvey sees these blank fields as being identical and only imports one record of the set. This is true any time multiple records have the same ID and password. If you did not use user ID and passwords in your form, you can safely delete these questions from the form. You can then re-build the database and re-import your web data. If you have the save and quit option selected on the Web form setup screen unselect it. Leaving this option selected will cause EZSurvey to re-create the user ID and password questions.

See also...