Hello Ertuğrul,
of course it is possible.
First, you need to read the data from the Excel file. Can I give you an example of how this can be implemented?
Then this data must be written to the catalog "Counterparties". This catalog has a tabular section "ContactInformation" (see screenshot), which stores all contact information on the counterparty - addresses, phone numbers, etc.
Below is a piece from the working code, which just adds the "LegalAddress" value for the counterparty:
| Code |
|---|
moduleAddressManagerClientServer = Common.CommonModule("AddressManagerClientServer");
structureAddress = moduleAddressManagerClientServer.NewContactInformationDetails(Enums.ContactInformationTypes.Address);
structureAddress.PostalCode = zip_code;
structureAddress.Country = country;
structureAddress.CountryCode = country_iso_code;
structureAddress.City = city;
structureAddress.AddressLine1 = street_1;
structureAddress.AddressLine2 = street_2;
stringShippingAddress = street_1 + ", " + street_2 + ", " + zip_code
+ ", " + city + ", " + country;
structureAddress.value = stringShippingAddress;
Value = ContactsManagerInternal.ToJSONStringStructure(structureAddress);
ContactsManager.AddContactInformation(NewCustomer, Value, Catalogs.ContactInformationKinds.CounterpartyLegalAddress, , False);
|
Best,
Aleksandr
