TimeTables - Online Help
EduPage - Online Help
Video Help

flag aSc TimeTables - Importing

ID numbers in import/export
This article is available in: gb.gif pl.gif ru.gif gr.gif lt.gif bg.gif

What does asterisk in ID number means?
When exporting from aSc Timetables to XML file, you may get exported id numbers looking like *1, *2, *3. These are so called "temporary id numbers". These numbers are assigned during export to objects that do not have any id number assigned yet. They are called "temporary", because they are valid only during one particular export. When you export same timetable next time, you may get different temporary id for the same object exported.

These temporary ids are needed to provide links between rows in tables, e.g. lesson row can link through temporary id in "teacherid" column to table of teachers.

If you want to get some real id numbers exported, you need to configure so called "idprefix".

IDPREFIX - How to specify where aSc Timetables should store your id numbers?
When creating XML you wish to import to aSc Timetables, you must fill in global option "idprefix". Example:

<timetable importtype="database" options="idprefix:MyApp" displayname="MyApp sample XML configuration" displaycountries="us">

Id prefix option specifies where should aSc Timetables store your id numbers. In the above example, your id numbers will be stored in custom field called "MyApp ID".
See also: Custom fields

How to specify idprefix during export
When you use default XML export from aSc Timetables, you will always get temporary ids exported (because internally idprefix is set to %TEMPID). To specify idprefix for export, you have to create your own XML export configuration file. These files are stored in directory C:\timetables\template\xmlexport\. You can find example in sample.xml file.

Special idprefix values
%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.
%TEMPID - do not store id numbers in timetable (this is default).

You can specify idprefix value also per individual tables with "idcf:" table option. E.g. if you want to store id numbers for students in "number" field, simply use:

<students options="canadd,idcf:%NUMBER" columns="....">

Note: There is a difference between "idprefix:" and "idcf:" when id is stored in custom field. With "idprefix:MyApp" aSc Timetables will append " ID" to the end, but with "idcf:" you need to use full custom field name: "idcf:MyApp ID".

You can find further details here. Check "Types - id", "Database options - idprefix" and "Table options - idcf".

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 87859 times.74213 / 87859

Previous article Back to aSc Timetables help index Next article