Read Our Reviews

Bold City Design is rated 5 out of 5.0 stars based on 11 review(s).

---

These guys are full of energy and great ideas.  They are local to the area and have a great reputation but also young enough to bring new technology and fresh ideas.  We had previously been working with another company on website marketing but the relationship had grown stale.  The same thing again and again and the results simply were not there.  Bold City has provided great direction and a new plan that we’re excited to see through.  I would certainly recommend them to others.

- Tess Riley

---

We hired Bold City to handle a marketing campaign for a newly released product we were rolling out.  We searched high and low before making a decision but the reviews & portfolio of Bold City coupled with cost considerations made this decision a no-brainer.  Bold City has been terrific crafting both an organic marketing campaign and PPC campaign to help drive our product sales.  While still in the early stages, we’re already seeing results and are looking forward to 2019!

- Tom Karol

---

Cabe and crew have been nothing but professional and highly organized throughout our entire website design project with them.  They had excellent recommendations in terms of content and flow of our website.  We would definitely recommend them to others.

- Mark Dawson

---

We LOVE Bold City.  If you’ve been searching for a web design company and afraid you’ll choose the wrong one, stop worrying!  You’ve found them.  Just don’t get too busy and forget about us :).

- Haley Walter

---

We’re a Jacksonville based technology company that needed to outsource a WordPress project.  A previous employee we had moved on from the company and we had nobody that understood our internal WordPress system.  Bold City really impressed me by how quickly they were able to pickup where our employee had left off.  They had several recommendations that improved our processes and made the system run better.  They were fair with pricing and will continue to be our go to company for any and all WordPress related questions or work.  Great job guys!

- Bob Turner

---

I’ve been working with Cabe on and off for nearly a decade.  We met on a mutual project and I’ve continued to keep him close due to his understanding of WordPress and ability to handle pretty much anything I throw at him custom development-wise.  Me being based in Canada, we’ve never actually met face to face but his communication skills are hard to find in a developer.  I don’t believe he’s ever missed a deadline and he’s always been willing to work with me to solve complex problems.  I can’t say enough about his ability to organize complex issues down to simple processes.  I’m sure Bold City follows his attention to detail and fulfillment of their promises.  I would recommend them to anybody.

- Kirby Sampson

---

The best of the best.  You’ve earned a client for life.  For anybody else looking, these guys know their stuff. Fast, affordable and understand that times money. 

- James McConnell

---

Can I give them 6 stars?!? These guys rock.  Local St. Augustine company that is always available when you need them.  If you’re looking for a great web design company you’ve just found it!

- Lucy Keller

---

We’re big fans of Bold City and have been since we started our website back in 2014.  Always very easy to get a hold of and give honest answers to our questions.  Fair with pricing and very reliable.  What else could you ask for?

- Mary Acumen

---

We had been with our previous web design company for nearly 5 years.  They were good but we didn’t feel like what they were doing was working.  We decided to make the switch to Bold City and the change of pace has been better than expected.  Great communication and bringing fresh ideas to our business and marketing.  If you’re looking to make change or starting a new business I would highly recommend Bold City.

- Jane Thomas

---

Trust me, your go to guys when it comes to website design.  As a general contractor, I wouldn’t call myself tech savvy.  These guys were efficient at explaining the process and delivered on every promise they made.  They know what their talking about and do great work.  Would recommend them to anybody.

- Greg Rodgers

Import CSV Data To WordPress Using Custom Plugin

Import CSV Data To WordPress Using Custom Plugin

This post was originally created on our sister site WP Cover.
View Original Article
November 30, 2018

When you start working with large WordPress sites you frequently need to update mass amounts of data.  Or in some cases add mass amounts of data.  The easiest way to do this is normally through spreadsheets.  There are a handful of plugins out there that handle common CSV importing and exporting but I’ve found many of them to be confusing, bloated and/or require different add-ons to be purchased depending on the task you need to complete.

This morning I had a task of updating every WordPress term within the custom taxonomy of ‘location’ with latitude and longitude data.  I already had the term ID, latitude and longitude stored in a neat spreadsheet but my searches for a pre-existing plugin that could handle the updating was getting me nowhere.  I’m not saying there’s not a plugin out there that will do this, but I didn’t feel like spending two hours researching, installing, re-formatting spreadsheets, receiving errors, etc. when I knew I could write my own custom plugin much quicker.  And as a bonus, it would give me a nice article to share with you.

Here It Goes:

As is the case with most plugins I create, I start with my handy framework for building a plugin to do ‘Random’ things.  From there, I modified the plugin to handle my CSV import, process the file and loop through the rows of data (beginning with row 2).  As you will see from the code, I had three rows of data in my spreadsheet, the first being the term ID, the second being the latitude coordinate and the third being the longitude coordinate.  Here is the file I uploaded in if you want to check it out.  We’re leveraging Advanced Custom Fields update_field function to update the term data within the loop.  Therefore, you’ll need to ensure that plugin is installed and activated as well.

Here is the full plugin code:

 

Import CSV Custom

Click Process button to do whatever is below in your run process.

1 && $i < 302) { $imported++; //start new import $locationID = sanitize_text_field($line_of_text[0]); $locationLat = sanitize_text_field($line_of_text[1]); $locationLng = sanitize_text_field($line_of_text[2]); $refpost = 'location_' . $locationID; update_field( 'latitude', $locationLat, $refpost ); update_field( 'longitude', $locationLng, $refpost ); echo 'Updated Term ID ' . $locationID . ' - ' . $locationLat . ', ' . $locationLng . '
'; } } } fclose($file_handle); echo 'Updated ' . $imported . ' terms'; } else { echo 'Fail'; } } ?>

Hope this helps somebody else with quick CSV imports. The base of this code could be tweaked in many ways to perform an infinite number of tasks on a WordPress database.

The post Import CSV Data To WordPress Using Custom Plugin appeared first on WP Cover.

Share Your Thoughts

FREE: 10 Step Guide To Choosing A Web Design Company

FREE: 10 Step Guide To Choosing A Web Design Company

Download your free e-book. Learn the questions you should be asking prior to partnering with a web design company. Enter your email address and we'll send it to you right away!

We've sent the e-book to your email address!