Order of custom fields changes when using copy feature

[dspaan]

I have been having this problem for years now and i'm surprised no one has posted about this before. When i use the copy custom fields feature to copy fields from one list to another and then later on you make an export you discover that the data is in different columns when you open the export in Excel.

You can clearly see that something goes wrong when you look at the custom fields tables in navicat, see here an example of the custom fields for list 511 which were copied to list 515. Absolutely nothing was changed about list 515 manually or the other list for that matter but still when you go to the Vicidial Reports page and do an export calls report for the campaign the data winds up in different columns.





This was tested on:

Versie: 2.14-605a
Meta-versie: 170327-1655

[mflorell]

How exactly did you copy them?

[dspaan]

Like this:

[mflorell]

If you do the same thing to another list, does the custom field order match the first one you copied?

Have you tried REPLACE when copying custom fields?

[dspaan]

Hi Matt,

I just made a new list called 517 and this time i used the REPLACE feature to copy the fields from list 515 to 517 but they are in the wrong order again.

edit: I think this has something to do with fields of the DATE type, they are the ones that get moved after copying them.