LouisaVenter
New Member
- Joined
- Mar 22, 2024
- Messages
- 2
- Thread Author
- #1
Good day,
I am an ECM Consultant for Datacentrix in South Africa. I have a migration-related question. I hope you can assist.
The issue is this:
1. The source system is a Windows shared drive
2. The target system is a document management solution
3. In the source system, the file names are very long. Most of them are more than 256 characters, thus making it impossible to migrate them to the target system
4. What we need to be able to do is to make the file names in the source system shorter by removing some components from the file names and then pulling them into custom advanced property fields that will be mapped to the metadata fields in the target system. An example of this type of file name is:
Hester Johanna Cornelia Catahrina Janse van Vuuren van Rensburg Winters Opperman van Oudshoorn ID 650909 5005 086.doc
I need the ID number to be the file name and all the name components to be custom metadata.
5. The migration tool we are using creates an MS Excel report of the content of the shared drive. This report is then used to do a data clean-up (i.e., making sure that date fields contain dates, not text, etc.) We can, however, not change any of the long file names on this MS Excel because the migration tool will not recognise the files again to enable them to be migrated.
6. Therefore, we need a method to reduce the file names in the source system while moving the excess information to custom advanced properties for each file.
Do you perhaps know how to do this?
I am an ECM Consultant for Datacentrix in South Africa. I have a migration-related question. I hope you can assist.
The issue is this:
1. The source system is a Windows shared drive
2. The target system is a document management solution
3. In the source system, the file names are very long. Most of them are more than 256 characters, thus making it impossible to migrate them to the target system
4. What we need to be able to do is to make the file names in the source system shorter by removing some components from the file names and then pulling them into custom advanced property fields that will be mapped to the metadata fields in the target system. An example of this type of file name is:
Hester Johanna Cornelia Catahrina Janse van Vuuren van Rensburg Winters Opperman van Oudshoorn ID 650909 5005 086.doc
I need the ID number to be the file name and all the name components to be custom metadata.
5. The migration tool we are using creates an MS Excel report of the content of the shared drive. This report is then used to do a data clean-up (i.e., making sure that date fields contain dates, not text, etc.) We can, however, not change any of the long file names on this MS Excel because the migration tool will not recognise the files again to enable them to be migrated.
6. Therefore, we need a method to reduce the file names in the source system while moving the excess information to custom advanced properties for each file.
Do you perhaps know how to do this?