How to automatically remove spaces in the product name when creating or saving a card
2023-06-22 11:41:27
Leave a message in this thread and the user's contacts will be shown to you
In the database, when products were created, spaces were made in the product names.
Now it is very difficult to find anything.
Is it possible to remove extra spaces?
Please share if there is a solution.
Original question is available on version: ua
Вячеслав Легеза
Now it is very difficult to find anything.
Is it possible to remove extra spaces?
Please share if there is a solution.
Answers:
Thank you, I think only the almighty Excel will help here, especially if there is no pattern.
I do it with Find and Replace.
I do it with Find and Replace.
22.06.2023, 13:04
Original comment available on version: ru
Легеза Вячеслав
iCOLOR OneBox
iCOLOR OneBox
ФОП Легеза В.В.
Personal license
Leave a message in this thread and the user's contacts will be shown to you
Roman Sergeevich Yurchenko wrote:
Glory, I think, only the almighty Excel will help here, especially if there is no pattern.
I do through Find and Replace.
it's difficult, Roma
I want not to bother with import/export at all
so maybe someone else has a solution?
22.06.2023, 15:59
Вячеслав Легеза
Original comment available on version: ua
You can go through the script and remove everything, it will take 1 hour. It is also an option to upload everything in xls, remove extra spaces and upload back by product id.
22.06.2023, 16:25
Original comment available on version: ru
Легеза Вячеслав
iCOLOR OneBox
iCOLOR OneBox
ФОП Легеза В.В.
Personal license
Leave a message in this thread and the user's contacts will be shown to you
.dev
OneBox production wrote:
you can use a script to go through all of them and remove them, it will take 1 hour. There is also an option to download everything in xls, remove extra gaps and upload back by product id.
and if, based on the script, we add an action that would continue to remove extra spaces when we create a product and save it
how much will this option cost?
22.06.2023, 18:24
Вячеслав Легеза
Original comment available on version: ua
in automation for products? All the same 1 hour.
22.06.2023, 21:29
Original comment available on version: ru
Легеза Вячеслав
iCOLOR OneBox
iCOLOR OneBox
ФОП Легеза В.В.
Personal license
Leave a message in this thread and the user's contacts will be shown to you
.dev
OneBox production wrote:
in automation for products? The same 1h.
Super
That is, in automations /app/automation-products/
an action will appear with the name: Remove extra spaces from the product name
It will work in such a way that it will remove any number of extra spaces between words in the title and replace them with a single space
Here is an example of a product where you need to remove such spaces https://balistyka.1b.app/app/product/457/edit/
In which section do you recommend adding this action:
Action during the creation of the product, but then we will not be able to correct existing errors, and there are already many such products
Action on save in the product card so that we can even those products that currently have errors fixed, as well as newly created ones, because they are also saved when we create them
I expect confirmation from the Client that he is ready to pay for the work
23.06.2023, 09:20
Вячеслав Легеза
Original comment available on version: ua
Легеза Вячеслав
iCOLOR OneBox
iCOLOR OneBox
ФОП Легеза В.В.
Personal license
Leave a message in this thread and the user's contacts will be shown to you
.dev
OneBox production wrote:
in automation for products? The same 1h.
The client is ready to pay, issue an invoice
23.06.2023, 09:31
Вячеслав Легеза
Original comment available on version: ua
Легеза Вячеслав
iCOLOR OneBox
iCOLOR OneBox
ФОП Легеза В.В.
Personal license
Leave a message in this thread and the user's contacts will be shown to you
.dev
OneBox production wrote:
in automation for products? The same 1h.
I can pay from the balance
what is the best way to run the mod?
23.06.2023, 14:54
Вячеслав Легеза
Original comment available on version: ua
I have already set the task on the account, will soon put it up
23.06.2023, 16:22
Original comment available on version: ru
Легеза Вячеслав
iCOLOR OneBox
iCOLOR OneBox
ФОП Легеза В.В.
Personal license
Leave a message in this thread and the user's contacts will be shown to you
OK
I expect
I expect
23.06.2023, 16:59
Вячеслав Легеза
Original comment available on version: ua
Legeza Vyacheslav
iCOLOR OneBox (FOP LEGEZA VIACHESLAV VALERIANOVYCH) wrote:
In the database, when products were created, spaces were made in the product names.
Now it is very difficult to find anything.
Is it possible to remove extra spaces?
Please share if there is a solution.
Good day
In principle, the problem was solved quite simply through the automation in products "Format the name of the product according to the template"
In the action settings, in the "Text" field, write a double space " ", and in the "Replace with value" field, write a single space " " and as a result, the double space will be replaced by a single one, you can make several blocks so that if there is a triple space and after the first pass a double space will appear, so that the system also then converts it into a single space.
Problems can arise only if there is multilingualism, but solutions can also be found there
25.06.2023, 13:00
Original comment available on version: ua
Commentary is available in ua and not yet translated to the current language.
25.06.2023, 13:00
Легеза Вячеслав
iCOLOR OneBox
iCOLOR OneBox
ФОП Легеза В.В.
Personal license
Leave a message in this thread and the user's contacts will be shown to you
Yulia wrote:
Legeza Vyacheslav
iCOLOR OneBox (FOP LEGEZA VIACHESLAV VALERIANOVYCH) wrote:
In the database, when products were created, spaces were made in the product names.
Now it is very difficult to find anything.
Is it possible to remove extra spaces?
Please share if there is a solution.
Good day
In principle, the problem was solved quite simply through the automation in products "Format the name of the product according to the template"
In the action settings, in the "Text" field, write a double space " ", and in the "Replace with value" field, write a single space " " and as a result, the double space will be replaced by a single one, you can make several blocks so that if there is a triple space and after the first pass a double space will appear, so that the system also then converts it into a single space.
Problems can arise only if there is multilingualism, but solutions can also be found there
Julia, thank you
interesting, tried it
but unfortunately nothing happened
It looks like I didn't do all the necessary settings for this action
25.06.2023, 19:45
Вячеслав Легеза
Original comment available on version: ua
Try to do not from 2 to 10, but on the contrary from 10 to 2. Maybe it will work out that way
25.06.2023, 19:58
Original comment available on version: ua
As another option, for each case, take 10 actions, that is:
1 automation - 10 spaces
2 automation - 9 spaces
and so on
1 automation - 10 spaces
2 automation - 9 spaces
and so on
25.06.2023, 20:01
Original comment available on version: ua
Легеза Вячеслав
iCOLOR OneBox
iCOLOR OneBox
ФОП Легеза В.В.
Personal license
Leave a message in this thread and the user's contacts will be shown to you
Roman Sergeevich Yurchenko wrote:
As another option, for each case, take 10 actions, that is:
1 automation - 10 spaces
2 automation - 9 spaces
and so on
does not work either way
25.06.2023, 22:11
Вячеслав Легеза
Original comment available on version: ua
Roman Sergeevich Yurchenko wrote:
As another option, for each case, take 10 actions, that is:
1 automation - 10 spaces
2 automation - 9 spaces
and so on
and then you will ask why the product card is kept for so long)) And there are just 10 automations that do nothing and cost nothing. Vital..
26.06.2023, 09:48
Original comment available on version: ua
.dev
OneBox production wrote:
and then you ask why the product card is saved for so long)) And there are just 10 automations that do nothing. Vital..
good day)
I'm not saying it's good, but in this case, this suggestion was written to generally test if it works. Whether to use it or not is up to Slava to decide.
Regarding the long loading of the card (I speak only for my experience with Boxing): often I have to make permanent / temporary crutches because the necessary functionality is missing, the description / name of the action is not clear, there is no information that some action has been added / updated or ordered improvements dragged on for months, and you need to work now. In addition, I am sure that if I make a calculation of "the total amount of my money spent on improvements and divide them by the licenses I have" (namely, for improvements, and not licenses or payment for the work of integrators), I made a great contribution to the fact that such there were fewer crutches in the system.
26.06.2023, 10:37
Original comment available on version: ru
In no way am I doubting your contribution to the development of the system, I'm just trying to explain that setting X actions to automate has consequences and if there is a choice to put X or one, then it's better to put one.
26.06.2023, 10:50
Original comment available on version: ru
.dev
OneBox production wrote:
I in no way doubt your contribution to the development of the system, I'm just trying to explain that setting X actions for automation entails consequences and if there is a choice to set X or one, then it is better to set one.
Yes, I completely agree with you here
26.06.2023, 10:54
Original comment available on version: ua
Легеза Вячеслав
iCOLOR OneBox
iCOLOR OneBox
ФОП Легеза В.В.
Personal license
Leave a message in this thread and the user's contacts will be shown to you
.dev
OneBox production wrote:
I have already placed the task on the account, it will be presented soon
when to expect the bill?
is it possible to pay from the balance for the development to speed up the decision?
26.06.2023, 12:23
Вячеслав Легеза
Original comment available on version: ua
Легеза Вячеслав
iCOLOR OneBox
iCOLOR OneBox
ФОП Легеза В.В.
Personal license
Leave a message in this thread and the user's contacts will be shown to you
Paid
When to expect a decision?
When to expect a decision?
26.06.2023, 14:21
Вячеслав Легеза
Original comment available on version: ua
Legeza Vyacheslav
iCOLOR OneBox (FOP LEGEZA VIACHESLAV VALERIANOVYCH) wrote:
but unfortunately nothing happened
You have some kind of error, if you look at the screenshot, the "Template" field is not filled, accordingly, nothing will work, try to check if the action works for you at all, try to measure some single character in the name, and then if it already works, then move on. it is possible that you do not have a space in the string, but another character that is not displayed.
26.06.2023, 17:50
Original comment available on version: ua
Good afternoon. In the "Generate product name according to the template" action, the setting "Instead of generating the name according to the template, remove double spaces from the product name" has appeared
Improvement uploaded to balistyka.1b.app
Improvement uploaded to balistyka.1b.app
28.06.2023, 15:04
Original comment available on version: ru
Легеза Вячеслав
iCOLOR OneBox
iCOLOR OneBox
ФОП Легеза В.В.
Personal license
Leave a message in this thread and the user's contacts will be shown to you
.dev
OneBox production wrote:
Good afternoon. In the "Generate product name according to the template" action, the setting "Remove double spaces from the product name instead of creating a template name" appeared
The update was uploaded to balistyka.1b.app
Checked both actions where it was added during development
checked on this product, which was given as an example
https://balistyka.1b.app/app/product/457/edit/
I keep
everything is fine and works
28.06.2023, 15:31
Вячеслав Легеза
Original comment available on version: ua
Легеза Вячеслав
iCOLOR OneBox
iCOLOR OneBox
ФОП Легеза В.В.
Personal license
Leave a message in this thread and the user's contacts will be shown to you
thank you sincerely
28.06.2023, 15:32
Вячеслав Легеза
Original comment available on version: ua
Legeza Vyacheslav
iCOLOR OneBox (FOP LEGEZA VYACHESLAV VALERIANOVICH) wrote:
Having checked the boxes on both days, de її were added according to the distribution
Keep in mind that other actions within the action are not performed if the checkbox is enabled. Those. if you check the box, the action will only remove spaces from the name and do nothing else
28.06.2023, 15:54
Original comment available on version: ru
Легеза Вячеслав
iCOLOR OneBox
iCOLOR OneBox
ФОП Легеза В.В.
Personal license
Leave a message in this thread and the user's contacts will be shown to you
.dev
OneBox production wrote:
Legeza Vyacheslav
iCOLOR OneBox (FOP LEGEZ VYACHESLAV VALERIANOVYCH) wrote:
By setting the checkmarks on both actions, where it was added by development
Note that other actions within the action are not performed if the check box is enabled. That is, if you checked the box, the action will only remove spaces from the name and will do nothing else
Ok, that's a useful point, thanks
28.06.2023, 18:07
Вячеслав Легеза
Original comment available on version: ua
Легеза Вячеслав
iCOLOR OneBox
iCOLOR OneBox
ФОП Легеза В.В.
Personal license
Leave a message in this thread and the user's contacts will be shown to you
maybe it is better to add this point in the description to the tick so that others will also understand it
28.06.2023, 18:08
Вячеслав Легеза
Original comment available on version: ua
Legeza Vyacheslav
iCOLOR OneBox (FOP LEGEZA VIACHESLAV VALERIANOVYCH) wrote:
thank you sincerely
Did you read the comment above, tried to change the settings taking into account the edits, was the result?
28.06.2023, 18:23
Original comment available on version: ua
Yulia wrote:
Legeza Vyacheslav
iCOLOR OneBox (FOP LEGEZA VIACHESLAV VALERIANOVYCH) wrote:
but unfortunately nothing happened
You have some kind of error, if you look at the screenshot, the "Template" field is not filled, accordingly, nothing will work, try to check if the action works for you at all, try to measure some single character in the name, and then if it already works, then move on. it is possible that you do not have a space in the string, but another character that is not displayed.
This
28.06.2023, 18:23
Original comment available on version: ua
Легеза Вячеслав
iCOLOR OneBox
iCOLOR OneBox
ФОП Легеза В.В.
Personal license
Leave a message in this thread and the user's contacts will be shown to you
Yulia wrote:
Legeza Vyacheslav
iCOLOR OneBox (FOP LEGEZA VIACHESLAV VALERIANOVYCH) wrote:
thank you sincerely
Did you read the comment above, tried to change the settings taking into account the edits, was the result?
yes, I read it
and immediately checked
unfortunately, this decision did not help
thank you :) sincerely
29.06.2023, 09:24
Вячеслав Легеза
Original comment available on version: ua
Legeza Vyacheslav
iCOLOR OneBox (FOP LEGEZA VIACHESLAV VALERIANOVYCH) wrote:
unfortunately, this decision did not help
Amazing, it should have worked
29.06.2023, 11:44
Original comment available on version: ua
Legeza Vyacheslav
iCOLOR OneBox (FOP LEGEZA VIACHESLAV VALERIANOVYCH) wrote:
maybe it is better to add this point in the description to the tick so that others will also understand it
it is written right there in the name of the tick, but I know you too well, so I wrote it again
29.06.2023, 12:08
Original comment available on version: ua
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
