Custom Fields and CSV Importing

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Tagged: upload CSV custom Field

Author

Posts
May 14, 2015 at 7:30 pm #39545

DesignGuy
Expired Member

Post count: 92

When creating a custom field type:

Which new field setting is going to be the new database “field name”? HTML Variable name? Admin label?

How to view our new db field name structure?

When importing from CSV;

Do all fields need to be included in header even if no data present?

Do fields need to be listed in any particular order?

If I have 15 fields and only data for 6, can i upload just those 6 fields only without worry about the extra ,,,,,,,?

May 14, 2015 at 9:05 pm #39555

Simone
Expired Member

Post count: 3515

the html variable name will be the name, you must append geodir_ before (e.g. geodir_customfield)

For the CSV, you can read the documentation, with the mandatory fields.
http://docs.wpgeodirectory.com/core-general/#csv
you can add extra column on the right (do not change the order of the pre-existent columns)

You can find the columns, in the database, looking at the table named wp_geodir_gd_place_details (assuming your custom post type is named gd_place)

May 14, 2015 at 10:41 pm #39563

DesignGuy
Expired Member

Post count: 92

Have read those posts but not finding exactly the point (before trashing db).

Went to PHPmyAdmin and found db and table. multi views of header and data.

There are 30+ columns, including our custom at the end. In your sample CSV, it seems obvious then that certain columns are skipped in the CSV upload.

To the question, do all columns need to be included in the CSV even if empty or Null?

If we only have the minimum required 10 fields plus 2 custom, can our CSV upload be effective and not destructive if only containing those fields 12 fields total.

What is difference between an empty cell and NULL as related to GD?

May 15, 2015 at 12:24 pm #39584

Simone
Expired Member

Post count: 3515

I believe, as long as the mandatory columns are there, you can get rid of the unnecessary columns

May 15, 2015 at 4:19 pm #39610

Paolo
Site Admin

Post count: 31206

Please do not worry about cells in the DB that are not in the CSV unless they are your custom fields.

Thanks

May 15, 2015 at 4:35 pm #39614

DesignGuy
Expired Member

Post count: 92

Got it. Would be a great feature to have the sample CSV actually read the db to produce actual template…plugin?

May 15, 2015 at 5:02 pm #39615

Paolo
Site Admin

Post count: 31206

Not sure I understand…

May 15, 2015 at 5:04 pm #39616

Paolo
Site Admin

Post count: 31206

If you mean an export feature, this is exactly what we are working on right now…

It will be in the next coming version.

You will be able to reimport too and update existing listings.

Thanks

May 20, 2015 at 12:20 am #39979

DesignGuy
Expired Member

Post count: 92

Paolo, Simone, Stiofan,

We’ve just done some work to finally CSV upload a lot of place data and have developed some tool protocols that might be beneficial to other users if documented. It covers fixing existing spreadsheet csv files that and while still using csv, a simple form creation for data entry teams and producing a new way to enter data into a csv without having to interact with the site until a large batch is completed. Using google forms, google maps, open office and GD. Best way to work with places that have middle of nowhere addresses.

May 20, 2015 at 4:43 pm #40088

Paolo
Site Admin

Post count: 31206

Hi,

Is this a php tool that works with GD?

let us know what this is about with more details, because I’m not sure I understand.

Thanks
Author

Posts