解决我的问题的最佳方法? [英] Best way to solve my problem?
问题描述
大家好!
目前,我通过电子邮件收到月度报告,然后将列表中的项目添加到(主)列表中,然后选中这些项目,然后将其发送到其他地方.
Currently I receive a monthly report through email, I then add the items on that list, to my (master) list, and check items off, and send them elsewhere.
为方便起见,我想通过共享点托管此文件.现在,我已经创建了一个共享站点,在该站点中放置了我的主列表,并自动执行了我需要的检查(我做了一些工作流,以便在某些情况正确的情况下,将它们分成不同的部分 共享点列表等)
I'd like to host this through share point for ease. Right now, I've already created a share point site, where I have placed my master list, and automated the checks i need (I made some workflows so that if certain things are true, they get separated to different share point lists, etc.)
我现在想将能够轻松地将我每月收到的列表添加到此(主)列表中.最好的方法是什么?我有不错的编程经验,但是我不确定如何处理导入等.
I'd like now, to be able to easily add the list i receive monthly to this (master) list. Whats the best way to do this? I have decent programming experience, but I'm not sure how to deal with importing, etc.
推荐答案
取决于您的几个选项编程舒适度和时间,您必须实施该解决方案:
A couple options depending on your programming comfort level and time you have to implement the solution:
- 不是通过电子邮件接收文件,而是将其放置到共享文件夹中.
- 计时器作业-编写计时器作业,以查找放置文件夹中的任何文件,然后以编程方式处理该文件将内容添加到列表中.
- PowerShell-编写一个PowerShell脚本,该脚本作为计划任务运行,将查找文件并将内容添加到列表中.
- 命令.exe行-与PS方法类似,将.exe作为计划任务来处理文件.
- Windows服务-使用FileWather事件引发新事件以在添加新文件时捕获到放置文件夹. 将这些项目处理到您的列表中.
最简单的是PowerShell.
Easiest would be PowerShell.
这篇关于解决我的问题的最佳方法?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!