Hello, if you need to add foreign key columns to SQL Query based wpDataTables, you can do that. Here is a detailed step--by-step example on how you can create foreign key relations in our plugin on this Documentation page --wpdatatables.com/documentation/front-end-editing/configuring-table-relations-foreign-key/ Please check it out. But in case if we did not understand what you meant, please open a support ticket here tmsplugins.ticksy.com/ , and our Support Agents can help you in more details. Thank you
Hello, in the example on our Documentation about foreign keys, it presents three SQL Query based wpDataTables, and creating foreign key relations between them. So, we are not sure exactly what you mean. Can you please open a Support Ticket on tmsplugins.ticksy.com/ , and our Support Agents can clarify everything in full details for you? Thank you. :)
@@mix2621 Hello, that will not be a problem at all. Once you prepare the details about your use-case, please open a Support Ticket on tmsplugins.ticksy.com/, and our Support Agents will help you out. :) Thanks
@@Littlemakeuplotofjesus Hello, Firstly, our sincere apologies for writing so late to this comment. 1. For headers being different - Can you please check what is the origin Header name versus the Displayed header name? For each Column, it is checking against the 'origin Header name'. 2. One more important factor : Are you including the wdt_ID column in your source Excel? If you are updating an existing Manual Table and if you try to include any of our auto-generated 'premade columns' like wdt_ID, or wdt_created_by, wdt_created_at, wdt_last_edited_by and wdt_last_edited_at; in that case, it will fail to import. So please check and ensure that you only use your custom Columns in the source Excel file which is used for importing of the 'replace rows with source data' and exclude any of these 'premade manual columns' because they will auto-populate with auto-assigned wdt_ID and auto-asigned data for the user who uploaded the file and the time, when it was uploaded, etc. If you still can't isolate the issue, please open a Support ticket here tmsplugins.ticksy.com/ and one of our agents will ask you additional questions to confirm exactly what your goal is, then they will advise you in full details. If you don't have a licence, you can open a Pre-Purchase ticket here, so you won't have to input any licence key tmsplugins.ticksy.com/submit/#100010481. Kind regards.
Hello, in regards to your WordPress throwing an error which prevents you uploading specific file types - That is not related to our Plugin, but rather permissions on your Site. You can research how to fix this online, there are a lot of easy tutorials, such as this one : www.wpbeginner.com/wp-tutorials/how-to-fix-sorry-this-file-type-is-not-permitted-for-security-reasons-error-in-wordpress/. 2. For the updated comments you sent, in regards to header errors - we made an additional reply on your comments below.
Hello, If you require assistance or have a question about any step of this process - please open a ticket and write to our Technical Support, they can help with this. In case if you are a wpDataTables premium user, please open the ticket here: tmsplugins.ticksy.com/submit/#100004195 If you don't have an active licence, just open a pre-purchase ticket on this link and it won't ask for licence code: tmsplugins.ticksy.com/submit/#100010481. Kind regards.
Great explanation!
Glad it was helpful!
Nice job!
Thank you! Cheers!
Great feature, and well explained on how to use it !
Very useful.
Glad it was helpful.
Thank you!
5.0 version is a nice improvement. Keep up the great work!
Thanks, will do!
great feature, thank you
Glad you like it!
How to add foreign key from sql table query ? It nice to add it in new versions 😁
Hello,
if you need to add foreign key columns to SQL Query based wpDataTables, you can do that.
Here is a detailed step--by-step example on how you can create foreign key relations in our plugin on this Documentation page --wpdatatables.com/documentation/front-end-editing/configuring-table-relations-foreign-key/
Please check it out.
But in case if we did not understand what you meant, please open a support ticket here tmsplugins.ticksy.com/ ,
and our Support Agents can help you in more details.
Thank you
Thanks, but i need to add foreign key from sql query to an sql query table, not from manuel table to sql query
Hello,
in the example on our Documentation about foreign keys, it presents three SQL Query based wpDataTables,
and creating foreign key relations between them.
So, we are not sure exactly what you mean.
Can you please open a Support Ticket on tmsplugins.ticksy.com/ , and our Support Agents can clarify everything in full details for you?
Thank you. :)
I want to prepare a detailed article about what i mean and i want to send it at the earliest
@@mix2621 Hello,
that will not be a problem at all.
Once you prepare the details about your use-case, please open a Support Ticket on tmsplugins.ticksy.com/,
and our Support Agents will help you out. :)
Thanks
All great except for the uploading part. WordPress gives me an error every single time saying that I can't upload an .XLS/.XLSM file type.
Finally got it to upload but I keep getting a header is different error. They are exactly the same. I've tried .csv and .xlsx
I just deleted the table and started over again. It did not work for me.
@@Littlemakeuplotofjesus Hello,
Firstly, our sincere apologies for writing so late to this comment.
1. For headers being different - Can you please check what is the origin Header name versus the Displayed header name?
For each Column, it is checking against the 'origin Header name'.
2. One more important factor :
Are you including the wdt_ID column in your source Excel?
If you are updating an existing Manual Table and if you try to include any of our auto-generated 'premade columns' like wdt_ID, or wdt_created_by, wdt_created_at, wdt_last_edited_by and wdt_last_edited_at;
in that case, it will fail to import.
So please check and ensure that you only use your custom Columns in the source Excel file which is used for importing of the 'replace rows with source data' and exclude any of these 'premade manual columns' because they will auto-populate with auto-assigned wdt_ID and auto-asigned data for the user who uploaded the file and the time, when it was uploaded, etc.
If you still can't isolate the issue, please open a Support ticket here tmsplugins.ticksy.com/ and one of our agents will ask you additional questions to confirm exactly what your goal is,
then they will advise you in full details.
If you don't have a licence, you can open a Pre-Purchase ticket here, so you won't have to input any licence key tmsplugins.ticksy.com/submit/#100010481.
Kind regards.
Hello,
in regards to your WordPress throwing an error which prevents you uploading specific file types - That is not related to our Plugin, but rather permissions on your Site.
You can research how to fix this online, there are a lot of easy tutorials, such as this one : www.wpbeginner.com/wp-tutorials/how-to-fix-sorry-this-file-type-is-not-permitted-for-security-reasons-error-in-wordpress/.
2. For the updated comments you sent, in regards to header errors - we made an additional reply on your comments below.
Not easy to follow.
Hello,
If you require assistance or have a question about any step of this process - please open a ticket and write to our Technical Support, they can help with this.
In case if you are a wpDataTables premium user, please open the ticket here: tmsplugins.ticksy.com/submit/#100004195
If you don't have an active licence, just open a pre-purchase ticket on this link and it won't ask for licence code: tmsplugins.ticksy.com/submit/#100010481.
Kind regards.