Page 1 of 1

Order of custom fields changes when using copy feature

PostPosted: Wed Nov 15, 2017 3:51 am
by 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.

Image

Image

This was tested on:

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

Re: Order of custom fields changes when using copy feature

PostPosted: Wed Nov 15, 2017 6:06 am
by mflorell
How exactly did you copy them?

Re: Order of custom fields changes when using copy feature

PostPosted: Wed Nov 15, 2017 6:09 am
by dspaan
Like this:

Image

Re: Order of custom fields changes when using copy feature

PostPosted: Wed Nov 15, 2017 7:33 am
by 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?

Re: Order of custom fields changes when using copy feature

PostPosted: Sat Nov 18, 2017 12:17 pm
by 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.