locked
import and upload data to share point through excel sheet RRS feed

  • Question

  • respected microsoft team.

    as we know we can upload document to share point one by one with the properties of the document.

    my question is can we prapare excel sheet with the location of pdfs of documents  and fill the required properties ( for example if i have 300 documents) then upload the excel sheet to share point? and if it success can we see these documents on share point as a separete documents? mean after uploading can we search the documents wich uploaded to share point through excel and find it with the pdf of the document  (auto extract of the excel sheet on share point) or it will be available as excel sheet only?

    as i know there is inhouse programs give the option to upload the patch of documents by excel then it will be available as separate documents so for sure the great share point program should have this option.

    waiting your response on my email address ( kareemccic@hotmail.com) urgently please that we are going to buy the program but need to confirm the availability of this option which it will save our time and will save our time better then the upload one by one document .

    Regards,

    Kareem O Elsayed

    Thursday, June 7, 2012 12:09 AM

Answers

  • This is a technical forum, manned by tech staff.  You have a pre-sales question.  How're you buying the product?  If you're buying it directly from MS, then they'll be a sales consultant you can chat too.  If you're going via a partner or licensed intermediary, pose the question to them.

    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/

    Friday, June 8, 2012 11:50 AM
    Answerer

All replies

  • I highly doubt you'll get a Microsoft response, let alone to a hotmail address.

    All I can think of in answer to your query is to: -

    1. Bulk Upload materials to a library
    2. Create the columns that match your data types
    3. Use Datasheet view to paste all the properties that you have

    You may also want to think about the validity of just uploading heaps of stuff into SharePoint, especially if it's not relevant data.  Things like federated search and BCS can help you access this content without storing it in SharePoint.


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/

    Thursday, June 7, 2012 12:53 PM
    Answerer
  • i do appreciate you response but actually my company going to buy share point product and i used before an inhouse program was providing me this option to upload drawings and documents one time by excel sheet with full properties and once opload complete you can search the documents one by one and find the pdf and full properties as you uploaded .

    but till now there is no response from MS staff  actually this is not the way to deal with customers they have to response or at least if they don't know how to solve or answer they should find somebody can answer officialy way !!


    Kareem O Elsayed

    Friday, June 8, 2012 10:25 AM
  • This is a technical forum, manned by tech staff.  You have a pre-sales question.  How're you buying the product?  If you're buying it directly from MS, then they'll be a sales consultant you can chat too.  If you're going via a partner or licensed intermediary, pose the question to them.

    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/

    Friday, June 8, 2012 11:50 AM
    Answerer