reading pipe delimited file in outsystem?

reading pipe delimited file in outsystem?

  
Hi,

please help reading delimited files in outsystem.
Hi Shivakumar,

Can you give us more details? Can you share your use case?

Cheers

I have one PIPE delemited text file,which will be picked from diffrent path.
then we have serprate the fileds with delemited ,then we have to insert data in database after separated from delemited 

Please find attached file for you refrence 
Hi Shivakumar,

To read in your file, I would suggest you use the FileSystem extension:
http://www.outsystems.com/forge/component/68/filesystem/

Once you have your file content in memory, use the String_Split action - you can reference it from the Text extension.
That will take all the strings between pipes and return them as a list.

You can then iterate your list and fill in an object of the same type as your entity, and insert into the DB.

Hope this helps.

Cheers,
Daniel
or maybe look here https://www.outsystems.com/forge/#category=&order=&s=csv

as https://www.outsystems.com/forge/component/601/csv-importer/ looks fit for purpose as the description states "Import comma separated files (or anything separated flat text files) with your OutSystems application."


scratch that as https://www.outsystems.com/forge/component-details/601/CSV+Importer/ use undocumented api and only java stack.

use https://www.outsystems.com/forge/component-details/636/CSVUtil/  as you can config the delimeter "Config: Configuration such as encode or field delimeter if necessary. (Default: utf8 and comma)" ---- But again  makes use of private and undocumented Platform API

Daniel Please provide the code for this ...

Hi Shivakumar,

To read in your file, I would suggest you use the FileSystem extension:
http://www.outsystems.com/forge/component/68/filesystem/

Once you have your file content in memory, use the String_Split action - you can reference it from the Text extension.
That will take all the strings between pipes and return them as a list.

You can then iterate your list and fill in an object of the same type as your entity, and insert into the DB.

Hope this helps.

Cheers,
Daniel



Daniel ,Please provide sample project on inserting delimited to file to database

Hi Shivakumar,

To read in your file, I would suggest you use the FileSystem extension:
http://www.outsystems.com/forge/component/68/filesystem/

Once you have your file content in memory, use the String_Split action - you can reference it from the Text extension.
That will take all the strings between pipes and return them as a list.

You can then iterate your list and fill in an object of the same type as your entity, and insert into the DB.

Hope this helps.

Cheers,
Daniel



Shivakumar,

I'm not sure you understand. Daniel pointed you to a Forge component, which you can use to create what you want. It's pretty self-explanatory. If you're stuck using a particular Action, please post a directed question. We're not here to do your homework for you!