So, I tried the free version on Wordpress. For my test document I downloaded an excel formatted file from Google docs, where my spreadsheet is. The formatting looked great, even though some of the fields came out blank (about 1K rows of data). I figured it was probably a quirk of the free version or the excel formatting. So I thought I would upgrade because I'm looking forward to using more features. So then I buy the thing, download it, install it, activate, etc. Then I go back to import the data directly from my spreadsheet via link, and I'm getting a generic "critical error" message. What the hell? It won't even tell me what kind of error, and the link on the error just goes to a generic "WP debugging page." .
Okay, I am having an incredibly bad experience. It seems to be munging all my data. The dates are screwed up and it's throwing out fields altogether. Seriously, the free version was better. I really need some help with this.
1) I have a field that is "month/day." There is no way to select a month/day type of date, so it keeps adding 2020 to the end of all my dates. 2) I have a column for "year." It has done several different things with this column, even though I select "year" for how it should display. It sometimes will change all the years to today's date: 4/25/20, even though I have selected that it should be displayed as a single year. Sometimes it simply deletes all the years.
LINK PROBLEMS: I have many links aliased, so for example I have a link that reads "1851," but the link goes to a website outside my site. The plugin is stripping out the link, leaving the text, and creating a link to a page within my site that does not exist.
COLUMN TITLES: Apparently you can't have an apostrophe in the column header? It inserts a slash before the apostrophe in the word. "Father's Name" becomes "Father\'s Name"
I have tried several different types of files (xlsx, ods) as well as pulling the data from a published Google spreadsheet. I'm trying to avoid using csv because I don't want to lose all the links I saved in it. I have about 1K rows of data.
Formatting applied in the original file (font families, color, size, fill color, etc.) will not be copied over to the wpDataTable, but you can make whatever adjustment you may need in WpDataTables.
Same goes for hyperlinks. The plugin can only see the data as it is presented to the user. The URL behind the text (hyperlink) will not be carried over unless it is stored in HTML way:
<a href="url-to-the-page">Custom text</a>
wpDataTables doesn't have month/day date format, but please feel free to add it as a feature suggestion on this page.
As for year - my advice would be to change the column's type to integer, and simply remove the decimal separator.
Date and number formats need to be the same in the source file and in wpDataTables for it to work as expected. If you're linking the file to create tables, you would also be able to select the input date format, so correct dates are displayed in the tables. wpDataTable's format would still be applied, though.
So, I tried the free version on Wordpress. For my test document I downloaded an excel formatted file from Google docs, where my spreadsheet is. The formatting looked great, even though some of the fields came out blank (about 1K rows of data). I figured it was probably a quirk of the free version or the excel formatting. So I thought I would upgrade because I'm looking forward to using more features. So then I buy the thing, download it, install it, activate, etc. Then I go back to import the data directly from my spreadsheet via link, and I'm getting a generic "critical error" message. What the hell? It won't even tell me what kind of error, and the link on the error just goes to a generic "WP debugging page." .
Okay, I am having an incredibly bad experience. It seems to be munging all my data. The dates are screwed up and it's throwing out fields altogether. Seriously, the free version was better. I really need some help with this.
UPDATE:
DATE PROBLEMS:
1) I have a field that is "month/day." There is no way to select a month/day type of date, so it keeps adding 2020 to the end of all my dates.
2) I have a column for "year." It has done several different things with this column, even though I select "year" for how it should display. It sometimes will change all the years to today's date: 4/25/20, even though I have selected that it should be displayed as a single year. Sometimes it simply deletes all the years.
LINK PROBLEMS: I have many links aliased, so for example I have a link that reads "1851," but the link goes to a website outside my site. The plugin is stripping out the link, leaving the text, and creating a link to a page within my site that does not exist.
COLUMN TITLES: Apparently you can't have an apostrophe in the column header? It inserts a slash before the apostrophe in the word. "Father's Name" becomes "Father\'s Name"
I have tried several different types of files (xlsx, ods) as well as pulling the data from a published Google spreadsheet. I'm trying to avoid using csv because I don't want to lose all the links I saved in it. I have about 1K rows of data.
Hello Eufemia
Thank you for your purchase.
Unfortunately, as stated in our documentation:
Formatting applied in the original file (font families, color, size, fill color, etc.) will not be copied over to the wpDataTable, but you can make whatever adjustment you may need in WpDataTables.
Same goes for hyperlinks. The plugin can only see the data as it is presented to the user. The URL behind the text (hyperlink) will not be carried over unless it is stored in HTML way:
<a href="url-to-the-page">Custom text</a>
wpDataTables doesn't have month/day date format, but please feel free to add it as a feature suggestion on this page.
As for year - my advice would be to change the column's type to integer, and simply remove the decimal separator.
Date and number formats need to be the same in the source file and in wpDataTables for it to work as expected. If you're linking the file to create tables, you would also be able to select the input date format, so correct dates are displayed in the tables. wpDataTable's format would still be applied, though.
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