Order of custom fields changes when using copy feature

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Order of custom fields changes when using copy feature

Postby dspaan » Wed Nov 15, 2017 3:51 am

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
Regards, Dennis

Vicibox 9.0.1
Version: 2.14b0.5
SVN Version: 3199
DB Schema Version: 1588
Build: 200310-1801
dspaan
 
Posts: 1374
Joined: Fri Aug 21, 2009 1:40 pm
Location: The Netherlands

Re: Order of custom fields changes when using copy feature

Postby mflorell » Wed Nov 15, 2017 6:06 am

How exactly did you copy them?
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Order of custom fields changes when using copy feature

Postby dspaan » Wed Nov 15, 2017 6:09 am

Like this:

Image
Regards, Dennis

Vicibox 9.0.1
Version: 2.14b0.5
SVN Version: 3199
DB Schema Version: 1588
Build: 200310-1801
dspaan
 
Posts: 1374
Joined: Fri Aug 21, 2009 1:40 pm
Location: The Netherlands

Re: Order of custom fields changes when using copy feature

Postby mflorell » Wed Nov 15, 2017 7:33 am

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?
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Order of custom fields changes when using copy feature

Postby dspaan » Sat Nov 18, 2017 12:17 pm

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.
Regards, Dennis

Vicibox 9.0.1
Version: 2.14b0.5
SVN Version: 3199
DB Schema Version: 1588
Build: 200310-1801
dspaan
 
Posts: 1374
Joined: Fri Aug 21, 2009 1:40 pm
Location: The Netherlands


Return to Support

Who is online

Users browsing this forum: Majestic-12 [Bot] and 86 guests