JCapper Message Board

JCapper 101
-- ECIA Export

Home	Register Log In

ECIA Export

Caveat
1/12/2025
10:06:29 AM

Is this out yet?

Would a video be possible?

jeff
1/13/2025
10:05:50 PM

It's out/was delivered starting with the initial release of JCapper Platinum 2025 on Dec 26, 2024.

I've got a long list of new videos in the works/yet to be cut - EICA File included.

Below is a cut and paste from what will eventually be part of the EICA File Help Doc:

EICA.csv File Description and Field Mapping:

Description:

The EICA.csv file (Everything I Care About) is created by the JCapper 2025 Main Module during Build Database routines. It contains more than 2500 columns. The objective is to facilitate importing large amounts of JCapper data into third party data tools such as Microsoft SQL Server, Python etc. for statistical analysis.

The EICA.csv file can be opened in Excel by double clicking it if file size is under about 1.5 gigabytes. Beyond that, if you want to open it to see or edit the data you will need to open it in an editor capable of handling BIG text files (Python.)

Hint:
1. Double click the EICA.csv file to open it in Excel. From there, you can make the data readable by clicking the 'square' at the upper left of the data to highlight all of the data -- followed by clicking 'Format' on the Ribbon -- Then select 'AutoFit Column Width.' (At this point the data should be easy to see.)

Field Mapping:

--Section 1.
Column names: "pps" (without the quotes) followed by column number.
Data Source: JCapper JCP Past Performance Data File (1435 Cols)
Description: Raw Past Performance Data
Latest Published Field mapping: http://www.jcapper.com/MessageBoard/Reports/ChartRacesFieldMapping.txt

Note: Currently working on updated .JCP Field Mapping for JCapper 2025.

--Section 2.
Column names: "res" (without the quotes) followed by column number.
Data Source: HDW F Text Chart Results File (255 Cols)
Description: Raw Chart Results Data
Field mapping: http://www.jcapper.com/messageboard/reports/Comma_Delimited_Charts_Spec.pdf

--Secton 3.
Column names: "tkw_" followed by the 39 TrackWeather Column Names from the ChartRaces Table
Data Source: ChartRaces Table in the JCapperSDK.mdb File (Cols 0-38)
Description: Weather Observations from the JCapper TrackWeather API
Field mapping: http://www.jcapper.com/messageboard/reports/TKW_ChartRacesFieldMapping.txt

--Section 4.
Column names: "ply" (without the quotes) followed by column number.
Data Source: Pl_Profile.txt File (550 to 600 Cols... currently 573 Cols)
Description: Factors (numeric value, rank, and gap) and output generated by JCapper in Playlist File Mode
Field mapping: http://www.jcapper.com/messageboard/pdfs/fieldmap_dec012011.pdf

--Section 5.
Column names: Actual Column Names from the StarterHistory Table
Data Source: StarterHistory Table in c:\JCapper\Exe\JCapper2.mdb file (253 Cols)
Description: Factors (numeric value, rank, and gap) and output generated by JCapper in SQL Mode
Field mapping: http://www.jcapper.com/messageboard/reports/JCapperStarterHistoryFieldMapping01272024.txt

--Notes:

1. Scratched horses are included in the data. Scratched horses are designated with a Y in Column 97 (res97) of the HDW Text Chart Results (Section B.)

2. Dates formatted as:

Section A: yyyymmdd -- example: 20240126

Section B: mm/dd/yyyy -- example 1/26/2024

Section c: mm/dd/yyyy -- 1/26/2024

Section D: #yyyy-mm-dd# -- example: #2024-01-26#

IMPORTANT!
If you are located outside the US, to ensure correct calculation of days back for workouts and running lines of previous races:

Change and persist the Windows Language and Region Setting to English (US) on all machines being used for JCapper.

3. Track Codes:

a. JCP FileNames always have 3 char track code, example: AQU (Aqueduct)

b. For 2 char Equibase Track Codes an X char is added, example: SAX (Santa Anita)

c. Track for past running line data in Section A cols pps286-pps295 for 2 char track codes contains a 2 char track code.

d. Lone exception is Fairmont Park which is FPK (to avoid confusion with Fairplex (FPX) which is no longer running.

e. HDW Text Chart Result FileNames are 2 Chars for 2 char Equibase Track Codes, example: SA (Santa Anita)

f. Track Codes in Section D StarterHistory Table are always 3 chars, example: SAX (Santa Anita)


Originally posted 1/13/2025 at 11:48:55 AM

Edited for spelling: 

original     corrected
---------    -------------
delievered   delivered
statisical   statistical
filesize     file size
Oservations  Observations

-jp
.

~Edited by: jeff on: 1/13/2025 at: 10:05:50 PM~

SILVER01HDW
2/2/2025
1:43:48 PM

Looking forward to a video ..soon?

jeff
2/3/2025
11:50:57 AM

Not yet.

There's still a fairly long list of new things I need to knock off first.

It'll make sense when I'm done. (The EICA File video will be towards the end.)

-jp
.

SILVER01HDW
2/3/2025
3:46:22 PM

JCapper Message Board

JCapper 101 -- ECIA Export

JCapper 101
-- ECIA Export