Importing data (generic excel spreadsheet into v2)

This topic contains 1 reply, has 2 voices, and was last updated by  Paolo 6 years ago.

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

Open Support Ticket
  • Author
    Posts
  • March 28, 2018 at 1:16 pm #423805

    David Sirius
    Expired Member
    Post count: 163

    Hi

    Given the beta status at the moment, I have postoponed any design work streams until the final version is out and am focusing on content only.

    I’m currently putting together the content / listings in Excel and would need to know how I would have to format the spreadsheet so that the file can be imported later. In v1 I have, in addition to the general listing data (name, address, etc), c. 40 custom fields for each listing..

    I presume the best way would be
    (1) create all these custom fields in the beta to give GD a template structure,
    (2) export the data to a csv (?) file which will have the above template structure by way of headings
    (3) copy and paste all the content from the existing xlsx spreadsheet into the csv file and arrange data to respective columns

    Would that be a possible and the best approach?

    Thanks
    David

    March 28, 2018 at 5:42 pm #423849

    Paolo
    Site Admin
    Post count: 31206

    You shouldn’t be using excel at all, it’ll add unnecessary format to your cells that will break import. You should use Open Office or similar like explained in the docs for import that are valid for V2 too.

    https://wpgeodirectory.com/docs/core-export/

    Your procedure is correct, except copying and pasting from a xls file that is a big no no.

    Thanks

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)

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

Open Support Ticket