question b****

[jyperier]

Bonjour à tous, encore un trcu que j'ai oublié (vive la maladie d'alzheimer) mais comment on crée un fichier col.

Je suis tjrs en .txt et lotus ne veut pas l'ouvrir . Comment on le transforme en fichier format

merci

[jyperier]

j'ai trouvé, faut forcer l'enregistrement sous notes pad en mettant le nom de fichier entre double quote

[silka]

Voila mon fichier import.col pour les carnets adresse.

J'ai renomer mon col en txt pour voir :

Code : Tout sélectionner

HEADERLINE 1

FirstName: TYPE TEXT UNTIL ";";
LastName: TYPE TEXT UNTIL ";";
MiddleInitial: TYPE TEXT UNTIL ";";
AltFullName: TYPE TEXT UNTIL ";";
Imp_Nickname: TYPE TEXT UNTIL ";";
InternetAddress: TYPE TEXT UNTIL ";";
HomeAddress: TYPE TEXT UNTIL ";";
Imp_HomeCity: TYPE TEXT UNTIL ";";
Zip: TYPE TEXT UNTIL ";";
Imp_HomeState: TYPE TEXT UNTIL ";";
Country: TYPE TEXT UNTIL ";";
PhoneNumber: TYPE TEXT UNTIL ";";
HomeFAXPhoneNumber: TYPE TEXT UNTIL ";";
CellPhoneNumber: TYPE TEXT UNTIL ";";
Imp_WebSite: TYPE TEXT UNTIL ";";
BusinessAddress: TYPE TEXT UNTIL ";";
Imp_BusinessCity: TYPE TEXT UNTIL ";";
OfficeZip: TYPE TEXT UNTIL ";";
Imp_BusinessState: TYPE TEXT UNTIL ";";
OfficeCountry: TYPE TEXT UNTIL ";";
WebSite: TYPE TEXT UNTIL ";";
OfficePhoneNumber: TYPE TEXT UNTIL ";";
OfficeFAXPhoneNumber: TYPE TEXT UNTIL ";";
PhoneNumber_6: TYPE TEXT UNTIL ";";
CompanyName: TYPE TEXT UNTIL ";";
JobTitle: TYPE TEXT UNTIL ";";
Department: TYPE TEXT UNTIL ";";
Location: TYPE TEXT UNTIL ";";
Comment: TYPE TEXT UNTIL "";

FORMULASTART
FIELD $AddressFormat:="1";
FIELD $BusinessAddressFormat:="1";
FIELD $ConflictAction:="1";
FIELD $ExternalFields:="1";
FIELD $NameFormat:="1";
FIELD $PersonalAddressFormat:="1";
FIELD $PreviewFormat:="1";
FIELD FullName:=AltFullName;
FIELD MailSystem:="5";
FIELD MailAddress:=InternetAddress;
FIELD Type:="Person";
FIELD Categories:=@If(@Contains(MailAddress;"@CompanyName.com");"CompanyName";"Personal");
FORMULAEND


@edit: ah c'etait juste pour le transformer le format fichier txt en col.
==> [ ]