You are viewing limited content. For full access, please sign in.

Question

Question

Suggestions for how to organize folder structure for over 500K customer accounts

asked on April 23, 2019

We have over 500K utility customer accounts, each has its own folder followed by subfolders.  Would someone has any suggestions as how to organize these folders to reduce the total # of folders for easy navigation and better performance?

Thanks in advance

0 0

Replies

replied on April 23, 2019

We encountered a similar problem with case folders. What I ended up doing is breaking them into alphanumeric subfolders.

Depending on how you utilize them, you could break them into lettered folders based on the customer name, or numeric folders based on a customer ID number.

For example, you could create subfolders for A-Z and route them based on the first letter of a last name or something along those lines.

Really it depends on how you manage the accounts. A lot of options exist like breaking them into region/city or zip code, then A-Z subfolders, etc. to make each folder have as few as possible.

The "best" option is really going to depend on how your users operate.

1 0
replied on April 23, 2019

You can create subfolders by thousands with regular expressions.

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.