Kinook Software Forums

Go Back   Kinook Software Forums > Ultra Recall > [UR] General Discussion

Thread Tools Rate Thread Display Modes
Old 09-20-2017, 08:25 AM
cnewtonne cnewtonne is online now
Registered User
Join Date: 07-27-2006
Posts: 351
How to perform mass truncate & replace on titles

I have a need to export a long tree of items into Windows 10 NTFS drive (default). A good deal of these items have long titles. When UR exports the tree, it creates a folder fo each item and the entire filesystem path ends up exceeding the 260 character limits. As such, these rtf files fail to open with 'file not found' or 'exceeded max limit for file path'.

Furthermore, some item titles have special characters in them that are not compatible with Windows file naming convention. Causes similar issues.

I attempted different hacks to rename these files and folders, but it was just arduous.

If there a way to have UR replace item title characters and truncate them. Is this configurable anywhere? If not, can I login to the SQLite database and issue and update statement on some table? How can I get more details on what tables to update and how to login?

Reply With Quote
Old 09-20-2017, 09:21 AM
kinook kinook is online now
Join Date: 03-06-2001
Location: Colorado
Posts: 5,612
Easiest fix would be to remove the long filename limit in Windows:

UR does replace invalid filename chars when exporting, and if the file was successfully created, the characters that were used must be valid. Maybe some software you're using isn't handling all valid characters?

See here for modifying attributes via SQLite (there are some examples related to item titles):
Reply With Quote
Old 09-26-2017, 08:47 AM
cnewtonne cnewtonne is online now
Registered User
Join Date: 07-27-2006
Posts: 351
I'll give that a try
Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

All times are GMT -5. The time now is 01:08 AM.

Copyright 1999-2019 Kinook Software, Inc.