Subscribe Bookmark RSS Feed
Justin_Chilton

Joined:

Aug 27, 2015

Word Import Tool

 

Description 

The Word Import Tool add-in allows you to import text, tables, or images from a Word document. It can also create a table summarizing one or more Word documents.

Launch WindowLaunch Window

Import Text

Import text from a Word document for use in Text Explorer.

Import Text.png

Import Tables

Import individual tables from a Word Document as a JMP Data Table. This feature includes a preview mode for each table with the opportunity to change column headers and data types before importing.

Import Tables.png

Import Images

Import images from a Word document as an Expression column. A source column and page number columns are included. Title and Descriptions are pulled from the Alt Text properties for an image.

Import Images.png

Document Summary

Get a summary a group of Word documents as a JMP Data Table. This information comes from OS level file properties as well as Microsoft Word specific properties.

 Document Summary.png

UPDATE: Version 1.1 (July 13, 2017)

Changelog:

  • Added ability to select a directory of files as an alternative to the previous method only allowing file selection. The two options (Select File(s) and Select Directory) appear as dropdowns when you click any of the buttons.
Comments
Craige_Hales

Cool tool! What a great way to rediscover the collection of DOCX files that has been growing in my Downloads folder.

tbidwell

First of all, thank you for this add-in.  It has helped me greatly!

 

My question is whether there is a limit on the number of Word docs it can import?  When I use the Add-in to import .docx files, it tends to stop around 300 - 350 docs (I've had as many as 500 - 600 to import in a folder, so I have to do it in 2 stages). Maybe the limit is on my end with my computer, but I thought I'd check first to see if it has something to do with the Add-in itself.

 

Thanks in advance for any direction.

Justin_Chilton

Hi @tbidwell,

I am glad to hear you find this add-in useful!

My add-in utilizes a JSL function, Pick File(), to prompt users to select the Word document files. There is a buffer limit when using this function that can cause some selected files to be excluded. This limit relates to the total length of all of the paths, so there is not a set limit on the number of files. Is the path to your Word documents fairly long? If so, you could try moving them to a shorter path to be able to import them all (although, it may be easier to just import twice).

One thing I could do is add the option to select a directory and import all documents within that directory instead of requiring you to select all files. Is this something you would find useful? 

Also, which of the four features of this add-in are you using?

Kind regards,

Justin

Justin_Chilton

Hi @tbidwell,

Check out the new verison of this addin I just posted (v1.1). I added the ability to choose a directory and import all docx files (non-recursively) within the directory.

Thanks,

Justin

tbidwell

Hi @Justin_Chilton,

 

Thank you for your response.  The problem is definitely the length of the path. The files were stored on a network drive down in a number of sub-folders.  Adding the option to choose a directory would work perfectly.  Thank you for the updated version.  I haven't tried it yet, but I'm sure it is exactly what I need.  So far, I have only used the option to choose an entire word doc.

Article Tags
Contributors