如何创建自定义Box应用程序以将内容直接移动到MS-Access数据库中?

问题描述

我想自动将box.com中的内容直接传送到MS-Access 2013数据库应用程序中.是否有可能做到这一点?要实现此目标需要什么成分?

I would like to automate content delivery from box.com, directly into an MS-Access 2013 database app. Is it possible to do this? What ingredients are needed to accomplish this objective?

一种典型的情况是，我有几家律师事务所处理人身伤害案件.他们的客户医生，保险公司等将内容(主要是PDF文档)放入上载文件夹中，以便我可以将它们分发给代表每个客户的相应律师事务所.我有一个Access 2013/SQL-Server应用程序，该应用程序为每个律师事务所提供我提供的服务的发票，但是我必须手动从Box检索文档并将其转发给每个律师事务所.大多数律师事务所都有一个用Access 2007编写的案件管理应用程序.我想使用Access应用程序作为中介，自动将文档的检索和转发以及帐单自动发送给每个律师事务所.

A typical scenario is I have several law firms that handle personal injury cases. Their clients doctors, insurance companies, etc. put content (mainly PDF documents) into the box upload folders so that I can distribute them to the corresponding law firm that represents each client. I have an Access 2013/SQL-Server application which invoices each law firm for the service I provide, but I have to manually retrieve the documents from Box and forward to each law firm. Most of the Law firms have a case management application, also written with Access 2007. I would like to automate the retrieval and forwarding of the documents, along with my billing, to each law firm, using my Access app as an intermediary.

推荐答案

基于您在后续问题中提供的信息，我理解以下内容是正确的:

Based on the information you provided in follow up questions, I understand the following to be true:

• 所有感兴趣的文件都包含在您拥有的Box帐户中.
• 每个客户的文档都在单独的文件夹中.

此外，我要规定所有与Access/SQL Server相关的文件处理内容不在此问题范围之内，或者至少范围太广，以至于无法在此处整体解决.

Further, I'm going to stipulate that all of the Access/SQL Server-related file processing stuff is beyond the scope of this question, or is at least too broad to be addressed here in whole.

也就是说，您根本不需要使用Box API.这样的事情可能会更容易:

That said, you don't really need to use the Box API at all. Something like this might be easier:

1. 下载并安装Box Sync ，这将使您的Box文件可轻松在工作计算机上使用.
2. 从Box网络界面选择要保持同步的文件夹.
3. 将您的应用程序指向Sync文件夹(例如C:\Users\Frank\Box Sync\<Client>\Inbox)中的客户端文件进行处理.
4. 通过电子邮件转发结果，或者最好将其写回到相应的同步文件夹(C:\Users\Frank\Box Sync\<Client>\Outbox

1. Download and install Box Sync, which will make your Box files easily available on your work computer.
2. From the Box web interface choose the folders that you'd like to keep in sync.
3. Point your application to the client files in your Sync folder (e.g. C:\Users\Frank\Box Sync\<Client>\Inbox) for processing.
4. Forward the results via email or, better, write them back to the appropriate sync folder (C:\Users\Frank\Box Sync\<Client>\Outbox

这篇关于如何创建自定义Box应用程序以将内容直接移动到MS-Access数据库中?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！