"Naaz" <Naaz@newsgroup> wrote in message
> Hi Tim,
> Please see below:
> 1) Its Livelink ECM application installed on Windows Server 2003.
google indicates that this is a document management system.
> 2) The excel sheet is in the web application. Excel sheet conists of
> Document Names, Document Links as separate columns. And this excel is
> by users regularly.
What kind of links are these: shortcut files, UNC's, URL's, other?
> 3) The documents are again in the web application, we need to use the
> document links from the excel to copy all those documents (not links) to a
> folder in the web application.
If the document is in the web application, it seems more likely that the
link is a code or reference that the application looks up to extract the
document. The "documents" in such a system are most likely not individual
files as known to the file system, but records in a database.
If that is the case, you will need to find some programmatic way to get the
application to deliver the documents to your script. Given your intended use
of vbscript for this, you will need a COM interface into the application.
> Example: There are n different documents located in n different folders in
> the web application. Users in a particular excel add the document names
> links. Our script should use this excel to copy all those listed documents
> a particular folder in the web application.
> Hope I am clear now.
> Any help is greatly appreciated.
> Many Thanks,
> "Tim Williams" wrote:
>> It's likely you haven't had any responses because your question is
>> What kind of web application (server OS?, intranet?)
>> Where is this excel sheet with the list of documents ? On your desktop,
>> in the web app ?
>> Where are the documents to be copied located? Are they already in the web
>> app and you just want to move them, or are they on your local
>> desktop/filesystem ?
>> "Naaz" <Naaz@newsgroup> wrote in message
>> > Guys,
>> > Can anyone help me with this please?
>> > Thanks,
>> > Atiya.
>> > "Naaz" wrote:
>> >> Hi All,
>> >> We have a web application containing documents and each document has
>> >> its
>> >> own
>> >> link. An excel sheet is having all document names and their links as
>> >> separate
>> >> columns. Now, the requirement is to copy all the documents using their
>> >> links
>> >> from excel to a particular folder in the web application.
>> >> I would like to know what all are the possible solutions of this
>> >> requirement? Or if there is any script available to do this, it would
>> >> be
>> >> great.
>> >> Many Thanks,
>> >> Atiya.