Jump to content
netnow

tblClients Manual editing

Recommended Posts

Is it permissible to use phpMyAdmin to edit some basic fields in tblClients?

If so, are there fields (other than uid, and uuid) that must name be edited?

-T

Share this post


Link to post
Share on other sites

Let me understand. Are we talking about renaming columns? If so, DON'T do that. It will break the entire system.

Share this post


Link to post
Share on other sites
11 hours ago, netnow said:

Is it permissible to use phpMyAdmin to edit some basic fields in tblClients?

if you mean values within the records, then yes (if you know what you're doing!)... as Kian says, definitely not column names/titles.

12 hours ago, netnow said:

If so, are there fields (other than uid, and uuid) that must name be edited?

I assume you are asking if there are fields that must not be edited... what are you intending/wanting to change ?

either way, backup the table before you make any changes.

Share this post


Link to post
Share on other sites

Brian,

Yes, sorry I meant ".. must not be edited..".

We are in the position to start updating client info. The first thing will be to get unique email address in the main contact so peeps can log in to the correct accounts. Other than writing an SQL script, it appears to us the easiest way would be to open the tblClients in phpMyAdmin and put them in by hand. Later on, changing the address phone numbers etc. 
If all these values are simply that, values used in tblClients, and not somehow joined to other tables  ... editing should be ok? (And yes, definately not editing columns or table structure in any way).

-T

Share this post


Link to post
Share on other sites
15 hours ago, netnow said:

If all these values are simply that, values used in tblClients, and not somehow joined to other tables  ... editing should be ok?

yes... the ID value is used as a reference by other tables, so changing names, addresses etc wouldn't have an impact on other tables.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.

×

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated