Command Line

The contents below require access to the on-premise version of DairyComp 305 and are only available to DC Unlimited subscribers.

Check the top of your PULSE Platform page to see if your dairy has DC Unlimited or DC Pro:

Click here to learn more about the different versions of PULSE.

The Command Line brings the power of DairyComp into PULSE Platform, allowing you to generate many of the same reports you're able to view in DairyComp. The PULSE Platform Command Line currently supports the LIST (SHOW), SUM, and COUNT commands. You can find this feature on the main menu bar, or by selecting F9 from your keyboard:

A typical command consists of the 5 parts defined below: 

1

The command word controls the type of report you run. The following commands are supported in PULSE Platform: 

  • LIST or SHOW: Generates a report that matches your command conditions. In PULSE Platform command line, LIST and SHOW are interchangeable commands. In DairyComp, the LIST command may be used to print the report, while SHOW displays the report on the screen. See LIST (SHOW) Command Examples for helpful sample commands!
  • SUM: Generates a summary of your animal data based on the command conditions, and presents the data in a table or graph. See SUM Command Examples for helpful sample commands! Animal countsAverage valuesStandard deviationData range details, including minimum and maximum values The graph view is flexible and may be adjusted on the fly:
  • COUNT: Calculates the total number of animals that match your command condition(s). See COUNT Command Examples for helpful sample commands!
2

In PULSE Platform command line, any switches must immediately follow the command word. The following switches are currently supported in the specified command(s): 

Switch

Definition

Command(s)

Example
\B

Includes results for both live and dead animals. Without the switch, command results include live animals only.

COUNT

LIST (SHOW)

SUM

LIST \B IDClosed Identifier LACTClosed Lactation number DIMClosed Days in milk RPROClosed Reproductive code ARDATClosed Archive date FOR FDATClosed Fresh date>-7 BY  LACT

Capture live and dead animal data for recently freshened animals by lactation.

\D

Limits results to dead cows only.

COUNT

LIST (SHOW)

SUM

COUNT \D FOR LACT=1 ARDAT>-90

Capture total number of dead animals in their first lactation in the last 90 days.

\S

Sets the standard deviation calculation to use sample values. Without the switch, PULSE Platform calculates population standard deviation.

SUM

SUM \S MILK PCTFClosed Percent fat PCTS LGSCC BY lact FOR LACT>0

Analyze sample standard deviation data for milk composition and quality by lactation.
\Z

Includes zero values in averages and standard deviation calculations. Without the switch, average, standard deviation, mode, and median calculations include non-zero values only.

SUM

SUM \Z TKET BY LCTGP FOR FDAT>-365

Analyze the number of times ketosis was diagnosed by lactation group for all animals that calved in the last year.

3

Follow these guidelines for items in your command:

  • The ID item is included in LIST reports by default, so including it is optional.
  • Insert a space between items.

In the command example above, the items are ID, PEN, LACT, DIM, DCC, and MILK:

LIST \Z ID PEN LACT DIM DCC MILK FOR LACT>0 DCC>220 DDAT=0 BY PEN

This tells the report to include columns for the animal ID, pen number (PEN), lactation number (LACT), days in milk (DIM), days carried calf (DCC), and milking weights (MILK).

Here are a few examples of items you can use:

Item

Description

ID

The animal's ID number.

PEN

The animal's current PEN number.

LACT

The animal's current lactation number.

DIM

The animal's current days in milk.

MILK

Pounds of milk the animal last produced.

RPRO

The animal's current reproductive code.

DCC

How many days the animal has carried its calf.

DSLH

How many days since the animal's last heat.
TIP: To see all available items for your dairy, go to your Item Definitions.
4

When you want to define one or more conditions, insert the word FOR and follow it with conditions to customize (i.e., filter) your report results, such as FOR PENClosed Pen number=4.

IMPORTANT: LIST (SHOW) commands require that the FOR keyword is typed before the BY or DOWNBY keyword. SUM commands require that the FOR keyword is typed after the BY or DOWNBY keyword.

In the command example above, the condition includes the word FOR, followed by 3 different conditions to customize the report results — one for lactation number (LACT), one for days carried calf (DCCClosed Days carrying calf/pregnant), and one for dry date (DDATClosed Dry date):

  • LIST \Z ID PEN LACT DIM DCC MILK FOR LACT>0 DCC>220 DDAT=0 BY PEN

    Adding these conditions to your command will narrow your report down to the following results:

    • LACT>0 tells the report to include only animals with a lactation number of 1 or higher.
    • DCC>220 tells the report to include only animals who have carried their calf for more than 220 days.
    • DDAT=0 tells the report to include only animals that are currently milking (i.e., a fresh date exists, but DDAT=0 means no dry date exists).

A SUM command requires that the FOR condition is typed after the sort word DOWNBY: 

  • SUM DOWNBY AGEClosed Age in months FOR LACT=0

    This tells the report to only include heifers, or animals that have not yet had a lactation cycle (LACT=0).

When entering a condition, you can choose from the following operators:

Operator

Definition for numeric and date values

Definition for string values

=

equal to

equal to

<>

not equal to

not equal to

>

greater than

contains

>=

greater than or equal to

-

<

less than

does not contain

<=

less than or equal to

-
5

The sort options are simple. You can use either BY or DOWNBY:

  • Use BY to sort lowest to highest.
  • Use DOWNBY to sort highest to lowest.
IMPORTANT: LIST (SHOW) commands require that the FOR keyword is typed before the BY or DOWNBY keyword. SUM commands require that the FOR keyword is typed after the BY or DOWNBY keyword.

The LIST command example above includes the sort word BY, followed by the column that will be sorted (PEN):

  • LIST \Z ID PEN LACT DIM DCC MILK FOR LACT>0 DCC>220 DDAT=0 BY PEN

    This tells the report to sort the list by the PEN column. It puts the lowest pen number at the top and the highest pen number at the bottom. If you used DOWNBY PEN instead, it would sort the highest pen number at the top and the lowest pen number at the bottom.

A SUM command requires that the sort word DOWNBY is typed before the FOR condition: 

  • SUM DOWNBY AGE FOR LACT=0

    This tells the report to sort the list by the AGE column. It puts the highest age group at the top and the lowest age at the bottom. If you used BY AGE instead, it would sort the youngest group at the top and the oldest group at the bottom.

Expand the topics below to learn more about the command line:

If you enter an incorrect command, or one that doesn't follow the expected syntax, the PULSE Platform provides a descriptive error message and highlights the area of the command that is in error: 

The Report Results page displays the results of your executed command. It includes the command and the date and time it was executed: 

You can choose to Print or Export your results. See Report Results for more information.

The PULSE Platform saves recent commands to the Reports History page: 

See Reports History to learn more!

Click the bookmark icon bookmark icon from the Report Results page to add your command to your Dairy Reports:

See Manage Dairy Reports to learn more!

The following cautions are especially important if you are familiar with DairyComp's command line feature: 

The PULSE Platform uses existing DairyComp 305 standard item numbers, as well as an expanded set of pre-defined standard items (2000+). See DairyComp Standard Items for more information.

PULSE Platform command line supports COUNT, LIST, and SUM.

The PULSE Platform interprets the order of month and day based on your User Profile Date format setting: 

The year may be two or four digits, and month and day may be one or two digits. Use a forward slash (/) or period (.) to separate year, month, and day. Dates may be specified in any of the following formats: 

  • yyyy/mm/dd or yyyy.mm.dd
  • mm/dd/yy or mm.dd.yy
  • mm/dd/yyyy or mm.dd.yyyy
  • dd/mm/yy or dd.mm.yy
  • mm/dd or dd/mm (assumes the current year)
  • yyyy/m/d or yyyy.m.d
  • m/d/yy or m.d.yy
  • m/d/yyyy or m.d.yyyy
  • d/m/yy or d.m.yy
  • m/d or d/m (assumes the current year)

For instance, September 17, 2019, can be formatted as:

  • 2019/09/17, 9.17.19, 9/17/19, or 9/17 if your date format is set to Month/Day/Year
  • 2019/17/09, 17.9.19, 17/9/19, or 17/9 if your date format is set to Day/Month/Year

Double quotes (") are required to identify a string in the command line. For instance, CODAClosed Wildcard 1 byte item any character="TEST".

Sort and condition keywords (BY, DOWNBY, FOR) must follow a prescribed order in LIST (SHOW) and SUM commands.

IMPORTANT: LIST (SHOW) commands require that the FOR keyword is typed before the BY or DOWNBY keyword. SUM commands require that the FOR keyword is typed after the BY or DOWNBY keyword.

In PULSE Platform command line, any switches must immediately follow the command word. The following switches are currently supported in the specified command(s): 

Switch

Definition

Command(s)

Example
\B

Includes results for both live and dead animals. Without the switch, command results include live animals only.

COUNT

LIST (SHOW)

SUM

LIST \B ID LACT DIM RPRO ARDAT FOR FDAT>-7 BY  LACT

Capture live and dead animal data for recently freshened animals by lactation.

\D

Limits results to dead cows only.

COUNT

LIST (SHOW)

SUM

COUNT \D FOR LACT=1 ARDAT>-90

Capture total number of dead animals in their first lactation in the last 90 days.

\S

Sets the standard deviation calculation to use sample values. Without the switch, PULSE Platform calculates population standard deviation.

SUM

SUM \S MILK PCTF PCTS LGSCC BY lact FOR LACT>0

Analyze sample standard deviation data for milk composition and quality by lactation.
\Z

Includes zero values in averages and standard deviation calculations. Without the switch, average, standard deviation, mode, and median calculations include non-zero values only.

SUM

SUM \Z TKET BY LCTGP FOR FDAT>-365

Analyze the number of times ketosis was diagnosed by lactation group for all animals that calved in the last year.

< Return to Features Overview