maynard
07-14-2007, 07:50 PM
I exported a node recursively from a UR tree that has the following sub-folders in UR:
TPE Domain A - Making Subject Matter Comprehensible to Students
TPE Domain C - Engaging and Supporting Students in Learning
TPE Domain D - Planning Instruction and Designing Learning Experiences for Students
TPE Domain E - Creating and Maintaining Effective Environments for Student Learning
TPE Domain F - Developing as a Professional Educator
Upon export, the resulting folder names on disk are all truncated to 51 chars long:
TPE Domain A - Making Subject Matter Comprehensibl
TPE Domain C - Engaging and Supporting Students in
TPE Domain D - Planning Instruction and Designing
TPE Domain E - Creating and Maintaining Effective
TPE Domain F - Developing as a Professional Educat
Also, this 51 char limit seems to apply to the names of items at each level of the exported hierarchy. Examples from filesystem after export:
-----------------------Folder (51 char limit)---------------------------File (51 char limit)---------------------------
a) TPE Domain A - Making Subject Matter Comprehensibl\TED624 - Physics - Reflection and Refraction of Li.pdf
b) TPE Domain A - Making Subject Matter Comprehensibl\TED611 - Physics - Speed - Lesson Plan.pdf
c) TPE Domain B - Assessing Student Learning\TED625A - Force of Friction - Lesson Plan.pdf
d) TPE Domain B - Assessing Student Learning\TED630 - Earth Science - Unit6 - Geologic Time Sca.pdf
Results:
a) Folder and file names (each GT 51) get truncated
b) Folder name (GT 51) gets trunctated but filename (LT 51) does not
c) Folder name (LT 51) does not get truncated but filename (GT 51) does.
d) Folder name and file name are each LT 51. Neither gets truncated. (this is the only case that is correct)
Note: In all file cases, the file extension does not get truncated but is properly appended to the truncated filename.
I moved the database file into a folder with a very short path (E:\Temp) and exported to the same folder to see if the pathname of the orginal source folder was too long. Still got the same results.
I tried compacting and repairing the database and got the following error:
Error repairing database: no such table: ttForm
I then tried compacting first and then repairing in a separate step. The compact ran fine but the repair generated the same error.
I then created a new database from a custom UR template.urd I've been using for awhile, copied the node I was trying to export from the 1st UR DB to the new DB and exported with the same truncated results. I then did a repair/compact on the new database which failed with the same error as above.
I then renamed template.urd to template.urd.bak and created another new DB using UR defaults. I immediately did a repair/compact on that DB and both ran fine. I then copied the node data from the original DB to the new default DB, did a successful repair/compact and exported again. No luck... got exactly the same truncated results.
Also, I received the following errors after working with the database pretty heavily over the course of the evening (a lot of copy, move, delete operations):
Selecting tree item - Error loading item(s): out of memory
Expanding tree item - Error expanding tree: out of memory
Help.
TIA
maynard
---------------------------
Environment:
UR 3.1.1
Windows XP SP2
TPE Domain A - Making Subject Matter Comprehensible to Students
TPE Domain C - Engaging and Supporting Students in Learning
TPE Domain D - Planning Instruction and Designing Learning Experiences for Students
TPE Domain E - Creating and Maintaining Effective Environments for Student Learning
TPE Domain F - Developing as a Professional Educator
Upon export, the resulting folder names on disk are all truncated to 51 chars long:
TPE Domain A - Making Subject Matter Comprehensibl
TPE Domain C - Engaging and Supporting Students in
TPE Domain D - Planning Instruction and Designing
TPE Domain E - Creating and Maintaining Effective
TPE Domain F - Developing as a Professional Educat
Also, this 51 char limit seems to apply to the names of items at each level of the exported hierarchy. Examples from filesystem after export:
-----------------------Folder (51 char limit)---------------------------File (51 char limit)---------------------------
a) TPE Domain A - Making Subject Matter Comprehensibl\TED624 - Physics - Reflection and Refraction of Li.pdf
b) TPE Domain A - Making Subject Matter Comprehensibl\TED611 - Physics - Speed - Lesson Plan.pdf
c) TPE Domain B - Assessing Student Learning\TED625A - Force of Friction - Lesson Plan.pdf
d) TPE Domain B - Assessing Student Learning\TED630 - Earth Science - Unit6 - Geologic Time Sca.pdf
Results:
a) Folder and file names (each GT 51) get truncated
b) Folder name (GT 51) gets trunctated but filename (LT 51) does not
c) Folder name (LT 51) does not get truncated but filename (GT 51) does.
d) Folder name and file name are each LT 51. Neither gets truncated. (this is the only case that is correct)
Note: In all file cases, the file extension does not get truncated but is properly appended to the truncated filename.
I moved the database file into a folder with a very short path (E:\Temp) and exported to the same folder to see if the pathname of the orginal source folder was too long. Still got the same results.
I tried compacting and repairing the database and got the following error:
Error repairing database: no such table: ttForm
I then tried compacting first and then repairing in a separate step. The compact ran fine but the repair generated the same error.
I then created a new database from a custom UR template.urd I've been using for awhile, copied the node I was trying to export from the 1st UR DB to the new DB and exported with the same truncated results. I then did a repair/compact on the new database which failed with the same error as above.
I then renamed template.urd to template.urd.bak and created another new DB using UR defaults. I immediately did a repair/compact on that DB and both ran fine. I then copied the node data from the original DB to the new default DB, did a successful repair/compact and exported again. No luck... got exactly the same truncated results.
Also, I received the following errors after working with the database pretty heavily over the course of the evening (a lot of copy, move, delete operations):
Selecting tree item - Error loading item(s): out of memory
Expanding tree item - Error expanding tree: out of memory
Help.
TIA
maynard
---------------------------
Environment:
UR 3.1.1
Windows XP SP2