Thursday, June 18, 2015

How to add a blank option to a pulldown menu

http://sharepoint-community.net/forum/topics/sharepoint-tip-need-a-blank-row-the-start-of-a-drop-down-list

What Sharepoint doesn't like when it comes to copy and paste

It's doesn't like newline characters

The only way I got Sharepoint to choose the "right" column for the Title column was to create it by hand and then copy/paste.
Last post in this thread:
https://social.technet.microsoft.com/Forums/office/en-US/d1e8e5af-245d-466b-8819-dabff16af9dd/choosing-which-column-is-the-title-when-importing-a-spreadsheet?forum=sharepointadminprevious

Best reference on how to import Excel into Sharepoint list

http://3sharp.com/blog/load-excel-data-into-a-sharepoint-2013-list-fast-and-easy/
One thing it didn't mention is that you have to be on Windows and using IE (at least in my experience) since Active X is needed to launch Excel. Also note the helpful comment about adding the sharepoint URL to the Trust Sites if you get an error.

Saturday, June 13, 2015

When using XML import for Ai

Make sure the variables column that Ai will use for it's data set identifier are unique, otherwise it will say that it's an invalid file and just block the import.

Good helpful links:
Online web converter from Excel (copy/paste) to Ai XML
https://joaofaraco.com.br/converter/

Good tutorial:
http://design.tutsplus.com/tutorials/quick-tip-data-driven-graphics-using-illustrators-variables-panel--vector-5604

Wednesday, June 10, 2015

IE's URL max length is 5120 characters

What our team figured out through many different and onerous tests is that the max URL length that IE supports is 5120 before it starts to just truncate. Come on IE, work like other browsers and get rid of the character limit please.

Thursday, June 4, 2015

Liked the answer on ownership

http://www.quora.com/From-the-perspective-of-a-CEO-what-are-the-most-underrated-skills-most-employees-lack