Kinook Software Forum

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

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 09-20-2017, 08:25 AM
cnewtonne cnewtonne is online now
Registered User
 
Join Date: 07-27-2006
Posts: 503
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?

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

https://tinyurl.com/m662hpy

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):

http://www.kinook.com/Forum/showthread.php?t=2825
Reply With Quote
  #3  
Old 09-26-2017, 08:47 AM
cnewtonne cnewtonne is online now
Registered User
 
Join Date: 07-27-2006
Posts: 503
Thanks.
I'll give that a try
Reply With Quote
Reply

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:53 PM.


Copyright © 1999-2023 Kinook Software, Inc.