upload and read an xslx file in mongoose then send it to ion

I have a requirement where I have to upload an xslx file, read the contents and get the total amount and compare it to another field before sending it as either JSON via IMS or an XML via BOD to ION DESK.

-is it possible to upload an xslx or are we stuck with csv?

-can we read the contents of what was uploaded?

-can we call IMS ION API?

-which is better IMS or BOD?

Find more posts tagged with

Accepted answers

All comments

Kevin Heiman

Your base request is starting off in Mongoose/ Application Developer, which would seem appropriate to upload a user file. There are some ways to acquire the file through ION and homepage widgets, but will assume Application Developer for now. Presuming there is an upload service UI built, you could send that file to ION for a Script to parse and process and return a outcome and determine the path forward. You could use Python CSV or excel libraries depending on your choice.

In short, ION could do most of the steps, however if Application Developer has advantages you could use those as well. Appl Developer / Mongoose members can advise on the Appl Developer capabilities.

DM9346

Mongoose was only selected because it's the one that can offer an interface where a user can upload a file. The users are not developers so I need something that will give them that capability.

kazuyuki-mochizuki

Hello,

Here's what I think,

1)Upload xslx file in CSI -> i think this will be saved in object and refviews

2) trigger a custom assembly to read the binary in refviews table and open the file in memory to compare or manipulate values

3) after manipulating values inside custom assembly, send the modified values via custom bod

Regards,

Kaz

DM9346

sorry what is CSI?

kazuyuki-mochizuki

Hi DM9346,

Syteline / CSI10 Cloud.... Are you using Syteline?

Regards,

Kaz

DM9346

nope we only use M3

Copyright © 2025 Infor. All rights reserved.