Convert .csv file into .txt file with different data arrangement using ION

Hello Everyone,

I have a requirement where I need to convert a .csv file into a .txt file with different arrangement of data. How do we approach to achieve this using ION.

What I could figure out is, the first step would be to setup an SFTP Connection point that can pick up a .csv file. Second step would be to define the object schema for the .csv file.

Once this is done, can we pass the .csv file to a work flow having a python script which can read the data in from the .csv file and convert the it into .txt file with different data arrangement and then some how store the .txt file in another SFTP Folder.

Is this the right approach to get this working ?

Since I'm working on this requirement for the first time which needs ION expertise, any suggestion provided would be a great help to me.

Thank you,

Ashish

Find more posts tagged with

Infor Chat

Accepted answers

All comments

Legacy Contributor

Hello Everyone,

I have created DSV Schema for input CSV file and for the output Text File. Created two connection points for the same and a document flow with a scrip in between the two ION connection points.

My question is, how do I get this working ? What library shall I import and how can I use the same in python script to convert a CSV file into a TXT file.

Regards,

Ashish

Legacy Contributor

Ashish,

The approach you describe here is just fine. You do not necessarily need to import any library into your Python script. You just need to write Python code that will do the "different data arrangement". I cannot help specifically with that since I don't know your specific requirements for the file. However, I can say you are on the right track.

Legacy Contributor

Hey Ashish,

When you say you'd like to re-arrange the data, what level of depth are you looking to do here?

If all you were hoping to do was change the file extension, you could use a read step in your FTP connection point and create a corresponding write step that takes your original file and changes the extension to .txt.

However, I'm sure you'd like to do some more with the data itself. Is it a matter of concatenating fields, re-arranging the order, generating some calculations?

Writing some python code here could be super useful but you may have other alternatives like using the ION Mapper which might be a little more indirect in achieving your goals but might be easier if you're not familiar enough with Python.

Legacy Contributor

Hi Keith,

Thank you for the inputs that you have provided. Is it possible for you to share with me a certain example of kind of the script that will be required here if you have any reference.

Why I'm asking this is because, I want to know how exactly the script should fetch the data from csv file ? Will it grab the whole content of CSV file in a single go ? OR will it process CSV data line by line and generate the txt file.

I can then try to handle the arrangement of data in python script once I know the basic rules to get the data from CSV file in my python script.

Thank you,

Ashish

Legacy Contributor

Hey Mike,

Thank you for your response.

I'm certainly looking for handling the different data arrangement as well apart from converting a CSV file into a TXT file.
I've decided to use the python scripting as I think it would be a quick way to achieve it using the scripting tool available within the dataflows. It would be a great help to me if you can provide any example of how we handle such transformation of file from cvs to txt using the scripting tool available under dataflows.

Regards,
Ashish

Copyright © 2025 Infor. All rights reserved.