!0DiBfSSKrSSKrSSK7 SSKrSSKrSSKJrJrJr Sr S\ S\ 4Sjr S\ S\ 4S jr S r 0S /S Q_S S/_SS/_S/SQ_SS/_S/SQ_SSS/_S/SQ_S/SQ_S/SQ_S /S!Q_S"S#S$/_S%S&S'/_S(S)/_S*S+/_S,S-/_S.S//_0S0S1S2/_S3S#S4/_S5S6/_S7/S8Q_S9/S:Q_S;/SQ_S?/S@Q_SASB/_SCSD/_SE/SFQ_SGS$SH/_SISJ/_SKSLSM/_SNS;/_SOSPSQ/_SQSR/_ESS/STQ0ErSU\4SVjrSW\SX\ S\ 4SYjrSW\4SZjrS[\S\\S]\SS4S^jrSX\ SW\4S_jrSX\ SW\4S`jrSlSX\ Sa\ 4SbjjrSlSX\ Sc\ Sa\ 4SdjjrSmSejr\Sf:Xa\"Sg5r\"Sh5r\R=5Hurr \ R=5Hur!r"\#"\!5 \"\!\"5r$\RK\!S5(ac\#"Si5 \\!R=5HDur&r'\$RK\&S5(d0\$\&'\'R=5Hur(r)\)\$\&\('M MF \"\"5ur*r+\"\$\*\+5 \#"5 \,"Sj\!Sk3\$5 M M gg)nN)*)ConnectTimeout ReadTimeoutConnectionError­textreturncNUR[S5RSS5$)z0Remove all soft hyphen characters from a string.z[p])replace SOFT_HYPHEN)rs 6t:\var\www\ffxiv\extras\json\XIVAPI\get_xivapi_data.pystrip_soft_hyphenrs << R ( 0 0 ;;keyc[U5n[R"SU5nU(a5URS5SURS53R SS5$UR SS5$)zm Convert keys like 'Abbreviation@lang(de)' to 'Abbreviation_de', remove '@as(html)', and strip soft hyphens. z^(.*?)@lang\((.*?)\)$_z @as(html)r )rrematchgroupr )rrs r normalize_keyrsc C C HH-s 3E ++a.!5;;q>"23;;KLL ;;{B ''rc^[U[5(a [U5$[U[5(a [U5$[U[5(aUVs/sHn[ U5PM sn$[U[ 5(dU$URS05nURS05nUR5VVs0sHupE[U5[ U5_M nnnUR5VVs0sHupE[U5[ U5_M nnn[ U5nUR5H*upEXH;aXXU'MSU-n X;a SU -n X;aM XXU 'M, UR5H$upEUS;dM [ U5U[U5'M& U$s snfs snnfs snnf)z7Recursively normalize and merge fields/transient dicts.fields transientt)rr) isinstancestrrintlistnormalize_dictdictgetitemsr) ditem raw_fields raw_transientkvnormalized_fieldsnormalized_transientmergednew_keys rr"r"s!S ##!S1v !T123t$33 a  x$JEE+r*M9C8H8H8J8J a.++8J9F8K8K8M8M a.++8M# $F$**, ?1IAgG#-#7O-  + +'5a'8F=# $ M=4sF!F#7!F) Achievement)zAchievementCategory.OrderIconPointsTypeAchievementCategoryzAchievementKind.OrderAchievementKindOrderAction)AdditionalCooldownGroup Cast100ms ClassJobLevelr: CooldownGroup EffectRanger1IsPlayerActionIsPvP IsRoleActionPrimaryCostTypePrimaryCostValueRange Recast100msSecondaryCostTypezStatusGainSelf.IconAozActionTransientNumberBNpcName)PronounPossessivePronounArticle Adjective BuddySkill BuddyLevelIsActiveClassJob)JobIndex PartyBonus Unknown11ClassJobCategory).ACNADVALCARCARMASTBLMBLUBRDBSMBTNCNJCRPCULDNCDRGDRKFSHGLAGNBGSMLNCLTWMCHMINMNKMRDNINPCTPGLPLDRDMROGRPRSAMSCHSGESMNTHMUnknown0Unknown1Unknown2VPRWARWHMWVRContentFinderCondition)AllianceRouletteClassJobLevelRequiredClassJobLevelSyncz Content.sheetz!ContentMemberType.HealersPerPartyz ContentMemberType.MeleesPerPartyz ContentMemberType.RangedPerPartyzContentMemberType.TanksPerPartyExpertRouletteFeastTeamRouletteGuildHestRouletteHighLevelRouletteItemLevelRequired ItemLevelSyncLevelCapRouletteLevelingRoulette MSQRouletteMentorRouletteNormalRaidRoulette TrialRouletteSortKeyr1mageContentMemberType)HealersPerPartyMeleesPerPartyRangedPerParty TanksPerParty CraftActionr:r1 CraftLevez ItemCount[]Repeats DynamicEvent EventType DeepDungeonzPomanderSlot[].IconDeepDungeonStatuszFloorEffectUI.IconDeepDungeon4GimmickEffect StatusIconEurekaMagiaActionzAction.StatusGainSelf.IconMaxUsesFateClassJobLevelMaxInstanceContentzBGM.FileItem)zBaseParamValueSpecial[]zBaseParamValue[]Block BlockRateCanBeHq DamageMag DamagePhys DefenseMag DefensePhysIsAdvancedMeldingPermittedIsUnique IsUntradablezItemUICategory.Icon LevelEquip LevelItemMateriaSlotCountRarityLeve) AllowanceCostr: ExpReward GilRewardLevel)Map TerritoryXYZr)OffsetXOffsetY SizeFactorIdMirageStoreSetItem) z Body.IconzBracelets.Iconz Earrings.Iconz Feet.Iconz Hands.Iconz Head.Iconz Legs.Iconz MainHand.Iconz Necklace.Iconz OffHand.Iconz Ring.IconMirageStoreSetItemLookupz Item[].IconOrchestrionPathFileQuest)r:r: EventIconTyper IconSpecialzInstanceContentUnlock.row_id IsRepeatablezIssuerLocation.Map.OffsetXzIssuerLocation.Map.OffsetYzIssuerLocation.Map.SizeFactorzIssuerLocation.RadiuszIssuerLocation.XzIssuerLocation.YzIssuerLocation.ZzIssuerStart.PronounzItemCountReward[]zIssuerLocation.Map.IdItemRewardTypezOptionalItemCountReward[]zOptionalItemIsHQReward[] QuestParamsStatusStatusCategorySubmarineExplorationRankReq TerritoryTypeBgNameTraitTreasureHuntRank MaxPartySizeTreasureHuntTexturer{ TreasureSpot)zLocation.Map.OffsetXzLocation.Map.OffsetYzLocation.Map.SizeFactorz Location.Xz Location.Yz Location.Zspecc[UR55n[U5S:agUSnUSn[U[5(a[U[5(dgX#4$)z For a dict element like {"Unknown0": "", "Icon": ""}: - first key is treated as old/original field name ("Unknown0") - second key is treated as new/final field name ("Icon") r)NNrr)r!keyslenrr)rrold_keyr/s r_decode_rename_dictrsY  D 4y1}1gG1gG gs # #:gs+C+C  rrsheetcBSnSn/SQnUGH{n[U[5(a[U5S:aUSS:Xa|USn[U[5(aB[ U5upxU=(d+ U(a"[ [ UR555OSn OUn U (dMUH n X9S U S 3- nM M[U[5(aB[ U5upxU=(d+ U(a"[ [ UR555OSn O&[U[5(aU(aUSOSn OUn U (dGM4U S ;a X)S 3- nGMDU [RU/5;a X)S 3- nGMhUH n X)S U S 3- nM GM~ US:XaUSS $USS USS -$)u Build the ?fields= and &transient= query parts from translation_filenames.json. Supported element types in `fields`: - "FieldName" (str) → normal field, language-expanded (unless in special list/IGNORELIST) - {"OldKey": "", "NewKey": ""} → non-transient rename spec: * OldKey is used in the API request. * later, OldKey* is renamed to NewKey*. - [{"OldKey": "", "NewKey": ""}, "transient"] → transient rename spec: * OldKey is requested as transient for all langs. * later, transient OldKey* is renamed to NewKey*. - ["FieldName", "transient"] → classic transient field, requested for all langs. r z &transient=)deenfrjarrrrNz@lang(z),)%zTerritoryType.Map.Idr PlaceNameIconzScreenImage.ImageIconObjective0IconObjective1PlaceNameRegionIconzMap.IdIndexIcon1z Name.IconIcon2QuestRedoUIWideQuestRedoUILargeQuestRedoUISmall StampIcon Excellent FailImageGoodGreatPoorIconMainIconOffMapIconUiIconIconMapIconDutyFinderrImager1IconReputation IconLarge IconSmall IconLarge2 IconSmall2 BottomImageTopImage,) rr!rr#rnextiterr IGNORELISTr$) rrresultresult2langsr base_specold_newfieldlangs rget_language_fieldsrs&FG $E dD ! !c$i1naK9OQI)T**/ : T T)..*:%; NewKey) applies to normal keys: - OldKey → NewKey - OldKey_de → NewKey_de - OldKey_en_foo → NewKey_en_foo transient_map (OldKey -> NewKey) applies to transient keys: - OldKey* → NewKey* (when only transient exists) - tOldKey* → NewKey* (collision-produced transient keys, dropping the leading 't' as requested) rNr)r%r!r startswithr) rrrrow_idrowrr rprefixrr/t_prefixt_prefix_with_underscores rapply_rename_mapsr!sR:: #  .(::(CzS^^F%;%;"%CHI"6CNN;S,T,T#&CMN(;"; #&8CL~H 2(rc:SUS[X53n[U5$)N'https://xivapi.akurosia.de/api/1/sheet/?fields=)r_handle_request)rrbase_urls rget_translated_sheetsr'6s'8xH[\bHjGklH 8 $$rc SUS[S[X53n[R"U5nUR 5 UR 5$)Nr#/r$)idrrequestsr$raise_for_statusjson)rrr&responses rget_id_from_translated_sheetsr/<sH8qHM`agMoLpqH||H%H  ==?rlanguagec(SUSU3n[U5$)Nr# ?language=)r%)rr0r&s r get_sheetr3Cs8z(TH 8 $$rr*cSUSUSU3n[R"U5nUR5 UR5$)Nr#r)r2)r+r$r,r-)rr*r0r&r.s rget_id_from_sheetr5Hs@8qJxjYH||H%H  ==?rc bSnSn0nXbSU3OS-nSnXq:a'[R"USS9nUR5 WR5n U RS /5n U (dU$[S U 55n U H3n U (aU SSU S3nO[U S5n[U 5X^'M5 U SSnX4:XaU$UnM![[[ 4aCn US- nXq:ae[ SU SUS US US 3 5 [R"U5 Sn A OSn A ff=fXq:aGMN)Nz&after=r rx)timeoutrzRequest failed (z ). Retrying r)z in zs...rc3J# UHoRSS5S:gv M g7f) subrow_idrN)r$).0rs r "_handle_request..gsCd%% Q/14ds!#r.r:r) r+r$r,rrrprinttimesleepr-anyrr")r& max_retries retry_delayafterafter2all_rowsurlattemptr.edatar has_subrowsrrs rr%r%Osk E FH /@GE7+bI# (#<<S9))+}}xx#  OCdCC CXq[)9(:;#h-(*3/HM R" ?  OC #KA (1 )(<y+dS^R__cde ;''  ( #s%C D%"9D  D%__main__z./translation_filenames.jsonz!./get_xivapi_data_additional.jsonzApply translations from jsonzP:/extras/json/xivapi_data/z.json)r) r)-r+r ffxiv_akurequests_cacherArequests.exceptionsrrrr rrrr"rr#rr!rrr!r'r/r3r5r%__name__ readJsonFile_input translationsr%rrLrrr@resultsr$rdata_rowd_keyd_valuerr writeJsonFilerrr]sA  LL   F?5D HE5F 0G5H 5I5JZK5NO5PxQ5R hS5Z v'([5\YK]5^dF^_5` gYa5b)>?c5dJ4!ZZ\ME6 %L+E6:Gt,,45%1%%8%>%>%@MC";;sD11') *2..*:w.5 U++;&A(9'@ $I} gy- @ G 7weDg N3*" r