TimeTables - Online Help
EduPage - Online Help
Video Help

flag aSc Седмично разписание - Прехвърляне/ Публикуване

=Import/Export: How to copy ID value from one (custom) field to another

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 helped me
This article is not understandable This article is not understandable
I am looking for something else I am looking for something else

This article was viewed 23999 times.23999 / 23999
ViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViewsViews

Previous article Back to aSc Timetables help index Next article