Emmersonforest4

Can you import multiple xml files into an editor data?

Hi all, Does anyone know what the xml code correlates to in the editor? I am learning python coding and may look to do a project where I can create xml code in bulk to import into my editor data for my own personal use obviously. I am just trying to get my head round when creating clubs what the code correlates to. I am almost there but the kit code does baffle me a bit. I have edited the home and away jerseys plus the icon. Does anyone know what piece of code below correlates to what pattern of shirt, shorts and socks? Also which ones are the Shirts, Shorts, Socks, Icon and text sections? <record> <integer id="database_table_type" value="3"/> <large id="db_unique_id" value="4203415951212460424"/> <unsigned id="property" value="1416326961"/> <record id="new_value"> <unsigned id="id" value="1802073203"/> <integer id="value" value="3"/> <integer id="lsop" value="1"/> <record id="olvl"> <integer id="kits" value="1"/> <integer id="bost" value="0"/> <integer id="kit_part" value="1"/> <colour id="ksfg" red="255" green="255" blue="255" alpha="255"/> <colour id="ksbg" red="0" green="0" blue="255" alpha="255"/> <colour id="ksou" red="0" green="0" blue="0" alpha="255"/> <colour id="number_colour" red="255" green="255" blue="255" alpha="255"/> <colour id="nmoc" red="0" green="0" blue="0" alpha="255"/> <integer id="ktal" value="0"/> <null id="competition"/> <null id="year"/> </record> </record> <integer id="version" value="3569"/> <integer id="db_random_id" value="432096475"/> <boolean id="is_client_field" value="true"/> </record> <record> <integer id="database_table_type" value="3"/> <large id="db_unique_id" value="4203415951212460424"/> <unsigned id="property" value="1416326961"/> <record id="new_value"> <unsigned id="id" value="1802724967"/> <colour id="value" red="255" green="190" blue="100" alpha="120"/> <integer id="lsop" value="1"/> <record id="olvl"> <integer id="kits" value="3"/> <integer id="bost" value="0"/> <integer id="kit_part" value="1"/> <colour id="ksfg" red="255" green="255" blue="255" alpha="255"/> <colour id="ksbg" red="0" green="0" blue="255" alpha="255"/> <colour id="ksou" red="0" green="0" blue="0" alpha="255"/> <colour id="number_colour" red="255" green="255" blue="255" alpha="255"/> <colour id="nmoc" red="0" green="0" blue="0" alpha="255"/> <integer id="ktal" value="0"/> <null id="competition"/> <null id="year"/> </record> </record> <integer id="version" value="3569"/> <integer id="db_random_id" value="970016580"/> <boolean id="is_client_field" value="true"/> </record> <record> <integer id="database_table_type" value="3"/> <large id="db_unique_id" value="4203415951212460424"/> <unsigned id="property" value="1416326961"/> <record id="new_value"> <unsigned id="id" value="1802723943"/> <colour id="value" red="77" green="182" blue="172" alpha="255"/> <integer id="lsop" value="1"/> <record id="olvl"> <integer id="kits" value="3"/> <integer id="bost" value="0"/> <integer id="kit_part" value="1"/> <colour id="ksfg" red="255" green="87" blue="34" alpha="255"/> <colour id="ksbg" red="0" green="0" blue="255" alpha="255"/> <colour id="ksou" red="0" green="0" blue="0" alpha="255"/> <colour id="number_colour" red="255" green="255" blue="255" alpha="255"/> <colour id="nmoc" red="0" green="0" blue="0" alpha="255"/> <integer id="ktal" value="0"/> <null id="competition"/> <null id="year"/> </record> </record> <integer id="version" value="3569"/> <integer id="db_random_id" value="681773691"/> <boolean id="is_client_field" value="true"/> </record> <record> <integer id="database_table_type" value="3"/> <large id="db_unique_id" value="4203415951212460424"/> <unsigned id="property" value="1416326961"/> <record id="new_value"> <unsigned id="id" value="1802727285"/> <colour id="value" red="77" green="182" blue="172" alpha="255"/> <integer id="lsop" value="1"/> <record id="olvl"> <integer id="kits" value="1"/> <integer id="bost" value="0"/> <integer id="kit_part" value="2"/> <colour id="ksfg" red="255" green="255" blue="255" alpha="255"/> <colour id="ksbg" red="0" green="0" blue="255" alpha="255"/> <colour id="ksou" red="0" green="0" blue="0" alpha="255"/> <colour id="number_colour" red="255" green="255" blue="255" alpha="255"/> <colour id="nmoc" red="0" green="0" blue="0" alpha="255"/> <integer id="ktal" value="0"/> <null id="competition"/> <null id="year"/> </record> </record> <integer id="version" value="3569"/> <integer id="db_random_id" value="961233315"/> <boolean id="is_client_field" value="true"/> </record> <record> <integer id="database_table_type" value="3"/> <large id="db_unique_id" value="4203415951212460424"/> <unsigned id="property" value="1416326961"/> <record id="new_value"> <unsigned id="id" value="1802723943"/> <colour id="value" red="255" green="87" blue="34" alpha="255"/> <integer id="lsop" value="1"/> <record id="olvl"> <integer id="kits" value="1"/> <integer id="bost" value="0"/> <integer id="kit_part" value="2"/> <colour id="ksfg" red="255" green="255" blue="255" alpha="255"/> <colour id="ksbg" red="0" green="0" blue="255" alpha="255"/> <colour id="ksou" red="77" green="182" blue="172" alpha="255"/> <colour id="number_colour" red="255" green="255" blue="255" alpha="255"/> <colour id="nmoc" red="0" green="0" blue="0" alpha="255"/> <integer id="ktal" value="0"/> <null id="competition"/> <null id="year"/> </record> </record> <integer id="version" value="3569"/> <integer id="db_random_id" value="113592680"/> <boolean id="is_client_field" value="true"/> </record> <record> <integer id="database_table_type" value="3"/> <large id="db_unique_id" value="4203415951212460424"/> <unsigned id="property" value="1416326961"/> <record id="new_value"> <unsigned id="id" value="1802723943"/> <colour id="value" red="255" green="87" blue="34" alpha="255"/> <integer id="lsop" value="1"/> <record id="olvl"> <integer id="kits" value="1"/> <integer id="bost" value="0"/> <integer id="kit_part" value="3"/> <colour id="ksfg" red="255" green="255" blue="255" alpha="255"/> <colour id="ksbg" red="0" green="0" blue="255" alpha="255"/> <colour id="ksou" red="0" green="0" blue="0" alpha="255"/> <colour id="number_colour" red="255" green="255" blue="255" alpha="255"/> <colour id="nmoc" red="0" green="0" blue="0" alpha="255"/> <integer id="ktal" value="0"/> <null id="competition"/> <null id="year"/> </record> </record> <integer id="version" value="3569"/> <integer id="db_random_id" value="936284406"/> <boolean id="is_client_field" value="true"/> </record> <record> <integer id="database_table_type" value="3"/> <large id="db_unique_id" value="4203415951212460424"/> <unsigned id="property" value="1416326961"/> <record id="new_value"> <unsigned id="id" value="1802723943"/> <colour id="value" red="255" green="87" blue="34" alpha="255"/> <integer id="lsop" value="1"/> <record id="olvl"> <integer id="kits" value="1"/> <integer id="bost" value="0"/> <integer id="kit_part" value="4"/> <colour id="ksfg" red="255" green="255" blue="255" alpha="255"/> <colour id="ksbg" red="0" green="0" blue="255" alpha="255"/> <colour id="ksou" red="0" green="0" blue="0" alpha="255"/> <colour id="number_colour" red="255" green="255" blue="255" alpha="255"/> <colour id="nmoc" red="0" green="0" blue="0" alpha="255"/> <integer id="ktal" value="0"/> <null id="competition"/> <null id="year"/> </record> </record> <integer id="version" value="3569"/> <integer id="db_random_id" value="614272503"/> <boolean id="is_client_field" value="true"/> </record> <record> <integer id="database_table_type" value="3"/> <large id="db_unique_id" value="4203415951212460424"/> <unsigned id="property" value="1416326961"/> <record id="new_value"> <unsigned id="id" value="1802723943"/> <colour id="value" red="255" green="87" blue="34" alpha="255"/> <integer id="lsop" value="1"/> <record id="olvl"> <integer id="kits" value="1"/> <integer id="bost" value="0"/> <integer id="kit_part" value="5"/> <colour id="ksfg" red="255" green="255" blue="255" alpha="255"/> <colour id="ksbg" red="0" green="0" blue="255" alpha="255"/> <colour id="ksou" red="0" green="0" blue="0" alpha="255"/> <colour id="number_colour" red="255" green="255" blue="255" alpha="255"/> <colour id="nmoc" red="0" green="0" blue="0" alpha="255"/> <integer id="ktal" value="0"/> <null id="competition"/> <null id="year"/> </record> </record> <integer id="version" value="3569"/> <integer id="db_random_id" value="977574830"/> <boolean id="is_client_field" value="true"/> </record> <record> <integer id="database_table_type" value="3"/> <large id="db_unique_id" value="4203415951212460424"/> <unsigned id="property" value="1416326962"/> <record id="new_value"> <unsigned id="id" value="1802073203"/> <integer id="value" value="47"/> <integer id="lsop" value="1"/> <record id="olvl"> <integer id="kits" value="1"/> <integer id="bost" value="0"/> <integer id="kit_part" value="1"/> <colour id="ksfg" red="255" green="255" blue="255" alpha="255"/> <colour id="ksbg" red="255" green="0" blue="0" alpha="255"/> <colour id="ksou" red="0" green="0" blue="0" alpha="255"/> <colour id="number_colour" red="255" green="255" blue="255" alpha="255"/> <colour id="nmoc" red="0" green="0" blue="0" alpha="255"/> <integer id="ktal" value="0"/> <null id="competition"/> <null id="year"/> </record> </record> <integer id="version" value="3569"/> <integer id="db_random_id" value="664820025"/> <boolean id="is_client_field" value="true"/> </record> <record> <integer id="database_table_type" value="3"/> <large id="db_unique_id" value="4203415951212460424"/> <unsigned id="property" value="1416326962"/> <record id="new_value"> <unsigned id="id" value="1802723943"/> <colour id="value" red="123" green="31" blue="162" alpha="255"/> <integer id="lsop" value="1"/> <record id="olvl"> <integer id="kits" value="47"/> <integer id="bost" value="0"/> <integer id="kit_part" value="1"/> <colour id="ksfg" red="255" green="255" blue="255" alpha="255"/> <colour id="ksbg" red="255" green="0" blue="0" alpha="255"/> <colour id="ksou" red="0" green="0" blue="0" alpha="255"/> <colour id="number_colour" red="255" green="255" blue="255" alpha="255"/> <colour id="nmoc" red="0" green="0" blue="0" alpha="255"/> <integer id="ktal" value="0"/> <null id="competition"/> <null id="year"/> </record> </record> <integer id="version" value="3569"/> <integer id="db_random_id" value="77411179"/> <boolean id="is_client_field" value="true"/> </record> <record> <integer id="database_table_type" value="3"/> <large id="db_unique_id" value="4203415951212460424"/> <unsigned id="property" value="1416326962"/> <record id="new_value"> <unsigned id="id" value="1802723943"/> <colour id="value" red="123" green="31" blue="162" alpha="255"/> <integer id="lsop" value="1"/> <record id="olvl"> <integer id="kits" value="1"/> <integer id="bost" value="0"/> <integer id="kit_part" value="2"/> <colour id="ksfg" red="255" green="255" blue="255" alpha="255"/> <colour id="ksbg" red="255" green="0" blue="0" alpha="255"/> <colour id="ksou" red="0" green="0" blue="0" alpha="255"/> <colour id="number_colour" red="255" green="255" blue="255" alpha="255"/> <colour id="nmoc" red="0" green="0" blue="0" alpha="255"/> <integer id="ktal" value="0"/> <null id="competition"/> <null id="year"/> </record> </record> <integer id="version" value="3569"/> <integer id="db_random_id" value="666341765"/> <boolean id="is_client_field" value="true"/> </record> <record> <integer id="database_table_type" value="3"/> <large id="db_unique_id" value="4203415951212460424"/> <unsigned id="property" value="1416326962"/> <record id="new_value"> <unsigned id="id" value="1802723943"/> <colour id="value" red="123" green="31" blue="162" alpha="255"/> <integer id="lsop" value="1"/> <record id="olvl"> <integer id="kits" value="1"/> <integer id="bost" value="0"/> <integer id="kit_part" value="3"/> <colour id="ksfg" red="255" green="255" blue="255" alpha="255"/> <colour id="ksbg" red="255" green="0" blue="0" alpha="255"/> <colour id="ksou" red="0" green="0" blue="0" alpha="255"/> <colour id="number_colour" red="255" green="255" blue="255" alpha="255"/> <colour id="nmoc" red="0" green="0" blue="0" alpha="255"/> <integer id="ktal" value="0"/> <null id="competition"/> <null id="year"/> </record> </record> <integer id="version" value="3569"/> <integer id="db_random_id" value="378742121"/> <boolean id="is_client_field" value="true"/> </record> <record> <integer id="database_table_type" value="3"/> <large id="db_unique_id" value="4203415951212460424"/> <unsigned id="property" value="1416326962"/> <record id="new_value"> <unsigned id="id" value="1802723943"/> <colour id="value" red="123" green="31" blue="162" alpha="255"/> <integer id="lsop" value="1"/> <record id="olvl"> <integer id="kits" value="1"/> <integer id="bost" value="0"/> <integer id="kit_part" value="4"/> <colour id="ksfg" red="255" green="255" blue="255" alpha="255"/> <colour id="ksbg" red="255" green="0" blue="0" alpha="255"/> <colour id="ksou" red="0" green="0" blue="0" alpha="255"/> <colour id="number_colour" red="255" green="255" blue="255" alpha="255"/> <colour id="nmoc" red="0" green="0" blue="0" alpha="255"/> <integer id="ktal" value="0"/> <null id="competition"/> <null id="year"/> </record> </record> <integer id="version" value="3569"/> <integer id="db_random_id" value="504488415"/> <boolean id="is_client_field" value="true"/> </record> <record> <integer id="database_table_type" value="3"/> <large id="db_unique_id" value="4203415951212460424"/> <unsigned id="property" value="1416326962"/> <record id="new_value"> <unsigned id="id" value="1802723943"/> <colour id="value" red="123" green="31" blue="162" alpha="255"/> <integer id="lsop" value="1"/> <record id="olvl"> <integer id="kits" value="1"/> <integer id="bost" value="0"/> <integer id="kit_part" value="5"/> <colour id="ksfg" red="255" green="255" blue="255" alpha="255"/> <colour id="ksbg" red="255" green="0" blue="0" alpha="255"/> <colour id="ksou" red="0" green="0" blue="0" alpha="255"/> <colour id="number_colour" red="255" green="255" blue="255" alpha="255"/> <colour id="nmoc" red="0" green="0" blue="0" alpha="255"/> <integer id="ktal" value="0"/> <null id="competition"/> <null id="year"/> </record> </record> <integer id="version" value="3569"/> <integer id="db_random_id" value="163412162"/> <boolean id="is_client_field" value="true"/> </record>

Does anyone know if you can merge the upload with fmf files?

12 Tiers TE Version 30-04-23.fmf So I want to add the attached Cities to a database I downloaded off the workshop. Is that possible? Problem is the databse I have downloaded has already used the first UID for the Cities so I cant import it and merge the data. City Upload 01-05-2023.xlsx

Thank you so much for that, so can I import data into another editor database? How would I do that? Also if my input file looks like this picture below will it not work?

Thank you! I started at that UID for the cities cause I want to add these to a database I have downloaded and that database starts at those numbers I had put on originally. Will that not work than? Also was it commas that was causing the issue with the longtitude and lattitide? Thank you for pointing me in the right direction.

@krlenjushka Also I am trying to add this to a editor file I have already downloaded from the steam workshop. Can the FM editor Generator do that to? Or will that nor work for me?

@krlenjushka Please can you advise, I have downloaded the FM 23 version of the generator. When I paste my excel table into the input.txt file the columns dont align. I have made sure they are delimited tab but that dosent work for me. The screenshot is what I get below. Ive also attached my spreadsheet I used to make the cities. This is a great tool! Thank you for sharing and getting back to people. It makes editing more accessible and fun. City Upload 01-05-2023.xlsx