Addy291 wrote:
1. go into STA_race
2. click on the blank row at the bottom
3. it will have an automatically generated number in the IDrace column, leave that
4. type 'Norwegian Championships' in the two columns next to the ID (or in whatever language)
5. fkIDcountry, put the code for Norway, '35'
6. fkIDnewUCI_class put the code '14' (national champs RR)
7. put '81' in the column fkIDclassification_time
8. put '0' in the next 2 columns (mountain and points)
9. put 127 in the next column (fkIDclassification_team)
10. put '0' in the next 3 columns (specific 1, 2 + 3)
NOW OPEN UP ANOTHER HANNES CONVERTOR (open the another program keeping the other still open as we will come back to it)
11. go into STA_stage
12. click on the blank row at the bottom
13. automatically generated stage ID, leave it
14. fkIDrace, put in the automatically generated ID number from step 3
15. gene_i_day, gene_i_month put when you want it
16. now the gene_i_computed_date
go to this website
https://www.onlineconversion.com/unix_...x_time.htm and in the bit that says Convert a Date/Time to a Unix timestamp, put the month, day and year in and click submit
the number that comes up is the number you put in the column i named above
17. gene_sz_stage_name put int Norwegian Championships or whatever you want
18. fkIDstage_type put '1'
19. fkIDrelief, put a number between 1 and 4
20. feat_f_rain put in 5, 15, 25, 30 or 50
21. feat_f_direction_wind put 999
22. gene_i_stage_number, put 1
23. gene_f_distance, however long it is
24. gene_i_sprints_number put 0 unless it has intermidiate sprint, which i doubt
25. gene_i_num_ravito put 3 or 4
26. gene_f_time_gap put 20
27, gene_b_selected put 1
28. gene_f_start put 0
29. gene_f_altitude put 0
30. gene_f_spline_length haven't got a clue what a spline is, so unless you know copy one of the other national champs
31. weather put 0
32. temperature put 0
33. addtemperature put 0
34. gene_f_mountain if it's flat put 0 if it's not put something (don't know what)
35. gene_f_uphillsprint put 0 unless there is an uphill sprint
36. gene_b_hascobble put as 0 unless has cobbles
37. gene_b_demo put as 0
38. gene_b_ladder_stage put as 0
39. CONSTANT leave blank
40. fkIDday put as 0
41. gene_sz_stage_xml put in the xml file name
42. gene_sz_stage_ladder_xml leave blank
43. gene_sz_stage_md5 wtf is that
44. gene_sz_stage_ladder_md5 leave blank
45. gene_b_played put as 0
BACK TO THE OTHER ONE (STA_race)
46. fkIDfirst_stage, fkIDlast_stage put inthe automatically generated stageID in step 13 (man that was a long time ago)
47. all 4 jersey ones put as 0
48. gene_b_inscription put as 0
49. gene_b_importantrace put as 0
50. gene_i_number_stages put as 1
51. number flat, number hill, number high mountain, put all as 0 apart from the stage type it is where you put a 1
52. gene_b_isactive put as 0
53. gene_i_min_cyclist put as 1
54. gene_i_max_cyclist put 9
55. leave the email column blank
56. leave the gene_ilist_fkIDteam blank
57. fkIDLastRaceLead put as 0
58 CONSTANT put as champ_norway (or whatever but it has to be champ_)
59. local_temp_count put as 0
60. gene_sz_classification_xml put 'default.xml'
61. gene_b_classification_mountain, classification_points, classification_young, gene_b_customrace and gene_f_organisatuer_coeff put as 0
62. gene_sz_variant_xml put Norwegian championships
63. fkIDtype_tour put as '9' (national champ)
64. gene_b_aso put as 0
65. make sure you save both open tables via the small button at the bottom, then the big button at the top and make sure you click on the table name before clicking ok
FINISHED!!!!!!!!!!!!!!!!!!!
my god that took ages
hope it helps and hope that answers you're question, if it doesn't, i will kill you
please report back if it works or not
