How to merge / move database tables to one database inside of Fabrik

[tmullins]

Yeah, I screwed up... at least I think that I did.
I created a second database with my candidate / carrier information assuming this database could grow to be large someday.

I used Phpmyadmin and imported all of my database tables from the candidate / carrier database into the main Joomla database.

How can I, hopefully easily, update Fabrik so that it will point to these tables instead of the old tables ?

Now, the reason that I'm doing this is because, if I read correctly, one can not join data from tables from 2 different databases. If I understand this correctly, I wouldn't be able to join my user_id from the joomla database with tables from my candidate / carrier database.

Any assistance with this would be greatly appreciated.

 

[lousyfool]

if I read correctly, one can not join data from tables from 2 different databases

You've read correctly.

The simplest way is to create new lists in Fabrik. In the "Data" tab you link them to the existing tables in your Joomla DB, as described here: http://fabrikar.com/forums/index.php?wiki/list-edit/#data
All other settings as you need them, and that's pretty much it.

Your old lists you can delete, obviously.

(Just for the record: of course, if you're very familiar with phpMyAdmin and how Fabrik list data is stored in its own tables, you could just mod the existing lists there... but, again, if you're not entirely sure what you're doing, the simplest way is the one described above.)

 

[tmullins]

Thank you