custom fileds not be checked in admin page

Closed

Import WP Pro Updated 1 year ago 14 Replies

Kitaek asked 1 year ago on September 18, 2023 at 12:50 pm

Hi,

“custom_fields._co_reading_id” is imported like this kind of value:

1695,1921,1923,1925,1919,1909,1920,1903,1924,1922

 

And the results are shown seperately in export csv and in admin page

In export csv file, the custom filed has same as imported value.

In admin page, however, the check boxes for the values are empty.

 

Attached two image to help your understand this situation.

 

Thanks in advance.

 

 

J

James replied Support Agent

1 year ago on September 22, 2023 at 8:15 pm

Hi,

The list of id's that are exported, do they exist on the website that you are importing to? if not what are the id's are they attachments, posts, taxonomies?

Once we know what this is we can add some code to update the exporter to write different data to the csv file.

James

KL

Kitaek replied

1 year ago on September 23, 2023 at 1:39 am

This list is available on the website.

I will briefly explain the configuration.

I am creating a tarot card website. There are different types of tarot card readings. And each tarot card needs to be interpreted differently depending on the type of reading.

Assuming this is an e-commerce site, each reading will be a parent category, and each card will be a child category or products under the parent categories.

In this case, the list is probably like a "post" area. Please refer to the attached image.

Thanks.

J

James replied Support Agent

1 year ago on October 2, 2023 at 10:56 pm

Sorry for the delay in getting back to you, we are back from vacation and response times should be back to normal.

The ID's in the original import for the custom field: "_co_reading_id" "1695,1921...", do these readings exist on the website where the cards are being imported to, and do the ID's match?

J

James replied Support Agent

1 year ago on November 20, 2023 at 12:38 pm

Hello Kitaek

This ticket is being marked as closed due to inactivity.

If this is not the case, please reply to this ticket to re-open it.

James

KL

Kitaek replied

1 year ago on December 13, 2023 at 4:28 pm

Hi,

Same problem is occured so i reopend this ticket - the older issue was cleared by clicking all the check box manually :)

How to import multiple values in a cell?

"The ID's in the original import for the custom field: "_co_reading_id" "1695,1921...", do these readings exist on the website where the cards are being imported to, and do the ID's match?"

-> Yes, sure.

Thanks.

J

James replied Support Agent

1 year ago on December 13, 2023 at 4:51 pm

How have you created the settings > Reading checkboxes, is this a theme or plugin functionality?

Are you able to manually create a card, and check a few of the reading checkboxes and save that card, taking note of the ID :  (can be taken from the url when saved: http://site.com/wp-admin/post.php?post=193&action=edit), e.g. this would be id 193

Then goto ImportWP > Exporters > Add Exporter

1. set a name
2. choose that you are exporting a card.
3. Set the unique identifier to ID, doesnt really matter.
4. Set File type to csv.
5. leave fields to export empty.
6. Under filter records, add filter, set the "field name" to ID , "operator" to Not Equals, and "That" to the card Id, which in my example would be 193.

Running the exporter you should get a csv file with one record, can you attach that csv file so i can see how your website saves the data in the database.

KL

Kitaek replied

1 year ago on December 14, 2023 at 5:46 am

This is a custom post type created as a feature of the plugin. 

 

As you requested, I registered a new cad manually. However, I couldn't find the ID in the URL - I tried to save the permalink as plain, but was forced to save it as post name only. 

 

I have extracted the csv file, but would like to share the link to the google sheet. The comments below are about the google sheet

 

https://docs.google.com/spreadsheets/d/17OjdqLS230lxOGMB84MoAA5d6wree-k_huzRQ9mI428/edit?usp=sharing

 

As for the ID 1782 (The Fool), I entered more values of co_reading_id in the csv the same as the other cards.

 

However, on the admin page, the checkbox for co_reading_id was blank. The 7 values currently extracted are the result of me manually filling in the checkboxes and then saving them.

 

The ID 12851(Test Card) in the lowest column is the result of doing what you requested. I created the card manually. I manually filled in some of the co_reading_id values.

 

I couldn't do the 6th of the exporter steps, which is to extract the CSV, because I couldn't find the ID in the URL address. So I extracted the entire card and the result is the same as the google sheet link. I've attached the CSV just in case.

 

Thanks.

J

James replied Support Agent

1 year ago on December 14, 2023 at 8:57 am

Thanks can you also repeat the export process for the post type that are the values in the reading checkboxes.

KL

Kitaek replied

1 year ago on December 14, 2023 at 10:23 am

Here are the two csv files for co_cards & co_readings.

Thanks.

J

James replied Support Agent

1 year ago on December 14, 2023 at 11:15 pm

So the Test card has the _co_reading_id custom field value of: "12666,1341,12664,12667,12665,1251,1604"

And the records that have been imported e.g. ID 1800, The Moon has the _co_reading_id custom field value of:
"1251,1604,1341,12664,12665,12666,12667,1572,12668,12669,12670,12671,1605,12672,12673,12674,12675,1606,12676,12677,12678,12679,1607,12680,12681,12682,12683,1608,12684,12685,12686,12687,1251,1604,1341,12664,12665,12666,12667,1572,12668,12669,12670,12671,1605,12672,12673,12674,12675,1606,12676,12677,12678,12679,1607,12680,12681,12682,12683,1608,12684,12685,12686,12687,1251,1604,1341,12664,12665,12666,12667,1572,12668,12669,12670,12671,1605,12672,12673,12674,12675,1606,12676,12677,12678,12679,1607,12680,12681,12682,12683,1608,12684,12685,12686,12687,1251,1604,1341,12664,12665,12666,12667,1572,12668,12669,12670,12671,1605,12672,12673,12674,12675,1606,12676,12677,12678,12679,1607,12680,12681,12682,12683,1608,12684,12685,12686,12687,1251,1604,1341,12664,12665,12666,12667,1572,12668,12669,12670,12671,1605,12672,12673,12674,12675,1606,12676,12677,12678,12679,1607,12680,12681,12682,12683,1608,12684,12685,12686,12687,1251,1604,1341,12664,12665,12666,12667,1572,12668,12669,12670,12671,1605,12672,12673,12674,12675,1606,12676,12677,12678,12679,1607,12680,12681,12682,12683,1608,12684,12685,12686,12687,1251,1604,1341,12664,12665,12666,12667,1572,12668,12669,12670,12671,1605,12672,12673,12674,12675,1606,12676,12677,12678,12679,1607,12680,12681,12682,12683,1608,12684,12685,12686,12687,1251,1604,1341,12664,12665,12666,12667,1572,12668,12669,12670,12671,1605,12672,12673,12674,12675,1606,12676,12677,12678,12679,1607,12680,12681,12682,12683,1608,12684,12685,12686,12687"

Based on this the import is working as expected it is importing the ID's to the specified custom field, are you able to attach either the theme or the plugin that is creating the checkboxes? without this i cant really offer any more help.

KL

Kitaek replied

1 year ago on December 15, 2023 at 4:18 am

First of all, thank you for your kind support. Really happy :)

 

Like in the case of ID 1800 - The Moon, the data uploaded as csv file is entered without any problem, but the checkbox in the admin screen is not activated. 

pls refer to the image of plugin-1 & plugin-2.

 

If I have a card with READING enabled manually, it works fine without breaking the design as shown below

In this case, the card ID 1782 (The Fool) is working because I manually enabled co_reading_id 1251.

https://staging14.tarotmoy.com/tarot/readings/daily-one-card/

 

However, if you don't have any cards with the reading checkbox enabled, the design will be broken.

https://staging14.tarotmoy.com/tarot/readings/celtic-cross-general/

 

pls refer to the image of plugin-3

 

Question:

Why is the checkbox not activated in the admin screen, even though it is entered as data?

If it has to be entered manually now, can't this be solved by uploading a csv via php-my-admin?

 

Plugin for this function:

https://wordpress.org/plugins/card-oracle/

 

Theme: 

https://demosites.io/craft-beer-gb/

 

Thanks!

J

James replied Support Agent

1 year ago on December 15, 2023 at 9:35 am

Thank you for letting me know the plugin, i was able to install and have created a quick plugin for you to install and activate to fix the saving of checkboxes.

KL

Kitaek replied

1 year ago on December 15, 2023 at 2:23 pm

WORKS WELL NOW. PERFECT!!!

Thank you very much for your kindness again!

J

James replied Support Agent

1 year ago on December 15, 2023 at 3:36 pm

Glad you got it working, if you need any more help just let me know.

Thanks
James

To help support the plugin i would be very grateful if you could leave a rating/review only if you want to https://wordpress.org/support/plugin/jc-importer/reviews/