Can you post your source file, and an archive with the data project directory?

Dear Alexis,
thanks for your prompt reply.
Please find attached what you required.

Best,
Andrea

It's possible to get the options.xml file ?
Thanks
Rafael

Dear Alexis,
if I chose
id as Primary key and Pre-association as Code name it seems to recognize the students.
Please have a look at the attached screenshot.
Best regards,
Rafael

Dear Rafael,
thank very much for your prompt reply.
Please, find attached the file you requested.

As far as your test is concerned, I guess then there is some problem in my installation because I
was never able to get it associated even though Primary key "id" was selected and "Pre-association" chosen.

Hope we can find a solution together.

Thanks again, Andrea

Dear All,

the fact that Rafael was able to work out the association phase convinced me that I should have some problems with my project. So I cleaned it by deleting all those files which are created during the run, included sqlite archive.

Miraculously automatic association went through!

I had a look at the debug file generated before and after, and this it what changes in the relevant part:

%%%%%%%%%% BEFORE %%%%%%%%%

[ 7091, 0.22] Opening RW transaction for association [ASSA]...
[ 7091, 0.22] [ASSA] <-> association
[ 7091, 0.22] Annotate source has changed! Time=1571649153
[ 7091, 0.22] Preparing statement clearAuto
[ 7091, 0.22] Preparing statement preAssocCounts
[ 7091, 0.22] Closing transaction for association [ASSA]...
[ 7091, 0.22] [ASSA] X association
[ 6518, 29.77] END of input

%%%%%%%%%%% AFTER %%%%%%%%%%%%%%%

[ 7448, 0.25] Opening RW transaction for association [ASSA]...
[ 7448, 0.25] [ASSA] <-> association
[ 7448, 0.25] Annotate source has changed! Time=1571649601
[ 7448, 0.25] Association variable mismatch: clearing database
[ 7448, 0.25] Preparing statement clearAuto
[ 7448, 0.25] Preparing statement preAssocCounts
[ 7448, 0.25] Association OK for code value 111222 (111222)
[ 7448, 0.25] Preparing statement insert
[ 7448, 0.25] Association OK for code value 222777 (222777)
[ 7448, 0.25] Closing transaction for association [ASSA]...
[ 7448, 0.25] [ASSA] X association
[ 7293, 13.69] END of input

In bold the only difference. It seems that database association.sqlite is not cleared
and therefore it is not filled at all.

I have now control of the process so I can manage it. Perhaps, you should add a "clearing procedure" and warn users that
if association does not work to clear existing databases.

Many thanks for you help.
Andrea

Well,
not really solved.

I am trying with another set of students. I cleared out all the previous files, but I still have a missing association.

There association.sqlite is empty and from the log file it is missing
Association variable mismatch: clearing database

So, there is still something not clear to me.

Thx,
A

I checked the file options.xml .
I found two lines where different from the project which delivered a correct association:
<allocate_ids>1</allocate_ids> ---- it was set to nothing and I set to 1;
<auto_capture_mode>0</auto_capture_mode> ---- it was set to 1 and I set to 0;

I am not sure this is the correct setting, but once I changed the association worked as expected.

I could not also understand where these two variables are set ... I did not find an equivalent in the Preference tab

Hope this works!

Best,
A

auto_capture_mode=0 is for Different answer sheets, and auto_capture_mode=1 means Some answer sheets were photocopied.
allocate_ids refers to the Pre-allocate sheet ids from the page numbers option when the photocopy mode is used for automatic data capture.
These two options are set from the automatic data capture window, and are not used outside this step.