I'm just wondering if it's possible to _divide_ values from a xml / csv import field and put different parts (strings) to different fields in Joomla!.
My goal is to import contact categories and contacts to these categories.
Here's the xml file (contact item):
<LSRMitarb>
<LSR_ID>69339902</LSR_ID>
<LSR_AMTSTITEL>Title</LSR_AMTSTITEL>
<LSR_TITEL>Title2</LSR_TITEL>
<LSR_NAME>Lastname</LSR_NAME>
<LSR_NGTITEL>Title 3</LSR_NGTITEL>
<LSR_DEF_ORG>organisation</LSR_DEF_ORG>
<LSR_VORNAME>firstname</LSR_VORNAME>
<LSR_EMAIL>firstname@organisation.tdl</LSR_EMAIL>
<LSR_TEL1>7011</LSR_TEL1>
<LSR_TEL2>7011</LSR_TEL2>
<LSR_FAX>faxnr</LSR_FAX>
<LSR_ABT>division (details of the division)</LSR_ABT>
<LSR_ZIMMER>room</LSR_ZIMMER>
</LSRMitarb>
I need the LSR_ABT field to be the category of the contact. But it would be really helpful if only the first part (until "(" would be imported as category name. The second part, inside the brackets, should go to the description of the category or into a custom field attached to the category.
Is this possible? Is there any documentation?
Thanks a lot!
Chris