Inspiring

Question

Long File in Appian

Forum|Forum|2 years ago
April 3, 2024
20 replies
0 views

Hello

We need to work with files larger than 1 GB, and in particular we have two scenarios:

1- A portal made in Angular, where users external to the organisation will attach a document larger than 1 GB. We need this file to reach Appian and then be sent to a sharepoint of the organisation. We have a limitation when receiving the file from the external portal as the appian api only allows 75 MB.

2- The other scenario is that a user in appian wants to attach files larger than 1GB in an appian interface with the uploadfile component, then appian through a web service must send it to sharepoint. We have the problem that the uploadfile component only allows 1GB.

For these two scenarios, what would be the optimal solution?

mikes0011

Brainy

1) in case it's a possibility, i've used the sFTP plug-in to easily transfer files larger than 1 GB. I'm unclear what your requirement is exactly, but this could potentially fill a gap.

2) how often do you have users needing to attach a file larger than 1GB? Is there any possibility of having files broken up first?

The Expression Guru

raulg0001Author

Inspiring

1) in case it is a possibility, I have used the sFTP plug-in to easily transfer files larger than 1GB. I'm not clear exactly what your requirement is, but this could fill a gap.

I'm not clear if SFTP can be used to drop files on Sharepoint, have you ever done it?

2) How often do users have to attach a file larger than 1GB, is there a possibility to split the files first?

Users will attach these files every time they create a case, it is a relatively small volume. How could I split the files in Appian, I have searched for information and I can't find it.

mikes0011

Brainy

I'm not clear if SFTP can be used to drop files on Sharepoint, have you ever done it?

I haven't - from a quick google it's suggested that it might be enabled via the addition of some 3rd-party service that handles the ultimate transfer of files from FTP to sharepoint. There may be other easier ways too, I'm not sure.

Users will attach these files every time they create a case

Users are regularly needing to attach files that are > 1 GB?!? That seems incredible. Is there no way to streamline that file size? What do the files contain??

How could I split the files in Appian

I'm talking about splitting them on the user-end prior to Appian upload. Like via creating multi-part ZIP archives or something else along those lines, if streamlining of the file sizes is impossible for you. That being said, the first thing I'd look into is reducing the original file sizes - 1 GB seems overboard for almost any use case I can think of, other than if users need to upload movie-length video files for some reason.

The Expression Guru

shubhama926776

Brainy

External Portal to Appian: Use a cloud storage service like AWS S3 or Azure Blob Storage to store files larger than 75 MB. Then, have Appian retrieve the file from the cloud storage and send it to SharePoint.
Appian Interface to SharePoint: Again, use a cloud storage service for files larger than 1 GB. Users upload files to the cloud storage via Appian, and then Appian transfers the file to SharePoint through a web service.

Let me know if that works for you?

शुभम्

stefanhelzle0001

Brainy

"Users upload files to the cloud storage via Appian" ... how would you do that?

mathieud0001

Brainy

[mention:7696b59cfd444da8b49f502dc2b23ba9:f7d226abd59f475c9d224a79e3f0ec07]
[mention:74a465e96f06422db61633510a0c6b7d:f7d226abd59f475c9d224a79e3f0ec07]
[mention:c5537d767d854495b8ba989a7aff093f:f7d226abd59f475c9d224a79e3f0ec07]

davidj137213

Brainy

Buenas Raul, creo que en ambos escenarios, lo ideal es que trabajarais con la referencia a los ficheros mas que con los ficheros en si.

EN el segundo escenario, igual podeis usar las funciones getfolderbybname y getdocumentsforfolder para obtener el nombre de los documentos y montar dinamicamente la llamada al SFTP

raulg0001Author

Inspiring

Hola david ,

Estoy de acuerdo contigo en que en appian se deberia trabajar con las referencias a los documentos externos , pero sigo ver como el usuario nos va a subir el fichero. Piensa que es un usuairo que accede mediante vpn a appian y se le muestra un formulario en appian para que adjunte la documentacion , la unica manera que conozco es con uploadfile y esta limitado a un GB.

davidj137213

Brainy

Como opciones para eso, serian factibles la creacion de un web component en el propio appian, o bien usar un webCOntentField para mostrar una interface o site externo que te permita hacer la subida de documento al repositorio que sea necesario.

Sign up

Login with SSO

Login to the community

Login with SSO