Hi There,
As I have a lot of data for a new project, and finally I decide to use my Excel file directly for my customs fields of a post type.
For that...
- I have created a post type
- I have created some customs fields into Meta Box - saved data in a custom table.
- I have done 2 posts to see who it reflects into my database (SQL)
- I have converted the Excel file into an SQL file - using a Saas app.
After...
- After a [few] adjustments (quicker than to fill up posts by hand with data), I have uploaded my SQL file into my database (INSERT INTO wp_mytype
) - all worked fine
- After I had to make an SQL file for inserting all post IDs - INSERT INTO wp_posts
(used the example of the 2 first post)
All seems to work fine. I can see and update any fields in any posts.
My question...:)
As I don't want any surprise in the future, can you tell me if I need to do something else, to make sure my data will be available any time for queries?
Or maybe what I've done is just "bad"?
Thank you,
Eric