[mfaisel]

Hi,

I am using a multi-file upload. When I upload a CSV file, the following error occurs



As a temporary solution, I changed the file extension from .csv to .txt

How do I fix this issue permanently?

[dan123dan]

Hi,

Make sure that you allow the CVS extension on your dynaform.

Because if a file with a different extension is attached, a validation error message is shown.

To more information about this, check the wiki, https://wiki.processmaker.com/3.1/Multi ... Extensions

let me know if everything is OK.

[programerboy]

Hi,
You are not allowed to upload a file by changing the format for security reasons (For example change csv to txt)
To fix your problem, set the following settings in the env.ini file:

Code: Select all

enable_blacklist = 1
files_white_list = 'docx, xlsx, doc, xls, jpeg, jpg, png, pdf, zip, csv, txt'

The path of this file is :
\opt\processmaker\workflow\engine\config\env.ini

https://pmlearning.info
Thanks

[mfaisel]

Hi,

Make sure that you allow the CVS extension on your dynaform.

Because if a file with a different extension is attached, a validation error message is shown.

To more information about this, check the wiki, https://wiki.processmaker.com/3.1/Multi ... Extensions

let me know if everything is OK.

Thank you for the advice.

However, the recommended steps do not fix the problem. I am still getting the same error message.

Thanks again.

[mfaisel]

Hi,
You are not allowed to upload a file by changing the format for security reasons (For example change csv to txt)
To fix your problem, set the following settings in the env.ini file:

Code: Select all

enable_blacklist = 1
files_white_list = 'docx, xlsx, doc, xls, jpeg, jpg, png, pdf, zip, csv, txt'

The path of this file is :
\opt\processmaker\workflow\engine\config\env.ini

https://www.youtube.com/channel/UCYiyz1 ... 1iw/videos
Thanks

The workaround. However, the problem is still there and I am still getting the same error message.

Thank you for helping.

[programerboy]

Hi,

This is processmaker base error, please add this code to the customMimeTypes file in the exist array :

Code: Select all

path: \opt\processmaker\config\customMimeTypes.php

'csv' => 'text/csv',

https://pmlearning.info
Thanks

[mfaisel]

Hi,

Probably you have an error in your csv file, please test with another file with the same format.
If you are sure your file is correct, please report to ProcessMaker.

https://www.youtube.com/channel/UCYiyz1 ... 1iw/videos
Thanks

No problem spotted after I change the extension from csv to txt.

[programerboy]

Please double check the previous post, I edited it

[mfaisel]

Hi,

This is processmaker base error, please add this code to the customMimeTypes file in the exist array :

Code: Select all

path: \opt\processmaker\config\customMimeTypes.php

'csv' => 'text/csv',

https://www.youtube.com/channel/UCYiyz1 ... 1iw/videos
Thanks

Still same..
Below is my sampel data:

Code: Select all

email,claim_type_code,mode,currency,amount
some.one@some.company.com,hp_bills,monthly,MYR,200
some.one@some.company.com,training_seminar,yearly,MYR,2000
some.one@some.company.com,subscription_memberships,yearly,MYR,2000
some.one@some.company.com,travelling,monthly,MYR,500
some.one@some.company.com,hp_purchase,yearly,MYR,1000
some.one@some.company.com,accommodation,yearly,MYR,5000
some.one@some.company.com,per_diem_allowance,monthly,MYR,500
some.one@some.company.com,mileage,monthly,MYR,100