1b.app
Link copied -

I can't change the field type in an already existing additional contact field

I'm trying to change the type of the field from "Integer" to "String", after clicking on save, it swears at the name of the field identifier, in the name of which there is the symbol "№". This field was created a long time ago with the current ID "RG#". There are also other fields in the system, which have the symbol "#" in the identifier, for which it is also impossible to apply any changes.
Original question is available on version: ru

Answers:

The use of special characters in keys in the system is prohibited. Probably initially when there were no such checks - they were created.
Normally, you should change the identifiers of additional fields, as well as their keys in the database table where the values of additional fields (shopcustomfield) are stored.
There are 2 solutions:
1. you do it on your own (but if you suddenly did something wrong, you are responsible)
2. we will do it for 1 hour of revision
If you were a cloud client, we would do it for free.
02.09.2021, 14:59
Original comment available on version: ru

If you change this additional field identifier, then all data in this field in all contacts and in all business processes will be lost. and you will have to manually interrupt and change all business processes where this field is involved.
How to remove the ban on the use of special characters in the system?
02.09.2021, 15:14
Original comment available on version: ru


If you change this additional field identifier, then all data in this field in all contacts and in all business processes will be lost. and you will have to manually interrupt and change all business processes where this field is involved.

actually for this I offered you an option that changed the keys in the values

How to remove the ban on the use of special characters in the system?

No way. And we will not make such an opportunity either in order to avoid possible "bad" consequences for the presence of special characters in the keys.
02.09.2021, 16:11
Original comment available on version: ru

Send an invoice to our mail, to which your personal account is linked
02.09.2021, 16:49
Original comment available on version: ru


Good afternoon, paid.
Once again about solving the problem.
It is necessary to replace all the fields with special characters in the field indicator with any corresponding Latin letter so that the data for these fields does not change and is not lost. All data must be saved and not affect business processes in any way. In general, everything should remain in working order and without data loss. Due to special characters, we cannot change the field type, for example, to the "text" type. For example, in the "DMS No." field (indicator DMS No. - here we change the special character to the letter "N") in the contact card, you must specify it in such a way that the first characters are in the form "0077577". And now, after saving, the field also takes the form "77577". That is, now I can not save the first 00 (zeros).
13.09.2021, 16:12
Original comment available on version: ru

As per previously provided assessment - found such keys and replaced them accordingly:
RVP# = RVPN
MK# = MKN
RG# = RGN
DMS# = DMSN
14.09.2021, 12:01
Original comment available on version: ru

Thanks, everything seems to be working. Describe step by step how you completed the task? If in the future I or someone else needs it. We paid you for the solution, I want users to be able to publicly see the solution to the problem.
14.09.2021, 12:34
Original comment available on version: ru

A script is written, according to which the correctness of the keys of the created additional fields in the database is checked for different entities.
Where it is not correct, the key is replaced and all records are updated by the values of this additional field with a new key.
PS: a simple user without access to the database, knowledge of the system architecture and basic programming skills will not do this.
14.09.2021, 13:00
Original comment available on version: ru

We've got a problem. At the moment, it is impossible to accept people, the audit does not allow MK and DMS, although everything is in order with the data. After you made the changes, all the changed fields in our employee card disappeared. then, through the interface settings, I displayed these fields MK№ = MKN and DMS№ = DMSN (here I changed the field type from Integer to String), where they used to be. Most likely, after the change, all these fields disappeared from the interface of contacts and business processes. Audit does not work for us now, VMI and MK are red, although all fields are filled out. We need to resolve the issue urgently!
14.09.2021, 15:07
Original comment available on version: ru


Most likely, after the change, all these fields disappeared from the interface of contacts and business processes. Audit does not work for us now, VMI and MK are red, although all fields are filled out.

Display fields with new keys in interface blocks - and they will be displayed. I see no problem for you to do it manually.
The values in the database of the fields have not gone away.
14.09.2021, 15:23
Original comment available on version: ru

in the interface blocks in the contacts are displayed. And in business processes, you still need to know where to output. at the stage that does not pass, these fields did not disappear there
here are the links
admin/customorder/migratsionniy-audit/288621/edit/
customorder/migratsionniy-audit/288629/edit/#done
admin/customorder/migratsionniy-audit/288637/edit/#done
14.09.2021, 15:31
Original comment available on version: ru

All the fields I mentioned above were related to the contact.
Do you have a problem displaying them in the interface, or is the value allegedly missing somewhere in the contact (you need a link to a specific contact)?
14.09.2021, 16:23
Original comment available on version: ru

in contacts everything is displayed correctly, the data is not lost. we have business processes that are tied to values and copying from one field to another. Most likely, in several business processes where these fields are used, the settings went wrong after your manipulations. The last "registration of employees" today was successful at 11.20 Moscow time. Now it does not work out some action in the business process and so far we have identified a problem at this stage, the links for which I sent you. These links, this is the business process of "applying to work" of different employees, it starts with an audit that does not go, the value is "NOT OK". They come out if the data of MK and VMI are not filled out, but they are filled out. You can write to me by mail, I will send you a video instruction in a personal message on how this business process is going on with us, so that it would be easier for you to search.
14.09.2021, 16:39
Original comment available on version: ru


Most likely, in several business processes where these fields are used, the settings went wrong after your manipulations

Yes, it could happen - because the keys of these fields are stored there. Where exactly what you have configured - I can not know.
You only have the option to manually change the settings of these actions to the desired fields with new keys.
14.09.2021, 16:54
Original comment available on version: ru

Personally, I cannot find an action with these fields in the database in your business process ...
14.09.2021, 17:02
Original comment available on version: ru


Companies CenterM Administrator
Client wrote:
Good afternoon, paid.
Once again about solving the problem.
It is necessary to replace all the fields with special characters in the field indicator with any corresponding Latin letter so that the data for these fields does not change and is not lost. All data must be saved and not affect business processes in any way. In general, everything should remain in working order and without data loss. Due to special characters, we cannot change the field type, for example, to the "text" type. For example, in the "DMS No." field (indicator DMS No. - here we change the special character to the letter "N") in the contact card, you must specify it in such a way that the first characters are in the form "0077577". And now, after saving, the field also takes the form "77577". That is, now I can not save the first 00 (zeros).

I pointed out in the task that your manipulations would in no way affect the working business processes !!!
And now you say, fix it yourself as you want. Is this professional? You yourself wrote that you will pay for an hour of revision and we will solve your problem!
And it turns out we can’t work for half a day? What is it like? Our crm broke down due to your fault and you say look for it and figure it out yourself!!!
Dear ONEBOX Technical Support. We kindly ask you to fix the working processes for us, the performance of which is broken due to the actions of your specialists!
14.09.2021, 17:19
Original comment available on version: ru


I pointed out in the task that your manipulations would in no way affect the working business processes !!!

I pointed out to you exactly what will be done.

And now you say, fix it yourself as you want. Is this professional? You yourself wrote that you will pay for an hour of revision and we will solve your problem!

I am telling you that I do not see that the fields I have changed are used in your business processes.
If this is not the case - provide a specific link where you have the action configured, where this action was used - I will select the changed field there instead of you if you cannot do this.
And I told you this because you set up your business processes (and not me) - and you should know where, what and how you have set up in the business process - or at least I ask you to provide this information to me.

And it turns out we can’t work for half a day? What is it like? Our crm broke down due to your fault and you say look for it and figure it out yourself!!!

You can't work part-time because you're wasting your time writing angry comments instead of meeting me and making changes (or pointing out where you have what is set up in the business process).

Dear ONEBOX Technical Support. We kindly ask you to fix the working processes for us, the performance of which is broken due to the actions of your specialists!

First, I'm not a tech support.
Secondly, I ask you once again to indicate where and during what actions you have an error with the above fields (links, screenshots, etc.) in order to understand where you have this or that action configured, in which this or that field is used .
You do not specify any specifics of the essence of the problem and at the same time require a solution. Give specifics - I will solve the problem if it arose as a result of my actions on this topic.
14.09.2021, 17:32
Original comment available on version: ru


Companies CenterM Administrator Client wrote:
The last "registration of employees" today was successful at 11.20 Moscow time. Now it does not work out some action in the business process and so far we have identified a problem at this stage, the links for which I sent you. These links, this is the business process of "applying to work" of different employees, it starts with an audit that does not go, the value is "NOT OK". They come out if the data of MK and VMI are not filled out, but they are filled out.

Do I understand correctly that somewhere you had the actions of copying the changed contact fields into processes and they were not copied? Or what's the problem?
14.09.2021, 17:39
Original comment available on version: ru


The last "registration of employees" today was successful at 11.20 Moscow time. Now it does not work out some action in the business process and so far we have identified a problem at this stage, the links for which I sent you. These links, this is the business process of "applying to work" of different employees, it starts with an audit that does not go, the value is "NOT OK". They come out if the data of MK and VMI are not filled out, but they are filled out.

I looked at the steps of the process https://crm.centrmig.com/admin/customorder/migratsionniy-audit/288637/edit/ - I don't see where there would be any actions with checks/copying additional contact fields in which we entered changes.
Can you specify where exactly you have a problem in the business process?
14.09.2021, 17:54
Original comment available on version: ru

https://crm.centrmig.com/admin/shop/workflowstatus/403/action/new/
https://crm.centrmig.com/admin/shop/workflowstatus/331/action/new/
found these business process settings, indicated new fields
check, with new processes - everything works correctly?
14.09.2021, 18:01
Original comment available on version: ru

We can check if all is well let you know. There are likely to be problems at several stages. Then today tomorrow we will check at what stages errors will occur, I will send links and a brief description of what happened and what should happen at this stage.
Excuse me, of course, for my harsh statements, but understand correctly, we have got work to do and all the managers have a crowd of questions and complaints about me. We have many times a day and dismissal and admission. These processes were set up by Ney and your colleagues 4 years ago. And one of your colleagues was responsible, I don’t remember my full name. There are hundreds of business processes and stages involved. Therefore, even for you it is very difficult to understand, especially for me.
I will post as I get problems. As we go through all the stages and business processes for hiring, firing and reinstating employees, I will unsubscribe accordingly.
14.09.2021, 18:26
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