Getting Connected

Connect – Logon – Login

Login

Your URL will be a subset of http://TheVizzini.com/YourSite. To login simply choose your account from the customer login page and enter your username and password supplied by your account executive.

Start Page

After logging in to your site you will be immediately directed to the Start Page. The Start Page is the home page for your site, It may contain any html elements. This is where you will find links for asset management and links to current layout documents. The Start Page button is available on all pages within your site.

Managing Your Password

Click on the Change Password link next to your name on the top bar any window.

You will be directed to enter the password you used to login and set a new password for yourself. If you forget your Username or Password contact your account representative at WMSG Incorporated at 1-214-638-4926. You may also send an e-mail to data@wmsginc.com requesting a new password. (Admins do not have access to your current password. For security reasons your password can only be reset to a new one.)

User Types (Just my type?)

There are two basic user types each with their own subcategories:

Admin —

Full Admins
Full access to all site attributes including adding and deleting database connections, deleting records, and editing all site users rights.
User Admin
Granted rights to add users and set their security level. Full rights to all database tables and fields including add and delete privileges for all records.
Full Table Access
All rights to edit all tables and records with NO rights to edit other users access.

User —

All user rights can be specifically defined in each table with view only rights or edit rights via group access settings. All users DO NOT have delete rights for deleting any record in any table. If a deletion is necessary an admin must perform the action.

Managing Users

Users with User Admin privileges and above have access to manage user rights. A standard user will have two buttons displayed at all times to either Logout of the system or quickly return to the Start Page. (The page you are directed to immediately after logging in to the site.) If you are given User Admin rights there will be a third button called Configuration.

Under the Manage Users section click on Click here. There are two tabs in this section. One is for group and the other is for individual users.

Group Permissions —

Group permissions is where access to view or edit specific tables are set. When you create a group you will assign it a unique name and select whether members of that group can view or edit any database table on the site. The three admin levels will always have full permissions to every table on the site. Admins will always have rights to delete any record in any table on the site. Be careful to only give admin rights to those who need that level of control.

User Permissions —

When creating a user you may then give them access to one or more group access levels. These users will see only the tables they either have View rights or Edit rights to. They will only have access to edit fields on database tables that is granted by their group level permissions.

Working With Databases, Tables, and Records – Oh my!

Let’s see what’s in there

Databases or Products (I love the smell of synonyms in the morning.)

TheVizzini.com is made up of databases and tables used to create final pint files. Databases hold all of the information that will be printed on a particular product layout.

• Products are defined as a database table that has the ability to create output suitable for print or posting on the web.

• Support tables are defined as tables that are necessary for products but do not have the ability to create any output by themselves.

Viewing Databases and Records can be achieved by clicking on the database name located within the left frame of the window.

Here you can see an example of multiple databases, some of which contain products and others are support databases and tables. By clicking on the database name the view will be expanded to reveal the tables held within the database.

Product Tables —

Within this example all of the tables in the EOC database are considered products. That simply means these tables have the ability to create an output document.

Support Tables —

All of the tables inside of the Medco_Tables database are used in the creation of the products in the EOC database. Without the support tables the products would be incomplete. As you can see support tables may be located within the same database or in a separate database or even on a different web site.

Viewing Records (What’s in there mommy?)

Let’s take a look at a record. To view what is in the table click on a database name and click on the table name you want to view.

Grid View —

Grid View is the basic view of a database. It is much like viewing an Excel spreadsheet. Although a database table may have thousands of entries this view will only display a limited number of records at a time. The number of records to display may be set by an Admin only as this is a global setting. At the top of the window there is a count of the total records in the table. If there are more records in the table than the display setting the right and left arrows next to the count will become active allowing you to change the displayed records.

Note: The Delete button is only available to admins with full table access and above.

Here is the table named WelcomeKit_Letter. This is a support table that will produce letters for a customer’s welcome kit after a purchase.

There are a few key things you can do in Grid View that cannot be done in any other view.

1. Sort records (Ascending or descending.)
2. Filter records (Create selections to view a subset of the data. Filters may be applied to one or more fields at a time.)
3. Batch Update (Update data for a single field on all selected records simultaneously).
4. Create Output (Only applies to non-support tables.)
5. Export Data (If a filter is set only the filtered records will be exported.)
6. Save Queries (Save selections for quick access.)

Grid View Options —

By default the data in the grid view is truncated allowing you to see more records at a time. By clicking the Options button you can un-check the Truncate Memos selection to show all of the contents in the data fields. The Grid View options is where you can perform vital tasks like saving queries (quick pre-saved selections for repeated tasks), exporting the selected records, and creating proofs from the selected set of records.

Here is an example as set by default:

This is what it will look like with Truncate Memos turned off:

A note about the Create Proofs button: Creating proofs will be covered extensively in a later section. The filter records is very important to the process of creating or updating documents. Only specific database tables have the ability to perform this task. Inadvertently running this process without proper filtering may delay other users create proofs function while yours completes.

Record View —

This is the view where edits can be made. To view particular record you may double-click on the record or click View - Edit button.

Here you can perform several task:

1. Lock records from further changes
2. Clone a record (Make exact replica of an existing record. This is useful when a new document will be similar to an existing one.)
3. Change records using the arrows at the top of the record.
4. Edit a fields content

To edit a field you may hover over the field name to produce an Edit button

or click on the field name to reveal the Edit button.

You will also notice the View Field History selection. This will be discussed later.

Entering Edit Mode

Edit Mode will allow you to make changes to that field and lock the record so that others cannot make changes to it until you release it. That record belongs to you as long as you maintain Edit Mode. This will be indicated by the Edit Mode bar displayed at the top of the screen. This message tells you that you have an exclusive lock on this record with a 20 minute countdown timer. (The timer is designed so that a user cannot inadvertently lock a record in edit mode permanently.) A warning will appear when there are 2 minutes left in the counter. You may then extend your lock for another 10 minutes. You may keep renewing by 10 minute intervals on each message. If you have left your system unattended and the timer expires any unsaved changes will be discarded and the record will become available for editing by another user.

If another user selects the record you currently have locked they will be notified what user currently has the lock and how much time is remaining on the exclusive lock. As you make and save changes to the record the other users screen will be updated with your changes. When you exit Edit Mode the other user’s message will be removed and the edit functions will become available.

Note: As a courtesy to other users it is good practice to click the Exit Edit Mode button before leaving the record. This will release the record to other users without waiting for the 20 minute timer to run out. Leaving the record will not automatically release the exclusive lock.

Field Types —

Currently there are four different field types.

1. Text – Contains a single line of text. This is commonly used for version and description fields. This is the field type that is used for image placements where the only pertinent information is the path and the exact name of the image file. This field type has a set character limit. All data entered after this character limit will not be saved. Although this field type can hold up to 255 characters many times it is set much smaller. When in Edit Mode this field type will appear as a single line:
2. Number – Although the appearance of this field in edit mode is the same as a text field this field type can only contain numbers. Upon entering a non-numeric value and attempting a save the user will be presented with an error screen. The user must correct the entry or cancel the edit. Number fields will typically have a set number of decimal places available. If the user enters no decimal places in the field the system will fill the default number of spaces with zeros.
3. Variable Character or Memo Fields – This field type is used extensively within TheVizzini.com to enter most types of text. This field type is characterized by the ability to hold large amounts of text information. This field type is the only field type that can enter paragraph returns within the field.
4. Boolean or True/False – This field type is used to turn something on or off. When checked the value is True. When left unchecked the returned value is False.

   

Editing Data (Change is all around us. Mostly under the sofa cushions.)

Making edits to the data fields is where a user will spend most of their time. By clicking the Edit button on any field you have entered Edit Mode. With the edit window open you may enter data directly in the field or paste any text that has been copied from any document or web page. This field will only accept text. After clicking the Save button you will see a message that your update has been successful.

There is no limit as to how many fields can be edited at the same time. If you have more than one field in edit at the same time you may click the Save All Changes button in order to make all of the saves simultaneously regardless of the field type.

Keeping Track of Changes (Who changed what? When?)

Keeping track of who is making changes is a very important task. The history tracking feature not only helps everyone know when updates are made it will also keep track of who has made updates and what was changed.

View Field History (The only thing I can’t tell you is why.)—

From the Record View click on a field name to bring up the Field Options Menu. You will notice there is an alternative to the Edit button that is activated while hovering over the field name. The second options of View Field History will help you keep track of changes that have been made and it will give you the option to revert the information in the data field to a previous state.

After clicking the View Field History you will be able to see the current contents of the field as-well-as an entry for every time this field has been altered.

Revert Field (If I could do it all again.) —

By clicking on the listed dates you will be able to revert the information in the field to any previous date. You will find this to be an invaluable feature within TheVizzini.com’s user interface.

Organizing and Filtering Records

Some tables will have very few records, making it easy to find what you are looking for, while other tables may have thousands of records, making finding entries more difficult. The Grid View makes it easy to find and sort records.

Here you see a support table containing 3112 entries with important information about each version. Notice that the are 200 records visible on the screen with records 1-200 visible. In order to scroll through every record you would have to click on the right arrow to display all of the records 200 records at a time.

  

One option is to choose Show All Results from the Options menu. You will be presented with a warning. If there are a large number of records in the database table it may take some time for the page to load.

In this case using the sort and filter methods may be a better choice.

Sorting Records —

By default all records in all tables are sorted in the order in which they were created. If you created three records in this order:

Charleston
Allen
New Jersey

They would be defaulted to that order within your database table. This is the order that they were created in.

Within the Data Grid view each field has an option menu that is displayed by simply clicking on the field name. By selecting Sort Ascending the entries would then be displayed as:

Allen
Charleston
New Jersey

By selecting Sort Descending the entries would be displayed as:

New Jersey
Charleston
Allen

Filtering Records —

Filtering records is basically the same function as using filter in an Excel spreadsheet or a query in an Access database. For example the database table shown previously had 3112 record entries. There is a field in the table that is used to place a list on a printed page that has to change position depending on what imagery is used.

If you wanted to see or export all of the records that were placed in the 5.2 inch range from the top of the document you could select all records that fit into that criteria. Click on Apply and the records will be displayed.

Now there are only 42 records out of the 3112 total

.

Now it won’t be so difficult to find what you are looking for. Now let’s take it one step further. What if you only wanted to know which Adamo products fell within this category? With the other filter still active you can sub-filter by clicking on the System_Name field and selecting Adamo.

Now we have selected the two Adamo records that will place the list in the 5.2 inch range from the top of the document. These records may now be exported or edited using the Batch Update feature.

To clear a filter simply click on the field names holding the filters and un-check the previously selected criteria and click Apply. To completely clear all filters re-click on the table name in the database listing. The default sort and listing will be displayed.

Batch Update (That’s it! Everybody out of the pool!) —

Making changes to multiple records at the same time.

Batch Update allows a user to update the data in a specific field for all selected (filtered) records. If no filter is used the update will be made to all records in the database table.

Let’s take a look at this in action. Let’s say we use a field is a support table called “Type”. When we print this field on a layout we want to print the contents of the “Type” field. In every occurrence where “DT” is entered into the field you need it to say “Desktop”. Instead of editing every occurrence of “DT” in this field individually you could invoke the Batch Update feature.

Here’s how you could accomplish the task very quickly.

1. Filter the “Type” field selecting only the “DT” entries.
2. 
3. After applying the filter click on the “Type” field name and select Batch Update. Enter the text you want placed in the selected fields. Notice that the window notifies you that you are about to update the field TYPE in 12 records. There is also a warning that his action cannot be undone. When clicking on the Save Changes button one more warning will be displayed.
4. 
5. Click OK to perform the action. The next time the records are displayed you will see the updated information in the field.
6. 

You can now see the updated information in the “Type” field.

Note: This feature will work with all data field types. When working in variable character (also referred to as memo) fields the box where you can enter or paste text is much larger as that field type can hold large amounts of text.

Saving Filters or Queries (Help me remember how I did that!) —

Many times when you are trying to get a layout to look just right you find yourself in the same record, or set of records repeatedly. When searching for the same record to edit again and again you may be thinking, “There’s got to be a better way?” Well, there is. This is exactly the time to begin saving queries.

SQL Query Script —

A query is basically an SQL script that is being written every time you use the Filter or Sort features of TheVizzini.com. While in the Grid View click on the Options button and you will see an SQL window with a simple script in it. Look at that! You have written an SQL selection script and you didn’t even know it.

You have told TheVizzini.com to show you all records from whatever table you have selected and even what order to place them in. Now let’s show everyone how smart you really are. Try using the Filter features (discussed in the Filtering Records section) on one or more of the fields in your table. You can even change the sort order (discussed in the Sorting Records section) you want the records displayed in. Now take a look at your script. Wow... You actually wrote that!

Save Query Script —

After doing all of that complex scripting you must be exhausted. You don’t want to have to do that again. It’s time to save your work. Just click on the Save Query button. Give your new query a name and click Save Query.

Query Window —

If no queries have been saved before a new Queries Window will show up below the databases list. The queries will stay separated by database for quick reference. Simply click on the database name to display the saved queries for that database.

To re-select the record or records from your saved query simply click on the saved query name. The record or records will immediately be displayed in the Grid View.

Manage Queries —

Although saved queries are great, too much of a good thing can muddy the waters. To view, execute, or delete queries click on the Manage Queries link at the top of the Queries Window.

The View SQL button will display the SQL query script you have written. The Execute Query button will run the query script. (This is exactly the same function as clicking on your query name in the queries window.) The Delete Query button will remove the query from the list.

Note; When all queries are deleted the Queries window will be removed from the window below the Databases list.

Programming Tags (You’re it!)

Formatting Characters and Paragraphs

The Anatomy of a Tag

Tags are the most basic forms of text formatting. Although most, if not all, of the formatting on TheVizzini.com site will be formatted behind the scenes you will have the ability to “touch up” the text when needed. So why do you need to know this?

When you are writing in any editor that allows for character formatting there are numerous “tags” being written in the background that tells your computer what you want the text to look like. Many programs like Word, InDesign, Powerpoint, and so on perform this process in the background. You may not know it but you are tagging the text. When working in
TheVizzini.com you may want programming level control to achieve the exact look you are looking for. To do this some basic skills will be needed.

A tag will always be surrounded by the greater than ‘<’ and less than ‘>’ characters. These characters tell TheVizzini.com that you are entering ‘programming’ mode.

Note: If you want the less than ‘<’ or greater than ‘>’ symbols to print please refer to the entities portion of the manual.

Example 1:

<fontsize=14><font=”Times new Roman”>Here is the text that <b>I am</b> going to edit.

This would result in this output:

Notice the use of the bold ‘<b>’ tags. By surrounding the ‘I am’ with the bold and stop bold tags you can alter the final output of the text.

Example 2:

Lorem ipsum dolor sit amet, consectetur adipiscing elit. In quis ullamcorper augue. Cras feugiat ipsum eget augue fermentum ac facilisis justo rutrum. Praesent ut ligula turpis. Donec viverra, purus in accumsan suscipit, tellus erat consectetur diam, eu sodales ipsum quam nec sapien. Nam vitae mi nisl. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Nullam tincidunt, leo id bibendum mattis, mauris odio convallis metus, ut venenatis libero neque lobortis libero. Vestibulum pharetra risus quis magna venenatis tempus bibendum turpis bibendum. Ut justo elit, venenatis a condimentum sodales, facilisis a risus. Maecenas nec ipsum tortor. Morbi eget velit non nunc molestie interdum. Donec quis gravida erat.

Fusce cursus sodales ante id rhoncus. Aliquam ante eros, pellentesque sit amet accumsan porta, scelerisque id nulla. Phasellus vitae diam ut arcu luctus ultrices. Sed sollicitudin euismod risus, sit amet facilisis justo sagittis et. Praesent rhoncus, diam a blandit imperdiet, tortor purus faucibus urna, vel scelerisque lacus felis quis velit. Maecenas quis odio dui, eu convallis ligula. Curabitur fermentum dignissim dictum. Cras nisl eros, consectetur vel aliquam at, scelerisque in nulla. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.

Now let’s introduce some tags to make some alterations.

<align=J><fontsize=12><leading=140>Lorem ipsum dolor sit amet, consectetur adipiscing elit. In quis <b>ullamcorper augue</b>. Cras feugiat ipsum eget augue fermentum ac facilisis justo rutrum. Praesent ut ligula turpis. Donec viverra, purus in accumsan suscipit, tellus erat consectetur diam, eu sodales ipsum quam nec sapien. Nam vitae mi nisl. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Nullam tincidunt, leo id bibendum mattis, mauris odio convallis metus, ut venenatis libero neque lobortis libero. Vestibulum pharetra risus quis magna venenatis tempus bibendum turpis bibendum. Ut justo elit, venenatis a condimentum sodales, facilisis a risus. Maecenas nec ipsum tortor. Morbi eget velit non nunc molestie interdum. <i>Donec quis gravida erat.</i>

<font=Arial><align=L><fontsize=16><leading=160><findent=1800><lindent=1800><rindent=1800><leadbefore=300> Fusce cursus sodales ante id rhoncus. Aliquam ante eros, pellentesque sit amet accumsan porta, scelerisque id nulla. Phasellus vitae diam ut arcu luctus ultrices. Sed sollicitudin euismod risus, sit amet facilisis justo sagittis et. Praesent rhoncus, diam a blandit imperdiet, tortor purus faucibus urna, vel scelerisque lacus felis quis velit. Maecenas quis odio dui, eu convallis ligula. Curabitur fermentum dignissim dictum. Cras nisl eros, consectetur vel aliquam at, scelerisque in nulla. <b>Pellentesque</b> habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.

The resulting paragraphs would now look like this:

Many tags may be used at the same time. The order of the tags is generally unimportant as long as the tags are placed before the desired action. Any spaces between tags like <b> <fontsize=20> will not be set into the final text. Place all spaces around actual text not in ‘programming’ mode. If you need to enter a space while in ‘programming’ mode use one of the spacing entities like this: <b>&nbsp;<fontsize=20>.

Values for the tags fall into two basic categories of character and paragraph tags.

Character Formatting Tags

Character tags will alter the fonts attributes without altering the paragraph structure. Character tags are used for character alterations like bolding, changing the font, the font size, italicizing, and so on.

Description	Usage	Format
Change the font.	<fontname=“Name”> or <font=“Name”> Enter the exact name of the font as given to you from your administrator. If there is a space in the font name you are using it is necessary to enclose the name in double quotes.	<fontname=“Times New Roman”>
Change the font size.	<fontsize=12> Enter the font size in points. There is no stop or undo for the fontsize tag. To reset the font size to the previous setting a new fontsize tag must be used.	<fontsize=nn>
Bold and Stop Bold	<b>bolded text</b> and unbolded text.	<b>...</b>
Italics and Stop Italics	<i>Italicized text</i> unitalicized text.	<i>...</i>
Underline and Stop Underline	<u>Underlined text</u> stop underlining.	<u>...</u>
Strike through and Stop Strike through	<s>Striked characters</s> with standard characters.	<s>...</s>
Superscript and Stop Superscript	<superscript>Super Characters</superscript> regular text.	<superscript>...</superscript>
Subscript and Stop Subscript	<subscript>Sub text</subscript> regular text.	<subscript>...</subscript>
Tracking and Stop Tracking	<tracking=2>Tracked text</tracking> with tracking set back to previous setting. Tracking refers to the space between characters. Negative values will reduce the character spacing while positive values increase the space.	<tracking=nn>...</tracking>
Leading and Stop Leading	<leading=120>Leading</leading> with leading set back to previous setting. Leading refers to the space between lines in a paragraph. This value will only be apparent if text flows to more than one line. Values are in points multiplied by 100. 120 would be equal to 12 point leading.	<leading=nnn>...</leading>
Smallcaps and Stop Smallcaps	<smallcaps>Text in small caps </smallcaps> then set as regualr.	<smallcaps>...</smallcaps>
Uppercase and Stop Uppercase	<uppercase>Uppercased text </uppercase>	<uppercase>...</uppercase>
Lowercase and Stop Lowercase	<lowercase>lower cased text </lowercase>	<lowercase>...</lowercase>
Character Width	<fontsize=12><setwidth=14>Text with width altered<setwidth=12> then the width is set to standard. The setwidth tag will scale the text horizontally using the point size in the tag. In this example the point size is set to 12 while the width is set to 14. This will stretch the text to the width of a 14 point font without changing the actual height of the font. A setwidth value greater than the font’s point size will stretch the font and a setwidth value less that the font’s point size will condense the font. There is no Stop or Undo for this value. a new setwidth tag must be entered to reset the value.	<setwidth=nn>

Paragraph Formating Tags

Paragraph tags are used to alter the structure of groups of text inside of a paragraph. How much space between paragraphs, indents, alignment, and tabs are some examples of paragraph structures. Paragraph tags will generally alter the paragraph structure for the entire paragraph that they are placed in. For example: If an alignment tag is entered as <align=J> to justify the paragraph and a later tag of <align=C> is entered into the paragraph the resulting paragraph would be centered. The <align=J> would be overridden by the later <align=C> tag. A paragraph cannot be aligned two different ways within the same paragraph so the last tag will be used.

Description	Usage	Format
Paragraph (Hard break)	<p> There is no stop paragraph tag as in standard html formatting.	<p>
Line break (Soft break)	<br> Enters a line break without starting a new paragraph.	<br>
Tab	<t> Enters a tab stop. For multiple tabs enter multiple <t> tags.	<t>
Alignment	<align=L> Alignment of text in a paragraph or table cell. Values are entered as: L = Left R = Right C = Center J = Justify	<align=L,R,C, or J>
Lead after paragraph	<leadafter=nnn> Values are in points multiplied by 100. <leadafter=500> will enter a 5 point space after each paragraph.	<leadafter=nnn>
Lead before paragraph	<leadbefore=nnn> Values are in points multiplied by 100. <leadbefore=500> will enter a 5 point space before each paragraph.	<leadbefore=nnn>
First line indent	<findent=3600> First line indent values are in points multiplied by 100. Since there are 72 points per inch <findent=3600> will set the first line indent of a paragraph to 1/2 inch or 12.7 mm.	<findent=nnn>
Left indent	<lindent=3600> Left indent values are in points multiplied by 100. Since there are 72 points per inch <lindent=3600> will set the left indent of a paragraph to 1/2 inch or 12.7 mm. Hanging indents may be achieved by setting the findent value smaller than the lindent value.	<lindent=nnn>
Right indent	<rindent=3600> Right indent values are in points multiplied by 100. Since there are 72 points per inch <rindent=3600> will set the right indent of a paragraph to 1/2 inch or 12.7 mm.	<rindent=nnn>
Superscript ratio	<superratio=35> Changes the font size ratio for superscripted characters. If a font is set at 10 points and the superratio is 35 then superscripted characters will be set at 3.5 points. Note: Multiple settings may exist within a paragraph and all settings will be honored.	<superratio=nn>
Superscript offset	<superoffset=70> Changes the offset of superscripted characters. A zero setting would sit the superscripted characters on the baseline of the font. Generally an offset of at least 50 is desired. Note: Multiple settings may exist within a paragraph and all settings will be honored.	<superoffset=nn>
Subscript ratio	<suberratio=35> Changes the font size ratio for subscripted characters. If a font is set at 10 points and the subratio is 35 then subscripted characters will be set at 3.5 points. Note: Multiple settings may exist within a paragraph and all settings will be honored.	<subratio=nn>
Subscript offset	<suberoffset=70> Changes the offset of subscripted characters. A zero setting would sit the subscripted characters on the baseline of the font. Generally an offset of at least 50 is desired. Note: Multiple settings may exist within a paragraph and all settings will be honored.	<suboffset=nn>

Entities (What-it-ies?)

Entities are used to enter special characters into text. Entities used for html are acceptable. TheVizzini.com will accept Mac hidden characters as-well-as any characters from the Windows character map. The most common special characters are known as ‘Smart Quotes’ in Word and many other text editing programs. These are the curly quotes that are entered around quoted text as “quote”. When entering text directly into TheVizzini.com you will get something like "quote". That is because that is what you are actually typing. If you are copying and pasting from Word or InDesign there probably won’t be any issues. Any characters that are copied from your system may be pasted into the text fields in TheVizzini.com. If you are entering text directly into TheVizzini.com text fields you may want to use the html entities.

Any characters copied from the ‘Show Character Pallet’ in the Mac OS will be accepted in any text field on TheVizzini.com. If entering text on a Windows based system the Alt characters may be used. This is achieved by holding the Alt key while typing the Alt Character equivalent listed below. When the Alt key is released the corresponding character will be entered. Although they may not be pretty to look at the entities are cross-platform and reliable.

Anatomy of an Entity

Listed below are the basic characteristics of an entity followed by a complete listing of the special characters used in
TheVizzini.com:

• An entity will always begin with an ampersand ‘&’ character. When as ampersand character is followed by anything other than a space character, ‘programming’ mode is initialized.

• An entity is always closed with a semi-colon ‘;’ character. This closes ‘programming’ mode.

• The characters between the ampersand and semi-colon define the printed character.

Example	Entity	Alt Character	Descriptinon
	 	0018	thin space 1/6 of em space
	 	0019	en space 1/2 of em space
	 	0020	em space
"	"	0034	quotation mark
&	&	0038	ampersand
'	'	0039	straight apostrophe (single quote)
<	&lt;	0060	less than
>	&gt;	0062	greater than
€	&euro;	0128	euro dollar
…	&hellip;	0133	ellipsis (horizontal)
†	&dagger;	0134	dagger
‡	&Dagger;	0135	double dagger
‘	&lsquor;	0145	rising single quote, left (low)
’	&rsquor;	0146	rising single quote, right (high)
“	&ldquor;	0147	rising dbl quote, left (low)
”	&rdquor;	0148	rising dbl quote, right (high)
•	&bull;	0149	bullet, solid circle
–	&ndash;	0150	en dash
—	&mdash;	0151	em dash
™	&trade;	0153	trade mark sign
	&nbsp;	0160	non-breakable space
¡	&iexcl;	0161	inverted exclamation mark
¢	&cent;	0162	cent
£	&pound;	0163	pound
¤	&curren;	0164	general currency
¥	&yen;	0165	yen
¦	&brvbar;	0166	broken vertical bar
§	&sect;	0167	section sign
¨	&Dot;	0168	dieresis or umlaut mark
©	&copy;	0169	copyright
ª	&ordf;	0170	ordinal indicator, feminine
«	&lArr;	0171	double left arrow
¬	&not;	0172	not sign
®	&reg;	0174	circled R registered sign
¯	&macr;	0175	macron
°	&cir;	0176	circle, open
±	&plusmn;	0177	plus-or-minus sign
²	&sup2;	0178	sup 2
³	&sup3;	0179	sup 3
´	&acute;	0180	acute accent
µ	&micro;	0181	micro sign
¶	&para;	0182	paragraph sign
·	&middot;	0183	middle dot
¸	&cedil;	0184	cedilla
¹	&sup1;	0185	superscript one
º	&ordm;	0186	ordinal indicator, masculine
»	&rArr;	0187	double right arrow
¼	&frac14;	0188	fraction one-quarter
½	&half;	0189	fraction one-half
½	&frac12;	0189	fraction one-half
¾	&frac34;	0190	fraction three-quarters
¿	&iquest;	0191	inverted question mark
À	&Agrave;	0192	capital A, grave accent
Á	&Aacute;	0193	capital A, acute accent
Â	&Acirc;	0194	capital A, circumflex accent
Ã	&Atilde;	0195	capital A, tilde
Ä	&Auml;	0196	capital A, dieresis or umlautmark
Å	&Aring;	0197	capital A, ring
Æ	&AElig;	0198	capital AE dipthong
Ç	&Ccedil;	0199	capital C, cedilla
È	&Egrave;	0200	capital E, grave accent
É	&Eacute;	0201	capital E, acute accent
Ê	&Ecirc;	0202	capital E, circumflex accent
Ë	&Euml;	0203	capital E, dieresis or umlautmark
Ì	&Igrave;	0204	capital I, grave accent
Í	&Iacute;	0205	capital I, acute accent
Î	&Icirc;	0206	capital I, circumflex accent
Ï	&Iuml;	0207	caiptal I, dieresis or umlautmark
Ð	&ETH;	0208	capital Eth, Icelandic
Ñ	&Ntilde;	0209	Capital N, tilde
Ò	&Ograve;	0210	capital O, grave accent
Ó	&Oacute;	0211	capital O, acute accent
Ô	&Ocirc;	0212	capital O, circumflexx accent
Õ	&Otilde;	0213	capital O, tilde
Ö	&Ouml;	0214	capital O, dieresis or umlautmark
×	&times;	0215	multiplication sign
Ø	&Oslash;	0216	capital O, slash
Ù	&Ugrave;	0217	capital U, grave accent
Ú	&Uacute;	0218	capital U, acute accent
Û	&Ucirc;	0219	capital U, circumflex accent
Ü	&Uuml;	0220	capital U, dieresis or umlautmark
Ý	&Yacute;	0221	capital Y, acute accent
Þ	&THORN;	0222	capital THORN, Icelandic
ß	&szlig;	0223	small sharp s, German(sz Ligature)
à	&agrave;	0224	small a, grave accent
á	&aacute;	0225	small a, acute accent
â	&acirc;	0226	small a, circumflex accent
ã	&atilde;	0227	small a, tilde
ä	&auml;	0228	small a, dieresis or umlaut mark
ä	&aauml;	0228	small a, dieresis or umlaut mark, legacy
å	&aring;	0229	small a, ring
æ	&aelig;	0230	small ae dipthong
ç	&ccedil;	0231	small c, cedilla
è	&egrave;	0232	small e, grave accent
é	&eacute;	0233	small e, acute accent
ê	&ecirc;	0234	small e, circumflex accent
ë	&euml;	0235	small e, dieresis or umlaut mark
ì	&igrave;	0236	small i, grave accent
í	&iacute;	0237	small i, acute accent
î	&icirc;	0238	small i, circumflex accent
ï	&iuml;	0239	small i, dieresis or umlaut mark
ð	&eth;	0240	small eth, Icelandic
ñ	&ntilde;	0241	small n, tilde
ò	&ograve;	0242	small o, grave accent
ó	&oacute;	0243	small o, acute accent
ô	&ocirc;	0244	small o, circumflex accent
õ	&otilde;	0245	small o, tilde
ö	&ouml;	0246	small o, dieresis or umlaut mark
÷	&divide;	0247	division sign
ø	&oslash;	0248	small o, slash
ù	&ugrave;	0249	small u, grave accent
ú	&uacute;	0250	small u, acute accent
û	&ucirc;	0251	small u, circumflex accent
ü	&uuml;	0252	small u, dieresis or umlaut mark
ý	&yacute;	0253	small y, acute accent
þ	&thorn;	0254	small thorn, Icelandic
ÿ	&yuml;	0255	small y, dieresis or umlaut mark

Glossary

Apply Filter Button

Accessed by clicking on a field name in Grid View. When in the ‘Filter’ function this button applies the users selection writing a SQL query. After clicking Apply Filter the selected records will display. If no records meet the users criteria no records will be displayed.

Archived

Designation for a record version that is no longer in use.

Archived Version Naming Convention

The naming convention for an archived version. Will always begin with a valid version name followed by an underscore “_” character, the letter ‘A’ and ending with the date the record version was archived.

Asset Management

An online tool for customer imagery management.

Backslash

A character used in directory structures. TheVizzini.com uses the backslash “\” character as a directory indicator within image fields. Field entries will be entered as folder1\folder2\imagename.tiff.

Birdseed

Legal text usually on the mailing panel of a document.

Bold

The heavy version of a font family accessed using the bold ‘<b>’ tag and ended using the stop bold ‘</b>’ tag.

Clone

An exact copy of a record. Cloning a record can be done while in the Record View of any record.

Create Proof

The process of creating a document using all text and image assets using one or more entries on a Product Table. This process will be successful only on valid Product Tables.

Customer System Image

The image applied to a product that is designated by the entry in the System 1 Model Name field in a live production file. Although this reference may be edited in the Product Table for use within a proof document a user has no control over placement of this image.

Default Directory

The directory a product initially points to to eliminate the need for long directory paths in Image Field entries.

Directory

A folder inside of the Manage Assets site in which image assets may be placed for use on a product layout.

E&A Image

Electronics and accessories imagery placed using the DYF Support table.

Edit Button

Accessed in the Record View of any record. Enter’s the user into Edit Mode when clicked on any field name.

Edit Mode

The mode a user is entered into any time an edit button is clicked. This locks all other users out of the current record until edit mode is ended or the exclusive lock expires.

Filtering Records

The process of selecting a subset of records in Grid View. Used while searching for specific entries within a large table. Also used to select records for the Create Proofs function of a Product Table.

Final Image Name

A field in the System_Product_Matrix_EMEA table of the Cross Product Tables Support Table. This entry is used to place the correct image referring to the actual purchase history of a customer.

Future Version

Reference to a version that is still in the development or approval stage. This entry will be characterized by using an underscore “_” in the Product and Support table’s Version field. This entry will be followed by an indicator of when the version is expected to go live. Entries will be preceded by the actual live version such as: LT-GB_Q3-2011.

Going Live

Refers to the act of making a non-live version live within the weekly production process. Characterized by the removal of the underscore “_” character from the version field of support tables and the archiving of the previous live version in the support tables. Live versions will not have an underscore “_” character within the version name.

Grid View

The spreadsheet-like view of a database table entered into by clicking on any table name from the database list on the left panel of the window. This is the view where a user can filter, sort, batch update, create proofs, save queries, or export records.

Hanging Indent

This is the exact opposite of standard indents. Characterized by the first line of a paragraph hanging to the left of the paragraph body. Used in bulleted or numbered lists.

Horizontal Image Placement

Image placement on the X axis. Left and right movement.

Horizontal Text Placement

Text placement on the X axis. The left margin.

Image

An asset placed on a document that has been placed into and available for use in the asset library.

Image captions

The text placed next to or below an image asset.

Image Editing

Refers to replacing image references in database image fields. Also may refer to image placement controls in a support table.

Image fields

Fields in a support table that hold directory and image references.

Image Scaling Controls

Support table fields that control the width or height or a placed image.

Indents

Paragraph controls for the left or right margin of a text area. There are three indent values as Left <lindent=nn>, first line <findent=nn>, and right <rindent=nn>. Values are in points multiplied by 100.

Italics

The italicized version from a font family entered as <i> for an initiator and </i> as a stop.

Leading

The space between lines in a paragraph. Refers to the old newsprint typesetter’s method of placing different thicknesses of lead to alter the spacing of paragraph lines on a page. If more space needed to be filled thicker leaded lines would be used to spread the text filling the space.

Left Margin

Text positioning control to adjust the right-to-left position of text areas.

Legal Birdseed

Legal text usually on the mailing panel of a document.

Live Version

The version of a support table with the actual version name without future or archived atributes.

Making an Archived Version for Posterity

The process of naming a version from the product table to match an archived version in a support table and running the create proofs process on that record to create a new document with the archived name.

Making a Non-Live Version Live

The process of archiving the out-of-date previous live version and removing the future naming convention from all occurrences of any support tables.

Manage Assets

Uploading, moving, or renaming images in the Asset Manager.

Naming Conventions

Version naming schemes in an understandable manner.

Navigate

Moving around in folders of the Asset Manager or proofing location.

Navigation Controls

Controls in the Asset Manager to change images or folders.

New Folder

Creating a new directory in the Asset Manager.

Non-Live Version

Any version field entry on a support table that will not be used in live production. Usually future or archived versions. Could also be versins used for testing or training.

Options

Functions available within the Options Menu.

Option Menu

Menu available from a table grid view. This is where a user can export data, create proofs (if within a Product Table), and save queries.

Password

Used with a user’s user name to gain granted access to assets product tables and support tables.

Position Fields

Fields used to position text and images by version on a document.

Positioning Images

The process of using positioning fields to adjust image placement.

Product Table

A table that has the ability to create output using the Create Proofs function.

Progress Bar

A graphic illustrating amount of process remaining during an upload.

Record View

A single record view where edits to field entries may be made.

Rename

The process of renaming an image in the Asset manager.

Root Directory

The highest level directory in the Asset Manager and the proof viewer.

Save All Changes

Button available in Edit Mode that will save all field edits.

Save Query

Button available from the Options window in a tables Grid View to save queries with selected sorting intact.

Start Page

The first page a user is directed to after login. This page will have links to all proofs and the Asset Manager.

Support Table

A table that is used during the document creation but does not have the ability to create documents.

Text Fields

Fields for entering text.

Top Margin

Text margin for vertical text placement. Values are from the top of the document.

Tracking

The space between characters. Overrides the fonts default character spacing values. Values less than zero reduce spacing while values above zero increase spacing.

Underscore

The ‘_’ character. When used in version fields this is a reserved character denoting a non-live version. Only one underscore character may be used in version fields.

Upload

The process of placing files into an external directory. For use on any document a user must upload an image into the Asset Manager.

Version

Refers to differing communications based on customer type, region, segment, or language.

Version Field

The field used in a Product or Support Table to define specific messaging or imagery.

Vertical Image Placement

Placement of images relative to the top of the document.

Vertical Text Placement

Placement of text relative to the top of a document or the placement of text directly above.

View-Edit

Button available in the Grid View of a database table that will display the selected record in Record View.

Viewing a Proof

The act of locating a proof document and selecting it for review.

Viewing Image Assets

The act of locating image assets and selecting them for review.

View Settings

The settings of the view window when viewing assets or proofs. View settings can be changed by clicking on the View Settings button in the proofs viewer or the Asset Manager.

X and Y coordinates

Locations on the X and Y axis for horizontal and vertical text and image placement.

X Position

The horizontal placement of text or image assets.

Y Position

The vertical placement of text or image assets.

Zero Position

The point characterized by a (0,0) placement. The zero position is the top left corner or the page. (For image designed to bleed the zero position may be set 1/8 inch or 3.177 millimeters off of the page.)