40% OFF EVERYTHING
Our 10th BIRTHDAY SALE
Buy Now

Import Issue – Missing fields

This topic contains 31 replies, has 2 voices, and was last updated by  Guust 5 years, 3 months ago.

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

Open Support Ticket
  • Author
    Posts
  • January 12, 2019 at 11:20 am #462879

    Kai Liu
    Expired Member
    Post count: 368

    I did my whole site data import in 8 CPT each has more than 10 categories all like this. Never manually created category at all. Otherwise, I would not raise this issue.

    This automated method save me lot of time to create categories, match cat ID, and need to save them for data processing.

    Opss, I cannot submit CSV here.

    Cheers

    January 12, 2019 at 12:09 pm #462881

    Guust
    Moderator
    Post count: 29970

    Interesting … you are right. That may have been a later addition I was not aware of, and you still need to update them. Probably therefore we also stated to create them first because it created problems for people.

    January 12, 2019 at 12:30 pm #462883

    Kai Liu
    Expired Member
    Post count: 368

    I understand what you are saying, such as mis-spelling causing trouble. However. if mis-spelling happened, it will create a new category and will not lost any data. When checking CP category section, we can easily detect this. the extra work to correct mis-spelling category is much quicker than creating categories and try to match Cat ID in source files.

    Especially for the projects I am working on, CTP will be 30-40, each has over 20 categories.

    If V2 cannot create category while importing, I think I will wipe out this V2, and put V1 back on.

    Just checked performance of V1 and V2 using GTmetrix, V1 has 200k records loaded, while V2 is currently empty. Huge difference in performance too.

    January 12, 2019 at 1:50 pm #462894

    Guust
    Moderator
    Post count: 29970

    It is easy to import categories first with the categories CSV.

    PS: V1 will one day become obsolete …

    January 12, 2019 at 5:45 pm #462938

    Kai Liu
    Expired Member
    Post count: 368

    How about upgrading V1 to V2? How safe to do upgrade?

    January 12, 2019 at 5:52 pm #462939

    Kai Liu
    Expired Member
    Post count: 368

    For category import, can I leave highlighted fields in blank and do those in GD settings?

    can we specify category ID ourself or have to leave it blank for system to assign?

    January 12, 2019 at 6:01 pm #462941

    Kai Liu
    Expired Member
    Post count: 368

    for cat image and marker, will full path be automated? sample file shows only file name.

    January 12, 2019 at 11:05 pm #462971

    Guust
    Moderator
    Post count: 29970

    How about upgrading V1 to V2? How safe to do upgrade?
    https://wpgeodirectory.com/docs-v2/geodirectory/installation/#convert

    For category import, can I leave highlighted fields in blank and do those in GD settings?
    Yes, they are not required.

    can we specify category ID ourself or have to leave it blank for system to assign?
    You must allow WP to assign IDs itself.

    for cat image and marker, will full path be automated? sample file shows only file name.
    You will have to import the images as per the message when you import the categories.

    Thanks

    January 13, 2019 at 4:06 am #462984

    Kai Liu
    Expired Member
    Post count: 368

    Thanks. I will try that.

    Final question, just to reconfirm if I can import category by CPT, and not doing all the CPT all at once?

    January 13, 2019 at 5:27 am #463000

    Guust
    Moderator
    Post count: 29970

    You can do as many or as few categories at the time, in one or more CPTs.

    January 13, 2019 at 10:02 am #463004

    Kai Liu
    Expired Member
    Post count: 368

    you convince me to continue using V2. I did actually wipe out the site I was working on and put GDv1 back on. However, I did clean backup (without content) for GDv1 and V2. lucky. I can easily wipe it out again and put V2 back on to the stage I was. I can easily switch between V1 and V2 as long as no data has been loaded yet.

    Thanks Guust.

    January 13, 2019 at 10:05 am #463005

    Kai Liu
    Expired Member
    Post count: 368

    There are post_category and default category field. What do we set on default one?

    Also, when I check database table, the post category value looks like “,77,” why are there commas in post_category value? If I make category CSV, do I just use a figure value (cat id)? can I leave default_category blank?

    You also mentioned that WP assign Cat ID, so cat ID should be NULL too. right?

    January 13, 2019 at 11:32 am #463006

    Guust
    Moderator
    Post count: 29970

    I can easily switch between V1 and V2 as long as no data has been loaded yet.
    I doubt that, because V1 and V2 use a different database structure, that is why you need to convert from V1 to V2, not just change plugins.

    There are post_category and default category field. What do we set on default one?
    In default category you should have one of the categories you add in the categories column.

    Also, when I check database table, the post category value looks like “,77,” why are there commas in post_category value?
    In case a listing is in more than one category.

    If I make category CSV, do I just use a figure value (cat id)? can I leave default_category blank?
    There is no default_category in the category CSV, so I guess you are asking if you can leave default_category blank in the Listings CSV. You can leave it blank, but that is required to determine which icons to use on the map etc, so highly recommended to add a cat ID in default_category.

    You also mentioned that WP assign Cat ID, so cat ID should be NULL too. right?
    You must leave that column empty, ie put nothing in it. NULL is not a valid value for a cat ID.

    January 13, 2019 at 2:46 pm #463010

    Kai Liu
    Expired Member
    Post count: 368

    Thanks Guust,

    I switched V1 back to V2 now. I use plugin to backup the whole site including WP.

    To switch, delete everything in folder, and FTP installer backup zip to folder and run its installer.php to overwrite the whole DB and bring back the whole lot, WP, GD, plugins, settings, media, post etc. Not switching plugin alone.

    In future, I can build a ready to go directory project in 30 mins with everything setup, if need to. Just need to change site title and logo.

    Thanks for you help.

    January 13, 2019 at 10:37 pm #463056

    Guust
    Moderator
    Post count: 29970

    You’re welcome

  • Author
    Posts
Viewing 15 posts - 16 through 30 (of 32 total)

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

Open Support Ticket