Hey community, I got some issues trying to test th...
# plugins-general
m
Hey community, I got some issues trying to test the "spreadsheets-everywhere" locally. I am trying to get the data out of a local xlsx file (screenshot 1). But the config does not work (screenshot 2). Is something wrong with my config? Is it even possible to load local data? PS: "/mnt/c/Users" is necessary as I am in the wsl. Thanks for the help!
v
When you say "config does not work" what does that mean. Do you have a stack trace or something?
I'm not super familiar with spreadsheets-anywhere, but generally file connectors allow you to look at local files (Almost always how the developer who wrote the tap tested it so it tends to work 😄 )
For testing purposes instead of using the /mnt/c/ I'd transfer a file to your /home dir in wsl (
\\wsl$
) just to rule out wsl oddness
It should work regardless but I'd just take it out of the picture for right now
m
Hey @visch Thanks for your comment. I will try the transfer to the /home in my wsl. In the CLI I just get an Error like "No Data found". Maybe there is a debug mode I have not seen?
v
Stack trace / logs? meltano.yml? Commands that you've ran? https://meltano.com/docs/command-line-interface.html#debugging for log-level stuff
m
I finally got the solution... It was a mix of issues. The "pattern" did not work correctly, I added the file to the wsl home and I had to add
file://
in front of a file to local path. Thanks for the help!