|
mbwoodruff
Registered: 08/05/07
Posts: 28
|
 Thursday, February 04 2010 @ 12:05 AM EST |
|
I am using Access 2003 with SIMS 5.1 beta 3. I am downloading the CAPWATCH text file and unzipping the data files into the SIMS CAPWATCH folder. When I run the import function I get the following message:
Data from one or more of the following CAPWATCH tables was not imported because the table is missing or not in the expected format:
MkTbl_tmpDownloadDate
MkTbl_tmpMbrAchievements
MkTbl_tmpMbrTasks
SMProfessionalDevelopment (48)
Any suggestions?
|
|
Mark Woodruff, Lt Col, CC, Group-705 Southeast Michigan
|
|
|
| |
CMetzger
Registered: 05/27/04
Posts: 123
|
| Thursday, February 04 2010 @ 01:13 AM EST |
|
I was going to post that I'm getting the same error as well. It was the table changes they made on 11/23/09 that did it. Not much we can do, as it is a new feature, but Dennis will fix it quick, I'm sure.
Dennis (and anyone else interested), it looks like those linked tables are getting #Num! errors for some reason (changed field lengths?). Re-linking fixed it, but it appears some of the field names have changed. It broke the make-table queries because ApprByCAPID is now AuthByCAPID, and ApprDate is now AuthDate in MbrAchievements and MbrTasks. Only the MbrTasks make-table needed to be modified with the old field names, though. It also broke qryESCAPWATCHMemberAchv-to-TCard query. Updating the field names in those three queries fixed it quick. Probably not the "right" way to do it.... |
|
Chris Metzger, Capt, CAP
|
|
|
| |
dvander
Registered: 02/18/04
Posts: 374
|
| Thursday, February 04 2010 @ 06:32 PM EST |
|
Yes, I'm on it.
I have a new report that compares SIMS and CAPWATCH cadet test scores that's almost good to go, so I'll include that in 5.1 b4 upload as well.
Dennis |
|
Dennis Van der Vieren Capt CAP
IT Officer
Dakota Ridge Composite Squadron RMR-CO-186
Colorado Wing
|
|
|
| |
dvander
Registered: 02/18/04
Posts: 374
|
| Thursday, February 04 2010 @ 09:22 PM EST |
|
OK, It's all fixed now. NHQ did change a few fields as Chris pointed out.
I relinked the tables as Chris suggested and updated the make table queries to change the new names to the old names so everything would continue working.
NHQ changed the download date to include the time after the date. I relinked the DownloadDate table and made the field an text field and did a conversion in the make table query using the CDate function.
I'll be packaging up the files and upload them from work tomorrow (Friday is a lighter day at work for me).
Thanks for reporting the issue here, and thanks to Chris for pinging me with an email to let me know about this issue.
Dennis |
|
Dennis Van der Vieren Capt CAP
IT Officer
Dakota Ridge Composite Squadron RMR-CO-186
Colorado Wing
|
|
|
| |
beric3236
Registered: 06/22/04
Posts: 22
|
| Friday, February 05 2010 @ 07:06 PM EST |
|
First thanks for the hard work you have put into the program. I downloaded the Version 5.1 beta 4, and tried to import from national.
I received the error: Data from one or more of the following CAPWATCH tables was not imported because the table is missing or not in the expected format:
SMDUTY(8)
Again Thanks for your hard work |
|
Robert Erickson, Lt. Col., Admin/Personnel Officer - Malmstrom AFB Composite Squadron, Great Falls, MT
|
|
|
| |
beric3236
Registered: 06/22/04
Posts: 22
|
| Friday, February 05 2010 @ 07:11 PM EST |
|
I downloaded SIMS 5.1 beta 4 and tried to import the national data. I am using Access 2003 I am downloading the CAPWATCH text file and unzipping the data files into the SIMS CAPWATCH folder. When I run the import function I get the following message:
Data from one or more of the following CAPWATCH tables was not imported because the table is missing or not in the expected format:
SMDUTY (8)
|
|
Robert Erickson, Lt. Col., Admin/Personnel Officer - Malmstrom AFB Composite Squadron, Great Falls, MT
|
|
|
| |
capt ssnyder
Registered: 03/14/04
Posts: 96
|
| Friday, February 05 2010 @ 10:19 PM EST |
|
I do like the idea of comparing SIMS to CAPWATCH cadet scores but I see an error. The Curry award is missing and Spaatz is listed twice. This causes the two columns to be off set. SIMS data for Curry is next to CAPWATCH data for Arnold etc. Dennis, I will email you an exerpt from my files so you can see what I mean.
Thanks Again for all of your work on this. |
|
Steven A. Snyder, Maj, CAP
Dept Commander for Cadets
Woodfield Composite Squadron
GLR-IL-075
|
|
|
| |
CMetzger
Registered: 05/27/04
Posts: 123
|
| Saturday, February 06 2010 @ 12:41 AM EST |
|
A bad link in one of the queries is causing the import error. tmpSMDutyPosition should be tmpCAPWATCHSMDutyPosition in qryUpdateSMDuty.
The SIMS v CAPWATCH report is trickier. The achievement name is looking at the "Next Achievement" for each cadet, and the SIMS achievement ID is 1 higher than the CAPWATCH, since CAPWATCH doesn't count C/AB as an achievement. It's in SIMS that way because, hey, SIMS is better. 
I shall also report up to our Glorious Leader, Dennis. |
|
Chris Metzger, Capt, CAP
|
|
|
| |
mbwoodruff
Registered: 08/05/07
Posts: 28
|
| Monday, February 08 2010 @ 09:46 AM EST |
|
| I have been waiting to apply beta 4 until the fix was complete. It sounds like there is still a problem. Beta 5? Or is there a quick fix for beta 4 someone can lead me through? |
|
Mark Woodruff, Lt Col, CC, Group-705 Southeast Michigan
|
|
|
| |
dvander
Registered: 02/18/04
Posts: 374
|
| Wednesday, February 10 2010 @ 10:47 PM EST |
|
Thanks Chris for the updates. I implemented them and they are working fine.
Let's call this next one beta 5.
Will get that uploaded here asap.
Dennis |
|
Dennis Van der Vieren Capt CAP
IT Officer
Dakota Ridge Composite Squadron RMR-CO-186
Colorado Wing
|
|
|
| |
