Under attack? Emergency incident response, remote or on-site.Get help now →Call (360) 524-3477

FileCabinet CS to SharePoint and OneDrive: Structure, Limits and Gotchas

A lot of firms already pay for Microsoft 365, so SharePoint is the obvious home for documents leaving FileCabinet CS. It works well, but SharePoint isn’t a document management system built for accounting, and a few of its limits are easy to trip over with years of client files. Here’s how to set it up.

SharePoint or OneDrive?

OneDrive is private by default and meant for one person’s files. Client documents the whole team works on belong in a shared SharePoint document library (Microsoft). Use OneDrive only for staff working files, not the firm archive.

A layout that holds up

Microsoft’s advice is to lean on metadata columns rather than deep folders, and to avoid folder trees more than one or two levels deep (Microsoft). For a FileCabinet archive, that usually means:

  • One Client Documents library, or one library per office if permissions differ
  • A folder per client, matching the FileCabinet drawer
  • The FileCabinet folders one level below, if your staff rely on them
  • Columns for tax year and document type, so views and searches can filter without more folders

Microsoft limits that matter for an accounting archive

  • Path length: the decoded path, including the file name, tops out at 400 characters (Microsoft). Long FileCabinet descriptions plus client names can hit it.
  • List view threshold: views over 5,000 items can throw errors, and in SharePoint Online the limit can’t be raised. Index the columns you filter on (Microsoft).
  • Permissions: inheritance can’t be broken once a library or folder holds more than 100,000 items, and Microsoft recommends no more than 5,000 uniquely permissioned items per library. Set client-level permissions before you load files.
  • Sync: Microsoft recommends syncing no more than 300,000 files per library, so don’t sync the whole archive to every laptop.
  • Size: files up to 250 GB, and up to 30 million files and folders per library.

Names SharePoint won’t accept

File and folder names can’t contain " * : < > ? / \ |, can’t start or end with a space, and can’t use reserved names such as CON, PRN, AUX or NUL (Microsoft). FileCabinet descriptions often include colons and slashes in dates, so plan a cleanup rule.

Microsoft’s migration tools

  • SharePoint Migration Tool (SPMT): free, moves file shares into SharePoint, OneDrive or Teams, keeps the folder structure and can rerun saved tasks incrementally (Microsoft). Turn on “Replace invalid filename characters,” or those files are skipped (Microsoft).
  • Migration Manager: runs from the SharePoint admin center through installed agents. By default it carries folder permissions only, and if you target the library itself instead of a folder inside it, root-folder permissions are lost (Microsoft).

Both tools move files that already sit in Windows folders. Neither can read FileCabinet, so the export comes first.

Where TekBryte fits

Our bulk export hands you every drawer as an ordinary Windows folder, with FileCabinet’s folders, annotations and drawer notes kept, ready for SPMT or Migration Manager to lift into SharePoint. The verification report lets you confirm the counts on both sides after the upload.

Heading to SharePoint?

We’ll get your FileCabinet archive into SharePoint-ready folders first. Free assessment, reply within one business day.

TekBryte FileCabinet Recover iconExports run on TekBryte FileCabinet Recover, our own bulk-export software.

See FileCabinet CS bulk exportCall (360) 524-3477