What does asterisk in ID number means?
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?
<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".
How to specify idprefix during export
Special idprefix values
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".
This article was viewed 47201 times.40643 / 47201