WordPress.org

1. Kai_Schuerrer
   Member
   Posted 7 months ago #
   

   As mentioned in another thread:

   Hello Ryan,

   just tested your workaround. I changed one field of one record in the db.

   Put all update flags in csv2post backend to "on" - but nothing happened.

   After that I trigger a "manual update" of the post by it´s id (2337)

   Now some strange behaviour:

   This post (id 2337) was updated to a new data-set from the db - I check it out - it was the next unused dataset.

   The old dataset (with my change) was not used. So now the old dataset has no more correspondening post on my blog :-(

   in the csv2post table the old dataset is still referenced to post 2337, but the content of 2337 is completely false.

   Now i generated 5 new posts:

   The first new post has the same content as my updated post 2337.

   Argl....

   Maybe you can fix this :-)

   Best regards,
   Kai

   http://wordpress.org/extend/plugins/csv-2-post/

2. WebTechGlobal
   Member
   Plugin Author
   Posted 7 months ago #
   

   Kai thanks for your help, seen the response you gave to other users.

   This is a strange one. What column was it you edited, I assume it was not a key/ID value column? The MySQL UPDATE query will update the record which holds the value in the WHERE part of the query. That value is usually unique. What your saying would need 2 CSV rows to have the same ID value, if things were working properly.

   I can't think how this could happen so it could take a while to track down. There is more manual ability in updating, coming in next version. So hopefully those recent improvements help.

   Suppose this one needs to stay Un-Resolved for now :) Could take a while to confirm the issue.

3. Kai_Schuerrer
   Member
   Posted 7 months ago #
   

   Hello Ryan,

   thanks for your answer. Maybe I don´t use the function in the correct way

   Never read the manual ;-)

   My approach was to change one field of one row by doing an update with phpmyadmin.

   I only changed the ZIP Code of one town.

   After that I start a manual update of the post by entering its WP id in the manual update field.

   The post was updated, but not to its new zip code. A completely new unused record was used to populate the post.

   After that I generate 5 new posts and the same dataset was used again for a new post.

   After that I had a look in the table and found:

   The reference to the old post was still there and unchanged.
   The content of the post in WP was NOT the content of the data row.

   The reference of the new post was correct to the new post with the content. The same content was on the old post.

   Strange!

   If you want I can grant you access to my live server to check it there..

   Regards,
   Kai

4. WebTechGlobal
   Member
   Plugin Author
   Posted 7 months ago #
   

   I done some work on the Update Specific Post procedure. Great improvement and a fix that should only update a post using the record used to make it.

   If that record for any reason, no longer exists. A warning will be displayed. Zara has been running some tests and found using this panel always done what it should now.

   Kai make sure you get a copy of the next premium edition version from me. Thanks a lot for bringing this one to my attention.

5. Kai_Schuerrer
   Member
   Posted 7 months ago #
   

   Hello Ryan,

   I will look forward to get the copy of premium edition by email.

   I´m curious right now to test all the new functions!

   thank you again!

   Regards,
   kai

Reply

You must log in to post.