Windows Vista Forums

How to copy documents using links from excel to web folder

  1. #1


    Naaz Guest

    How to copy documents using links from excel to web folder

    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 System SpecsSystem Spec

  2. #2


    Naaz Guest

    RE: How to copy documents using links from excel to web folder

    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 System SpecsSystem Spec

  3. #3


    Tim Williams Guest

    Re: How to copy documents using links from excel to web folder

    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
    newsD39F425-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 System SpecsSystem Spec

  4. #4


    Naaz Guest

    Re: How to copy documents using links from excel to web folder

    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
    > newsD39F425-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 System SpecsSystem Spec

  5. #5


    Al Dunbar Guest

    Re: How to copy documents using links from excel to web folder



    "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
    >> newsD39F425-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 System SpecsSystem Spec

  6. #6


    Tim Williams Guest

    Re: How to copy documents using links from excel to web folder

    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
    >> newsD39F425-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 System SpecsSystem Spec


How to copy documents using links from excel to web folder
Similar Threads
Thread Forum
Can't copy anything from My Documents folder on older hard drive. Vista General
Can't copy anything from My Documents folder on older hard drive. Vista file management
Recreate Documents Folder in Favorite Links Vista file management
Excel documents Vista General