DB Structure to Box Folders
This is an interesting one.
We want to mirror the box folder structure to our database. Structure is
- Company
- Division
- Employee
Apis to create folders - easy. Our "CURRENT" plan is
- Company Name---CompanyID
- Division Name---DivisionID
- Employee Name---EmployeeID
The issue is if something changes in the database, such as company name, division name, or employee name, we would create duplicate folders (jon doe changed name to Jonathon doe). We tried adding metatdata such as companyid, divisionid, employeeid. Works, but then we are doing thousands of searches a day and metadata can be an issue if a folder was created outside of automation or copied.
To compound, we have 2 requirements:
- Has to be human readable (company name vs company id)
- Has to work with UI and Box drive (Windows). Our system only works on file transfers over smb (file shares, C: drive).
Been scratching head on this one. Wondering if anyone has had the same type of setup and what they did.
サインインしてコメントを残してください。
コメント
0件のコメント