Steve Borsch
Forum Replies Created
-
Forum: Plugins
In reply to: [IMPress Listings] Import a CSV File to Create ListingsLiterally just got done doing this and spent HOURS and HOURS on it. Hopefully I can give you some pointers…though I’m still jammin’ on the site build so won’t have much of any followup.
Unfortunately I was unable to find any free plugins that allow a WP exported xml file to be imported in to a custom post type like WP Listings delivers. There is also a lack of free CSV importing plugins to do the same thing…all the csv importers have commercial versions to buy if you need to import in to a custom post type.
**IMPORTANT**
Make certain you backup the database right before trying an import. We made a backup which we used at least 25 times until we got the import perfect. If we goofed one up we’d delete all database tables in phpmyadmin and upload that database backup. Try again, goofed up again, delete again and upload again.So anyhow, here is my adventure in a nutshell:
Project: Moving a client site, which displays over 1,000 properties which were posts, and import them in to WP Listings using a new, mobile responsive theme (Studiopress’ AgentPress).
Steps:
1) Cloned the site and database for the new site in to a subdirectory. The property posts (which were just posts) used postmeta in the old theme to store all the stuff WP Listings stores in its postmeta, so now it didn’t display in the new theme. We needed to get those posts in WP Listings so they’d have all data displayed as well as looking great.
2) I first off did buy the commercial plugin called “WP All Import Pro” and they were really great and responsive…but importing custom fields from the WordPress XML export was REALLY tricky. Since it was tough to programmatically bring in postmeta consistently — the numeric keys change post-by-post — so the data didn’t come in consistently and go in to the correct fields. They did help out with support tickets and we tried and tried their suggestions in a bunch of different ways, but I decided we needed “cleaner” data first and then we could use WP All Import to bring in the csv data.
3) Using phpmyadmin, I exported ONLY the property posts. Tried a buhc of different SQL queries I found via Google, but ended up getting a lot of tips and ideas from the video here.
4) That resulted in the data I could use and put into a spreadsheet which I could then save as a .csv. Here is an Excel template I made of the fields you need.
(Note that I put some data in so you can see that I added my own WP Listings taxonomy types, including one called ‘Market Rate Rentals’, and used “Listing Price” and other fields for stuff like phone number and website. You can even add text or HTML as post content if you don’t have any for some posts).
5) Copied the “single-listing.php” template from WP Listings in to my theme’s folder and modified it so some custom field names in WP listings display different data like the Website, Phone and Email (see #6 below). Here is my modified version so you can see the changes I made to the original.
6) Modified the *display* of the field names in WP Listing’s “Details” tab by adding this code to my theme’s functions.php file:
# Add filter for listing details add_filter( 'wp_listings_property_details', 'custom_wp_listings_details'); function custom_wp_listings_details() { $property_details_columns = array( 'col1' => array( __( 'Address:', 'wp_listings' ) => '_listing_address', __( 'City:', 'wp_listings' ) => '_listing_city', __( 'State:', 'wp_listings' ) => '_listing_state', __( 'ZIP:', 'wp_listings' ) => '_listing_zip', __( 'Phone:', 'wp_listings' ) => '_listing_mls', ), 'col2' => array( __( 'Website:', 'wp_listings' ) => '_listing_year_built', __( 'Email:', 'wp_listings' ) => '_listing_floors', ), ) ; return $property_details_columns; }
7) Now that all the data was ‘clean’ in the spreadsheet, I exported it as a .csv and then I imported it using WP All Import Pro. It worked!! Everything went in to the correct fields. Phew.
Hope this helps.
Forum: Plugins
In reply to: [Timely All-in-One Events Calendar] Change Read More Link in Agenda ViewHi Nicola — You didn’t answer luccisa’s question though. While one IS able to create a new child theme, agenda.twig does NOT contain the button code to change.
It would be extremely helpful if you could specify exactly how to achieve changing ‘Read More’ to something else.
This is the current agenda.twig code:
<a class="ai1ec-read-more ai1ec-btn ai1ec-btn-default ai1ec-load-event" href="{{ event.permalink | e('html_attr') }}"> {{ text_read_more }} <i class="ai1ec-fa ai1ec-fa-arrow-right"></i> </a>
This is what I tried but it didn’t work:
<a class="ai1ec-read-more btn" href="<?php echo esc_attr( get_permalink( $event->post_id ) . $event->instance_id ) ?>"> <?php _e( 'Learn More & Register', AI1EC_PLUGIN_NAME ) ?> <i class="icon-arrow-right"></i></a>
So can you be a bit more specific? Thanks!
Forum: Plugins
In reply to: [WP Power Stats] SUCURI MALWARE "CRITICAL" WARNINGThanks for the reply, but I solved this a long time ago.
BTW, we developers out here make business decisions on which plugins to support based on your responsiveness. Just sayin’…
Forum: Plugins
In reply to: [Simple Lightbox] errors in log, maybe theme related?I, too, am receiving dozens of errors per day like this:
mod_fcgid: stderr: PHP Strict Standards: Only variables should be assigned by reference in /var/www/vhosts/accessdomain.com/mydomain.com/wp-content/plugins/simple-lightbox/includes/class.field_collection.php on line 543
Jquery Check shows the page is loading 1.11.1 so all should be good. Here is an example page: https://trendcurve.com/trend/place-settings/
Too bad no one answered you in *10 months*, but if anyone else needs to know how to do this here’s the code to add to your theme’s CSS:
.click_more_each_categories { display: none!important; }
This will turn off the “No more products to view in this category” sentence.
Forum: Plugins
In reply to: [Multi Rating] Activating star rating to complicatedHi Daniel,
Let me echo Florian’s request since it is simply not intuitive for the user to have to first click the no entry sign.
Does the Pro version of the plugin already include the option to have all rating stars empty to start, so the user can hover over and select their rating?
Forum: Plugins
In reply to: [Dropdown multisite selector] {dms} works only once per page…Thank you alordiel! Works perfectly.
Forum: Plugins
In reply to: [Dropdown multisite selector] {dms} works only once per page…Also, same thing happens when I use the widget instead. Only the first instance on the page, any page, works.
Forum: Plugins
In reply to: [Genesis Simple Sidebars] Erro: Illegal string offsetNicely done Nick. Thanks!
By the way, you are getting quite a rep on the MSP WordPress GGroup as Mr. Helpful and I know *I* really appreciate all of your contributions…and now here too?
Guess I need to buy a Nick Ciske Action Figure. Know where I can get one? ??
Forum: Plugins
In reply to: [Genesis Simple Sidebars] Erro: Illegal string offsetBluehost upgraded PHP to 5.4.20 today (yes, one day before a MAJOR HOLIDAY) and maybe Apache. Took sites down all over their hosting but also impacted we dedicated server folks too.
This error happened to me too. The fix worked too and sidebars appear as they did with the widgets assigned to them, but now cannot see sidebar names nor add/subtract widgets from any Simple Sidebars in wp-admin.
Am not a php guy but I’m betting there is a new php array call that needs to be tweaked. Whaddya think Ron?
These guys have answered zero of their support requests in the last two months too.
Kind of tells you something about the quality and support of the plugin, heh? I’d look for something else (which I am).
Forum: Plugins
In reply to: [Connections Business Directory] Your site gives off a 504 timeout error“So that meant my large demo directory was being run, but not shown, no less than six times on the page.”
How funny! I’ll head back over and look at what to buy first thing tomorrow morning.
Forum: Plugins
In reply to: [Spots] Edit SpotThe 1.1.7 update did NOT fix this issue. Also, where exactly does the “0” value go in this string below?
function cache_time_field() { echo '<input type="text" name="spots_cache_time" value="' . get_option( 'spots_cache_time', SPOTS_CACHE_TIME ) . '" />'; echo '<p class="description">' . __( 'Enter an amount of time in seconds to cache spots for. Set to 0 to turn the caching off, recommeneded if you use a caching plugin.' ) . '</p>'; }
Forum: Plugins
In reply to: [Spots] Edit SpotDoh…just saw the update included a fix so we’re all set!
Forum: Plugins
In reply to: [Spots] Edit SpotThanks Su. Just opened icit-spots.php and it *is* set to 0 so I’ll have to wait until the Spots dev fixes it.