WHMCS database

[KNK]

Hey.

My current WHMCS database is messy and broken due my fault. Orders ID are messed, and invoices show deleted bc I deleted them instead of cancelling etc...

I plan 2 make a new WHMCS install and just copy the customers data. Do I just need to export: tblclients to move the active clients?

Because on the page: admin/clients.php I have 177 Records Found and on admin/user/list I have 372 Records Found (How do I delete all this users that don't have an account?)

Also, once I move the clients table to the new WHMCS database is it possible to copy their services/products as well or I need to create a new order for each once I move them?

Thank you, guys.

[WHMCS Danny]

Hello KNK,

We have an ImportAssist tool that may be able to accomplish this.
Please review this addon tool WHMCS developed at the below MarketPlace link:

https://marketplace.whmcs.com/product/46-importassist

 

Here is the documentation for the Migration Guide that explains this tool as well:

https://docs.whmcs.com/Migration_Guide#ImportAssist

 

Note: We do not recommend making edits to the WHMCS database directly.  In version 7.5 we added automated data retention settings, which allows for the automated deletion of inactive clients: https://docs.whmcs.com/Data_Retention_Policy_Automation
Have you tried this feature, as it was also updated in WHMCS 8.0 as well?

The system can automatically change the client status now by using the Client Status Update setting to control this.

Please review the below documentation on this setting for more information:
https://docs.whmcs.com/Automation_Settings#Client_Status_Update 

 

Quote

Also, once I move the clients table to the new WHMCS database is it possible to copy their services/products as well or I need to create a new order for each once I move them?

If you are unable to use the ImportAssist tool, then you would have to follow the steps on manually adding services, domains and clients by following the Manual Entry section of the Migration  Guide below:
https://docs.whmcs.com/Migration_Guide#Manual_Entry

I hope this helps.

 

Someone may have some better advice with SQL commands but WHMCS Technical Support does not advise making edits to the database directly due to database relationships and  the IDs of those relationships to other tables, that could cause issues down the road.

 

[KNK]

5 hours ago, WHMCS Danny said:

Hello KNK,

We have an ImportAssist tool that may be able to accomplish this.
Please review this addon tool WHMCS developed at the below MarketPlace link:

https://marketplace.whmcs.com/product/46-importassist

 

Here is the documentation for the Migration Guide that explains this tool as well:

https://docs.whmcs.com/Migration_Guide#ImportAssist

 

Note: We do not recommend making edits to the WHMCS database directly.  In version 7.5 we added automated data retention settings, which allows for the automated deletion of inactive clients: https://docs.whmcs.com/Data_Retention_Policy_Automation
Have you tried this feature, as it was also updated in WHMCS 8.0 as well?

The system can automatically change the client status now by using the Client Status Update setting to control this.

Please review the below documentation on this setting for more information:
https://docs.whmcs.com/Automation_Settings#Client_Status_Update 

 

If you are unable to use the ImportAssist tool, then you would have to follow the steps on manually adding services, domains and clients by following the Manual Entry section of the Migration  Guide below:
https://docs.whmcs.com/Migration_Guide#Manual_Entry

I hope this helps.

 

Someone may have some better advice with SQL commands but WHMCS Technical Support does not advise making edits to the database directly due to database relationships and  the IDs of those relationships to other tables, that could cause issues down the road.

 

Yea. first mistake was "deleting" the fraud orders instead of letting them be "fraud". Second mistake was deleting the services, instead of letting them be "cancelled".

Now there are services without "orders IDs" and there are orders ID starting at 900 and others at 50. Do you think this tool will let me to start on a clean database and just move tickets, invoices, clients with services?

[WHMCS John]

Hi @KNK,

ImportAssist can certainly be used to import data into a fresh database, and it'll assign new IDs to everything.

All the data points itemized in the documentation here will be imported: https://docs.whmcs.com/ImportAssist#WHMCS_8.0_and_later

It is not currently possible to selectively import data; most things are relational, so you'd need most of it anyway.

[KNK]

On 9/01/2023 at 4:56 PM, WHMCS John said:

Hi @KNK,

ImportAssist can certainly be used to import data into a fresh database, and it'll assign new IDs to everything.

All the data points itemized in the documentation here will be imported: https://docs.whmcs.com/ImportAssist#WHMCS_8.0_and_later

It is not currently possible to selectively import data; most things are relational, so you'd need most of it anyway.

Whoops\Exception\ErrorException: The file /home/domain.com/public_html/modules/addons/import_assist/import_assist.php encoded as type [1/71] cannot be decoded by this version of the ionCube Loader.
in Unknown:0
Stack trace:
#0 /home/domain.com/public_html/vendor/whmcs/whmcs-foundation/lib/Utility/Error/Run.php(0): WHMCS\Utility\Error\Run->handleError()
#1 [internal function]: WHMCS\Utility\Error\Run->handleShutdown()
#2 {main}

Unfortunately, I can't use the module now. Using the last version of WHMCS and IonCube.