自动化 LIMS 数据输入
我开始在一家制药公司担任 Stagiaire 工作，他们希望我阅读主批次记录，即他们药物的详细配方，并且我会将有关“过程控制”的部分放在他们的文件中LIMS（实验室信息管理系统）以便更好地控制生产过程。
这是一项相当无聊的任务，也需要大量的关注，因为他们的 LIMS 相当违反直觉且陈旧。
我想知道你对我天真的意见/想法的看法：
我认为如果他们以某种方式将他们的主批次记录（它们是WORD文件）转换为类似网站的东西，工人可以在其中编写他的/她的分析/控制，所以我的问题是：
- 是否有可能以这种方式驳回 LIMS？
- 另外考虑到他们拥有 SAP 系统，为什么他们需要添加一个在与 SAP 的接口中已经显示出一些问题的 LIMS？
也许，因为他们花了很多钱来验证该软件，所以它可能在某种程度上有用：
- 是否可以从 MBR 文件中提取必要的信息并将其转换为 LIMS 可以理解的内容，以便自动化我应该做的工作做？
- 我的意思是至少在原则上这是可能的吗？使用 Powershell 脚本？
I begin to work as a stagiaire in a pharmaceutical company, they expect to me that I will read the Master Batch Records, that is the detailed recipes of their drugs, and that I will put the parts regarding the "in process controls" in their LIMS (Laboratory Information Management System) in order have a better control of the production process.
It is a quite boring task that requires also a lot of attention since their LIMS is quite counterintuitive and old.
I would like to know your opinion about my naive opinions/thoughts:
I thought that the company needs could be satisfied if they somehow convert their master batch records (they are WORD files) in something like web sites in which the worker can write his/her analysis/controls, so my questions:
- could it be possible to dismiss that LIMS in this way?
- Also considering that they own a SAP system, why did they need to add a LIMS that has already shown some problems in its interface with SAP?
Maybe, since they spent a lot of money in validating that software, it might be useful somehow:
- could it be possible to extract the necessary information from the MBR files and convert it in something LIMS can understand, in order to automate the work I should do?
- I mean is it possible at least in principle? With Powershell scripting?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
Mareczek，我确实使用 AutoHotKey 将数据从 Excel 读取到内存中的数组中。然后，AutoHotKey 切换到 SAP GUI，自动为我输入数据。
它在每一步中所做的就是验证正确的窗口是否打开以及输入的数据是否被接受。如果这可以帮助您，请告诉我。我可以发送一些示例脚本。此致，
罗伯特·伊尔布林克
Mareczek, I do use AutoHotKey to read data from excel into an array in memory. AutoHotKey then switches to the SAP GUI to automatically enter the data for me.
What it does at every step is to verify that the right window is open and that the entered data was accepted. If this could help you, let me know. I can send some sample scripts. Regards,
Robert Ilbrink