Forum

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