RehabJobBoards.com Batch Processing Formats

The RJB website now offers the ability for employers/job posters to enter numerous job listings at once, using either an uploaded batch file, or via an external, HTTP-accessable feed. Data can be provided in both cases as either XML or CSV format, detailed below...

Data Specification

(items with * are required, or the job will be rejected)

* job_identifier: a combination of letters and/or numbers that is entirely unique to this one job listing. This identifier can then be used later to provide updates to this specific listing.

* category: pt, ot, or slp

* title: the title of this job as it will be shown in search results

* city: the city this job will be in

* state: the state this job will be in; this MUST be the full name of the state (i.e. "Texas") or the job will be rejected. (do not use an abbreviation like "TX")

* duration: a short line of text that will describe to the candidate how long this job will last (i.e. "Permanent" or "3 Months")

* description: the longer description of what this job is about. Be sure to include pertinent details about the position that will help candidates decide if they want to apply.

requirements: [optional] this short bit of text should let the candidate know what (if any) specific requirements this job has. (i.e. "minimum 5 years experience"). This field is optional and may be left blank.

comments: [optional] any additional comments that will be shown at the bottom of the job listing

salary: [optional] a line of text indicating the salary or salary range for this position (i.e. "50k" or "$60,000+" or "45,000 - 70,000 negotiable", etc.)

when_needed: [optional] a line of text indicating when a candidate is needed for this position. (i.e. "Immediately" or "in 3 months")

hours: [optional] What kind of hours does this job have? (i.e. "Full-time" or "Part-time" or "35 hrs/week")

contact_company: the name of the company or organization listing this job. THIS IS AN OVERRIDE AND IS OPTIONAL. Setting this will OVERRIDE the company name the will be automatically linked to the job based on your user account settings. In general, you won't need to set this if you've provided a company name via the website.

* contact_name: the name of the contact person for this specific job.

* contact_email: the email address of the contact person

contact_address: [optional] the street address of the contact person

contact_city: [optional] the city of the contact person

contact_state: [optional] the U.S. state of the contact person

contact_zip: [optional] the zipcode of the contact person

contact_phone: [optional] the phone number of the contact person

contact_fax: [optional] the fax number of the contact person

CSV Format

CSV, or "Comma-Separated Values" format, is a simple way of passing data to the system and may be the fastest for our system to process. However, this format can be harder to read and easier to make subtle mistakes.

In a CSV job listing file, each job listing occupies a single, long line.

CSV files must be constructed using the order listed above, and optional elements must still be included as empty entries between two commas. Each job listing MUST span a single line. Any special characters (including actual commas, double-quotes, or newlines), must be contained inside double-quotes.

Though the 'official' CSV specification (RFC 4180) allows it, the RJB system cannot properly understand a CSV file where the first line is a listing of the column headers. This line should be removed before attempting to upload or supply as a feed. If it is not removed, it's possible that the system may try to insert that first line into the database as an actual job listing, thereby costing the employer 1 purchased job listing from their account, and filling our database with invalid jobs that will confuse job seekers. To put it simply, the first line of a CSV file must be the first job listing, and each line thereafter the next listing.

Example:
(note that requirements and comments have been left blank, which is why you see multiple commas in a row; each job MUST occupy a single, long line - do not break the line until you get to the next job)

MYJOB001,pt,Awesome PT Job in San Diego!,San Diego,California,Permanent,"This is my description of this job, complete with a comma in it.",,,"$50,000+ negotiable",Immediately,Full-Time,"Example Rehab Jobs, Inc.",Jane Doe,jdoe@example.com,123 Example St.,Austin,Texas,78754,512-555-1234,512-555-4321
MYJOB002,slp,Another Great Job,Austin,Texas,Permanent,"This is my description of this job.",Must work well with people.,,"$65,000 - $70,000",Immediately,Full-Time,"Example Rehab Jobs, Inc.",Jane Doe,jdoe@example.com,123 Example St.,Austin,Texas,78754,512-555-1234,512-555-4321

XML Format

XML, or "eXtended Markup Language," is a more complex format, creates a larger file to upload, and takes longer for our system to process. But, it's our preferred format due to its better readibility and lower chance for mistakes and parsing problems.

In an XML job listing file, each job listing consists of a block of markup tags inside <job>...</job> tags and the ENTIRE file should be inside <xml>...</xml> tags.

Unlike CSV, it's not important that the XML file be structured in the order noted above, nor do things like rows/line-breaks or spaces between tagged elements matter. It's also not necessary to include empty blocks (though it won't hurt if you want to, for the sake of readability).

It IS imperative, however, that your tags match the wording noted above! (i.e. <when_needed>...</when_needed> or <salary>...</salary> etc.)

Note that in your XML file, line-breaks will NOT be preserved. If (for example, in the description) you want to produce a block of text with line-breaks, you will need to use the HTML <br /> tag. The following HTML tags are valid within text blocks (all others are ignored):

<br />

Example (this shows 2 listings... you can put as many as you want in your XML upload file or feed response, as long as each is contained within <job>...</job> tags):
(note that comments has been left out entirely, since we have nothing to put there for this job listing)

    
<xml>
<job>
  <identifier>MYJOB001</identifier>
  <category>pt</category>
  <title>Awesome PT Job in San Diego!</title>
  <city>San Diego</city>
  <state>California</state>

  <duration>Permanent</duration>
  <description>
    This is my description of this job, with commas and "double-quotes" in it.
  </description>
  <requirements>Must work well with people.</requirements>
  <salary>$50,000 negotiable</salary>
  <when_needed>Immediately</when_needed>

  <hours>Full-Time</hours>
  <contact_company>Example Rehab Jobs, Inc.</contact_company>
  <contact_name>Jane Doe</contact_name>
  <contact_email>jdoe@example.com</contact_email>
  <contact_address>123 Example St.</contact_address>
  <contact_city>Austin</contact_city>

  <contact_state>Texas</contact_state>
  <contact_zip>78752</contact_zip>
  <contact_phone>512-555-1234</contact_phone>
  <contact_fax>512-555-4321</contact_fax>
</job>

<job>
  <identifier>MYJOB002</identifier>

  <category>ot</category>
  <title>Exciting OT opportunity!</title>
  <city>Austin</city>
  <state>Texas</state>
  <duration>Permanent</duration>
  <description>

    This is the description of the second job in this file!
  </description>
  <comments>This job has this comment noted (but no requirements or salary)!</comments>
  <when_needed>Immediately</when_needed>
  <hours>Full-Time</hours>
  <contact_company>Example Rehab Jobs, Inc.</contact_company>
  <contact_name>Jane Doe</contact_name>

  <contact_email>jdoe@example.com</contact_email>
  <contact_address>123 Example St.</contact_address>
  <contact_city>Austin</contact_city>
  <contact_state>Texas</contact_state>
  <contact_zip>78752</contact_zip>
  <contact_phone>512-555-1234</contact_phone>

  <contact_fax>512-555-4321</contact_fax>
</job>
<job>
  <identifier>MYJOB003</identifier>
  <category>slp</category>
  <title>Another SLP listing</title>
  <city>Austin</city>

  <state>Texas</state>
  <duration>Permanent</duration>
  <description>
    This is the description of the third job in this file!
  </description>
  <comments>This job has this comment noted (but no requirements or salary)!</comments>
  <when_needed>Immediately</when_needed>

  <hours>Full-Time</hours>
  <contact_company>Example Rehab Jobs, Inc.</contact_company>
  <contact_name>Jane Doe</contact_name>
  <contact_email>jdoe@example.com</contact_email>
  <contact_address>123 Example St.</contact_address>
  <contact_city>Austin</contact_city>

  <contact_state>Texas</contact_state>
  <contact_zip>78752</contact_zip>
  <contact_phone>512-555-1234</contact_phone>
  <contact_fax>512-555-4321</contact_fax>
</job>
</xml>