chrisvallleyoc

It looks like they trying to go into custom meta fields when menu_order and post_parent are standard fields in the wp_posts database:

wp_posts:

post_parent: bigint(20) unsigned
menu_order: int(11)

I see the fields now but everything I upload is putting “0” into the db for both those fields. I can give you admin access if it helps? Here is the debug code:

Array
(
    [post_id] =>
    [function] => wp.newPost
    [args] => Array
        (
            [post_title] => Test Product
            [post_type] => product
            [terms_names] =>
            [terms] =>
            [custom_fields] => Array
                (
                    [0] => Array
                        (
                            [key] => post_parent
                            [value] => 19725
                        )

                    [1] => Array
                        (
                            [key] => menu_order
                            [value] => 1337
                        )

                    [2] => Array
                        (
                            [key] => sku
                            [value] => 999.0000
                        )

                    [3] => Array
                        (
                            [key] => regular_price
                            [value] => 5
                        )

                )

            [post_status] => publish
            [post_author] =>
            [post_password] =>
            [post_excerpt] =>
            [post_date] =>
            [post_date_gmt] =>
            [post_thumbnail] =>
            [comment_status] =>
            [ping_status] =>
            [post_format] =>
            [enclosure] =>
            [post_parent] =>
            [menu_order] =>
        )

)
POST /dev13378919841/wp-content/plugins/supraCsvPremium//xmlrpc/supra_xmlrpc.php HTTP/1.0
Host: www.orthoclassic.com
Content-Type: text/xml
User-Agent: The Incutio XML-RPC PHP Library
Content-Length: 2464

<?xml version="1.0"?>
<methodCall>
<methodName>wp.newPost</methodName>
<params>
<param><value><string></string></value></param>
<param><value><string>admin</string></value></param>
<param><value><string>d9$67rtg</string></value></param>
<param><value><struct>
  <member><name>post_title</name><value><string>Test Product</string></value></member>
  <member><name>post_type</name><value><string>product</string></value></member>
  <member><name>terms_names</name><value><string></string></value></member>
  <member><name>terms</name><value><string></string></value></member>
  <member><name>custom_fields</name><value><array><data>
  <value><struct>
  <member><name>key</name><value><string>post_parent</string></value></member>
  <member><name>value</name><value><string>19725</string></value></member>
</struct></value>
  <value><struct>
  <member><name>key</name><value><string>menu_order</string></value></member>
  <member><name>value</name><value><string>1337</string></value></member>
</struct></value>
  <value><struct>
  <member><name>key</name><value><string>sku</string></value></member>
  <member><name>value</name><value><string>999.0000</string></value></member>
</struct></value>
  <value><struct>
  <member><name>key</name><value><string>regular_price</string></value></member>
  <member><name>value</name><value><string>5</string></value></member>
</struct></value>
</data></array></value></member>
  <member><name>post_status</name><value><string>publish</string></value></member>
  <member><name>post_author</name><value><string></string></value></member>
  <member><name>post_password</name><value><string></string></value></member>
  <member><name>post_excerpt</name><value><string></string></value></member>
  <member><name>post_date</name><value><string></string></value></member>
  <member><name>post_date_gmt</name><value><string></string></value></member>
  <member><name>post_thumbnail</name><value><string></string></value></member>
  <member><name>comment_status</name><value><string></string></value></member>
  <member><name>ping_status</name><value><string></string></value></member>
  <member><name>post_format</name><value><string></string></value></member>
  <member><name>enclosure</name><value><string></string></value></member>
  <member><name>post_parent</name><value><string></string></value></member>
  <member><name>menu_order</name><value><string></string></value></member>
</struct></value></param>
</params></methodCall>
transport error - HTTP status code was not 200Problem Ingesting Test Product

This should clearly be a setting for the plugin. Anyone figure out a fix?

Where do you put the code to make the caption part work? I’m having the same problem.

Thanks Geoff, Appreciate the fix!

That helps a lot. Opening the csv in notepad and saving it as UTF-8 fixed the problem. Thanks!

Thanks for the help. It works like a charm now. Marked resolved and 5 star rating!

One things to note:
-I had some degree symbols, trademark symbols, and reserved mark symbols in the content and title fields that the ingestion process didn’t like. It wasn’t a big deal to take them out, but I wasn’t sure how to get them to come through. Perhaps they need to be escaped somehow?

I’m not sure what the last working version was. It was from a while back (weeks, possibly a month or more). Got it to work, then the website was put on hold for a while before I needed it again so I upgraded the plugin. I set up a user for you and emailed the info.

Thanks for the help.

Yeah, no problem. What’s an email address I can send it to?

It uploads now but wont ingest. The file shows up to ingest but no button to click, only the drop-down appears. Also the “Preview/Download” displays this error:

Warning: fopen() [function.fopen]: https:// wrapper is disabled in the server configuration by allow_url_fopen=0 in /wp-content/plugins/supra-csv-parser/classes/UploadCsv.php on line 112