Support » Plugin: Swim Team » Import Events from Team Manager

  • Resolved gdisalvo

    (@gdisalvo)


    Hi Mike,

    I created a group. I wish to import a file from TM. TM creates the ZIP file with both ev3 and the hyv files. The ev3 has the events list for the meet. Can this file be imported into the event group and it creates a new meet number during loading?

    I can extract into a CVS and reformat the data to align with your table and import into table using the PHPMYADMIN – this is the long way.

    http://wordpress.org/plugins/wp-swimteam/

Viewing 15 replies - 1 through 15 (of 31 total)
  • Thread Starter gdisalvo

    (@gdisalvo)

    I am getting these errors.

    Please review the following error(s) below.
    Hy-tek Event File
    Invalid header record encountered in Hy-tek Event File on line 1.
    Hy-tek Event File
    Error: Invalid number of fields in Header Record, found 33, should have 11

    Thread Starter gdisalvo

    (@gdisalvo)

    HyV file is sorta working

    Please review the following error(s) below.
    Hy-tek Event File
    Invalid event record encountered in hy-tek event file on line 2.
    Hy-tek Event File
    Error: Age range (8-9) in Event Record does not match any ‘Female’ age groups

    I change the file from 9-9 to 8-9 but now the validation is on ages. I have normal meets that are 0-8 and 9-10 and 11-12.
    This special one is a TM file containing 9-9. 10-10 12-12 and so on.
    Do I need to create age groups for each just to load the file?
    Is there a way to over this age group check on the event file load?

    Plugin Author Mike Walsh

    (@mpwalsh8)

    wp-SwimTeam can import the HYV file but not the EV3 file.

    Regarding your age group issues, check this post from a while back. It reviews what you need to do to set up age groups which are a superset or overlap of other age groups.

    The event import process requires that there be a matching age group defined within wp-SwimTeam or it doesn’t know what to do with that age group. The “combined” age group functionality allows you to define age groups which span multiple age groups and/or genders.

    Plugin Author Mike Walsh

    (@mpwalsh8)

    Can post the content of the Event file so I can see what the header looks like? What version of Meet Manager is generating the HYV file. It is possible Hy-tek changed the format of the file.

    Thread Starter gdisalvo

    (@gdisalvo)

    I have to add the age group records or it starts to load blanks.

    I removed some of the validation to pass through.

    I will try adding adding age groups and resetting validation again and try another test.

    Thread Starter gdisalvo

    (@gdisalvo)

    File Sample with header

    2013 EMAC Pentathlon Trophy Challenge;10/12/2013;10/12/2013;10/12/2013;Y;Emmaus High School;;Hy-Tek Sports Software;4.0Eg;CN;91481
    1;F;F;I;9;9;50;1;;;;4;;;;;;
    2;F;M;I;9;9;50;1;;;;4;;;;;;
    3;F;F;I;10;10;50;1;;;;4;;;;;;
    4;F;M;I;10;10;50;1;;;;4;;;;;;
    5;F;F;I;11;11;50;1;;;;4;;;;;;
    6;F;M;I;11;11;50;1;;;;4;;;;;;
    7;F;F;I;12;12;50;1;;;;4;;;;;;
    8;F;M;I;12;12;50;1;;;;4;;;;;;
    9;F;F;I;0;12;100;1;;;;4;;;;;;
    10;F;M;I;0;12;100;1;;;;4;;;;;;
    11;F;F;I;9;9;50;4;;;;4;;;;;;

    Thread Starter gdisalvo

    (@gdisalvo)

    Hi Mike,

    OK Here is what I did.

    I used the COMBINED radio as my standard is for normal division meets.
    The combined allow me to create various agegroups.
    Example:
    9 – 9 = F
    9 – 9 = M
    10 – 10 = F
    10 – 10 = M

    And so on.
    This allowed me to pass the checks.

    I did have to alter the input file as the hy-tek event creation from this invitational use value 0 as low or lowest and 0 as high or unlimited age.
    Example age group:
    0 – 13
    16 – 0

    So I altered each of these to match the age groups I entered in Swim team. I entered the age group using PHPADMIN. As you front end is looking for a higher value than a matching value.

    I think you need to allow for only one age for event.

    This meet is for 5 total events for one age and this grouping competes against each other.

    Here is a sample of the loaded events.

    1 	Girls 9-9 	50 	Short Course Yards 	Freestyle 	EMAC Pentathlon Trophy Challenge 	636
    	2 	Boys 9-9 	50 	Short Course Yards 	Freestyle 	EMAC Pentathlon Trophy Challenge 	637
    	3 	Girls 10-10 	50 	Short Course Yards 	Freestyle 	EMAC Pentathlon Trophy Challenge 	638
    	4 	Boys 10-10 	50 	Short Course Yards 	Freestyle 	EMAC Pentathlon Trophy Challenge 	639
    	5 	Girls 11-11 	50 	Short Course Yards 	Freestyle 	EMAC Pentathlon Trophy Challenge 	640
    	6 	Boys 11-11 	50 	Short Course Yards 	Freestyle 	EMAC Pentathlon Trophy Challenge 	641
    	7 	Girls 12-12 	50 	Short Course Yards 	Freestyle 	EMAC Pentathlon Trophy Challenge 	642
    	8 	Boys 12-12 	50 	Short Course Yards 	Freestyle 	EMAC Pentathlon Trophy Challenge 	643
    	9 	Girls 12-12 	100 	Short Course Yards 	Freestyle 	EMAC Pentathlon Trophy Challenge 	644
    	10 	Boys 12-12 	100 	Short Course Yards 	Freestyle 	EMAC Pentathlon Trophy Challenge 	645
    	11 	Girls 9-9 	50 	Short Course Yards 	Butterfly 	EMAC Pentathlon Trophy Challenge 	646
    	12 	Boys 9-9 	50 	Short Course Yards 	Butterfly 	EMAC Pentathlon Trophy Challenge 	647
    	13 	Girls 10-10 	50 	Short Course Yards 	Butterfly 	EMAC Pentathlon Trophy Challenge 	648
    	14 	Boys 10-10 	50 	Short Course Yards 	Butterfly 	EMAC Pentathlon Trophy Challenge 	649
    	15 	Girls 11-11 	50 	Short Course Yards 	Butterfly 	EMAC Pentathlon Trophy Challenge 	650
    	16 	Boys 11-11 	50 	Short Course Yards 	Butterfly 	EMAC Pentathlon Trophy Challenge 	651
    	17 	Girls 12-12 	50 	Short Course Yards 	Butterfly 	EMAC Pentathlon Trophy Challenge 	652
    	18 	Boys 12-12 	50 	Short Course Yards 	Butterfly 	EMAC Pentathlon Trophy Challenge 	653
    	19 	Girls 12-12 	100 	Short Course Yards 	Butterfly 	EMAC Pentathlon Trophy Challenge 	654
    	20 	Boys 12-12 	100 	Short Course Yards 	Butterfly 	EMAC Pentathlon Trophy Challenge 	655
    	21 	Girls 9-9 	50 	Short Course Yards 	Backstroke 	EMAC Pentathlon Trophy Challenge 	656
    	22 	Boys 9-9 	50 	Short Course Yards 	Backstroke 	EMAC Pentathlon Trophy Challenge 	657
    	23 	Girls 10-10 	50 	Short Course Yards 	Backstroke 	EMAC Pentathlon Trophy Challenge 	658
    	24 	Boys 10-10 	50 	Short Course Yards 	Backstroke 	EMAC Pentathlon Trophy Challenge 	659
    	25 	Girls 11-11 	50 	Short Course Yards 	Backstroke 	EMAC Pentathlon Trophy Challenge 	660
    	26 	Boys 11-11 	50 	Short Course Yards 	Backstroke 	EMAC Pentathlon Trophy Challenge 	661
    	27 	Girls 12-12 	50 	Short Course Yards 	Backstroke 	EMAC Pentathlon Trophy Challenge 	662
    	28 	Boys 12-12 	50 	Short Course Yards 	Backstroke 	EMAC Pentathlon Trophy Challenge 	663
    	29 	Girls 12-12 	100 	Short Course Yards 	Backstroke 	EMAC Pentathlon Trophy Challenge 	664
    	30 	Boys 12-12 	100 	Short Course Yards 	Backstroke 	EMAC Pentathlon Trophy Challenge 	665
    	31 	Girls 9-9 	50 	Short Course Yards 	Breaststroke 	EMAC Pentathlon Trophy Challenge 	666
    	32 	Boys 9-9 	50 	Short Course Yards 	Breaststroke 	EMAC Pentathlon Trophy Challenge 	667
    	33 	Girls 10-10 	50 	Short Course Yards 	Breaststroke 	EMAC Pentathlon Trophy Challenge 	668
    	34 	Boys 10-10 	50 	Short Course Yards 	Breaststroke 	EMAC Pentathlon Trophy Challenge 	669
    	35 	Girls 11-11 	50 	Short Course Yards 	Breaststroke 	EMAC Pentathlon Trophy Challenge 	670
    	36 	Boys 11-11 	50 	Short Course Yards 	Breaststroke 	EMAC Pentathlon Trophy Challenge 	671
    	37 	Girls 12-12 	50 	Short Course Yards 	Breaststroke 	EMAC Pentathlon Trophy Challenge 	672
    	38 	Boys 12-12 	50 	Short Course Yards 	Breaststroke 	EMAC Pentathlon Trophy Challenge 	673
    	39 	Girls 12-12 	100 	Short Course Yards 	Breaststroke 	EMAC Pentathlon Trophy Challenge 	674
    	40 	Boys 12-12 	100 	Short Course Yards 	Breaststroke 	EMAC Pentathlon Trophy Challenge 	675
    	41 	Girls 9-9 	100 	Short Course Yards 	Individual Medley 	EMAC Pentathlon Trophy Challenge 	676
    	42 	Boys 9-9 	100 	Short Course Yards 	Individual Medley 	EMAC Pentathlon Trophy Challenge 	677
    	43 	Girls 10-10 	100 	Short Course Yards 	Individual Medley 	EMAC Pentathlon Trophy Challenge 	678
    	44 	Boys 10-10 	100 	Short Course Yards 	Individual Medley 	EMAC Pentathlon Trophy Challenge 	679
    	45 	Girls 11-11 	100 	Short Course Yards 	Individual Medley 	EMAC Pentathlon Trophy Challenge 	680
    	46 	Boys 11-11 	100 	Short Course Yards 	Individual Medley 	EMAC Pentathlon Trophy Challenge 	681
    	47 	Girls 12-12 	100 	Short Course Yards 	Individual Medley 	EMAC Pentathlon Trophy Challenge 	682
    	48 	Boys 12-12 	100 	Short Course Yards 	Individual Medley 	EMAC Pentathlon Trophy Challenge 	683
    	49 	Girls 12-12 	200 	Short Course Yards 	Individual Medley 	EMAC Pentathlon Trophy Challenge 	684

    Thread Starter gdisalvo

    (@gdisalvo)

    Here is the old age group

    76 	Boys 15-15 	100 	Short Course Yards 	Backstroke 	EMAC Pentathlon Trophy Challenge 	711
    	77 	Girls 16-18 	100 	Short Course Yards 	Backstroke 	EMAC Pentathlon Trophy Challenge 	712
    	78 	Boys 16-18 	100 	Short Course Yards 	Backstroke 	EMAC Pentathlon Trophy Challenge 	713
    	79 	Girls 13-15 	200 	Short Course Yards 	Backstroke 	EMAC Pentathlon Trophy Challenge 	714
    	80 	Boys 13-15 	200 	Short Course Yards 	Backstroke 	EMAC Pentathlon Trophy Challenge 	715
    	81 	Girls 13-13 	100 	Short Course Yards 	Breaststroke 	EMAC Pentathlon Trophy Challenge 	716
    	82 	Boys 13-13 	100 	Short Course Yards 	Breaststroke 	EMAC Pentathlon Trophy Challenge 	717
    	83 	Girls 14-14 	100 	Short Course Yards 	Breaststroke 	EMAC Pentathlon Trophy Challenge 	718
    	84 	Boys 14-14 	100 	Short Course Yards 	Breaststroke 	EMAC Pentathlon Trophy Challenge 	719
    	85 	Girls 15-15 	100 	Short Course Yards 	Breaststroke 	EMAC Pentathlon Trophy Challenge 	720
    	86 	Boys 15-15 	100 	Short Course Yards 	Breaststroke 	EMAC Pentathlon Trophy Challenge 	721
    	87 	Girls 16-18 	100 	Short Course Yards 	Breaststroke 	EMAC Pentathlon Trophy Challenge 	722
    	88 	Boys 16-18 	100 	Short Course Yards 	Breaststroke 	EMAC Pentathlon Trophy Challenge 	723
    	89 	Girls 13-15 	200 	Short Course Yards 	Breaststroke 	EMAC Pentathlon Trophy Challenge 	724
    	90 	Boys 13-15 	200 	Short Course Yards 	Breaststroke 	EMAC Pentathlon Trophy Challenge 	725
    	91 	Girls 13-13 	200 	Short Course Yards 	Individual Medley 	EMAC Pentathlon Trophy Challenge 	726
    	92 	Boys 13-13 	200 	Short Course Yards 	Individual Medley 	EMAC Pentathlon Trophy Challenge 	727
    	93 	Girls 14-14 	200 	Short Course Yards 	Individual Medley 	EMAC Pentathlon Trophy Challenge 	728
    	94 	Boys 14-14 	200 	Short Course Yards 	Individual Medley 	EMAC Pentathlon Trophy Challenge 	729
    	95 	Girls 15-15 	200 	Short Course Yards 	Individual Medley 	EMAC Pentathlon Trophy Challenge 	730
    	96 	Boys 15-15 	200 	Short Course Yards 	Individual Medley 	EMAC Pentathlon Trophy Challenge 	731
    	97 	Girls 16-18 	200 	Short Course Yards 	Individual Medley 	EMAC Pentathlon Trophy Challenge 	732
    	98 	Boys 16-18 	200 	Short Course Yards 	Individual Medley 	EMAC Pentathlon Trophy Challenge 	733
    	99 	Girls 13-15 	400 	Short Course Yards 	Individual Medley 	EMAC Pentathlon Trophy Challenge 	734
    	100 	Boys 13-15 	400 	Short Course Yards 	Individual Medley 	EMAC Pentathlon Trophy Challenge 	735
    Thread Starter gdisalvo

    (@gdisalvo)

    Now I have this in the system.
    I can get registered swimmers and create a roster file export to be handed to the event organizers.

    This way we do not have to manually create the files or input all the swimmers and their events.

    I have many more to enter some are different hyv files.

    Do you think you can find a way to check for ZERO low and ZERO high end
    If that is there to override with closest match age group defined?

    Thread Starter gdisalvo

    (@gdisalvo)

    Here is the NEXT hyv file
    You can see that this is for 13 and older
    I will create a combine 13-18 for each gender.
    I hope the others fall under standard
    The 0 – 0 is OPEN – I guess any age will do?

    1;F;F;I;0;0;400;5;;;;4;;;;;;
    2;F;M;I;0;0;400;5;;;;4;;;;;;
    3;F;F;I;0;0;500;1;;;;4;;;;;;
    4;F;M;I;0;0;500;1;;;;4;;;;;;
    5;F;F;I;9;10;200;5;;;;4;;;;;;
    6;F;M;I;9;10;200;5;;;;4;;;;;;
    7;F;F;I;13;0;200;4;;;;4;;;;;;
    8;F;M;I;13;0;200;4;;;;4;;;;;;
    9;F;F;I;13;0;100;3;;;;4;;;;;;
    10;F;M;I;13;0;100;3;;;;4;;;;;;
    11;F;F;I;13;0;100;2;;;;4;;;;;;
    12;F;M;I;13;0;100;2;;;;4;;;;;;
    13;F;F;I;13;0;200;5;;;;4;;;;;;
    14;F;M;I;13;0;200;5;;;;4;;;;;;
    15;F;F;I;13;0;100;1;;;;4;;;;;;
    16;F;M;I;13;0;100;1;;;;4;;;;;;
    17;F;F;I;9;10;50;2;;;;4;;;;;;
    18;F;M;I;9;10;50;2;;;;4;;;;;;
    19;F;F;I;11;12;100;2;;;;4;;;;;;
    20;F;M;I;11;12;100;2;;;;4;;;;;;
    21;F;F;I;11;12;200;3;;;;4;;;;;;
    22;F;M;I;11;12;200;3;;;;4;;;;;;

    Thread Starter gdisalvo

    (@gdisalvo)

    Another file that is different.

    Event numbers with letters
    34A
    34B

    See example file:
    33;F;M;I;11;12;50;1;;;DUNIGAN & COMPANY BUILDERS;5;;;;;;
    34A;F;F;I;13;14;100;1;;;;5;;;;;;
    34B;F;F;I;15;0;100;1;;;;5;;;;;;
    35A;F;M;I;13;14;100;1;;;;5;;;;;;
    35B;F;M;I;15;0;100;1;;;;5;;;;;;
    36;F;F;I;11;12;50;2;;;;5;;;;;;
    37;F;M;I;11;12;50;2;;;VISION CARE SPECIALISTS, INC.;5;;;;;;
    38A;F;F;I;13;14;100;2;;;;5;;;;;;
    38B;F;F;I;15;0;100;2;;;;5;;;;;;
    39A;F;M;I;13;14;100;2;;;;5;;;;;;
    39B;F;M;I;15;0;100;2;;;;5;;;;;;
    40;F;F;I;11;12;50;3;;;;5;;;;;;
    41;F;M;I;11;12;50;3;;;;5;;;;;;
    42A;F;F;I;13;14;100;3;;;;5;;;;;;
    42B;F;F;I;15;0;100;3;;;;5;;;;;;

    Thread Starter gdisalvo

    (@gdisalvo)

    Here is the PREG
    if (!preg_match(‘/^\d+$/’, $fields[0]))

    Should we allow letter to match event number?

    Thread Starter gdisalvo

    (@gdisalvo)

    Getting – Duplicate events
    event Number 34B on line 27 will be ignored, duplicate event number.
    I will see if I can clean it in the code.

    Thread Starter gdisalvo

    (@gdisalvo)

    Table is INT(11)

    Not sure if I can make it alpha numeric without upseting other references.

    Then the code should insert without the check for same number

    Thread Starter gdisalvo

    (@gdisalvo)

    Hi Mike,

    Most files seem to be loading fine.

    Here is what I have compiled.

    1) Adding age groups for all variations.
    Using combined option for these special variations.

    0-0 etc.

    2) Duplicate Events. Cannot be resolved unless I change table from numeric to alpha. I will test later.
    By solving this TM files with events that are 34 and 34A can be loaded. Just representing them or if other code does validation check matches could cause some rewrites.

    3) Missing dump of TM of only events from an event group. I would like to duplicate ONE group or meet into others. This will save time entering manually.
    Scenario:
    I have 5 boys and 5 girl meets each swim same events. If I manually load one, can it be dumped and reloaded into other 9 meets. I will need to dump the event file before opening registration.

    4) Is there a way to read incoming file to determine age group. Basically, if 0-7 or 15-0 is not in the min – max of an age group for a gender, simply add it as part of the load? Send message that it was added, then proceed to loading event in your sequence.

Viewing 15 replies - 1 through 15 (of 31 total)
  • The topic ‘Import Events from Team Manager’ is closed to new replies.