Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

Importing Data to Profiles

  Asked By: Marla Nixon         Date: Jan 05, 2010      Category: Sharepoint      Views: 200
 

I have many drawings (*.dwg) that I am putting into Sharepoint Portal
Server.

I created a profile specifically for them, but since they are not
Microsoft items, they do not automatically pull in the information.

So I created an Excel spreadsheet with their individual properties,
such as Description.

Question is this: Is there a way to write a VB script to go out to
the Excel spreadsheet and pull in the properties into each documents
profile?

Tagged:        

 

1 Answer Found

 
Answer #1       Answered By: Jayme Raymond          Answered On: Jan 05, 2010       

I'm not a developer but for one of our projects, our customer had over
1,000 PDF files. They were managing this through an access database that
included all the metadata for each file as well as a path to the
location of the physical files on the PC or Server. My developer then
developed an executable via VBScript that extracted that information,
created the folder structure in SharePoint and then imported the file
into the appropriate location. After talking to him, he told me it can
be done via access, excel  or a flat file. You might want to check with
your developer because it can be done.

 
Didn't find what you were looking for? Find more on Importing Data to Profiles Or get search suggestion and latest updates.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].