Asset Manager

AssetManager.py is a program I created to manage and organize
assets and files either locally on a computer or dynamically on
an SQL server.

=========================================================
Copyright © 2013 Craig Barnett
=========================================================

This program is to be distributed only by the owner, it was created
in the hope that it will be useful to artists, but WITHOUT ANY WARRANTY.

=========================================================
Craig Barnett,
302 W 40th St Apt A, Savannah, Ga 31401
mailto: craigbme@hotmail.com
http://www.bhvfx.com
=========================================================

This script allows the user to import files and add a variety of properties
and information to them along with custom icons. The asset manager can
either run locally, storing all of the information on your computer,
or dynamically through a SQL database. It has options for opening files
with Maya, Houdini, Nuke, Photoshop, Text Editor, Photo Viewer, and
the default application. It has 8 categories to organize files by and
some basic custom ui options. (Python, PyQt, MySQLdb)

The program can be used in two different ways. The first, locally where
all of the information is stored on the harddisk in either the
installation folder or the current working folder. The second, dynamically
where all of the information is stored on a SQL server and can be shared
and modified by other users.

To connect to a server the user will need to enter a server address, a
database name, a username, and a password.

The following server information is my own personal server provided for
testing purposes. In no way will this server be guarenteed to always be
online or available:
Address:         mysql.bhvfx.com
Database Name:   burninghelix123
Username:        exampleuser123
Password:        password

=========================================================
To install and run AssetManager just execute 'runner.py'.
=========================================================
To Uninstall navigate to your python installation and
delete the AssetManager folder inside \Lib\site-packages\.
=========================================================
For any additional information, problems, or advice feel free to contact
me using the information that was above.

Changes:
v1.5 - OSX Support - Code Cleanup - UI Update 9/17/13

-AssetManager now runs on OSX -not yet fully tested -expect problems with open-with
-Fonts and font sizes changed to be cross-platform compatible
-Reworked registry lookup largely removing redundant code
-Find Selected Item is now separated and resused
-All delete menu's now reuse the same delete function
-Reworked OpenAsset code/Removed redundant code
-Removed redundant code in MainWindow
-Removed redundant code in AddItem module
-Consolidated except statements in DatabaseConnect Module
-Ui Color Changes and bug fixes on custom colors, more variation


Previous Fixes:

v1.4 - Large Update and Bug Fixes 8/21/13

- Connecting to the server is now done using a reusable template
- File information is now stored and location based on its address/location so files with the same name can coexist
- Icon loading from the server is now loaded directly from the server instead of a temporary location on the users computer
- File Writing and Reading is now done using a reusable template
- Refreshing files after connecting and disconnecting from the server now change correctly
- Properties and image files now stored in separate folders when run locally
- Recreated function to add files and made it resuable
- ItemDisplay recreated and is now a reusable template
- Fixed some bugs when changing modes from a server to locally
- PropertiesWindow functions recreated
- More cross platform path changes
- More redundant code removed


 v1.3 - Created one template to be used for several dialogs 7/8/13

- Repurposed RegistryLookup to be able to lookup custom programs along with a more accurate result
- Added functionality for the user to add custom applications to the open with menu
- Added window under Display>Manage Applications to be able to show and hide applications that have been added but not
currently needed
- OpenAsset now using one template to load programs
- Everything should now be cross-platform other then the RegistryLookup (In process of installing Linux to further test)
- Directory for settings and temp files moved to computers temporary directory and is now cross-platform
- Several Bug Fixes and redundant code removed