I have a database of user data in an excel file that I wish to import into backdropcms.
I exported "users" backdropcms table and 2 rows of contents (fresh install). Using Excel, I added additional columns/fields desired, the dataset was then mapped to the fields. then saved as .csv. Then, used a .csv to .sql conversion tool.(only a small test set of 25 records.)
Then, attempted to import the sql file into the "users" table via phpmyadmin.
Fail. Recurring error was "incorrect number of columns".
I suspect this solution is two fold, though unsure.
a. manually add the additional fields/columns to the table likely through backdropcms interface or hopefully through phpmyadmin
b. once fields exist, run sql import again.
I am hoping there is an easier solution. The database of "users" is about 50,000, so importation is important.
As a "best practices" consideration, I'm wondering if a better approach is to create another table "user_details", which then opens in a block below the "user" pages. In this way, automatic updates/modifications to the base table set do not blow up the site structure. Thoughts and best practice tips greatly appreciated. It would seem that a sitewide search for "users" table would then enable me to determine which pages require a link to the additional table "user_profile". In this way, the upgrades or changes to the base system structure would not impair or damage the site, with the exception of the additional code insertion linking the "user_profile" table.
Help appreciated. I'm quite skilled with backend server functionality yet new to both backdrop and customization of these sites.
Thanks in advance.