|
Here's my example CSV that I am trying on the demo instance: Date,Name,Category,Amount When I copy this & import it, here's what happens(see attached). What am I doing wrong? |
Replies: 5 comments 2 replies
|
Hi @Eandy11, MyFin's import feature currently only supports tab-delimited data, not comma-delimited CSV format. When you copy your CSV with commas, the system treats the entire line as a single column because it's looking for tabs (\t) to separate the columns. You could try the following workaround:
When you copy from a spreadsheet, it automatically uses tabs as delimiters, which is what MyFin expects. I will work on making the import function support more formats in the future, but in the meantime the suggested workaround should work for your usecase. Thanks for reaching out |
|
still doesn't work with copying from google sheets or office libre calc. Maybe i'll revisit the app once it has matured more with possibly an import file feature that does a csv. it doesn't pickup the columns in the clipboard. I even just tried copying the column headers into the clipboard and still just populates with 1 column. logged out and logged back in and i get the same results. |
|
i've tried several times with copying just 5 lines without the headers and still only get column-0 |
|
I followed the import instructions and still just 1 column appears when i click next. I verified that the data was in the clipboard by opening a blank text file and pasting the contents in it. All my data appeared in it tab delimited 5 column fields. i'll wait to hear from you on what you think is going on. I've tried these steps about 5 times and am giving up for now. I so wanted this to work and was looking forward to using myfin! |
|
We i'll be darn, i got it to import the columns. I had to access the myfin app through a reverse proxy and use myfin.domain.com in order to get it to access the clipboard. It does not copy the clipboard in when using an ip address:port to access myfin . |
Hi @Eandy11,
MyFin's import feature currently only supports tab-delimited data, not comma-delimited CSV format. When you copy your CSV with commas, the system treats the entire line as a single column because it's looking for tabs (\t) to separate the columns.
You could try the following workaround:
When you copy from a spreadsheet, it automatically uses tabs as delimiters, which is what MyFin expects.
I will work on making the import function support more formats in the future, b…