MicrostockGroup
Microstock Photography Forum - General => General Stock Discussion => Topic started by: visceralimage on January 30, 2011, 21:25
-
Now that I am expanding from exclusive at one agency to multiple agencies; how do i track what I have sent to the different agencies and what was accepted, rejected, etc.
I know I could setup a database of image numbers with columns for each agency (Shutterstock, accepted, rejected) but was curious what others are doing to track image submissions.
i have over 35K wildlife images; want an efficient way to track my submissions. Thanks in advance.
-
I created an Excel spreadsheet to keep track of my images, but I had less than 1,000. Maybe Lighroom or Bridge could keep track?
-
I have Submitted, Accepted and Rejected folders for each agency (i.e. 'DT Accepted', etc). I also have an Upload Queue folder where I put JPEGs that are ready to go, with EXIF, etc. I FTP files to all the sites, so I open multiple FileZilla windows (one for each site), drag and drop everything from the Upload Queue folder into each window. FileZilla will automatically throttle everything, so it uploads two images at a time in each window to each site (all customizable). While the files are uploading, I select everything in Upload Queue again, right-click and choose 'Create Shortcut'. The shortcuts will automatically be selected when they are created, so I just drag them to one of the Submitted folders, then repeat for each site. When the uploads finish, I then copy everything in the Upload Queue folder and move them to a JPEG folder. As sites accept/reject the files, I just move the shortcut to the appropriate folder, and the OS will figure out how to make the shortcuts point to the correct place. It only takes me a few minutes to get uploads started to all the sites, its actually pretty quick once you are used to the workflow.
I keep all of these site folders in a folder for the current year, which is handy when trying to look for a particular image.
-
Perfect timing. Just so happens I created a new database today in FileMaker.
-
i use a spreadsheet, agencies in columns, filenames in rows. At each crossing, I I paint the cell green in approved, yellow when waiting review, red when rejected, no color when not submitted. Also write number of sales, add a comment for ELs. Columns are thin to make cells square. Different subjects go in different tabs.
-
I make batches up in single folder with the batch number as the folder number, as I finish with pictures and their file info.
The rest is done in an excel spreadsheet: Website names in rows with batch numbers as column headings; if uploaded "Y" is indicated next to Website name and below batch number - if finally submitted I add a background color (very visual to get quick impression of what needs to be done). Very simple way of just keeping basic track.
I do not keep record of each file. With most sites being totally irrational in which pictures they accept, I think I will go off my mind trying to make logic of it (so why keep record of it?).
Make more sense to me to keep record of which ones sells at which site, to be able to focus my offer/selection better.
Just my inexperienced 5 cents worth.......
-
For me I work a bit differently since I mainly do vectors. I have main folders for my AI files, large jpgs, eps and so on. Inside those folders I'll place the month and save them in there and upload to the various agencies according to their requirements. I haven't kepts up with my file names spreadsheet in the last 3 months or so so I don't do that anymore. The only spreadsheets I have is what I earn at each agency every month. I used to keep track of what was accepted/rejected but that drove me nuts so I stopped that too.
Simply it for yourself and how your workflow is. You'll find what works best for you.
-
i use a spreadsheet, agencies in columns, filenames in rows. At each crossing, I I paint the cell green in approved, yellow when waiting review, red when rejected, no color when not submitted. Also write number of sales, add a comment for ELs. Columns are thin to make cells square. Different subjects go in different tabs.
This is exactly how I do it as well.
-
I use a spreadsheet, with sites in columns and folders in rows. Then I tick cells to mark uploaded folders. I find it easier to print an empty spreadsheet and tick cells by hand, since I have already too many windows opened on my screen at any given time.
-
i use a spreadsheet, agencies in columns, filenames in rows. At each crossing, I I paint the cell green in approved, yellow when waiting review, red when rejected, no color when not submitted. Also write number of sales, add a comment for ELs. Columns are thin to make cells square. Different subjects go in different tabs.
This is exactly how I do it as well.
I do something similar, and also attache a small thumbnail of the image at the top, but I'm finding it tedious and having a hard time keeping it up to date. I like that database that was posted here by Karimala and I'm tempted to try to set up something similar in MS Access since I'm more familar with that program (thanks for the inspiration!)
-
I've been facing variations on problem for over 30 years. First, with slides and classical stock agencies [often called rights managed, with examples like Corbis, and Getty]. I went thru multiple physical organizing systems - by shoot, by slideshow, by topic, etc, eventually settling on metal filing boxes for over 35,000 slides organized by category. I also kept a simple spreadsheet list of slide numbers and captions. I’ve shot digital since 2001 and problems quickly multiplied with the greatly increased number of images that were now created. Most photographers aren’t computer programmers, but some computing oriented approaches are helpful. Rather than choose a software solution and force it to fit your needs, take some time to analyze what you currently have and what you’d like to be able to do. At that point you can decide what sort of workflow system works best for you. Only then do you need to decide what actual software might be needed.
http://cascoly.com/mssub1.asp (http://cascoly.com/mssub1.asp)
-
i use a spreadsheet, agencies in columns, filenames in rows. At each crossing, I I paint the cell green in approved, yellow when waiting review, red when rejected, no color when not submitted. Also write number of sales, add a comment for ELs. Columns are thin to make cells square. Different subjects go in different tabs.
I do more or less the same, just that I don't keep track of sales on my spreadsheet. To make it easier to mark the correct column when I upload, I make the different columns different colours (I submit to 12 agencies). I mark the cells "p" for pending, "1" for accepted "x" for rejected and "r" when I want to resubmit a rejected photo.