Curtis
Forum Replies Created
-
Thanks for the update, Kasia.
No problem. PHP 7.4. Thank you.
Upon reviewing this further, it seems what I need is “related post” functionality, but I would need this to be a near 100% match with specific categories (by dynamically programmed in the template).
Forum: Plugins
In reply to: [Really Simple CSV Importer] Post imports containing custom taxonomy valuesI found out how to do this. It was as simple as prefixing the cf47rs_property_location with tax_. I am having an issue however getting the value “Miami, FL” to import without WordPress breaking that out as two values during import. Any way around this?
Thanks for the clarification. I was able to find a way around this working with the theme’s developer. For anyone that is interested:
After:
$attach_id = wp_insert_attachment( $artdata, $save_path );Add:
$url = wp_get_attachment_url($attach_id); \Timber\ImageHelper::resize($url, $width, $height, $crop);You can then adjust the variables as needed and repeat the last line as needed for the additional thumbnails.
- This reply was modified 9 years, 7 months ago by Curtis. Reason: Code typo
@aurovrata / any others:
Just wondering if you might have any new info on how I might be able to handle the custom photo thumbnail names?
Thanks!
I could be wrong, but after looking at the local image sourcing further, it appears the images need to be hosted online rather than on my local system for this to work. WP All Import also has this limitation (http://www.wpallimport.com/documentation/images/local-computer/).
For the thumbnail generation, I tried this code but it is not quite what I need (I need to append the “-c-center” to the end of the file name somehow to match my list above – i.e. photo12345-1-1170×600-c-center.jpeg, photo12345-1-1740×960-c-center.jpeg, photo12345-1-270×180-c-center.jpeg):
//generate metadata and thumbnails, comment this out if you don't want thumbnails if ($attach_data = wp_generate_attachment_metadata( $attach_id, $save_path)) { //wp_update_attachment_metadata($attach_id, $attach_data); add_image_size( '1170×600', 1170, 600, array( 'left', 'top' ) ); // 1170×600 add_image_size( '1740×960', 1740, 960, array( 'left', 'top' ) ); // 1740×960 add_image_size( '270×180', 270, 180, array( 'left', 'top' ) ); // 270×180 }Is it possible to do this somehow?
Thank you
@aurovrata
Thanks very much for this code. I tried using this and it failed, so seeing your last comment in your reply, I had another look at my CSV file. It seems that I cannot use http://localhost/… in the photo URLs. I uploaded the photos elsewhere via a http://www.mydomain.com address and the photos successfully uploaded and became associated with my post then.Just a few small concerns/questions below I was wondering about?
Concern #1- Is there a way that I can force the system to import from my local system, either from a local C:\ path, or via http://localhost/… ?
Concern #2-
In my FTP client, when I looked at the imported_cf47rs_images/ directory on my server, I saw the files as:
photo12345-1.jpeg
photo12345-2.jpeg
photo12345-3.jpeg
photo12345-4.jpegThis is expected behavior as I commented out the thumbnail generation code at the end of your code. When I performed a subsequent import to test the re-write function, I saw the same list (expected). However, I found a slight issue when after importing, if I go to my post and refresh the page, the system generates thumbnails. The list then becomes:
photo12345-1-1170×600-c-center.jpeg
photo12345-1-1740×960-c-center.jpeg
photo12345-1-270×180-c-center.jpeg
photo12345-1.jpeg
photo12345-2-1170×600-c-center.jpeg
photo12345-2-1740×960-c-center.jpeg
photo12345-2-270×180-c-center.jpeg
photo12345-2.jpeg
photo12345-3-1170×600-c-center.jpeg
photo12345-3-1740×960-c-center.jpeg
photo12345-3-270×180-c-center.jpeg
photo12345-3.jpeg
photo12345-4-1170×600-c-center.jpeg
photo12345-4-1740×960-c-center.jpeg
photo12345-4-270×180-c-center.jpeg
photo12345-4.jpegIn the WordPress Dashboard, in Settings > Media, I have the following settings:
Thumbnail size – Width: 0, Height: 0, Crop thumbnail… (unchecked)
Medium size – Max Width: 0, Max Height: 0
Large size – Max Width: 0, Max Height: 0
Uploading files – Organize my uploads into month… (unchecked)Perhaps the thumbnail generation is happening from code in the theme? If so, is there a way you know that can force prevent thumbnails from getting generated at the theme level?
——
Update: for the last question, some people might be interested in this, but I just saw these additional images are needed for my theme to work correctly. Do you know of a way I can generate these specific thumbnails during import as well?If I use your code as is, it generates thumbnail as follows:
photo12345-1-768×576.jpeg
photo12345-1.jpeg
photo12345-2-768×576.jpeg
photo12345-2.jpeg
photo12345-3-768×576.jpeg
photo12345-3.jpeg
photo12345-4-768×576.jpeg
photo12345-4.jpegAnd upon going to my post and refreshing, the system retains these thumbnails, in addition to generating the ones needed for my theme.
Thanks again!
I ran the debugger script at https://gist.github.com/hissy/7175656 and noticed this output (partial provided to save space):
$is_update: bool(true) $post: array(9) { ["post_type"]=> string(15) "cf47rs_mypostsample" ["ID"]=> string(7) "123456789" ["post_name"]=> string(34) "Post name here" ["post_author"]=> int(3) ["post_date"]=> string(19) "2015-01-01 00:00:00" ["post_status"]=> string(7) "publish" ["post_title"]=> string(36) "1 Main Street, City, ST 12345" ["post_content"]=> string(892) "Content here..." ["post_category"]=> array(1) { [0]=> string(2) "97" } } $meta: array(18) { ...various here... ["field_cf47rs_mypostsample_add_to_gallery"]=> string(0) "" ["cf47rs_map_location"]=> string(92) "address|1 Main Street, City, ST 12345, United States||lat|40.123456789||lng|-70.123456789" ["_cf47rs_map_location"]=> string(34) "field_cf47rs_property_map_location" ["photo_count"]=> string(2) "18" ["cf47rs_images"]=> array(0) { } ["_cf47rs_images"]=> string(27) "field_cf47rs_gallery_images" ["field_cf47rs_mypostsample_tour"]=> string(0) "" } $tax: array(0) { }@aurovrata
I have removed the add-on plugins and placed your code at the end of my theme’s functions.php file. I ran the import again and there were no errors after the import, but the images did not upload and the value in the database for cf47rs_images appeared as “a:0:{}” (without quotes). I entered the photo values in my import exactly as “http://localhost/websitename/photos/photo12345-1.jpg|http://localhost/websitename/photos/photo12345-2.jpg|http://localhost/websitename/photos/photo12345-3.jpg” (without quotes) without luck. I then tried with quotes around this, and that did not work. Do you have any other suggestions I can try? Thanks!@aurovrata
Thanks for your detailed reply. I unfortunately ran into some issues. I am assuming that it is okay to add this code as another custom add-on plugin? If so, I created this as #1 below.Custom Image Uploader (Really Simple CSV Importer add-on)
This is the same code you provided in your reply.I also have these add-ons:
Divide Meta Fields with Comma (Really Simple CSV Importer add-on)
add_filter('really_simple_csv_importer_save_meta', function($meta, $post, $is_update) { foreach ($meta as $key => $value) { if (strpos($value, ',') !== false) { $_value = preg_split("/,+/", $value); $meta[$key] = $_value; } } return $meta; }, 10, 3);Divide Meta Fields with Double-pipe (Really Simple CSV Importer add-on)
add_filter('really_simple_csv_importer_save_meta', 'address_to_array',10,3); function address_to_array($meta, $post, $is_update){ $address = $meta['cf47rs_map_location']; $address = explode('||',$address); $meta_arr = array(); foreach($address as $sub){ $sub = explode('|',$sub); $meta_arr[$sub[0]] = $sub[1]; } $meta['cf47rs_map_location'] = $meta_arr; return $meta; }My data for the cf47rs_images column is in the format:
http://localhost/mysite/photos/photo1234567-1.jpeg|http://localhost/mysite/photos/photo1234567-2.jpeg|http://localhost/mysite/photos/photo1234567-3.jpeg|http://localhost/mysite/photos/photo1234567-4.jpeg|http://localhost/mysite/photos/photo1234567-5.jpegWhen I import the .csv file, I get the following error (repeated for each record):
Warning: strpos() expects parameter 1 to be string, array given in /home/myaccountname/public_html/mydomain.com/wp-content/plugins/divide-meta-fields-with-comma/divide-meta-fields-with-comma.php on line 7 Warning: preg_split() expects parameter 2 to be string, array given in /home/myaccountname/public_html/mydomain.com/wp-content/plugins/divide-meta-fields-with-comma/divide-meta-fields-with-comma.php on line 8 Warning: explode() expects parameter 2 to be string, array given in /home/myaccountname/public_html/mydomain.com/wp-content/plugins/divide-meta-fields-with-double-pipe/divide-meta-fields-with-double-pipe.php on line 14 Warning: Invalid argument supplied for foreach() in /home/myaccountname/public_html/mydomain.com/wp-content/plugins/divide-meta-fields-with-double-pipe/divide-meta-fields-with-double-pipe.php on line 16 Processing "123 Main Street, City, ST 12345" done.When I the database record, I do not see any of the images referenced (URL, path, or IDs) and no images are uploaded to /public_html/mydomain.com/wp-content/uploads/imported_cf47rs_images
…although the “imported_cf47rs_images” directory was created.`Do you have any suggestions on how I can approach this issue? Thanks!
@aurovrata
Thanks for your reply. The challenge I have now is that I only found a way to associate images previously uploaded to WordPress’s library with my posts. In a test, I noted the image IDs and stored them in a custom field (cf47rs_images). For example, “107, 204, 301”. When I import, the plugin “Divide Meta Fields with Comma (Really Simple CSV Importer add-on)” converts this to an array and the post successfully displays the images in my post…What I would like to do is in the “cf47rs_images” field, reference something like “http://localhost/websitename/photos/photo12345-1.jpg, http://localhost/websitename/photos/photo12345-2.jpg, http://localhost/websitename/photos/photo12345-3.jpg” and during import, have WordPress upload these and store the IDs automatically.
– The photos themselves can change over time, but the filenames will not, so I would like to prevent creating duplicates (if possible). It is okay to overwrite existing files however (preferred, in case photos get updated).
– I just need the full size photos (no need for multiple size variations that WordPress generates).I am running a local server and using “http://localhost/…” in the image names hoping that this can be a ‘trick’ to make WordPress think it is an external image. I know some import scripts can automatically upload external images from a URL and reference the image IDs.
Any help with this would be greatly appreciated — thanks!
- This reply was modified 9 years, 7 months ago by Curtis.
Update: I was able to get this to work. In the custom plugin code, I actually had to reference “cf47rs_map_location” instead. For the support mapping requirement mentioned by the theme developer, I created another column, “_cf47rs_map_location” and filled that with “field_cf47rs_property_map_location”. Seems to work great now. Thanks everyone for your patience and help with this!
Thanks @mjjojo for your feedback. I have deactivated unnecessary plugins and have the “Really Simple CSV Importer” plugin installed/active, along with the “Divide Meta Fields with Double-pipe (Really Simple CSV Importer add-on)” plugin.
When I import data in the format (on one line):
12 Main Street, City, ST 12345, USA||lat|40.123456789||lng|-73.123456789
that gets imported without changes. I have tried importing to cf47rs_map_location and cf47rs_property_map_location without luck.I am not sure I am approaching this correctly (for a CSV import), but this is from the theme developer if it helps:
To create a valid location entry, you should create these 2 meta fields:
1. “cf47rs_map_location” field with serialized array of the following values (example)Array( [address] => 12 Main Street, City, ST 12345, USA [lat] => 40.123456789 [lng] => -73.123456789 )2. Map the “cf47rs_map_location” field to the global meta field identifier “field_cf47rs_property_map_location”
In XML format it looks like this:
<wp:postmeta> <wp:meta_key><![CDATA[cf47rs_map_location]]></wp:meta_key> <wp:meta_value><![CDATA[a:3:{s:7:"address";s:36:"12 Main Street, City, ST 12345, USA";s:3:"lat";s:17:"40.123456789";s:3:"lng";s:16:"-73.123456789";}]]></wp:meta_value> </wp:postmeta> <wp:postmeta> <wp:meta_key><![CDATA[_cf47rs_map_location]]></wp:meta_key> <wp:meta_value><![CDATA[field_cf47rs_property_map_location]]></wp:meta_value> </wp:postmeta>Thanks for any additional help you can provide 🙂
PS: Serialization is not correct in the code, but provided as an example.
Hi Aurovrata, thanks for your detailed reply. I unfortunately only have a very basic programming background so I was unable to follow after the data format advice. Can you please explain where I can reference the filter hook and the code snippet you provided? Thanks again!
