Forum: Poser - OFFICIAL


Subject: WIP : Product and Project Management Database

starmage opened this issue on Apr 11, 2007 · 19 posts


starmage posted Wed, 11 April 2007 at 8:09 PM

Hi All Well this all started out as a very basic product tracking system for Poser...... But it's kind of grown to a fully fledged database that can track all sorts of addon's for all sorts of programs.  I had to dump the original design (lack of expandability) and start again.

Anyway, here's the splash screen to whet your appetite :)

It's coming along nicely but am trying to make it a polished product that doesn't look like a average old database, but is more geared towards users who are accustomed to a more program like interface.

Current features :

Anyways, catch ya all later :)
Cheers

Only your mind limits yourImagination. Let it free.


Victoria_Lee posted Wed, 11 April 2007 at 9:01 PM

This sounds really promising, starmage!  Please keep us informed on its progress.

Hugz from Phoenix, USA

Victoria

Remember, sometimes the dragon wins. Correction: MOST times.


pakled posted Thu, 12 April 2007 at 6:19 PM

wish I'd had this 23,000 items ago..;) Access only goes so far..;)

I wish I'd said that.. The Staircase Wit

anahl nathrak uth vas betude doth yel dyenvey..;)


bcoleman posted Thu, 12 April 2007 at 9:45 PM

Sounds familiar.  I'll be interested in what you come up with.  I link to applications that do what the PDT does because no program will fill all niches (and mine definitely doesn't).  When you get it done, send me a link via site mail and I'll put it on my site.

More stuff than you can keep track of? Try the free Poser Download Tracker.


starmage posted Fri, 13 April 2007 at 1:16 AM

Yeah it might sound a bit familiar :)
I started looking into this and what people wanted in such a database about 2 years ago.  Unfortunately I lost interest for a while but it's been a pet project of mine and I hope to get it finished by mid year.  Theres actually a lot of programming involved.

lol pakled.
That's what got me started....

Only your mind limits yourImagination. Let it free.


starmage posted Fri, 13 April 2007 at 1:18 PM

Ok here's a couple more screen shots

This one is part of the setup process......

Only your mind limits yourImagination. Let it free.


starmage posted Fri, 13 April 2007 at 1:24 PM

Ok and this is a demo fo the Error message box.

Only your mind limits yourImagination. Let it free.


Conniekat8 posted Fri, 13 April 2007 at 9:29 PM

Looks very promissing :D

Hi, my namez: "NO, Bad Kitteh, NO!"  Whaz yurs?
BadKittehCo Store  BadKittehCo Freebies and product support


starmage posted Sat, 14 April 2007 at 5:54 AM

Ok guys

This is the full setup wizard for you to see.

Also have most of the tables in and linked properly.

Only your mind limits yourImagination. Let it free.


Victoria_Lee posted Sat, 14 April 2007 at 10:28 AM

Sweet!  Can't wait until it's done.  I'd love to give it a good go since I've got so many things going on right now.  This should prove invaluable in managing my projects and products.

Hugz from Phoenix, USA

Victoria

Remember, sometimes the dragon wins. Correction: MOST times.


starmage posted Mon, 16 April 2007 at 12:59 AM

Ok dokey... Here's the basic table design and relationships.  This is without the Project management functionality as yet.

It's rather complex so if you're not an Access nut maybe better not  try to decipher it.

Only your mind limits yourImagination. Let it free.


starmage posted Mon, 16 April 2007 at 2:09 AM

Ok well the Project Management tables are now in.

Some of the basic features of the Project Management will be :
  - Track File Assocations
  - Track which Products it requires
  - Track which Programs it requires
  - Project Description
  - Artist(s) working on the Project
  - Project Preview images
  - Project types (ie modelling, texturing etc)

Some of the more advanced features :
  - Project completion wizard (Moves it over to the Products table for you)
  - Automatic Readme file creation (including Copyright, Terms of Use and File list).

Note that the whole database will be using a split design (Back end and Front end) which means if you have multiple artists working on different computers over a Network, all can access the same information from the back end..... (Supposedly, this is my first try at this).

I should also point out that just about every peice of information is "Optional" (hence the rather complex design).

Only your mind limits yourImagination. Let it free.


DarkEdge posted Mon, 16 April 2007 at 8:48 AM

Starmage,

Simply awesome. I want to thank you for all of your hard work. 😉

Comitted to excellence through art.


Victoria_Lee posted Mon, 16 April 2007 at 10:13 AM

Just one word for you, Starmage ... SWEET!!!!!!!!!!!!!!!!!!!!!!

Thanks for all your work with this.  I can't wait.

Hugz from Phoenix, USA

Victoria

Remember, sometimes the dragon wins. Correction: MOST times.


starmage posted Thu, 19 April 2007 at 5:34 AM

Hi All
Took a slight break from doing the database and delved into Poser 7.  There's nothing quite as relaxing as pumping out a little bit of creative work :) .  Well it's more relaxing than programming a database anyway!!!!!! lol  Besides I can always use some of my art in the actual Database.

Anyway.......
Bit of a question about the automated creation of a Readme file......

The actual process of doing this is easy enough, but it's the process of creating the template that's not.  I need a pretty basic idea of what you'd expect in a Readme file for a product?

I'm thinking you'd need.....

  1. Introduction (General Description of the product)
  2. Requirements  (Automated)
  3. Installation Instructions
  4. Copyright Information
  5. Terms of Use
  6. FIle List (Automated)

Apart from that I'm also of the impression that the actual readme file needs a specific name that partains to the actual product.  (Note my recent frustrations about older Readme's being overwritten by new installs of other products because they're not named specifically for the product).

Only your mind limits yourImagination. Let it free.


EnglishBob posted Fri, 20 April 2007 at 6:19 AM

Yes, I always give my readmes a name of the form readme_nameofthing.txt for just that reason. I'm wondering if it might not be better to use readme_author_nameofthing.txt in order to avoid clashes when two people make the same thing. The content varies, but the usual layout covers the following: - Name of thing, and brief description (including whether a particular Poser feature is required) - Installation instructions - Specific usage instructions -- Materials -- Morphs -- Special features etc. - Terms of use -- Renders: commercial or personal? -- Add-ons: (morphs, textures etc.) allowed or limited? -- Redistribution: allowed or not, and if so, under what conditions? - Contact details


starmage posted Fri, 20 April 2007 at 12:03 PM

Ok kewl Bob
Assuming one would take advantage of the full features of the database most of that could be automatically added.  Like the Name/Description and the requirements.  And I suspect the Installation instructions would be pretty "Generic" in most cases.

Not to sure about the special features etc....
That might have to be added specifically.

The Terms and Usage and stuff I also think would be pretty well covered by a "Generic" bit that could be determined by whether the product is Free or commercial and whether it's just for Personal use or commercially usable.

Info could always be piped through into a textbox on a form and people could "Adjust and edit it from there.  But even that would allow for the removal of the more tedious components of the actual creation of stuff like the File lists/Installed components. 

I just noticed office 07 has a translate function so i could even provide the basics in multiple languages (Not sure if that would be useful though).

Only your mind limits yourImagination. Let it free.


Victoria_Lee posted Fri, 20 April 2007 at 12:31 PM

This is the template I use in all of my readme files - both for sale and free.  This is the one that is approved by Renderosity and works on all of the other sites with only minor changes (like the site license).


Product Title: Name of Product
Author: Victoria Hall  (Victoria Lee)
Author E-mail: victoria85015@cox.net
Product Date: Date of Creation
Product Copyright: Digital Imagination & Victoria Lee; Year



Ownership statements or list of licensed source material:


Needed Files List and System Required:


Detailed Installation Instructions


Usage Instructions:


Packing List:

Files and locations

RuntimeDI_Readme
DI_productname_readme.txt (this file)
Renderosity License.txt


The product does not require conversion


Thank you for downloading this package.  Feedback is greatly appreciated.  Please contact me using site mail. 
<<

 

Hugz from Phoenix, USA

Victoria

Remember, sometimes the dragon wins. Correction: MOST times.


starmage posted Fri, 20 April 2007 at 12:47 PM

Yeah okay could be made to be Distributor dependant too I suppose.  Anyway I need to get back into it cos I took a break (Had a Psych assignment due yesterday and a test next week).

Presently am trying to concentrate on the interface design.  And tweak the actual Database backend.

But I suspect an approach to doing this particular function would be a wizard that would let you choose what particularly parts you want to add/leave out beyond the necessary basics and more advanced bits could be added later to the file if necessary.  Either through editing in notepad or through a textbox on a form.

Only your mind limits yourImagination. Let it free.