Kinook Software Forum

Kinook Software Forum (https://www.kinook.com/Forum/index.php)
-   [UR] General Discussion (https://www.kinook.com/Forum/forumdisplay.php?f=23)
-   -   How to perform mass truncate & replace on titles (https://www.kinook.com/Forum/showthread.php?t=5511)

cnewtonne 09-20-2017 08:25 AM

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

kinook 09-20-2017 09:21 AM

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 09-26-2017 08:47 AM

Thanks.
I'll give that a try


All times are GMT -5. The time now is 07:43 PM.


Copyright © 1999-2023 Kinook Software, Inc.