Hi,
thanks for your post, and sorry for the trouble.
Before importing this as a CSV file, did you really save it as a CSV file in Excel?
Regards,
Tobias
Thank you for your reply. I have never had to save an Excel workbook as a csv file before importing it previously. If I do save it as a csv file before importing it, all my dates are a series of xxxx’s. Is there some other reason that this is happening?
A further reply: This morning I successfully uploaded a table, importing it in excel format and choosing the option to import as a csv file. It imported successfully. Unfortunately I had to delete that able and begin again. The following three or four uploads, using the same method, were unsuccessful. If I convert my excel table to csv before uploading it, all my date formats are gibberish. Has something changed in Tablepress to make this problem arise?
I really need some assistance as soon as possible. I do need to upload this table but am running into a problem as mentioned in my previous e-mails that has never happened to me with all the other tables I uploaded. My usual method is to import the table in Excel format and have it import as a csv. I cannot change the excel format to csv prior to uploading as it changes all the formatting on my dates. If you could provide some information as to how I can fix this problem, I would be grateful. Thank you.
Hi,
if your table is in Excel format, why do you choose CSV then? Doesn’t the automatic selection of “Excel” work?
Regards,
Tobias
Once you begin the import selection there are several choices. Two of them are Excel choices with (experimental) in brackets. Are you saying I am to use one of those?
I just tried importing using the 2007 – 2013 experimental format and it changed all my dates to a series of numbers. As I said, this has never happened before.
Hi,
no, you should use one of those if you are importing an actual Excel file (with a file extension of .xls or .xlsx).
The CSV selection should only be made for files that have a .csv file extension.
Regards,
Tobias
I am now at my complete wit’s end with this. I have followed all the instructions, imported it with the proper extension and I still have incorrect dates. The dates are now all a series of numbers – not even close to an actual date. This is now day two and it was supposed to be uploaded and ready to go yesterday. Do you have any other suggestions as to how I can have it uploaded with the correct dates? Thank you.
Hi,
ok, so now the import of the Excel file worked, but the dates are showing wrong?
This is actually a problem in the Excel import, which has problems properly detecting date formats.
The proven workaround here is to save the table to a CSV file and then import that. Now, you mentioned that you tried that and that this would also result in the dates coming up wrong. To be honest, this kind of surprises me, as in all my experiments (and from feedback of other users) this has worked totally fine. The CSV saving in Excel has always saved the exact content that one would see in Excel.
I would therefore like to encourage you to try saving the table to a CSV file again in Excel, and then import the .csv file into TablePress.
If the dates still come out wrong, can you then email me the source Excel file and the saved CSV file?
Regards,
Tobias
After a great deal of fussing with the date, I finally found a format that tablepress would accept. Thank you for your assistance. I have one further question as to the width of individual columns. In this table I would like to change the width of the “burial/cremation” column to a narrower width and change the width of the two date columns to a wider width. What settings do I edit to effect that change? The url is http://www.qbfhs.ca/parksville-newspaper-obituary-index-1982-2002/2000-2002-pqb-newspaper-obituaries/
Again, thank you.
I am still trying to correct the column widths to have them set properly. I tried changing columns 4, 5 and 6 to a different width but that didn’t change anything. Column 7 is far too wide and if that could be set to a smaller width, then 4, 5 and 6 should show the date on one line. What I did try is as follows and if you could advise what changes I should make, I would appreciate it.
.tablepress-id-42 .column-4 {
width: 110px;
}
.tablepress-id-42 .column-5 {
width: 110px;
}
.tablepress-id-42 .column-6 {
width: 110px;
}
Tobias, could you possibly please give me some information as to how I could change the width of the columns. I would like the three date columns to have the entire date on one line and the column after that less wide. Thanks.
Hi,
unfortunately, your link is only giving me a “Not found” message 🙁 Is this really a published page?
Now, your CSS code is correct, but you have to keep in mind that a column can never be made more narrow than what the widest content in that column requires.
As you mention a “burial/cremation” heading, this already sounds as if this would be shown as one very long word. It might be sufficient to add a space here, i.e. “burial/ cremation”, so that the browser can split this over two lines to make the column more narrow.
Regards,
Tobias
