How to copy documents using links from excel to web folder
in [VbScript]
|
From: Tim Williams on 6 May 2010 23:06 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(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. > 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: Naaz on 7 May 2010 09:44 Hi Al, The links are URL's. Thanks, Atiya. "Al Dunbar" wrote: > > > "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. > >> > >> > >> . > >> > . >
First
|
Prev
|
Pages: 1 2 Prev: Encrypt files in folder Next: How to copy documents using links from excel to web folder |