Abhishek

Hi,

Yes, it is possible to add data to an existing table created by another plugin. To do this, you need to ensure that the column names in the existing table match the field names in your form (ACF filed group) and that the existing table includes a “post_id” column.

Hi,

By default, the plugin saves ACF field data in the?wp_postmeta?table along with a custom table. You can disable this behavior using following filter.

https://acf-custom-tables.abhisheksatre.com/docs/filters/store-acf-values-in-post-meta-table/

Hi @francoistdc,

We are actively maintaining this plugin. Soon new version will be available.

Hi,

My bad.

Thanks for reporting the issue.

Currently, the plugin does not support the get_fields function. You can use the get_custom_table_fields function to fetch all data.

We will add support for get_fields function soon.

https://acf-custom-tables.abhisheksatre.com/docs/functions/get-custom-table-fields/

• This reply was modified 2 years ago by Abhishek.

Hi @nicmare,

Our plugin supports get_field function to retrieve data from the custom table.

It looks like the data for the post you’re trying to access may not be available. Please verify if the necessary data is present in the custom table.

Hi @nicmare,

Thank you reporting the php warning issue. We will fix the warnings soon.

Yes, you are using correct filter to change mysql column data type.

https://acf-custom-tables.abhisheksatre.com/docs/filters/change-data-type/

Hi,

the_custom_table_field function does not have any negative impact on performance. Please note that the function will not work if the plugin is deactivated.

Hi @andreas-2013,

Thank you for providing the detailed steps.

In order to further investigate the issue, could you please share the complete MySql query generated after the ‘posts_where’ hook is applied? You can use the query monitor plugin to check the generated query.

Additionally, could you try using the get_custom_table_field() function instead of get_field to see if that resolves the issue?

https://acf-custom-tables.abhisheksatre.com/docs/functions/get-custom-table-field/

Hi,

Can you please provide the sample code you are using to display the taxonomy?

• This reply was modified 2 years, 1 month ago by Abhishek.

Hi @devtestconcise,

Currently, the plugin does not have a migration feature. We are working on a tool to migrate ACF data to a custom table.

An alternate solution:
1. Export acf data using the export plugin. While exporting add post id as a post_id column
2. Open exported CSV and verify CSV columns with custom table column names.
3. Import this CSV into the custom table using any database GUI.

Hi,
This notice is not yet fixed. We are doing some code refactoring to fix this notice.

Hi,

The problem has been resolved in the updated version (1.0.4). Please update the plugin and check.

Thank you so much for reporting the issue ??.

Hi,

Thank you for the detailed steps. I am able to replicate the issue. Will fix the issue asap.

Closing the thread.

Hi,

Thank you for reporting the notice message. We will try to resolve the notice issue.

When you add the above filter, the plugin does not save ACF data in the post meta table. In the admin, while showing data, if data is not present in the custom table then it displays data from the post meta table.

– ACF values are not showing for all posts or for a particular post?
– Please verify whether the data is present in the custom table or post meta table for the post that is not showing the data.
– If data is not showing for all posts then some other plugins or theme code may be conflicting.

I tried to replicate the issue. But working fine for me.