create automation for directories for generating and updating data in a custom directory
we need to improve automation for directories, with the help of which it will be possible to "transfer" addresses from the Nova Poshta directory to a custom address directory
here is a directory with a set of fields that you need to get as a result https://crm.swisstrade.com.ua/admin/shop/custom/object/directory/25/ (it was filled with data import from xls)
here is the query that received data from the boxing tables for loading into the directory
select novaposhtastreet.address street, novaposhtastreet.type, novaposhtastreet.ref streerRef, novaposhtastreet.cityName, qcity.ref cityRef, qcity.areaName from novaposhtastreet
left join
(select * from novaposhtacity) qcity on qcity.ref=novaposhtastreet.cityRef
you just need to make the process of updating the custom directory a background one, similar to how the automation of the directory for downloading Nova Poshta branches works
Original question is available on version: ru
here is a directory with a set of fields that you need to get as a result https://crm.swisstrade.com.ua/admin/shop/custom/object/directory/25/ (it was filled with data import from xls)
here is the query that received data from the boxing tables for loading into the directory
select novaposhtastreet.address street, novaposhtastreet.type, novaposhtastreet.ref streerRef, novaposhtastreet.cityName, qcity.ref cityRef, qcity.areaName from novaposhtastreet
left join
(select * from novaposhtacity) qcity on qcity.ref=novaposhtastreet.cityRef
you just need to make the process of updating the custom directory a background one, similar to how the automation of the directory for downloading Nova Poshta branches works
Answers:
Pereginyak Alexander wrote:
you just need to make the process of updating the custom directory a background one, similar to how the automation of the directory for downloading Nova Poshta branches works
Well, except that you can do an automatic action once a day, which will only be aimed at transferring data from the NP tables for integration into your directory, where we will give the directory selection setting + multi-setting for the fields "which field of the NP directory (sew the list into the selector) into which write directory field.
The duration of this action is 5 hours.
28.12.2020, 10:53
Original comment available on version: ru
Tyndyk Maxim Vadimovich
Administrator wrote:
Well, except that you can do an automatic action once a day, which will only be aimed at transferring data from the NP tables for integration into your directory, where we will give the directory selection setting + multi-setting for the fields "which field of the NP directory (sew the list into the selector) into which write directory field.
why not create the same automation as this one ?
28.12.2020, 11:05
Original comment available on version: ru
Pereginyak Alexander wrote:
why can't you create the same automation as this one?
It is possible and similar automation - the assessment is the same.
28.12.2020, 12:28
Original comment available on version: ru
Tyndyk Maxim Vadimovich
Administrator wrote:
by fields "which field
IM addresses are stored in two tables novaposhtastreet, novaposhtacity . Will I be able to use the data of these two tables as a result, or will the action not take data from these tables, but will work exclusively with the data that the new mail api sends and there will be a choice of fields from what it gives?
and the final question - can I get all the data that is now
in this directory https://crm.swisstrade.com.ua/admin/shop/custom/object/directory/25/ ? If yes, please send me an invoice. Will do
14.01.2021, 10:05
Original comment available on version: ru
If the action - there will be a choice "Which field from the directory?" (there will be a list of all fields from 2 directories of NP - cities and streets) and in which column of the existing directory to write.
Automation will load columns from 2 directories with API into 1 directory with columns like https://crm.swisstrade.com.ua/admin/shop/custom/object/directory/25/
If you need to do something - indicate which specific option - we will issue an invoice
Automation will load columns from 2 directories with API into 1 directory with columns like https://crm.swisstrade.com.ua/admin/shop/custom/object/directory/25/
If you need to do something - indicate which specific option - we will issue an invoice
15.01.2021, 16:18
Original comment available on version: ru
Tyndyk Maxim Vadimovich
Administrator wrote:
Automation will load columns from 2 directories with API into 1 directory with columns like https://crm.swisstrade.com.ua/admin/shop/custom/object/directory/25/
here we do this option. Invoice please
15.01.2021, 17:19
Original comment available on version: ru
I ask you to implement the revision in the form of the development of automation for directories
according to this developer comment
Tyndyk Maxim Vadimovich
Administrator wrote:
It is possible with similar automation - the same assessment
according to this developer comment
Tyndyk Maxim Vadimovich
Administrator wrote:
It is possible with similar automation - the same assessment
20.01.2021, 16:12
Original comment available on version: ru
automation is called "New mail (addresses)"
when adding a directory - a directory is built + a mark is put on the need to update the streets of the NP
further in the night crown, when branches and addresses are updated - the directory will be filled in (similar to other NP automations)
when adding a directory - a directory is built + a mark is put on the need to update the streets of the NP
further in the night crown, when branches and addresses are updated - the directory will be filled in (similar to other NP automations)
26.01.2021, 17:58
Original comment available on version: ru
Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter.
Log in and comment
Copyright © OneBox 2024
