Hello,
I am looking for a way for RMS to export an inventory report to a CSV file every X min or after there is a change. Each file should replace the existing file.
Need to do this because another program I have can monitor the folder and us the data to make sure it's aware of current inventory levels.
Can anyone point me towards an answer? I've found a lot of ways for a one time export, but I need this to be ongoing.
Thank you,
*This post is locked for comments
Thanks Ed,
I'll reach out to you. The other tricky part is that the output file needs to follow a specific format for the column titels and things like that.
I can create this export for you. There is no way to automatically run a report or automatically export in RMS.
You could do this from SQL Server, using SSIS, but that requires sql server standard edition.
You might also be able to do this via PowerShell or cmd shell, but it would need to be created.
If you want me to create this, feel free to send me a private message, we can work out an arrangement.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (