Jump to content

CSV data update to existing WHMCS tblClients table


Recommended Posts

We have successfully used the 7.8.3 sync tool to get all the users loaded into the WHMCS database.

As I am sure you all know, the firstname Lastname fileds in the WHMCS will now have the unix user name as first name, and admin as the last name. 

We are currently working an a spreadsheet that will is very close to being saved as a flat text csv file.

Before I embark on authoring a a php script to update the WHMCS tblClients from the csv file, I am reaching out to see of one already exists somewhere.

The idea of the script would be to:

read the unix_user field from the csv and find the exact match in the firstname column of the WHMCS_tblclient. If found, move the firstname data (in tblcliennts) to the NOTES field. then update the firstname, lastname, email, address1 address2, etc. etc. etc. fields in tblsclients from the csv file.

Anyone?

-N

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

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