Monthly Archives: January 2017

Adding a Custom Dictionary to Microsoft Word

Hi Oscar,

Attached is an example “Authority” document for commonly referenced species, perhaps something similar exists for the Forest Service?

www.fws.gov/northeast/njfieldoffice/PCP_2007/Chapterr_16_XVI.pdf

If you have a list of species, the way to get a .dic file is to open a plain text file, then save it with a “.dic” extension, or save it as a .txt function, and then change the extension from “.txt” to “.dic”

If you want all species of a certain genus (such as all hemlock species – a species I am familiar with from Tennessee that I believe you have several types here in the PacNW), I had an idea you could go to ITIS.gov and obtain the “name authority” list from them:

https://www.itis.gov/

I just downloaded a file for genus “Tsuga” from the following site, by entering “tsuga” in the taxon name entry field:

https://www.itis.gov/download/

I refined my query be selecting “Genus” for “where to begin the download” and I selected “subspecies” for where to end the download;

Further, I removed all of the “additional data” beyond the “base data.”

· Synonyms

· Vernacular

· Jurisdiction

· References

· Geographic Division

· Comments

What I got was a file called 712.csv (see attached).

I was prompted to open up the .csv file using MS Excel – *don’t do that.*

Instead, open up Excel on its own, then import the .csv file.

If you have not done this before, the way to do this is to click the “Data” tab in the Excel ribbon, and then choose “From Text” button on the left hand side of the ribbon.

You will be prompted to select a text file. Choose your text file from the Windows file explorer window that pops up. In my case, my file was “712.csv.” Yours will likely be named something random by ITIS, so just remember what the file name was and where it got downloaded. If you don’t see the downloaded file where you expect it, you may have to change your windows explorer to “show all file types” to get the .csv file to shop up as a file to choose to import (this happened to me).

Once you have selected the file, and clicked “OK,” this will launch the Text Import Wizard. Step 1 in the wizard is not important, as long as “delimited text file” is indicated.

In step 2, you must specify the delimiter.

In the case of the ITIS file I obtained, the delimiter is a pipe “|” so it is necessary to indicate that by selecting “other” and entering the pipe character (|) – no parentheses. Then you are free to finish the wizard, and your data will be neatly arranged into separate columns in Excel.

You can ignore everything else in the file besides column D (genus name) and F (species name).

At this point there is a slight problem in that the genus and the species are separated by a tab, which won’t help your dictionary with correct spelling of your species names.

Therefore, I propose that you select column F (so the whole column is highlighted), and then past column F into a blank text document.

Then save it as “yourfilename.dic” (I created a “tsuga.dic” file, see attached.)

In this case you can add on “Tsuga” to prevent the spell checker from catching that.

If you have a whole bunch of genus names, you could filter your column D by genus and repeat the process of creating a .dic file.

Here are the instructions I copied from Yahoo Answers re: importing a custom dictionary:

https://answers.yahoo.com/question/index;_ylt=A0LEVioRzo9YiW0A5zInnIlQ;_ylu=X3oDMTEyc3I1M2dlBGNvbG8DYmYxBHBvcwMxBHZ0aWQDQjI2ODNfMQRzZWMDc2M-?qid=20100317173055AAPkEId

Not into the main dictionary, but if the words are in the correct file format, you can supply the file as a custom dictionary.

1. The file has to be a straight ASCII file (not a Word .doc or .docx).
2. The file has to have the extension .dic
3. Each word has to be on a line by itself.
4. The words have to be in alphabetical order (I’m not sure what happens if they’re not. Word MIGHT sort them for you.) Note that upper case letters are "lower than" lower case letters.
5. I think that lower case letters also match words in documents with upper case letters, but the reverse may not be true. That is, letters in upper case on the dictionary may match only upper case letters in documents.
6. The file should be added to this directory:

In Windows XP: C:Documents and Settingsyour usernameApplication DataMicrosoftProof

In Windows Vista: C:Usersyour username AppDataRoamingMicrosoftUProof

(Note: If the directory Appdata doesn’t appear in Windows Explorer, enter the full path name in Explorer’s address window.)

The custom dictionary has to be added to the dictionary list this way.

In versions of Word prior to Word 2007:

1. Click the Tools->Options menu item.
2. Click the Spelling & Grammar tab.
3. Click the Custom Dictionaries button.
4. Click the Add button.
5. Navigate to the dictionary, select it and click the Open button. The dictionary should now be added to the dictionary list box.
6. To be in use, it has to have a check in its checkbox.
7. To make the dictionary the default, select it (don’t uncheck it) and click the Change Default button.
8. Click OK.

In Word 2007:

1. Click the round Office button in the upper-left corner of the window.
2. Click the Word Options button.
3. Click Proofing.
4. Continue as in Step 3, above.

Hope that helps.

Another answer suggests Microsoft has instructions on adding a custom dictionary, I followed the recommended URL and arrived here:

https://support.microsoft.com/en-us/help/322198/how-to-add-a-custom-dictionary-in-word

I have not tested these steps with the .dic file I created.

Interesting research question, thank you for sharing your idea – let me know if you have other questions. Would love to know if this helps you with the issue you identified.

-Tanner

Tanner Jessel, MSIS
Science Communications Research Fellow
Forest Service

Pacific Northwest Research Station

p: 503-808-2108
f: 503-808-2130
tjessel
1220 SW 3rd Ave, Suite 1400
Portland, OR 97207
www.fs.fed.us
Caring for the land and serving people

This electronic message contains information generated by the USDA solely for the intended recipients. Any unauthorized interception of this message or the use or disclosure of the information it contains may violate the law and subject the violator to civil or criminal penalties. If you believe you have received this message in error, please notify the sender and delete the email immediately.

Chapter_16_XVI.pdf

Advertisements

Steps to establish sunflower planting at TDOT SmartFix-40 site?

Kristin,

Hope you’re doing well. We’ve exchanged messages before about park land opportunities on TDOT right-of-way for SmartFix-40 section of I-40.

Today I’m writing because Parkridge Community Organization in Knoxville Tennessee funded a study by the East Tennessee Community Design Center to beautify the area in the vicinity of the SmartFix-40 overpass at 6th Avenue.

Some progress has already been made in cooperation with TDOT with a "Sixth Avenue Mural Project" to beautify the I-40 overpass at 6th Avenue.

One of the East Tennessee Community Design Center’s suggestions was to beautify the area inside the TDOT fence (see map and photo below) by establishing a planting of sunflowers.

Image Source: July 2016 Google Street View, https://goo.gl/maps/dpe4kDZSNFL2

Obviously, this would require a new partnership with TDOT to make possible, likely also involving the City of Knoxville Public Works and Urban Forestry to coordinate on establishing the planting.

I wonder if you could help me out with understanding what might steps need to be taken from the neighborhood organization to get the ball rolling on preparing a spot for a sunflower planting? Can you foresee any objection from TDOT with respect to establishing a stand of sunflowers at this location?

The biggest cost will be sunflower seeds – but I believe the neighborhood organization can cover that cost. I wonder if you’re aware of any TDOT grants that might go towards the cost of acquiring sunflower seeds for this location?

Thanks,

Tanner

Answer re: Q on “cap on file size in SharePoint 2013”

Hi Keith,

Answer to your Q here:

By default, the default document size threshold is set to 250MB, but can be changed to support the maximum boundary of 2GB.

An example of a boundary is the 2 GB document size limit; you cannot configure SharePoint Server 2013 to store documents that are larger than 2 GB. This is a built-in absolute value, and cannot be exceeded by design.

https://technet.microsoft.com/en-us/library/cc262787.aspx

-Tanner

This electronic message contains information generated by the USDA solely for the intended recipients. Any unauthorized interception of this message or the use or disclosure of the information it contains may violate the law and subject the violator to civil or criminal penalties. If you believe you have received this message in error, please notify the sender and delete the email immediately.

Some More Detailed H-1 Extension Data

I went ahead and did my copy-paste plan to capture the owner information for each address I had flagged as "owner absent." I copied the address out, then pasted it in to http://tn-knox-assessor.publicaccessnow.com/PropertyLookup.aspx, and copied the owner address out.

Result is updated spreadsheet here:

https://docs.google.com/spreadsheets/d/12zQ69ppfy4d2G14rtQHl6SkftrgF3r0t1ixbtVCU-wQ/edit?usp=sharing

The updates revealed a large number of errors in my initial classification of "owner occupied" versus "owner absent." (Either I was just wrong a lot, or the ownership data was updated since I last looked at it). I corrected 30 "P" (owner absent) properties to "B" (owner address matches street address).

I will need to make corrections to my color-coded map based on this latest round of data quality assurance.

Kaye, if the MPC GIS shop can get this data in a way that is less risky for introducing human error, that’d be ideal – any human error (operator error in GIS speak) on my part is all too easily cast as "intentional misleading."

My 30 corrections means my initial tally and related metrics were off by 30 owner-occupied properties. It’s possible, if not likely, similar level of error would be found if I went through my "owner occupied" spreadsheet – properties I classified as "owner occupied" may well be "owner absent."

Also – there are four "weird" cases that I just erred on the side of classifying as "not owner occupied."

  1. First is Cochran Enterprises in the old Park City Library on Magnolia.
  2. Second is residence owned by a church, but since the church is not a person, I say it is not owner occupied.
  3. Third is a residence owned by Hope Central. Same logic – not owner occupied.
  4. Fourth "weird" case is where a human being has a P.O. box as their mailing address, but I have no information either way that the owner lives or does not live at the residence.

So of the original 276 I said were "not owner occupied," subtract 30 to reflect my corrections, leaving, 236 residences, give or take, that are not owner occupied.

Of those, 18 absentee owners are "neighbors" in "
parkridge" (again, the number is likely lower, due to the P.O. Box problem)

6 are "East Knoxville Neighbors" broken down as follows:

  • 3 in "Park City"
  • 2 in "Burlington"
  • 1 Holston Hills

A common refrain is "disadvantaged entrepreneurs in East Knoxville rely on rental properties for income and can’t afford preservation-quality materials and labor called for in H1 guidelines" I think this analysis hints at the reality on the ground; the recurring argument that low-income East Knoxville entrepreneurs will be harmed by H1 is pretty far off base.

The absentee property owners are literally all over the map as can be seen in the images below (interactive map here, look on the maps tab)

County View:

National View:

-Tanner

Share internal USGS blog posts on ORCID?

Hi Mike,

Tanner here, from back in the NBII and DataONE days.

I’m doing a post-masters’ ORISE fellowship in science communication with the U.S. Forest Service’s Pacific Northwest Research Station in Portland, Oregon. (And yes, I’ve already evangelized here about getting the Forest Service Research Data Services repository on board as a member node for DataONE).

I’m writing today because I’m looking in to the USGS’ use of ORCID. We recently had a PNW Research Station employee as a co-author on a USGS publication, and this brought USGS use of (requirement of) ORCID to our attention.

I have learned the Forest Service has a fair number of researchers already using ORCID – nothing to brag about.

While I don’t think we’re in a position to “require” that our researchers use ORCID, I think it’d be worthwhile to encourage them to sign up for one and share it with us.

Enter a science communication problem: communicating the value of ORCID to our scientists.

I figured USGS already had some promotional material or documentation on why ORCID is a good idea – a quick search of “ORCID site:usgs.gov” pulled up promising material at <https://my.usgs.gov/confluence/pages/viewpage.action?pageId=555648166>.

However, two documents detailing USGS leadership thinking on the value of ORCID are internal only.

1. http://internal.usgs.gov/thecore/leaders/2016/03/08/public-access-to-results-of-usgs-funded-research-scholarly-publications-and-digital-data/

2. http://internal.usgs.gov/thecore/leaders/2016/05/02/science-data-policies-governing-usgs-funded-research-scholarly-publications-and-digital-data/

I was wondering if you could copy and paste the content of those posts to share with me?

Also – if you have any other contacts who might have “promotional” material on the value of ORCID – I’d much appreciate if you could forward my inquiry on to see if anyone has material that could help me communicate the value of ORCID at the Forest Service.

Thanks,

Tanner

Tanner Jessel, MSIS
Science Communications Research Fellow
Forest Service

Pacific Northwest Research Station

p: 503-808-2108
f: 503-808-2130
tjessel
1220 SW 3rd Ave, Suite 1400
Portland, OR 97207
www.fs.fed.us
Caring for the land and serving people

This electronic message contains information generated by the USDA solely for the intended recipients. Any unauthorized interception of this message or the use or disclosure of the information it contains may violate the law and subject the violator to civil or criminal penalties. If you believe you have received this message in error, please notify the sender and delete the email immediately.

Possible Workaround for Image Upload Problem

Hi Tiffany,

The difference between the two image upload options appears to be this:

· The “add image” icon to the right (screen capture from earlier message) uploads an new image directly to the post

· The “add image” icon to the left (screen capture in this message) allows editor to specify a URL to an existing image

I have taken a few screen captures to illustrate a possible workaround.

1) Upload an image with the “Documents and Media Upload” (note: no preview of image – feature request?)

a. https://pnw-dr-sand-1.netbase420.com/sites/default/files/2007-Front-of-OFSL.JPG

b. See screen grab “Drupal-image-by-url-no-preview.png”

2) Add image using icon to left in editor window

a. See screen grab “Drupal-image-by-url.png”

b. Finished product: https://pnw-dr-sand-1.netbase420.com/research-labs/olympia-forestry-sciences-laboratory

I’m not sure actually doing this makes sense, from a content management perspective, but perhaps it does.

Any thoughts?

Thanks

Tanner

Tanner Jessel, MSIS
Science Communications Research Fellow
Forest Service

Pacific Northwest Research Station

p: 503-808-2108
f: 503-808-2130
tjessel
1220 SW 3rd Ave, Suite 1400
Portland, OR 97207
www.fs.fed.us
Caring for the land and serving people

This electronic message contains information generated by the USDA solely for the intended recipients. Any unauthorized interception of this message or the use or disclosure of the information it contains may violate the law and subject the violator to civil or criminal penalties. If you believe you have received this message in error, please notify the sender and delete the email immediately.

USDA VIVO Compatibility with

Results of inquiry at https://vivo.usda.gov/contact re: USDA VIVO https://vivo.usda.gov/about, which is a type of CRIS (Current Research Information Systems). More on VIVO online: http://vivoweb.org/info/about-vivo

From: Jessel, Tanner – FS
Sent: Tuesday, December 20, 2016 5:29 PM
To: Marsh, Emily <emily.marsh ars.usda.gov>
Subject: RE: Message from the VIVO Contact Form

Thanks for the info –

Will pass this info along.

By the way, I have since learned that an ORCID was not a requirement of a publisher, but a requirement of the USGS –

One of our scientists was a co-author on a USGS paper.

Since we do not have ORCID for our FS researchers, the USGS dropped the requirement for non-USGS co-authors.

By the way, I do like the sound of “Dr. Jessel,” but I’m only a post-masters’ researcher right now, MSIS. 

Perhaps one day, though!

-Tanner

From: Marsh, Emily
Sent: Tuesday, December 20, 2016 2:13 PM
To: Jessel, Tanner – FS <tjessel fs.fed.us>
Subject: RE: Message from the VIVO Contact Form

 

Hello Dr. Jessel:

Thank you for your interest in VIVO.

At this time, the USDA VIVO instance is not equipped for integration with ORCID identifiers. The implementation of new features is on hold until ARS can determine in what direction it wants the project to proceed.

We will keep your observation in mind when the project can more forward again.

Thanks again, Emily

Emily Marsh, Ph.D., MLS

Librarian | Digital Library Branch

National Agricultural Library

From: Tanner Jessel [mailto:tjessel fs.fed.us]
Sent: Tuesday, December 20, 2016 4:32 PM
To: NAL-USDA-VIVO <NAL-USDA-VIVO [ a t ] ars.usda.gov>
Subject: Message from the VIVO Contact Form

Message from the VIVO Contact Form

From: Tanner Jessel

Email Address: tjessel fs.fed.us

IP address: 127.0.0.1

Comments: Hi, I’m a researcher in science communications with USDA FS Research and Development, Pacific Northwest Research Station, Communications and Applications Group. We have a researcher who is being required to register for an Open Researcher and Contributor ID (ORCID) as a condition of submitting a manuscript for publication to a scientific journal. I understand that VIVO can be integrated with ORCID. If it has not been done already, I am wondering if it is possible for you to integrate ORCID with USDA VIVO so that our researchers will have an ORCID that is linked to USDA Vivo. Instructions here: https://wiki.duraspace.org/display/VTDA/Activating+the+ORCID+integration If it has already been done, can you advise on how our scientist might obtain her VIVO-linked ORCID? Thanks, Tanner

How is a Forest Service DOI born?

Hi Dave and Laurie,

I’m a post-master’s research participant in science communication with the Pacific Northwest Research Station’s Communications and Applications Group.

I found your contact info here: https://www.fs.usda.gov/rds/archive/contactus

I’m looking into the Forest Service’s use of digital object identifiers and I noticed that the Data Archive reliably uses DOIs.

I thought you might be able to help me better understand the process by which FS is able to generate a DOI for digital assets.

I’ve gathered a few facts:

· the USDA Forest Service is registered with crossref.org with member ID 1450.

· datasets published by the FS Research Data Archive generally have the prefix “10.2737”

· Digital Assets with a DOI on TreeSearch appear to have the same prefix (10.2737)

o Examples:

§ Northern Research Station: http://doi.org/10.2737/NRS-GTR-87-2

§ Rocky Mountain Research Station: http://doi.org/10.2737/rmrs-rp-3

§ Pacific Northwest Research: http://doi.org/10.2737/pnw-gtr-839

With these facts in hand, I have a few questions I hoped you might be able to shed some light on.

1) Do you know how a DOI is assigned to a FS digital asset (either in FS RDA, or TreeSearch?)

If you do have knowledge of how a DOI is assigned to FS digital assets, I have three additional questions I wonder if you could help me with:

2) Is there a lag time between when an asset is uploaded to TreeSearch and when it is assigned a DOI?

3) Are existing publications being retroactively assigned a DOI?

4) Is an individual Research Station able to assign DOIs to publications, either retroactively or proactively?

Thanks for any help,

Tanner

Tanner Jessel, MSIS
Science Communications Research Fellow
Forest Service

Pacific Northwest Research Station

p: 503-808-2108
f: 503-808-2130
1220 SW 3rd Ave, Suite 1400
Portland, OR 97207
www.fs.fed.us
Caring for the land and serving people

This electronic message contains information generated by the USDA solely for the intended recipients. Any unauthorized interception of this message or the use or disclosure of the information it contains may violate the law and subject the violator to civil or criminal penalties. If you believe you have received this message in error, please notify the sender and delete the email immediately.

A few problems uploading Olympia Lab Poster

Hi Tiffany,

I noticed something that might be kind of a bug.

I have a lab poster to upload.

The poster was given to me as a .PPT.

I used powerpoint to convert it to .PDF

I then used “Upload Content” to upload a “PDF with Preview”

The end result is kind of bizarre.

https://pnw-dr-sand-1.netbase420.com/document/olympia-forestry-sciences-lab-40-year-history-poster

As you can see, the PDF preview is larger than the browser window. I suppose the lesson learned is that the feature should not be used for “unconventional size” PDF documents – it may work just fine for normal 8.5 x 11 print size PDF documents.

I do appreciate there’s a preview for the poster – what might need to happen is the preview is scaled automatically to the browser window?

Also I think the types of content for “Documents and Media” might need some additional instructions in terms of what exactly a person should upload to it.

https://pnw-dr-sand-1.netbase420.com/node/add/documents

The options for now are:

Agendas

Briefing Papers

Other Documents

Photos

Podcasts

Presentations

Transcripts

Videos

White Papers

Filetypes include:

doc

docx

ppt

pptx

xls

xlsx

pdf

txt

gif

png

jpg

jpeg

bmp

wav

mp3

mp4

mkv

webm

flv

avi

csv

The problem I had was that after uploading a GIF, there was no “document preview,” but there was an option to download.

I’m thinking my use of this content type was a bit of overkill – I could have just gone to https://pnw-dr-sand-1.netbase420.com/node/add and added the GIF there.

I think that “Posters” might be a good fit here since they are an odd file type and they are very similar to “Presentations.”

I just tried to add the Poster as a “document and media” but it seems to have failed because it is 108 MB and the limit is 100 MB.

There was not a warning for why it failed – if possible might be worth adding that on to save some frustration for editors down the road.

Anyway just some quick thoughts to share before wrapping up work today.

-Tanner

Tanner Jessel, MSIS
Science Communications Research Fellow
Forest Service

Pacific Northwest Research Station

p: 503-808-2108
f: 503-808-2130
tjessel
1220 SW 3rd Ave, Suite 1400
Portland, OR 97207
www.fs.fed.us
Caring for the land and serving people

This electronic message contains information generated by the USDA solely for the intended recipients. Any unauthorized interception of this message or the use or disclosure of the information it contains may violate the law and subject the violator to civil or criminal penalties. If you believe you have received this message in error, please notify the sender and delete the email immediately.