Hello All,
We are having a requirement to split the document uploaded by the user into smaller documents if the size of the document uploaded by the user is more than 5MB.
The file type can be any like Excel, txt, pdf etc. We need to create a solution that will pick the file and divide that in small size files and save in Appian document folder.
Thanks in advance for your response.
Regards
Discussion posts and replies are publicly visible
What is the purpose of this. Why do these file be stored in pieces?
Hi Stefan & All,
I too have a case where a text file of above 50 mb size need to be spitted to smaller size files so that the readtextfromfile can be used to read and parse the raw file and load to db tables .
right now the readtextfromfile is failing on larger size files .
Thanks in advance , appreciate the response.
Raj
IMHO this is just something Appian is not made for.
What format is your file and what does "parse" mean? Why not just dump the whole file into a single field table and process it from there?
Thanks stefan for the response, the file holds dynamic columns and data separated using pipe or unique characters , i meant parsing is extraction of only the interested data for the database tables.
Would the idea work to dump the each whole line into a single database field and then run a stored procedure to process the data?
there are 250K plus lines, along with it we have dynamic columns as well. even to read the file to dump the data , the functions available are not working .
OK. I suggest to implement that elsewhere. As of now, that will not work reliably with Appian.
i too feel that , still thought to check on forum . Thanks for the responses
You are welcome. Appian is about business processes, not for data/number crunching.