With this command you can copy ID value for certain object type between two (custom) fields:

!dbcopyid table prefix1 prefix2

This command will copy id from prefix1 field to prefix2 field. To use this command, open your timetable file and go to menu - Options - Advanced. Then type the command into Advanced field.

Possible values for table:

subjects
teachers
classes
classrooms
students
lessons

For prefix1 or prefix2 you can use same value as in "idprefix:MyApp" database option. In that case, id is stored in custom field called "MyApp ID". You can also use some of these special codes:

%NAME - id is stored in name of object.
%SHORTNAME - id is stored in short name of object.
%NUMBER - id is stored in number field of object.

Examples:

Copy short names of teachers to custom fields for MyApp.
!dbcopyid teachers %SHORTNAME MyApp

Copy custom fields "OtherApp" for students to number field of students:
!dbcopyid teachers OtherApp %NUMBER

This article helped me
This article is not understandable
I am looking for something else

This article was viewed 44637 times.44637 / 44637

Previous article

Back to aSc Timetables help index

Next article