I filled necessary fields in "Exchange nodes with sites" correctly. But when I try to push "Execute full data exchange" button to dump products and exchange orders, it gives ERROR below:
Code
{(283, 3)}: Table name expected
<<?>> To TemporaryTablePrices.Characteristic = NomenclatureCharacteristicAdditionalAttributes.Ref
What's the problem? How to fix?
I use 1C enterprise (8.3.4.496) Small Business (1.4.7.38)
I changed "To" -> "ON" in the code in Common Modules -> ExchangeWithSite Module. Here is the code part I have changed.
Code
|SELECT DISTINCT
| TemporaryTablePrices.Characteristic AS Characteristic,
| NomenclatureCharacteristicsAdditionalAttributes.Property AS Property,
| NomenclatureCharacteristicsAdditionalAttributes.Value AS Value
|FROM
| TemporaryTablePrices AS TemporaryTablePrices
| INNER JOIN Catalog.NomenclatureCharacteristics.AdditionalAttributes AS NomenclatureCharacteristicsAdditionalAttributes
| To TemporaryTablePrices.Characteristic = NomenclatureCharacteristicsAdditionalAttributes.Ref
|Totals BY
| Characteristic
|;
But it gives a new, different error. Here is the new error:
By the way, while you are waiting for the new release, take a look at Publish functionality of 1C:Translator application. This application provides both examples:
1C:Enterprise-side publishing script (PublicationOverridable common module, triggered by Publish button).
Bitrix CMS publication web service (PublicationWebServiceBitrix common template, can be saved as ZIP from Project item form).
I have downloaded ver. 1.4.7.39 of Small Business and installed applied solution (in Demo installer). I have created an “Exchange nodes with sites” and tested it. When I try to push “Execute full data exchange” button, I get this ERROR below:
Code
{CommonModule.ExchangeWithSite.Module(1273)}: Error calling context method (Create)
BusinessInformationXTDO = XDTOFactory.Create(BusinessInformationType);
because:
Type mismatch (parameter number '1')
See screenshot below.
When I try to push “Execute data exchange” button, it says “Exchange with sites completed” but nothing is added in web site. No categories or no products.