|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | CXN Export | |
| Maltzaroo 8/30/2010 2:05:46 AM | I'm learning how to export CXN data. Did it successfully today, for trainer/jockey.. Tried it again tonight for trainer/owner and am getting an error message that says: Run-time error '2147217887(8004e21)': The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. I cleared previous data first. I tried entering different dates. Nothing works. The instructions don't mention the pop-up calendar for a date range. Why is only one date asked for? Is the second date always today? Can you tell me what's going on, please? I don't think I'm doing anything differently on this second attempt than I did on the first, which worked fine. Thanks!
| |
| jeff 8/30/2010 8:17:24 PM | --quote: "I'm learning how to export CXN data. Did it successfully today, for trainer/jockey.. Tried it again tonight for trainer/owner and am getting an error message that says: Run-time error '2147217887(8004e21)': The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.--end quote First best guess about the error msg is an owner name longer than the max number of characters in your table. Tell me what time period you are using and I'll try to replicate at my end and then have a look. The procedure for running a CXN Export is explained in this video: http://www.jcapper.com/podcasts/cxn35.wmv The Calendar Control was added after the video was cut. The date is called a Trend baseline Date. If you click the "What's This?" button on the Calendar Control you will get a pop up with a simple explanation describing what a trend Baseline Date is. A trend baseline date is intended to enable the interface to accurately populate the 60, 45, 30, and 15 day trend date fields in table so that you can see CXN trend data reported accurately in your reports. Ideally, you will be up to date through yesterday with your datababase builds at the point in time you run a CXN Export - and you wil supply today's date as your trend baseline date. If you are not up to date with your database builds, then supply the interface with a trend baseline date of the day after the date of the most recent records in most recent your database build. -jp .
| |
| Maltzaroo 8/31/2010 2:12:57 AM | I just successfully did one for jockeys and it worked fine. Still get same error message for owner/trainer so I guess you're right about the long trainer name. I had already watched the video a couple of times before I posted. Also the "What's this?" button doesn't really say what a Trend baseline date is....it just states that it's whats being asked for. It so happens that in my ignorance I in effect used today's date because I put in 2 dates because I thought it was asking for a start date and end date. The "end" date was inserted last and thereby took precedence when I hit the play button. At any rate, I'm using the whole month of August, HDW data for all available tracks. I just wanted to see if I could identify any trainer win streaks. Let me know if I need to explain more. Thanks!
| |
| jeff 8/31/2010 5:58:51 AM | Re: The error message. Rider and trainer names check out ok. The problem appears isolated to owner names. Looking at the data itself, there are a handful of owner names longer than the 50 character max length allocated for each cxn name in the table. Two options: 1. Widen the name field in the table to allow for names longer than 50 chars. 2. Truncate names longer than 50 chars to the left most 50 chars before writing names to the table. Leaning towards the second option at the moment as it impacts the CXN Export Module only... enabling faster turn around time in getting a bug fix published. Will sleep on it and decide in the morning. -jp .
| |
| jeff 9/3/2010 8:56:41 PM | A quick update... The 9-3-2010 Program Updates (both Platinum and Silver) contain a bug fix for this. The problem turned out to be that there are a handful of owner names out there that are longer than 50 characters in length - while the amount of space for cxn names in the CXNSummary table is 50 chars per name. The fix involves a routine that pre-screens cxn names for character length. If a cxn name is found to be more than 50 chars in length, the text string that gets written to the table is the 50 left most characters of the cxn name. After installing the 9-3-2010 program update you should find that you can once again successfully run a CXN Export for owners. Be aware though that there will likely be thousands of owner names (as opposed to a few hundred rider names or several hundred trainer names) in a complete database once it spans a reasonably large time period. Therefore it can take up to several hrs to run a CXN Export involving owner names. -jp .
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |