How to perform mass truncate & replace on titles

[cnewtonne]

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

[kinook]

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

[cnewtonne]

Thanks.
I'll give that a try