Abhishek

Hi,

get_custom_table_field function provides the raw data from custom table. You will need to perform a decoding to get formatted results.

Example

<?php

$value = get_custom_table_field (‘table’, ‘field’, $post_id);
$formattedValue = json_decode($value);

Hi,

Currently, the plugin does not offer native support for importing data directly through the WP All Import plugin. However, you can utilize the WP All Import plugin to export ACF data to a CSV file and import that CSV data into a custom table via a database GUI tools such as TablePlus, phpMyAdmin

Hi,

The conversion of the character é to Unicode \u00e9 is due to JSON encoding. Our plugin stores array data in JSON format. This encoding is employed as a best practice to ensure data consistency and prevent any potential character encoding issues during data storage and transmission. When you retrieve and display this data, our plugin uses the json_decode method to decode it.

Regarding second question, the ACF plugin stores data in a serialized format, while our plugin stores data in JSON format. If you prefer to store data in the serialized format similar to ACF, you can achieve this by implementing a following filter. Once this filter is applied, our plugin will start storing data in the serialized format.

add_filter('acf_ct/settings/serialize_array', '__return_true');

Hi,

Using WP_Query on a custom table isn’t supported.

To work around this limitation, you can follow these steps:

1. Write a SQL query that selects all post IDs that meet your condition
2. Pass an array of post IDs to the post__in WP_Query argument to query the posts.

<?php

// Retrieve post IDs where the location is 'de'
global $wpdb;
$query = "select post_id from WP_CUSTOM_TABLE where location=%s";
$postIdQuery = $wpdb->prepare($query, 'de');
$postIds = $wpdb->get_col( $postIdQuery );

// Retrieve posts whose IDs are contained in the $postIds array.
if (is_array($postIds) && count($postIds) > 0) {
	$query = new WP_Query( [
		'post_type' => 'event',
    	'post_status' => array('publish'),
		'post__in' => $postIds,
	] );
}

Hi,

Yes, our plugin supports saving data from the frontend using acf_form().

Feel free to reach out if you have any more queries. Closing the thread.

Hi,

It appears that there might be an issue with a different functionality or plugin that is causing the data not to be saved in the custom table. To better assist you, could you please provide more details by emailing us? This will help us investigate the problem more effectively and provide you with a solution.

Hi,

Currently our plugin does not support migration of existing data. It stores data in a custom table whenever you manually create/update an article.

You can follow these steps to import existing data to custom table:

1. Export postmeta data to CSV.
   Install the WP ALL EXPORT plugin. Export the existing ACF data, with each ACF field value corresponding to a separate column in CSV format. Additionally, include the post ID as a separate column labeled “post_id” during export.
2. Open exported CSV and verify CSV column names with custom table columns
3. Import this CSV into the custom table using database GUI tools like TablePlus, phpMyAdmin.

Regarding data is not saved in the custom table:
Please ensure that the custom table is enabled for the ACF Field group and that the field group is associated with your custom post.

Please email your ACF field group details on [email protected] to debug the issue further.

Hi,

Certainly, the migration feature is part of our future plans.

Hi @avidflow,
Currently our plugin does not support migration of existing data. It stores data in a custom table whenever you update an article.

You can follow these steps to import existing data to custom table:

1. Export postmeta data to CSV.
   Install the WP ALL EXPORT plugin. Export the existing ACF data, with each ACF field value corresponding to a separate column in CSV format. Additionally, include the post ID as a separate column labeled “post_id” during export.
2. Open exported CSV and verify CSV column names with custom table columns
3. Import this CSV into the custom table using database GUI tools like TablePlus, phpMyAdmin.

Hi,

Our plugin uses the ACF field group to create columns for a custom table. If your post types are using same ACF field group, then you can use a single table for all of them.

Hi,

This is expected result. 

To maintain dynamic image URLs, similar to the ACF approach, we also store the image ID in the database.? The return format is primarily taken into account when displaying the image on the frontend. You can use the get_field function to access the image URL.

Hi,

The plugin does not offer a bulk update option. To perform bulk updates on the custom table rows, you’ll need to create a PHP script.

Hi,

Our plugin supports ACF’s get_field function to display the custom table data. If WPML is compatible with the get_field function then our plugin will support the WPML.
However, as WPML is a paid plugin, I was unable to personally verify the compatibility of our plugin with WPML.

Hi,

Can you please share the plugin link? I couldn’t find the wpml advance custom table plugin.