excel

[TjitseT]

cant import csv document straight from excel only google spreadsheets but in google spreadsheets a comma is a comma and a dot is used in the way of 1000 =1.000 however in tailor a comma is nothing and a dot is a comma so incompatible af

[davidfokkema]

Tailor supports many different formats. The CSV format used by default is the 'international' standard. So a comma is used to separate columns, hence the name, comma-separated values (CSV), while the dot is used as a decimal separator: 4.7 means 4 POINT 7. However, when you import a CSV file, Tailor presents you with an option screen where you can specify the column separator and the number format.

Two things are important. In Excel, make sure you "export as CSV", and not try to import an Excel file directly. In Tailor, make sure you choose File -> Import CSV and not File -> Open (which is intended for Tailor projects).

In short, it should be compatible af. After trying the above, are you still running into issues?

[TjitseT]

Dear David Fokkema Appreciate the quick reply. I did use CSV format but when I use a spreasheet exported from excel it wont load. It alsp wont give a screen just wont work. Tjitse T

[davidfokkema]

Could you attach a file sample so I can take a look? I can probably help you with the correct way to import it or I will find out it's a bug in Tailor so I can fix it.

[TjitseT]

On 19 Dec 2024, at 14:10, David Fokkema ***@***.***> wrote: Tailor supports many different formats. The CSV format used by default is the 'international' standard. So a comma is used to separate columns, hence the name, comma-separated values (CSV), while the dot is used as a decimal separator: 4.7 means 4 POINT 7. However, when you import a CSV file, Tailor presents you with an option screen where you can specify the column separator and the number format. Two things are important. In Excel, make sure you "export as CSV", and not try to import an Excel file directly. In Tailor, make sure you choose File -> Import CSV and not File -> Open (which is intended for Tailor projects). In short, it should be compatible af. After trying the above, are you still running into issues? —Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you authored the thread.Message ID: ***@***.***>

[TjitseT]

On 19 Dec 2024, at 14:10, David Fokkema ***@***.***> wrote: Tailor supports many different formats. The CSV format used by default is the 'international' standard. So a comma is used to separate columns, hence the name, comma-separated values (CSV), while the dot is used as a decimal separator: 4.7 means 4 POINT 7. However, when you import a CSV file, Tailor presents you with an option screen where you can specify the column separator and the number format. Two things are important. In Excel, make sure you "export as CSV", and not try to import an Excel file directly. In Tailor, make sure you choose File -> Import CSV and not File -> Open (which is intended for Tailor projects). In short, it should be compatible af. After trying the above, are you still running into issues? —Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you authored the thread.Message ID: ***@***.***>

[davidfokkema]

If you were trying to attach a file, I think it can only be done via the web interface. So if you go here: #86 and then press the link icon in the header of the comment it should work.

[TjitseT]

like this?

amplitude set 1l(Blad1).csv

[davidfokkema]

Yes, thank you very much! I'm looking into it. It seems to be a character encoding issue. The issue is the 'squared' character in m/s^2. Excel did not export this using the standard format (utf-8) but using the older DOS/Windows format (ISO 8559-1). In Excel 2016 and later, you should be able to save your file as "CSV UTF-8 (comma delimited)". That should work. You can also remove the squared characters manually and then save the file. I will include a workaround in Tailor, thanks for reporting!

On a side note: I noticed that the CSV file has blank lines after every line of data. It looks like the import from the data acquisition software used in the experiment into Excel already had issues. Most measurement software includes the option to export the data to CSV, so you might save a step (and have no issue) if you take your measurements, save them directly to CSV and then import that into Tailor.