-
This is a reminder of 3 IMPORTANT RULES:
1- External self-promotion websites or apps are NOT allowed here, like Discord/Twitter/Patreon/etc.
2- Do NOT post in other languages. English-only.
3- Crack/Warez/Piracy talk is NOT allowed.
Breaking any of the above rules will result in your messages being deleted and you will be banned upon repetition.
Please, stop by this thread SoccerGaming Forum Rules And Guidelines and make sure you read and understand our policies.
Thank you!
Kitserver 6
- Thread starter juce_66
- Start date
OK, so now I have something to colaborate: how to get fast a player list, in Excel. I could simply publicate my list, but unfortunately for you I have an option file most of you don't have, so it will be different.
You need PESFAN Editor 6. Open your option file with it. In the menu bar, select Tools -> Make csv stats file...
Select all three options in the right part (Column Headings, Extra Players, Created Players). Then save the csv file in any folder.
Now open a new file in Excel. Select A1, and go to Tools -> Macros -> Visual Basic Editor (I don't know exactly what names the menus have, because i have the spanish Office). Now see the top-left part of the Editor, below the icons, ubicate where it says Page1, Page2..., double click in Page1, it will open the code editor. Copy and paste there this code:
Public Sub ImportTextFile(FName As String, Sep As String)
Dim RowNdx As Integer
Dim ColNdx As Integer
Dim TempVal As Variant
Dim WholeLine As String
Dim Pos As Integer
Dim NextPos As Integer
Dim SaveColNdx As Integer
Application.ScreenUpdating = False
'On Error GoTo EndMacro:
SaveColNdx = ActiveCell.Column
RowNdx = ActiveCell.Row
Open FName For Input Access Read As #1
While Not EOF(1)
Line Input #1, WholeLine
If Right(WholeLine, 1) <> Sep Then
WholeLine = WholeLine & Sep
End If
ColNdx = SaveColNdx
Pos = 1
NextPos = InStr(Pos, WholeLine, Sep)
While NextPos >= 1
TempVal = Mid(WholeLine, Pos, NextPos - Pos)
Cells(RowNdx, ColNdx).Value = TempVal
Pos = NextPos + 1
ColNdx = ColNdx + 1
NextPos = InStr(Pos, WholeLine, Sep)
Wend
RowNdx = RowNdx + 1
Wend
EndMacro:
On Error GoTo 0
Application.ScreenUpdating = True
Close #1
End Sub
Public Sub DoTheImport()
Dim FName As Variant
Dim Sep As String
FName = Application.GetOpenFilename _
(filefilter:="Text Files(*.txt),*.txt,All Files (*.*),*.*")
If FName = False Then
MsgBox "You didn't select a file"
Exit Sub
End If
Sep = InputBox("Enter a single delimiter character.", _
"Import Text File")
ImportTextFile CStr(FName), Sep
End Sub
Now click the "play" button in the standard toolbar. It will show the Open dialog. First where it says to open "text files", select "all files", then search for the first created csv file you saved before. Then it should open a message asking about the "separator". There write "," (without the "") and Accept. Wait some time, and then you should have a table with all option file data, divided by columns. I copied it to another excel file, to have it without macros. Then I inserted a column as the first column, with title "IDs". In this column, simply write 1 in A2, 2 in A3, and fill in all the column A incrementing the numbers, until you get to 5183.
The important thing is that PESFAN Editor makes the csv file ordering it with the player ID, so you can fill those numbers correctly.
I copied to another excel file only these columns: IDs, Name, Club Team.
Now you can for example order all the file by Name, or by Club Team, or even use filters. I applied a Filter in the first row (Data -> Filter -> "autofilter" or "self-filter", don't know the english name). So I can select any team "FC Barcelona" for example, as the Club Team, and it will show all Barça players with their IDs.
This process was long to write, but should take you less than 10 minutes. So you can do it everytime you change a lot of data in the option file, to update it.
Hope this helps.
You need PESFAN Editor 6. Open your option file with it. In the menu bar, select Tools -> Make csv stats file...
Select all three options in the right part (Column Headings, Extra Players, Created Players). Then save the csv file in any folder.
Now open a new file in Excel. Select A1, and go to Tools -> Macros -> Visual Basic Editor (I don't know exactly what names the menus have, because i have the spanish Office). Now see the top-left part of the Editor, below the icons, ubicate where it says Page1, Page2..., double click in Page1, it will open the code editor. Copy and paste there this code:
Public Sub ImportTextFile(FName As String, Sep As String)
Dim RowNdx As Integer
Dim ColNdx As Integer
Dim TempVal As Variant
Dim WholeLine As String
Dim Pos As Integer
Dim NextPos As Integer
Dim SaveColNdx As Integer
Application.ScreenUpdating = False
'On Error GoTo EndMacro:
SaveColNdx = ActiveCell.Column
RowNdx = ActiveCell.Row
Open FName For Input Access Read As #1
While Not EOF(1)
Line Input #1, WholeLine
If Right(WholeLine, 1) <> Sep Then
WholeLine = WholeLine & Sep
End If
ColNdx = SaveColNdx
Pos = 1
NextPos = InStr(Pos, WholeLine, Sep)
While NextPos >= 1
TempVal = Mid(WholeLine, Pos, NextPos - Pos)
Cells(RowNdx, ColNdx).Value = TempVal
Pos = NextPos + 1
ColNdx = ColNdx + 1
NextPos = InStr(Pos, WholeLine, Sep)
Wend
RowNdx = RowNdx + 1
Wend
EndMacro:
On Error GoTo 0
Application.ScreenUpdating = True
Close #1
End Sub
Public Sub DoTheImport()
Dim FName As Variant
Dim Sep As String
FName = Application.GetOpenFilename _
(filefilter:="Text Files(*.txt),*.txt,All Files (*.*),*.*")
If FName = False Then
MsgBox "You didn't select a file"
Exit Sub
End If
Sep = InputBox("Enter a single delimiter character.", _
"Import Text File")
ImportTextFile CStr(FName), Sep
End Sub
Now click the "play" button in the standard toolbar. It will show the Open dialog. First where it says to open "text files", select "all files", then search for the first created csv file you saved before. Then it should open a message asking about the "separator". There write "," (without the "") and Accept. Wait some time, and then you should have a table with all option file data, divided by columns. I copied it to another excel file, to have it without macros. Then I inserted a column as the first column, with title "IDs". In this column, simply write 1 in A2, 2 in A3, and fill in all the column A incrementing the numbers, until you get to 5183.
The important thing is that PESFAN Editor makes the csv file ordering it with the player ID, so you can fill those numbers correctly.
I copied to another excel file only these columns: IDs, Name, Club Team.
Now you can for example order all the file by Name, or by Club Team, or even use filters. I applied a Filter in the first row (Data -> Filter -> "autofilter" or "self-filter", don't know the english name). So I can select any team "FC Barcelona" for example, as the Club Team, and it will show all Barça players with their IDs.
This process was long to write, but should take you less than 10 minutes. So you can do it everytime you change a lot of data in the option file, to update it.
Hope this helps.
Thanks juce!juce_66 said:
The part with Visual Basic code is so you can divide all data in columns. This helps to delete the ones that are not needed and order them in Club Team, Name, or even use filters. Using the filter in the Club Team column to select a team, so it show only all players in that team, really helps to make the folder for faces and hairs for that team.
Juce, I'm not trying to rush you but maybe a good idea for the next update.
A start and menu screen server which randomly sets the start and/or menu screen
Lots of starting screens out there but its hard to find one you want to look at every time you start the game, would be nice to have it in random order though. Same for the main menu screen. Is this possible?
Now Im off to enjoy some HD kits You rock.
A start and menu screen server which randomly sets the start and/or menu screen
Lots of starting screens out there but its hard to find one you want to look at every time you start the game, would be nice to have it in random order though. Same for the main menu screen. Is this possible?Now Im off to enjoy some HD kits You rock.
I followed dr13's guide, and came up with this playerlist:
http://www.speedyshare.com/189374422.html
With this list I just inserted Manchester United and Manchester ****ty faces:
# Manchester City
01655,"EPL\ManchesterCity\AndyCole.bin"
01641,"EPL\ManchesterCity\Barton.bin"
00150,"EPL\ManchesterCity\James.bin"
01637,"EPL\ManchesterCity\Mills.bin"
01640,"EPL\ManchesterCity\Reyna.bin"
03971,"EPL\ManchesterCity\Riera.bin"
01644,"EPL\ManchesterCity\Samaras.bin"
01642,"EPL\ManchesterCity\Sinclair.bin"
01654,"EPL\ManchesterCity\Vassell.bin"
01653,"EPL\ManchesterCity\Dickov.bin"
00901,"EPL\ManchesterCity\Trabelsi.bin"
Took me less than 5 minutes to re-configure from my pes5 face folder
http://www.speedyshare.com/189374422.html
With this list I just inserted Manchester United and Manchester ****ty faces:
# Manchester City
01655,"EPL\ManchesterCity\AndyCole.bin"
01641,"EPL\ManchesterCity\Barton.bin"
00150,"EPL\ManchesterCity\James.bin"
01637,"EPL\ManchesterCity\Mills.bin"
01640,"EPL\ManchesterCity\Reyna.bin"
03971,"EPL\ManchesterCity\Riera.bin"
01644,"EPL\ManchesterCity\Samaras.bin"
01642,"EPL\ManchesterCity\Sinclair.bin"
01654,"EPL\ManchesterCity\Vassell.bin"
01653,"EPL\ManchesterCity\Dickov.bin"
00901,"EPL\ManchesterCity\Trabelsi.bin"
Took me less than 5 minutes to re-configure from my pes5 face folder
pogoss said:THANKS A LOT JUCE ! YOU ROCK !!
now I can play pes6 .
it's even better than the kitserver for pes5 , I can do what I want in edit mode without any problem
I have Julio faceserver from the time of PES5 !
I am using this Julio [33.7Mb, 1058 faces & 575 hairs]
If u like I can upload it to filefront !
But u must change map.txt sometimes !
Beckham is nr 146 in PES5 and PES6 , but Ronaldo etc isnt
