[mohamad]

Hello Experts,
Is it possible that users can upload the files (pdf, img,...) to a special path of server? At the moment, when the users upload the files, the mentioned files are stored in the following path: processmaker\shared\sites\workflow\files\905\262\500\57158b1b439014072150115\74863719957158b39af56d2076904431_1.png
Can the users determine different paths of server? For example, in their server, they have special folders for their projects and want to have the attachment files there (it is not fixed path) and I can not use a link property. The users want to define the links (not administrator) or they upload files in another paths which are not fixed.
. Is it possible and if it is, how?
Another question is that, if they upload lots of files on PM at various cases, Community Edition will face some problems like the reduction of process speed, hesitation and hanging or these sorts of things?
What is your advice?
Looking forward to your valuable points and comments.
Kind Regards

[amosbatto]

You can change the location of the shared directory:
https://wiki.processmaker.com/3.0/Addit ... _directory
(It is a good idea to clear the cache after doing that.)

Home > Documents provides for the ability to place files in virtual subdirectories, so files are easier for users to find.

ProcessMaker doesn't provide for more configuration than that. You could create a plugin which looks up the files which the user has uploaded in the APP_DOCUMENT table and displays links to those files for the user. The documentation on Files, Input Documents and Output Documents provides more info.
These examples also might help you:
https://www.pmusers.com/index.php/Save_ ... a_PM_Table
https://www.pmusers.com/index.php/Displ ... l_web_page

[mohamad]

Dear Amos, Thank you very much

A friend of mine told me, if they upload lots of files on PM at various cases, Community Edition will face some problems like the reduction of process speed, hesitation and hanging or these sorts of things. Is that correct statement?
What is your advice?
Kind Regards

[amosbatto]

The Community Edition slows down when tables like APP_CACHE_VIEW (which holds case and task data) gets too big. The Enterprise Edition has been optimized to have better database performance when the number of cases grows large.

The number of files which have been uploaded shouldn't effect the performance very much, although it might take a little longer to search in a large APP_DOCUMENT table for files from a case.

Some people who use the Community Edition and have over 100,000 cases are changing the workspace every year to use a new database and others are deleting old cases from the database to speed it up . This shouldn't be necessary if you are using the Enterprise Edition.

[mohamad]

Dear Amosbatto,
According to your knowledge and experience, how many cases can CE support without any problem?

What about the security? If we share CE on the Internet, are there some threats ( like hacking, ...) or not?

At the last, is it possible to install SQL server instead of My SQL or not? if it is possible, would you please send me a link?

I was wondering if you could answer my concerns for this.
Looking forward to your comments
Kind Regards

[amosbatto]

According to your knowledge and experience, how many cases can CE support without any problem?

It depends on your hardware and the amount of data being stored in each case. I know people who run the Community Edition with more than 250,000 cases. If you add more RAM to your server, and increase the size of key_buffer_size, sort_buffer, read_buffer and table_cache in your my.cnf file, you can speed up MySQL. Using an SSD instead of an HDD on your server will also speed up MySQL. Using Nginx in place of Apache will also speed up ProcessMaker.

How many concurrent users do you have and what kind of CPU does your server have? More CPU cores are better if you have a lot of concurrent users.

What about the security? If we share CE on the Internet, are there some threats ( like hacking, ...) or not?

Make sure that you are using SSL/TLS:
https://wiki.processmaker.com/3.2/Addit ... _SSL.2FTLS

At the last, is it possible to install SQL server instead of My SQL or not? if it is possible, would you please send me a link?

ProcessMaker will only run on MySQL. You can create Database Connections to SQL Server, but ProcessMaker's tables which need to be stored in MySQL. For SQL Server, you need to use FreeTDS to convert to the UTF-8 character set when connecting to ProcessMaker.

[mohamad]

Thank you very much for your kind reply