# DevonAgent to open and scan zip archives

**URL:** <https://discourse.devontechnologies.com/t/devonagent-to-open-and-scan-zip-archives/13280>\
**Category:** Tips\
**Created:** [December 23, 2011, 5:16pm UTC](https://discourse.devontechnologies.com/t/devonagent-to-open-and-scan-zip-archives/13280 "2011-12-23T17:16:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![bschima](https://discourse.devontechnologies.com/letter_avatar_proxy/v4/letter/b/a88e4f/32.png) [@bschima](https://discourse.devontechnologies.com/u/bschima)\
**Post date:** [December 23, 2011, 5:16pm UTC](https://discourse.devontechnologies.com/t/devonagent-to-open-and-scan-zip-archives/13280/1 "2011-12-23T17:16:27Z")

</div>

Folks,  
I’ve started a new job recently where I deal with high volume of disparate and non interlinked databases.  
The issue here is mainly that I have several tools, database frontends and Excel-sourced information which need to be pulled together manually.  
I’m curious if DA could help me here - a question that comes up for instance: Can I use DA to create this workflow:

1. Download newest .zip from a filer via a given URL.
2. unpack that zip file (xls) and check for defined contents (textfields) in excel?  
(at least having the data unpacked and imported into DT automatically would help too)

Other question - can DA help me to work with Database frontends? I assume not as the db query will be given to a script rather than in a url. Not sure if that makes sense - any hints are welcome.  
Regards, Branko

---

<div class="post-metadata">

**Author:** ![cgrunenberg](https://discourse.devontechnologies.com/user_avatar/discourse.devontechnologies.com/cgrunenberg/32/7172_2.png) [@cgrunenberg](https://discourse.devontechnologies.com/u/cgrunenberg)\
**Post date:** [January 13, 2012, 1:42pm UTC](https://discourse.devontechnologies.com/t/devonagent-to-open-and-scan-zip-archives/13280/2 "2012-01-13T13:42:22Z")

</div>

> [@bschima](#):
>
> 1. Download newest .zip from a filer via a given URL.
> 2. unpack that zip file (xls) and check for defined contents (textfields) in excel?  
> (at least having the data unpacked and imported into DT automatically would help too)

At least the first two steps should be scriptable, the last one probably too if Excel is installed on the computer.

> [@](#):
>
> Other question - can DA help me to work with Database frontends? I assume not as the db query will be given to a script rather than in a url. Not sure if that makes sense - any hints are welcome.

What kind of database/frontend do you have in mind?

Finally, this thread might be useful too:

> [@Module & Scanner for local search (spotlight)](https://discourse.devontechnologies.com/t/module-scanner-for-local-search-spotlight/13366/1):
>
> I think it would be quite handy to have a module & scanner for a local search too. I would create a combined search for the web and local documents together. An example might show the benefits of this approach. Today I had to find out some advanced information about a special barcode workflow to be implemented. I was sure I would find some relevant information in my file system , some in my mails, some in some DevonThink DBs and some in the web. All together in one DevonAgent search would be …

---

<div class="post-metadata">

**Author:** ![system](https://devontech-discourse.s3.dualstack.us-east-1.amazonaws.com/uploads/original/2X/4/4e6ff70c96be2eb307a274d890bba8d71ba671b3.png) [@system](https://discourse.devontechnologies.com/u/system)\
**Post date:** [January 21, 2022, 11:14am UTC](https://discourse.devontechnologies.com/t/devonagent-to-open-and-scan-zip-archives/13280/3 "2022-01-21T11:14:35Z")

</div>