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

Το άρθρο αυτό με βοήθησε
Το άρθρο αυτό δεν είναι κατανοητό
Ψάχνω για κάτι άλλο

Αυτό το άρθρο αυτό προβλήθηκε 44613 φορές.44613 / 44613

Προηγούμενο άρθρο

Πίσω στη βοήθεια του aSc Timetables

Επόμενο άρθρο