How to copy documents using links from excel to web folder
in [VbScript]
|
From: Naaz on 4 May 2010 11:26 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 any vbscript is available to do this task? Many Thanks, Atiya.
From: Naaz on 5 May 2010 06:42 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.
From: Tim Williams on 5 May 2010 22:48 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(a)discussions.microsoft.com> wrote in message news:DD39F425-6660-4E31-89BC-464064AB6A52(a)microsoft.com... > 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.
From: Naaz on 6 May 2010 06:36 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(a)discussions.microsoft.com> wrote in message > news:DD39F425-6660-4E31-89BC-464064AB6A52(a)microsoft.com... > > 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. > > > . >
From: Al Dunbar on 6 May 2010 21:47 "Naaz" <Naaz(a)discussions.microsoft.com> wrote in message news:CEA1B19A-E253-4B19-8DAB-D6E4BF604069(a)microsoft.com... > 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(a)discussions.microsoft.com> wrote in message >> news:DD39F425-6660-4E31-89BC-464064AB6A52(a)microsoft.com... >> > 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. >> >> >> . >>
|
Next
|
Last
Pages: 1 2 Prev: Encrypt files in folder Next: How to copy documents using links from excel to web folder |