Creating a database that supports FileTables < Previous                                Next > Deleting or downloading files

You have two ways of adding files to an existing FileTable.

  1. Adding them one by one using My Semantic Search.
  2. Dropping files on the FileTable’s folder.

We’ll explain both ways here.

First, you can execute the following procedure to add a single Word file to the newly created FileTable.

Adding a file to a FileTable using My Semantic Search
  1. At the top of the Documents section, click Add.
  2. Browse to the location of a Word document you would like to add to this FileTable.
  3. In the Open dialog, select the Word document and click Open.
  4. Check that the file has been added to the FileTable, and is now listed in the Documents section.
  5. Wait a few seconds, and then click the document to force the application to update the Tag Cloud section.

It takes a few seconds for the SQL Server background process to scan the document for the most relevant terms and make them available to the FileTable.

The previous procedure is not practical if you need to add more than a couple of files to the FileTable. The following procedure helps you to deal with adding more than one file.

Adding several files to a FileTable
  1. Open Windows Explorer, and browse to the name of the machine that hosts the SQL Server instance.
  2. Double-click the MSSQLSERVER shared folder.



    When creating a database, My Semantic Search creates a folder with a random name.
  3. Double-click the folder with a random name.

  4. Double-Click the created FileTable.

  5. Drop all the files you want into this folder.

  6. Go back to My Semantic Search, and click Search at the Search Options section, to force the Documents list to update.

  7. Check that the Documents list now shows all the new documents you added to the FileTable folder.

 

Creating a database that supports FileTables < Previous                                Next > Deleting or downloading files

Last edited Nov 4, 2011 at 7:58 PM by danielaltamirano, version 6

Comments

No comments yet.