I have a problem with advanced import / export of user profile data. In Germany, ZIP and phone data always include a leading zero. I did not manage to import csv files which where exported correctly in advanced mode back into the installation without loosing leading zeros.
By definition csv files do not have a format for fields. I only used OpenOffice calc and did not change the text format when opening the file nor the file format when saving it.
The csv contains the ZIP field like this “069…”, but when imported S2M shows just “69…”.
Is there anything I can do to force S2M to import these fields as text fields? Is there a trick for the expected formats or is there some php code to solve this?
This seems very basic, but is nevertheless very important for me. Thank you for your assistance!