• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

How to copy documents using links from excel to web folder

N
#1
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.
 

My Computer

N
#2
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.
 

My Computer

T

Tim Williams

#3
It's likely you haven't had any responses because your question is lacking
detail.

What kind of web application (server OS?, intranet?)
Where is this excel sheet with the list of documents ? On your desktop, or
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 ?

Tim


"Naaz" <Naaz@newsgroup> wrote in message
news:DD39F425-6660-4E31-89BC-464064AB6A52@newsgroup

> 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.
 

My Computer

N
#4
Hi Tim,

Please see below:

1) Its Livelink ECM application installed on Windows Server 2003.
2) The excel sheet is in the web application. Excel sheet conists of
Document Names, Document Links as separate columns. And this excel is filled
by users regularly.
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.

Example: There are n different documents located in n different folders in
the web application. Users in a particular excel add the document names and
links. Our script should use this excel to copy all those listed documents to
a particular folder in the web application.

Hope I am clear now.

Any help is greatly appreciated.

Many Thanks,
Atiya.

"Tim Williams" wrote:

> It's likely you haven't had any responses because your question is lacking
> detail.
>
> What kind of web application (server OS?, intranet?)
> Where is this excel sheet with the list of documents ? On your desktop, or
> 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 ?
>
> Tim
>
>
> "Naaz" <Naaz@newsgroup> wrote in message
> news:DD39F425-6660-4E31-89BC-464064AB6A52@newsgroup

> > 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.
>
>
> .
>
 

My Computer

A

Al Dunbar

#5
"Naaz" <Naaz@newsgroup> wrote in message
news:CEA1B19A-E253-4B19-8DAB-D6E4BF604069@newsgroup

> 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
> filled
> 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.

/Al

>
> Example: There are n different documents located in n different folders in
> the web application. Users in a particular excel add the document names
> and
> links. Our script should use this excel to copy all those listed documents
> to
> a particular folder in the web application.
>
> Hope I am clear now.
>
> Any help is greatly appreciated.
>
> Many Thanks,
> Atiya.
>
> "Tim Williams" wrote:
>

>> It's likely you haven't had any responses because your question is
>> lacking
>> detail.
>>
>> What kind of web application (server OS?, intranet?)
>> Where is this excel sheet with the list of documents ? On your desktop,
>> or
>> 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 ?
>>
>> Tim
>>
>>
>> "Naaz" <Naaz@newsgroup> wrote in message
>> news:DD39F425-6660-4E31-89BC-464064AB6A52@newsgroup

>> > 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.
>>
>>
>> .
>>
 

My Computer

T

Tim Williams

#6
As Al asked: in what format are the document links ?

Are they the LiveLink "open short link" format: if not then what ?
How are the users getting these links that they then paste in ?

Theoretically you could use the LiveLink API to perform the copy, or you
could download the files and upload copies via the LL DAV path:
\\LLservername\livelinkdav\... (or something like that, depending on your
setup)

I'm guessing you want to be able to open this Excel file on a client, then
run a macro in the file to perform the copy ?

Tim



"Naaz" <Naaz@newsgroup> wrote in message
news:CEA1B19A-E253-4B19-8DAB-D6E4BF604069@newsgroup

> Hi Tim,
>
> Please see below:
>
> 1) Its Livelink ECM application installed on Windows Server 2003.
> 2) The excel sheet is in the web application. Excel sheet conists of
> Document Names, Document Links as separate columns. And this excel is
> filled
> by users regularly.
> 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.
>
> Example: There are n different documents located in n different folders in
> the web application. Users in a particular excel add the document names
> and
> links. Our script should use this excel to copy all those listed documents
> to
> a particular folder in the web application.
>
> Hope I am clear now.
>
> Any help is greatly appreciated.
>
> Many Thanks,
> Atiya.
>
> "Tim Williams" wrote:
>

>> It's likely you haven't had any responses because your question is
>> lacking
>> detail.
>>
>> What kind of web application (server OS?, intranet?)
>> Where is this excel sheet with the list of documents ? On your desktop,
>> or
>> 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 ?
>>
>> Tim
>>
>>
>> "Naaz" <Naaz@newsgroup> wrote in message
>> news:DD39F425-6660-4E31-89BC-464064AB6A52@newsgroup

>> > 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.
>>
>>
>> .
>>
 

My Computer

Users Who Are Viewing This Thread (Users: 1, Guests: 0)