Is it possible to read a file in a Mongoose form

Is it possible to read a file in a Mongoose form? And then process the records in the file?

What I want to do is allow the user to select a csv file on their computer. And then read the file and insert the data into a Mongoose IDO.

I've previously been able to save a file to a Mongoose IDO in Form Script using this command: ShowOpenFileDialogAndImportCurrentObjectPropertyAsBlob But this gives me the contents of the file as a blob. I want to contents as a FileStream so that I can read each line individually.

Does anyone know if it is possible to read the a file in Mongoose Form Script?

Find more posts tagged with

Accepted answers

Caitlin Porter

[View:/cfs-file/__key/communityserver-discussions-components-files/91/8420.ImportReadXML.txt:320:240]

All comments

Caitlin Porter

Hi Terry - I am actually working on something very similar to this. I am building a tool that allows the user to import an XML file using ShowOpenFileDialogAndImportCurrentObjectPropertyAsBlob, then I will store the property as a blob. I then take that property and load it as an XML in form script to grab the IDO name and properties, then I convert it to JSON where I parse out each record and do an insert into the corresponding table. I have successfully gotten this to work, I am sure this could probably also be done with a csv file. I would be happy to share my form script with you if you would like to see how I did it.

tdickens

Thanks. Please share your form script with me. How can you share it? Can you post it here? Or do you need to email it to me?

I was playing around with: Application.ShowOpenFileDialog I'm able to get the File Name selected. But it appears that this method doesn't allow for reading the contents of a file.

Caitlin Porter

[View:/cfs-file/__key/communityserver-discussions-components-files/91/8420.ImportReadXML.txt:320:240]

tdickens

Thanks. Your example showed me what to do.

This is what I did to get the blob from the collection into a string.

string convertedData = (Encoding.UTF8.GetString(Convert.FromBase64String(ThisForm.PrimaryIDOCollection.GetCurrentObjectProperty("DocumentObject"))));

DM9346

Do we code this in the form script? or is this specific to the import button or maybe whatever component catches the file upload?

I am trying to read an xslx file that will be submitted by the user, can probably compromise with a csv if xslx doesn't work. I plan to send the contents to an ION API call.

Copyright © 2025 Infor. All rights reserved.