« Does anybody else wonder … | Home | Leave my ginger snaps alone! »

Download organizer - marketer’s version

By barney | October 7, 2007

Ok, here’s the material I promised on how I organize my downloads.

I don’t organize my downloads <grin />.

Instead, I annotate them.

The following list is what I’m using right now to keep track of my downloads, both marketing and non-marketing.  With the files annotated as demonstrated after the list, it’s very easy to load the directory list into my database, then use the PHP script I’ve developed to find the file(s) I want at any given time.  Can’t say this is perfected as yet, but it has improved considerable over the past year - in fact, I’m now on version 2.3.8, and getting close to starting version 3 <chortle />.  If you’re interested, let me know & I’ll show ya how to set it up.\

The annotation list.

Ok, now that you have the list I’m using, I’ll proved examples to demonstrate how I use the values.

When I download, each file goes into its own directory unless there are several files associated with the download, e.g., the main file, then a help file, maybe a theme or mod.  All of those directories are subdirectories of either _dl or _mktg.  The _mktg top level directory holds all files related to marketing:  the _dl top level directory holds everything else.

So now I’m going to download emailsecrets.zip from a marketing page.  When I initiate the download, I create the directory for the file:  drive:\_mktg\eMail Secrets\.  Then I change the target file name as follows:
emailsecrets.2006.09.03.v3-0-5.V47.00.V97.00- .V27.00+.S.W.H.Z4.Yah375.$0.00.zip.

When I look at the file name later, it tells me that I downloaded the file on the 3rd of September in 2006; the file version is v3.0.5, I may resell the file; the SRP is $47; the max price I may charge is $97; the min price I may charge is $27; some sales material is included (usually a sales page and a thank you page); the file is multimedia or has a multimedia component; the file was a gift (free); the file is passworded and the password is ah375; and my cost was $0.

It’s relatively simple to use PHP to break the filename down into its individual components, then store those components in a MySQL database.  Now, if I want to find all resale rights file, or all files downloaded in 2006, or even all files downloaded in September of 2006, it’s simplicity itself to set up a prewritten SQL statement with variables for those values, then plug in the values I choose.

Now, if I need to expand I could apply numerics, such as I did for Z, in order to expand the definitions list without using more letters, doubling letters, etc.  For instance, I could make H1=audio/video, H2=graphic, H3=video, H4=audio … expansion is relatively easy.

Now, what you don’t see that is a part of my database system is the source data.  For each file I download, I copy appropriate bits & pieces over to Info Select.  Then, after I’ve loaded the file into the database, I can come back and enter such information as: person who created the file; person I got the file from, if different; URIs for both those people; contact info if appropriate; affiliate info if appropriate; my evaluation of the file, both text and grade; my evaluation - not normally for publication - of one or both of the purveyors of the file; a few other misc. things, e.g., commissions, affiliate income, longevity, etc.

If you’re really interested, I can shoot you the SQL to create the database tables and a zip file of the scripts I’m using, at least for the file part.  But I’d suggest you make up your mind reasonably soon:  from what I’ve seen online, this thing is salable.

[Posted 2006-09-03, Moved 2007-10-07]

- 30[%] -

Topics: Organize |

Comments

You must be logged in to post a comment.