I create a table linked to an existing data source CSV, now I need the result that brings change the values, like from String to Integer and in other String do a Split of the column in several columns.
I am sorry, but I didn't quite understand what it is You're trying to do. Could You, please, explain it in a bit more detail? If it is at all possible, could You provide some screenshots or even better a screen recording of what You wish to accomplish.
If You've created a table linked to an existing data source, You can't add new columns, so I don't understand what You mean by "String do a Split of the column in several columns".
Exactly the last thing that it says is what I'm trying to do, I'm reading a CSV and I want to change some columns of text to number, or make a column convert into three different columns.
I apologize for the late response, we've had non-working days during the holidays, and our replies are sparse a bit. We thank You for understanding.
Unfortunately, wpDataTables cannot create multiple columns from one column. It reads the data from the data source and displays it the way it has been written. You can read more about Creating editable tables by importing data from Excel, CSV or Google Spreadsheets and How to create a table from CSV data. If the column has only numbers in it, You can change the type from "String" to "Integer" or "Float" when You create a table by importing data from an existing data source (third option), and then selecting the type drop-down. However, if the column has mixed values (text and numbers) it will not be able to read the data properly, and will probably come back with empty cells, or zeroes, or it may even display an error that the table cannot be created.
Could You send us the file You're trying to create a table from, so that we can try it in our local environment? Just make sure You check the Private reply option, since this ticket is public. That way only we can see the file.
Thank you very much for your response and do not worry about the time, we were all on holidays. With respect to his answer, what I understand is that this file uploads and becomes a flat table, but what I need is that this file will be updated weekly and I do not want to do all the import manually, but the information is updated every time I upload the CSV.
Yes, of course. You just need to create the table using the first option - Create a table linked to an existing data source. You can read more about that here.
Just make sure all the columns have headers and data type is the same inside the column. When You create a table linked to the existing data source, that file source will be stored in the "uploads" folder of wpDataTables, so keep that in mind for editing - when You edit the file, You need to edit the file in that folder, not the one You uploaded.
For example, if You upload the file from Your desktop, wpDataTables stores a copy of that file in the "uploads/2019/01" directory, and that's the file You need to edit in order for the table to show changes in real time.
I create a table linked to an existing data source CSV, now I need the result that brings change the values, like from String to Integer and in other String do a Split of the column in several columns.
Hello inteligentic.
I am sorry, but I didn't quite understand what it is You're trying to do. Could You, please, explain it in a bit more detail? If it is at all possible, could You provide some screenshots or even better a screen recording of what You wish to accomplish.
If You've created a table linked to an existing data source, You can't add new columns, so I don't understand what You mean by "String do a Split of the column in several columns".
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Exactly the last thing that it says is what I'm trying to do, I'm reading a CSV and I want to change some columns of text to number, or make a column convert into three different columns.
If that's what I want, what do you recommend?
Hello again inteligentic.
I apologize for the late response, we've had non-working days during the holidays, and our replies are sparse a bit. We thank You for understanding.
Unfortunately, wpDataTables cannot create multiple columns from one column. It reads the data from the data source and displays it the way it has been written. You can read more about Creating editable tables by importing data from Excel, CSV or Google Spreadsheets and How to create a table from CSV data. If the column has only numbers in it, You can change the type from "String" to "Integer" or "Float" when You create a table by importing data from an existing data source (third option), and then selecting the type drop-down. However, if the column has mixed values (text and numbers) it will not be able to read the data properly, and will probably come back with empty cells, or zeroes, or it may even display an error that the table cannot be created.
Could You send us the file You're trying to create a table from, so that we can try it in our local environment? Just make sure You check the Private reply option, since this ticket is public. That way only we can see the file.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Thank you very much for your response and do not worry about the time, we were all on holidays. With respect to his answer, what I understand is that this file uploads and becomes a flat table, but what I need is that this file will be updated weekly and I do not want to do all the import manually, but the information is updated every time I upload the CSV.
Is it possible?
Regards
Hello again inteligentic.
Yes, of course. You just need to create the table using the first option - Create a table linked to an existing data source. You can read more about that here.
Just make sure all the columns have headers and data type is the same inside the column. When You create a table linked to the existing data source, that file source will be stored in the "uploads" folder of wpDataTables, so keep that in mind for editing - when You edit the file, You need to edit the file in that folder, not the one You uploaded.
For example, if You upload the file from Your desktop, wpDataTables stores a copy of that file in the "uploads/2019/01" directory, and that's the file You need to edit in order for the table to show changes in real time.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables