We are trying to Localize all of the content on our website as a whole by exporting all the website content in the HTMLTEXT table and pair it with the corresponding language and location on the site per text object, modifying/translating what we need, then importing it back into the database. We're having to write a query that filters out the older versions of the text objects, and that links to two other tables (TabModules and Tabs) to get the language and the location.
We think we got the information all together in the same table, but we're seeing multiple duplicates of text objects that are technically the same modules but that all have different tab names and different langauges. In the end, we don't quite understand the correct relationships between the tables, or what all the different terms mean (e.g. ModuleID, TabID, ItemID).
These are my questions:
First of all, is this even a feasible process, or are we better off sticking to manual modifications within the admin console?
What relationship does ItemID, or TabID have with the website?
Is Module ID the ID for the modules in the website, or does module in the database refer to something different? (if it is referring to the same thing, how do we filter out the modules that are primarily for the htmltext?)
Is there a better relationship we should use to query these tables?
Is there a schematics available for the SQL DB with DNN?
We don't expect answers for all of these. They are just questions we have. If there are answers, please pass them on to us!