# Delimited File - Automated Aggregation **URL:** \ **Category:** SHF Discussion and Questions\ **Tags:** identity-security-cloud\ **Created:** [October 15, 2024, 12:51pm UTC](https://developer.sailpoint.com/discuss/t/delimited-file-automated-aggregation/85477 "2024-10-15T12:51:31Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![sahincelik](https://avatars.discourse-cdn.com/v4/letter/s/c68b51/32.png) [@sahincelik](https://developer.sailpoint.com/discuss/u/sahincelik)\ **Post date:** [October 15, 2024, 12:51pm UTC](https://developer.sailpoint.com/discuss/t/delimited-file-automated-aggregation/85477/1 "2024-10-15T12:51:31Z")
Hi all, We have 10 sources to connect with IDN as read only using Delimited File connector. I was wondering, by any chance, can we aggregate users (import accounts) automated? Currently, If I am not wrong, only manual import option is available. We can’t also read accounts from an FTP. What would be the best practice to implement this requirement in this case? Thanks in advamce! ---
**Author:** ![jishnu\_suresh](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/jishnu_suresh/32/20590_2.png) [@jishnu\_suresh](https://developer.sailpoint.com/discuss/u/jishnu_suresh)\ **Post date:** [October 15, 2024, 12:54pm UTC](https://developer.sailpoint.com/discuss/t/delimited-file-automated-aggregation/85477/2 "2024-10-15T12:54:23Z")
Hi Sahin, Please check this post. > [@Automating delimited file aggregations using the File Upload Utility](https://developer.sailpoint.com/discuss/t/automating-delimited-file-aggregations-using-the-file-upload-utility/81805): > > Description Join Expert Ambassador Krishna Mummadi as he showcases a few ways to use the [File Upload Utility](https://developer.sailpoint.com/discuss/t/file-upload-utility/18181) tool in Identity Security Cloud. Krish will show how to delimit file aggregations automatically, compare feed files, avoid unnecessary access gaps, and send emails with workflows. Find the File Upload Utility and other awesome tools in the #CoLab! Resources The Powershell script is in the process of being added to the #CoLab. This might be helpful for your use-case. ---
**Author:** ![antony\_petson](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/antony_petson/32/2697_2.png) [@antony\_petson](https://developer.sailpoint.com/discuss/u/antony_petson)\ **Post date:** [October 15, 2024, 1:16pm UTC](https://developer.sailpoint.com/discuss/t/delimited-file-automated-aggregation/85477/3 "2024-10-15T13:16:21Z")
Hey @sahincelik Unlike in IIQ, we use [File Upload Utility](https://developer.sailpoint.com/discuss/t/file-upload-utility/18181) in IDN to schedule and import delimited files. Ensure all the delimited files are available in a location where [File Upload Utility](https://developer.sailpoint.com/discuss/t/file-upload-utility/18181) has access to fetch. ---
**Author:** ![Prashanth0707](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/prashanth0707/32/23773_2.png) [@Prashanth0707](https://developer.sailpoint.com/discuss/u/Prashanth0707)\ **Post date:** [October 15, 2024, 1:22pm UTC](https://developer.sailpoint.com/discuss/t/delimited-file-automated-aggregation/85477/4 "2024-10-15T13:22:39Z")
Hi @antony_petson , In order for the files to be in a location that the file upload utility can access, is there any script that we can use which refreshes the file everyday or is it a manual upload everyday? ---
**Author:** ![antony\_petson](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/antony_petson/32/2697_2.png) [@antony\_petson](https://developer.sailpoint.com/discuss/u/antony_petson)\ **Post date:** [October 15, 2024, 1:25pm UTC](https://developer.sailpoint.com/discuss/t/delimited-file-automated-aggregation/85477/5 "2024-10-15T13:25:19Z")
You can schedule a `task scheduler` job to run the [File Upload Utility](https://developer.sailpoint.com/discuss/t/file-upload-utility/18181) using jar command and you can ask the application team to drop delimited files daily. Using powershell script or any other scripting language, you can move the files once uploaded using tool. ---
**Author:** ![Prashanth0707](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/prashanth0707/32/23773_2.png) [@Prashanth0707](https://developer.sailpoint.com/discuss/u/Prashanth0707)\ **Post date:** [October 16, 2024, 3:35am UTC](https://developer.sailpoint.com/discuss/t/delimited-file-automated-aggregation/85477/6 "2024-10-16T03:35:59Z")
Got it . Thank you for the response !! ---
**Author:** ![nikhlesh21](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/nikhlesh21/32/11800_2.png) [@nikhlesh21](https://developer.sailpoint.com/discuss/u/nikhlesh21)\ **Post date:** [October 16, 2024, 9:46am UTC](https://developer.sailpoint.com/discuss/t/delimited-file-automated-aggregation/85477/7 "2024-10-16T09:46:30Z")
HI @Prashanth0707, If it is feasible then you can try SQL Loader connector as well, where you can connect to a location like SharePoint and configure the scheduled aggregation in SailPoint. [Integrating SailPoint with SQL Loader](https://documentation.sailpoint.com/connectors/sql_loader/help/integrating_sql_loader/intro.html) Thanks, Nikhlesh ---
**Author:** ![jishnu\_suresh](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/jishnu_suresh/32/20590_2.png) [@jishnu\_suresh](https://developer.sailpoint.com/discuss/u/jishnu_suresh)\ **Post date:** [October 16, 2024, 10:09am UTC](https://developer.sailpoint.com/discuss/t/delimited-file-automated-aggregation/85477/8 "2024-10-16T10:09:02Z")
Please refer to this post [POST /api/source/loadAccounts - #199 by tdelorge-mmb](https://developer.sailpoint.com/discuss/t/post-api-source-loadaccounts/20515/199) It has different examples of Python scripts and powershell scripts which can be used to achieve this use-case. ---
**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\ **Post date:** [December 15, 2024, 10:09am UTC](https://developer.sailpoint.com/discuss/t/delimited-file-automated-aggregation/85477/9 "2024-12-15T10:09:40Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.