This website uses cookies to personalize your experience. By using this website you agree to our cookie policy.

Odd search result

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #56454
    toddkarr_OkUrtoddkarr_OkUr
    Participant

    Hi, Ernest

    Wow, my search is working beautifully. The memory limit is at 512mb and working faster.

    However, I noticed that one entry showed up without its ID tag and missing its “dust jacket” field entry. Dust jacket shows up fine in other results, and it’s in the original spreadsheet.

    Any thoughts?

    I reset your username to ajaxsearchpro and password to searchtheindex

    Thank you.

    #56458
    toddkarr_OkUrtoddkarr_OkUr
    Participant

    UPDATE

    The problem seems to be that I have some duplicate entries, but not on my spreadsheet/CSV.

    Yesterday, while initially importing, I stopped an initial index table generation when I realized that I had not added the ID number that gives them a unique identity.

    I stopped the index, and then deleted all the Books posts from my site.

    I then corrected the spreadsheet/CSV and imported it again, then generated a new index table.

    Somehow, the old entries remained and now they show up in the results.

    I will start over later and delete all the Books posts and import them again. then delete the current Index Table and generate a new one. Hopefully that will solve the problem.

    See attached.

    #56460
    toddkarr_OkUrtoddkarr_OkUr
    Participant

    UPDATE

    OK, I know what happened. The hidden rows in my spreadsheet are showing up. I need to delete them before importing it. That should eliminate the ghost entries.

    #56461
    toddkarr_OkUrtoddkarr_OkUr
    Participant

    FIXED: I saved a lot of time and did a search on my posts for the empty parentheses in the title – “()” – because of the missing identifier, then deleted all those posts. Whew. I had forgotten this quirk about OSX Numbers.

    #56468
    Ernest MarcinkoErnest Marcinko
    Keymaster

    All right, thank you for updating me. I have very little experience with importing CSV files, so I’m learning with you.

    #56469
    toddkarr_OkUrtoddkarr_OkUr
    Participant

    My pleasure. I shouldn’t even have hidden rows. I was keeping them saved in case I needed to access the information, but I’ll be deleting them permanently so I don’t run into this problem or have an extra step to deal with!

Viewing 6 posts - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.