importing CVS question re: custom field
This topic contains 8 replies, has 3 voices, and was last updated by James Barker 7 years, 4 months ago.
We have moved to a support ticketing system and our forums are now closed.
Open Support Ticket-
AuthorPosts
-
November 13, 2017 at 3:21 am #405010
I began collecting my data before downloading GeoDirectory and searched the forums for column headers to use as an example. Now that I’m preparing to upload several thousand listings, I’ve exported a CVS from the dummy data and realized I have an additional category to implement between post_country and post_zip. How do I go about adding this? I was able to add the “pricing” component that I needed and placed it accordingly in the “add new Place listing form,” which I assume will create the necessary column in the export, but am unsure how to go about adding a new category. Other than city, region (state), country and neighborhood, I need to create something like “Casino.” Further to that end, is there a way (or how might I) set-up a casino as a “parent” with numerous child-listings (e.g., many of the casinos/resorts will have anywhere from a handful to dozens of restaurants and bars located within them.)
Thanks!
Jim
November 13, 2017 at 4:34 am #405015Hello!
Each CPT (places is also a CPT) has a set of categories. Click on “Places” in the WP admin on t he left side to select place categories > Add category. Add a category there, and then add the category to a simple listing sample. Then do your export of places again to see where you category ends up in the CSV.
You can have parents and children in the categories, and select both or one or the other, but the first listed in the CSV will be the ‘default’ category of the listing.
Any custom field that you add to the CPT will also be included in the export. You don’t have to use only categories, you can also add custom fields. Categories are slightly different than custom fields, though, because all your categories must exist prior to importing the listings.
Locations are not categories, they are the location data retrieved from the Geocoding API you choose to use on your site, either Google Maps or OpenStreetMap. You should definitely add one or more listings with locations, or use the sample data, to see how locations and location data are stored in the CSV.
There is not an exact concept match if you are looking for parent ‘listings’ except for the franchise plugin, but that is designed for a single business with multiple locations, not a single site with multiple businesses at that site/location.
Let us know if you have further questions
November 13, 2017 at 4:11 pm #405097Wasn’t quite what I was looking for with adding categories, but I got it working this morning using your suggestion to add and then export to see where they were – I just did it with the new form field and it worked. Thanks!
November 13, 2017 at 4:40 pm #405098Great!
Let us know if you have more questions!
November 13, 2017 at 4:51 pm #405100I do! Please see attachment: I thought perhaps removing the default $ sign in one of the fields would prevent the $ to show up before pricing as shown. Is there a place/way to remove it? It’s kind of redundant to have it before pricing and then dollar signs after. Thanks!
November 13, 2017 at 6:23 pm #405127Hi James,
if you provide a link so that we can inspect the page, we can provide the css needed to hide it.
Let us know,
Thanks
November 13, 2017 at 6:34 pm #405129Hi Paolo,
Sure thing. Here’s a link to one of the details page where it shows on the sidebar:
Also, is there a way to have the first line of the address default to the following so that it reads as such:
Address:
5757 Wayne Newton Blvd
Las Vegas
NVThat way everything justifies left and looks cleaner (or perhaps tab the rest of the address lines to match the top line).
Thanks!
November 13, 2017 at 8:10 pm #405135This should help with both things
You can add it to GeoDirectory > Design > Scripts > Custom CSS:
.geodir_price .fa.fa-usd { display: none; } .geodir-i-location { display: block; }
November 13, 2017 at 8:30 pm #405137Thanks, worked like a charm!
-
AuthorPosts
We have moved to a support ticketing system and our forums are now closed.
Open Support Ticket