Closed dslengel closed 1 year ago
Hello @dslengel Please describe your case in more detail. Are you talking about CRM? attach a screen where these fields interfere with you?
Hi @Carazyda Yes, it is the CRM. When I export my data, there are always many columns in the file that I don't need. Therefore I wanted to know from you if it is possible to delete these (for me) unnecessary columns. Maybe in MySQL? With the goal that they no longer appear as columns to be exported.
Do you know what I mean? I have marked the columns in the example as "unneccessary"
Unternehmen/Person | Vorname | Nachname | Name des Unternehmens | Position | Hinweis | Kontakttemperaturniveau | Kontakttyp | Liste mit Schlagwörtern der Kontakte | Telefon (zuhause) | Telefon (arbeit) | Telefon (mobil) | Telefon (fax) | Telefon (direkt) | Telefon (sonstiges) | E-Mail (privat) | E-Mail (geschäftlich) | E-Mail (sonstiges) | Website (privat) | Website (geschäftlich) | Website (sonstiges) | Skype (privat) | Skype (geschäftlich) | Skype (sonstiges) | Twitter (privat) | Twitter (geschäftlich) | Twitter (sonstiges) | LinkedIn (privat) | LinkedIn (geschäftlich) | LinkedIn (sonstiges) | Facebook (privat) | Facebook (geschäftlich) | Facebook (sonstiges) | Adresse (startseite) straße | Adresse (startseite) stadt | Adresse (startseite) bundesland | Adresse (startseite) plz | Adresse (startseite) land | Adresse (lieferung) straße | Adresse (lieferung) stadt | Adresse (lieferung) bundesland | Adresse (lieferung) plz | Adresse (lieferung) land | Adresse (office) straße | Adresse (office) stadt | Adresse (office) bundesland | Adresse (office) plz | Adresse (office) land | Adresse (fakturierung) straße | Adresse (fakturierung) stadt | Adresse (fakturierung) bundesland | Adresse (fakturierung) plz | Adresse (fakturierung) land | Adresse (sonstiges) straße | Adresse (sonstiges) stadt | Adresse (sonstiges) bundesland | Adresse (sonstiges) plz | Adresse (sonstiges) land | Adresse (stelle) straße | Adresse (stelle) stadt | Adresse (stelle) bundesland | Adresse (stelle) plz | Adresse (stelle) land | LiveJournal (privat) | LiveJournal (geschäftlich) | LiveJournal (sonstiges) | MySpace (privat) | MySpace (geschäftlich) | MySpace (sonstiges) | Gmail (privat) | Gmail (geschäftlich) | Gmail (sonstiges) | Blogger (privat) | Blogger (geschäftlich) | Blogger (sonstiges) | Yahoo (privat) | Yahoo (geschäftlich) | Yahoo (sonstiges) | MSN (privat) | MSN (geschäftlich) | MSN (sonstiges) | ICQ (privat) | ICQ (geschäftlich) | ICQ (sonstiges) | Jabber (privat) | Jabber (geschäftlich) | Jabber (sonstiges) | AIM (privat) | AIM (geschäftlich) | AIM (sonstiges) | VK (privat) | VK (geschäftlich) | VK (sonstiges) |
Person | Test | Tester | Test-Company | GF | Test | nicht erreicht | Kunde | test | xxx-xxxxxx | xxx-xxxxxx | xxxx-xxxxxx | unneccessary | unneccessary | unneccessary | test1@test.de | test2@test.de | test3@test.de | www.www.de | www.www2.de | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | Test Str. 173 | Stadt | Land | xxxxx | DE | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary | unneccessary |
Sorry, but this can only be done in source codes and recompiled with changes. There is no way to fix this through the database.
Well, then. Too bad there's no other way. It's a pity to have to deal with quite a few columns that are completely unnecessary.
But thank you anyway
Hello together,
I use the Community Server 12.1.1194. There are a lot of unused fields in it. My question is whether and how I can eliminate these many fields: For example: Skype (privat) Skype (geschäftlich) Skype (sonstiges) Twitter (privat) Twitter (geschäftlich) Twitter (sonstiges) ... and many, many more.
I look forward to hearing from you again.