How to Import Tracked Submissions

How to Feed Chill Subs’ Tracker Some Delicious Subs!

From Submittable

1. Go to: https://www.submittable.com/

2. Sign in.

3. Go to the “Submissions” tab

4. Click the little folder-arrow-download-looking button

1. Go to Chill Subs Tracker: https://www.chillsubs.com/tracker 6. Click “Import from Submittable”

1. An interface will open where you can map Submittable columns to Chill Subs columns. They will most likely already be preselected, so you can just click “Next”:

1. After mapping columns, you’ll be able to edit any data if you need to. No need to rename statuses, our code will handle that. Press “Confirm” and you’re all set! :)

From ‘The Grinder’

1. Go to: https://thegrinder.diabolicalplots.com/

2. Sign in.

3. Under “my account” click: “manage submissions”

4. Check off all boxes under “by status”

1. Below, click “show submissions” then “generate export”

1. Go to Chill Subs Tracker: https://www.chillsubs.com/tracker 7. Click “Import from The Grinder”

1. An interface will open where you can map The Grinder columns to Chill Subs columns. They will most likely already be preselected, so you can just click “Next”:

1. After mapping columns, you’ll be able to edit any data if you need to. No need to rename statuses, our code will handle that. Press “Confirm” and you’re all set! :)

*Both Submittable & The Grinder will generate (because they’re rad) ‘.csv’ files which are perfect for uploading to Chill Subs. Special thanks to David from The Grinder for giving us permission to offer this information.

From Duotrope

1. Go to: https://duotrope.com/about/terms-of-use.aspx

2. Read: “Any data downloaded from this site, including but not limited to your submission history, is strictly for your personal use and may not be shared with third parties or used for any commercial purpose.”

3. Go fuck ourselves.

*no, really, don't send us your Duotrope data. Chill Subs is still a baby and babies can't afford those kinds of conflicts.

From a personal spreadsheet

1. create a Google Sheet with these categories: submission title, type (optional), publisher, date submitted,result date, status, submission method (optional) & notes (optional).

*should look like this.

Note: don’t worry about column names, you’ll be able to edit them in our CSV editor. But don’t create any weird statuses. Our code understands “submitted”, “accepted”, “rejected”, “withdrawn” and Submittable/Grinder status names.

You can also skip the “Type” and we will mark the submission as “magazine” by default (you’ll be able to edit it later). We’ll probably get rid of types at all at some point, but for now it’s like this.

1. Download it as a .CSV file

1. Go to Chill Subs Tracker: https://www.chillsubs.com/tracker 4. Click “Import custom CSV”

5. An interface will open where you can map your columns to Chill Subs columns :)

11. After mapping columns, you’ll be able to edit any data if you need to. No need to rename statuses, our code will handle that. Press “Confirm” and you’re all set! :)

Other notes

After importing you can notice an alert icon next to some magazine names. That’s because we couldn’t automatically connect it to a Chill Subs listing (cause the name doesn’t exactly match).

This will become smarter in the future (we literally did this whole tracker stats and import thing in 24 hours lol), but for now, it would be cool if you clicked on that sub and connected it manually by clearing the Magazine field and reselecting the value again (if the magazine exists in our database :) Nothing will change for you, you can leave it this way, but if the sub is connected to a listing, our tracker stats become more accurate :) And everyone wants better stats

That’s all, enjoy your tracking!