Inserting data into MagicFields using mysql queries

I had the same problem but I was successful importing from an self produced xml (for the postmeta).

<wp:postmeta>
<wp:meta_key>telefono</wp:meta_key>
<wp:meta_value><![CDATA[$tel_azienda]]></wp:meta_value>
</wp:postmeta>

The problem was that after that the data were not available to use with MF, I’ve solved it with this mysql query:

INSERT IGNORE wp_mf_post_meta (`id`, `group_count`, `field_count`, `post_id`, `field_name`, `order_id`) 
SELECT `meta_id`, 1, 1, `post_id`, `meta_key`, 1 FROM `wp_postmeta` WHERE  `meta_key` = 'mini_descrizione' OR  `meta_key` = 'imagen_en_categoria' OR `meta_key` = 'direccion' OR `meta_key` = 'codigo_postal' OR `meta_key` = 'ciudad' OR `meta_key` = 'provincia' OR `meta_key` = 'telefono' OR `meta_key` = 'email'OR `meta_key` = 'web' OR `meta_key` = 'google_map'

It copies the metas from the wp_postmeta table to the wp_mf_post_meta.

Related Posts:

  1. Importing users to Buddypress with custom fields
  2. Importing data for advanced custom fields plugin?
  3. importing data from non-wordpress mysql db
  4. Query meta field using between
  5. Move value of one custom field to another
  6. Get multiple custom field values in a $wpdb query [duplicate]
  7. Difference between ‘LIKE’ and ‘IN’ in meta queries
  8. Create Posts using Import>RSS/WXR/XML and pass values to Custom Fields
  9. little help with a mySQL query to wp database
  10. MySQL query to set wp_postmeta using term_taxonomy_id value
  11. MySQL Query that looks for post with Custom Field, then changes Category
  12. Unique Post Meta Values
  13. Add custom field to all posts in specific post_type
  14. UPDATE on SELECT results. A SQL query to swap Author with Meta Box value
  15. Importing WordPress Posts With Custom Meta Data As CSV Files Through PHPMyAdmin
  16. Copy price categories to custom field
  17. If I update WordPress my custom data will be deleted from the wp_users table?
  18. Update post meta data (custom field) by post link
  19. Help setting up a sql query
  20. Hide / Show Custom field depending of the page ID (Magic Field 2)
  21. wpdb function insert doesn’t work
  22. How to improve my non-unique metadata MySQL entries?
  23. Delete a custom field in mysql for all posts with specific category id
  24. use mysql to replace one custom field value with another custom field value
  25. Copy url from post_content to custom field
  26. Convert many posts from having a specific meta_key to use a post_format
  27. Custom Search, MySql Query Gone Wrong?
  28. Can running a WP-Cron to update_post_meta cause performance issues?
  29. Including inline Custom Fields info with add_filter in functions.php
  30. Post rating using Custom Field
  31. Inserting custom fields into new-post.php without using the Custom Fields Template plugin?
  32. If post custom meta data is not set, show normal state
  33. Creating an If/Else statement using WPAlchemy MetaBox radio boxs
  34. How can I duplicate “Add Custom Field” with just JavaScript?
  35. Sort posts after filtering them through multiple taxonomies
  36. how to have custom post template including custom write panels for the users to post
  37. How to get the value of particular get $meta value in wordpress
  38. How to retrive Custom Fields as Values for a Form field
  39. Multiple image uploader under editor?
  40. How can I display only the post titles from a selected category in columns?
  41. Display agents (custom post type) alphabetically, except one who always shows last
  42. custom field as a boolean with a checkbox?
  43. Use custom field value as href
  44. add_post_meta insert null value into Database
  45. Make Custom Fields Public in JSON – API
  46. Pagination not displaying correct number of pages
  47. Update field name without losing the value
  48. get adjacent post by meta key and meta value
  49. Custom registration form and custom field
  50. Advenced custom fields auto fill problem
  51. Cannot Hide Google Map if custom field is blank
  52. Display custom field outside the loop
  53. Adding custom field to an array
  54. How to implement jquery-ui autocomplete into custom fields?
  55. unlink() doesn’t delete the uploaded file
  56. Get single image from custom fields made with WCK custom fields creator
  57. Post count by meta_key meta_value [closed]
  58. How do i output images from URL’s added to the same custom field key
  59. Change post status by custom fields
  60. Add Custom field under the post title [closed]
  61. Display custom field value into content with hyperlink
  62. woocommerce how in checkout to add my custom field check box, and when i check it hide the shipping adress and add tax 19% [closed]
  63. Add image custom attribute [closed]
  64. how to add radio field on user meta on function.php?
  65. How can I attach files without using a plugin?
  66. Media Custom Fields – get a value with PHP
  67. Check if a field is capitalized?
  68. Retrieving custom field as shortcode
  69. Using CMB2 Plugin to create text_date metabox (datepicker) How do I save multiple dates? [closed]
  70. price calculation from custom field (woocommerce) [closed]
  71. Advanced Custom Fields for Header that are Editable from a Page [closed]
  72. Hiding custom fields when content is empty [closed]
  73. Show or hide custom fields by user’s role [frontend]
  74. Cannot save values to custom fields for variations on Woocommerce 2.4.6
  75. Website that sells statistics
  76. Send checkout page custom field in order email
  77. Custom fields doesnt work well with any postTAB plugin
  78. Colecting values from custom field checkboxes and displaying them in the post
  79. Extract array from custom field
  80. Add values of post meta fields?
  81. Build Array from Input Fields question
  82. Show div based on custom meta value
  83. How to mark a image attachment as background image?
  84. Custom field for image, not showing image!
  85. Associate an image with a post to show it in a slideshow
  86. extra post fields for url + youtube video / implementation
  87. How do delete a meta key?
  88. file upload user profile
  89. i want to send email on custom post field (job_status == 2) but it is not working
  90. Filter Query Post by Custom Fields(by date)
  91. Show only first image of multiple image field
  92. How to add google map to custom field
  93. update_post_meta based on acf repeater field
  94. Can’t sort custom column on user.php by number / meta_value_num?
  95. Foreach giving one too many list items, how can I remove the last empty line?
  96. Need to call this php function inside a modal window from text widget
  97. Custom field not showing
  98. Change Fields of Comments and make them searchable?
  99. Display filesize of custom field value
  100. I used a custom field for header image and can’t get it to show up on posts
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)