Home › Forums › ACF PRO › Creating a searchable 'database' from excel sheet › Reply To: Creating a searchable 'database' from excel sheet
Hi James,
Think some progress – would you (or anyone else) have any recommendations as to how to best batch import? 800k rows, or so!
My concern would be the creation of duplicate posts though for Restaurants and/or Suppliers.
My CSV is structured as follows;
1) Restaurant Name 2) Supplier 3) Country 4) Region 5) Speciality 6) Speciality Sub-section
Each row is repeated where there is a unique record, so for some restaurants, I end up with multiple instances of the same.
Ultimately, I would like to establish the relationship Restaurant <–> Supplier and then filter using the other fields.
Not sure if a clever use of taxonomies is the right way forward or not? But initially I’ve got 1 & 2 as post types, with the rest as custom fields and another (relationship) custom field for each CPT.
Could e-mail over a sample of the data if that would help?
Thanks thus far and in advance – appreciate this is my own headache to solve!
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users
Helping others is a great way to earn karma, gain badges and help ACF development!
We use cookies to offer you a better browsing experience, analyze site traffic and personalize content. Read about how we use cookies and how you can control them in our Privacy Policy. If you continue to use this site, you consent to our use of cookies.