---

Hello,

For faster A. updating the texts in the database, as well as B. adding ERP numbers of imported elements, we would like to make an edit directly in the SQL database.
For point A. is the SQL table dbo.Translation suitable for editing?
for point B. is the SQL table dbo.tblPart suitable for editing?
What are the conditions - e.g. max. length, etc.

or
- How is it possible to copy all EN translations at once into empty other new translations (so that fields are not left empty and can be further translated manualy)?
- How is it possible to assign ERP numbers (not one at a time) for multiple elements at once?

E.g. prepared assignments

Element number ERP number
5SY4316-7 8500056378
5SY4310-7 8500064521
5SY4302-7 8500067842
5SY4105-7 8500052345

Is it true that as of version 2022, the data in the database is encrypted (or exist any posibility to have it non ecrypted)?

Thank you.

Eine Antwort auf diesen Beitrag verfassen (mit Zitat/Zitat des Beitrags) IP

---

Hi
You can edit the dbo.Translation and dbo.tblPart via SQL query.
This worked at lest for me in the past to do some cleanup/correction of data entries. Using query you can also copy data etc. just need to right lines of code. Another option is to export/import the data in excel and do the modification there.

Yes, 2022 is encrypted.

Eine Antwort auf diesen Beitrag verfassen (mit Zitat/Zitat des Beitrags) IP