| Author |
 Topic  |
|
|
emj
19 Posts |
 Posted - Jan 01 2007 : 02:55:31
|
I'm using MLK v5.36P. I imported a list from one MLK DB to another (standard maintenance updatey sort of thing), but accidentally included a couple of custom fields.
In the past, I've been able to open up an individual record, choose the "Custom Fields" tab, select the field I wanted to get rid of, and hit the "Remove Field" button, and have the whole field yanked from the entire DB.
Now, though, it doesn't seem to be working. All proceeds as normal, I am prompted "Are you sure you want to remove the field, TitleOfCustField?", and I let her rip. But the field is not removed from the DB, nor is it removed from the record I have open.
In place of the usual:
----------------------------
TitleOfCustField | $value |
----------------------------
deal, I see
----------------------------
| |
----------------------------
But when I close and reopen that particular record, the title and value are back.
I have tried adding and removing a custom field using the "Add New Field" and "Remove Field" buttons in the "Custom Fields" tab, and am able to remove any fields that I've newly created.
I just can't remove the fields added during the import.
Any help much appreciated.... |
|
|
xequte
7042 Posts |
|
|
adrianw
United Kingdom
40 Posts |
Posted - May 15 2007 : 04:19:00
|
Nigel
Due to a problem with underscores in field names in imported data, I've accidentally ended with with two custom fields with identical contents: one called "Person No" and one called "Person_No" (and a couple of other custom field names with and without underscores)
I would like to remove the "Person_No" field from the entire database.
I can delete custom fields manually from individual entries but it is not practical to go through the database one by one.
How can I remove a custom field from every member at once?
I've tried check and repair database which didn't help.
When I backup the database, the resulting CSV file doesn't have the offending custom fields in it (ie the ones with underscores in their names).
Presumably the offending custom fields would go away if I deleted every member and reimported from the backup csv.
But would I then lose each member's history?
Thanks
Adrian |
 |
|
|
xequte
7042 Posts |
Posted - May 16 2007 : 17:29:05
|
Hi Adrian
Unfortunately at this time there is not a good method for removing custom fields en masse. You could use your CSV file as you mention, but that would cause the other data for the member to be lost, such as their history.
We will be revamping the custom field handling for a later update.
Nigel
Xequte Software
nigel@xequte.com |
|
|
|
Skindude
United Kingdom
31 Posts |
Posted - Sep 01 2009 : 10:31:22
|
Hi Nigel
I know this is an old post but could find no other reference to Delete Custom Fields from entire Database. So, can this now be done and how?
Somehow, when I have imported Custom ileds from Excel I have two fields that are identical except for underscores between the words. this confuses MLK when I try to personalise an email with that field and the wrong info gets displated.
Using MLK 8.55R
Thanks
Andrew
Andrew |
|
|
|
xequte
7042 Posts |
Posted - Sep 01 2009 : 15:27:07
|
Hi
Unfortunately this has not been improved because we have plans for a major overhaul of custom fields handling in a coming update.
You could export your database to an Excel file, clear all of your existing custom fields using SQL, do a find and replace in your Excel file and then import it back in.
Let me know if you need help with the SQL.
Nigel
Xequte Software
www.xequte.com
nigel@xequte.com
|
|
|
|
Skindude
United Kingdom
31 Posts |
Posted - Sep 02 2009 : 01:20:27
|
Hi Nigel
Thank you. I have never used SQL before and have no idea what I need to do to run it or use it!
Any help appreciated.
Andrew |
|
|
|
xequte
7042 Posts |
Posted - Sep 02 2009 : 03:35:11
|
Hi Andrew
If you prefer you can email me your mlk_main.* files and I will do it for you (click Ctrl+Shift+I to display your database folder).
Nigel
Xequte Software
www.xequte.com
nigel@xequte.com
|
|
|
|
Skindude
United Kingdom
31 Posts |
Posted - Sep 02 2009 : 03:51:45
|
I would prefer to have a go at it myself so I can use SQL agin in the future if I need to.
Can you just point me in the right direction or to aguide on SQL?. Is it like using Microsoft ACCESS? I have used that many years ago
Andrew |
|
|
|
xequte
7042 Posts |
Posted - Sep 03 2009 : 15:24:51
|
OK, then.
Warning: Advanced Users Only
Back up your database! It is easy to clear an entire table with SQL!
To delete all of your custom fields:
i) Download the Database Utility from http://www.xequte.com/download/dbsys330.exe
ii) Install and Run it.
iii) Select File > Open Table, browse to your database folder and select MLK_Main
iv) Select File > new SQL Query and click OK to your database folder
v) Paste the following into your edit box:
UPDATE MLK_Main SET CustomFields=''
vi) Click "Run SQL"
Nigel
Xequte Software
www.xequte.com
nigel@xequte.com
|
|
|
| |
Topic |
|
Cannot remove custom fields
