• Hello Fabrik Community

    Fabrik is now in the hands of the development team that brought you Fabrik for Joomla 4. We have recently transitioned the Fabrik site over to a new server and are busy trying to clean it up. We have upgraded the site to Joomla 4 and are running the latest version of Fabrik 4. We have also upgraded the Xenforo forum software to the latest version. Many of the widgets you might have been used to on the forum are no longer operational, many abandoned by the developers. We hope to bring back some of the important ones as we have time.

    Exciting times to be sure.

    The Fabrik 4.0 Official release is now available. In addition, the Fabrik codebase is now available in a public repository. See the notices about these in the announcements section

    We wish to shout out a very big Thank You to all of you who have made donations. They have really helped. But we can always use more...wink..wink..

    Also a big Thank You to those of you who have been assisting others in the forum. This takes a very big burden off of us as we work on bugs, the website and the future of Fabrik.

import existing mysql table

Hello Fabrik Team,

I have a table with >100 columns. I know I have asked this before, but please allow me to ask again.

Is it possible to import a table by now or do we have to create each field?

In my case, I have > 100 fields that are just text.

Or is my best bet: create a table, check the database how fields are saved and bulk INSERT from Excel?

Also. It would be great, if we could edit the table name once created.
 
What do you mean with "existing mysql table"?

If it's already existing in your database you can just create a new list and select the "Database table" in the list's "Data" tab.
In Fabrik Options you can set how elements labels should be created from columns names automatically (you can edit the labels afterwards if you like/need to).
Table names (i.e. the name in the database) can't be edited but you could rename your database table before creating the list.

If you want to import a CSV file (should be UTF8) you can use the "Import" in list listing. Here you can chose the table name, which columns to import, which element types to create etc.
 
Ok, I am at the same point as before.
Fabrik isn't really user friendly, when it comes to renaming tables.

//////////

Sorry for asking again.

//////////

I have created a list/form with table name "LABEL_FABRIK_USER".
The table name in MySQL is "LABEL_FABRIK_USER" as well.
This table name is a mistake!
Now I need to change the table name to "fabrik_user".
I will use the form as a register form with JUSER Plugin.

How can I change the table name and keep all elements that I have already created?

I have tried to create a new form/list and tried to copy all elements, but there is always a problem with already existing "ID" element or "date and time" element.
Also, a copy will establish a connection between the original field and the new field, rather then actually copying the element.
I am really confused on this. I don't want to break my form.

//////////

My initial question:

I have an already existing MySQL table.

Do I have to create a form and each element by hand or can I "import" an existing table with all elements???

As I said, I have a table with > 100 columns and I don't want to create each element by hand.
 
Fabrik isn't really user friendly, when it comes to renaming tables.
You'll mess up your application if renaming database stuff which may be used at different places.

Why do you need to rename the database table name at all? Fabrik users will see only the list label and form label which you can change at any time.
I have tried to create a new form/list and tried to copy all elements, but there is always a problem with already existing "ID" element or "date and time" element.
So copy all but id and date_time element (which are created at list creation automatically).
Afterwards you can trash the original elements and then empty trash without dropping the columns.

If your original elements are used somewhere (prefilter, ordering, CCD element, placeholders, plugins ...) you have to adapt these places

Other possibility:
In form listing use "Content type"/Export
Then create a new list with the table name you want and select the new content type when you are asked to do so.
 
We are in need of some funding.
More details.

Thank you.

Members online

No members online now.
Back
Top