Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Click on File > Database Tools > click copy database radio button 

  • Enter new database name and ensure the source database is the one you are copying.  

  • Image Added
  • Click Create and sign into new database.  

    Image Added
  • Image Added

    Sign into newly created Database

  • Take a backup, name is Copy of “” whatever database you copied from 

  • Click on Tools > Rollover > Delete and select:  

    • Courses 

    • Scheduling Groups 

    • Scheduling Ties 

    • Academic Blocks 

    • Course Combinations 

    • Programs (Program Content, Program Allocations, Student Course Requests, Course Combination Requests, Academic Blocks) 

    • Rooms 

  • Click Next, then Delete, then once it’s finished click “Previous” 

...

Clear any notes and Done Flags: Click on Tools > Rollover > Clear Notes… and select all notes and done flags to be deleted. Select all the notes (DCU Done Flags, DCU Professor Constraints, DCU Room Notes, DCU Time Notes and Professors) Not “Patterns” notes though, those should stay. 

...

Manually delete:  

  • Secondary Files > Course Characteristics > Select all and delete.  

  • Secondary Files > Terms > select term and delete  

  • Pattern Constraints > only those created for the term (under 2x1 or 3x1 ) 

Take a back up in current database “Before Import” then switch

Switch databases to the previous like term. 

...

  • Target Type: Space-delimited Text file (TXT) 

  • ACCDB (the access database) staging file path: C:\Infosilem\AcademicSuite\14.1\Transfer\Timetabler\Export\Target\TimetablerExport.accdb 

  • Recurring Export Options: 

  • Delete previously exported data, in the target, prior to exporting = Y 

  • Populate the change indicator flags (DIFF_FLAG) =Y 

  • Export Data Selection: 

  • Export all tables = All files 

 

...

Click on export. When export is complete view report to ensure there are no errors then click Close.

...

Switch databases back to the one you’re creating. File -> Switch Database 

...