export master command -d flag file path error

banillie commented

2021-04-27 08:57:40 +00:00

(Migrated from github.com)

When doing the command datamaps export master [PATH to master] -d [PATH to datamap.csv] get the error:

CRITICAL - Cannot find C:\Users\Standalone\Documents\datamaps\input\Documents\datamaps\Q3_dm_export.csv

I've kept the actual file path in there so you can see that the file path is being repeated. i.e. has Documents twice.
You only need a dummy master and datamap to check this.

When doing the command `datamaps export master [PATH to master] -d [PATH to datamap.csv]` get the error: ``` CRITICAL - Cannot find C:\Users\Standalone\Documents\datamaps\input\Documents\datamaps\Q3_dm_export.csv ``` I've kept the actual file path in there so you can see that the file path is being repeated. i.e. has Documents twice. You only need a dummy master and datamap to check this.

yulqen commented

2021-04-27 14:04:36 +00:00

(Migrated from github.com)

If you put the datamap in another location (Desktop?) and call again, do you get a similar error?

banillie commented

2021-04-27 14:34:01 +00:00

(Migrated from github.com)

Yes. CRITICAL - Cannot find C:\Users\Standalone\Documents\datamaps\input\Desktop\datamap_export.csv

Yes. ` CRITICAL - Cannot find C:\Users\Standalone\Documents\datamaps\input\Desktop\datamap_export.csv`

yulqen commented

2021-04-28 07:15:12 +00:00

(Migrated from github.com)

Can you please email (personal email) me a copy of the current blank_template.xlsm file so I can test with most up to date files? I've probably got one around somewhere on another machine but if you an ping it in an email, that would be great. Ta.

banillie commented

2021-04-28 08:33:43 +00:00

(Migrated from github.com)

Done and done.

yulqen commented

2021-04-28 16:39:29 +00:00

(Migrated from github.com)

Unable to reproduce.

What is the exact command, Will - particularly what does the path to the datamap file look like in the -d flag? I've tried both relative and absolute path with no problems. Not tested on Windows.

Unable to reproduce. What is the exact command, Will - particularly what does the path to the datamap file look like in the `-d` flag? I've tried both relative and absolute path with no problems. Not tested on Windows.

banillie commented

2021-04-29 08:58:51 +00:00

(Migrated from github.com)

Yes this error was on Windows. However, given you couldn't reproduce did some further testing and got it to work with absolute rather than relative file paths. so

datamaps export master C:\Users\Standalone\Documents\datamaps\output\master.xlsx -d C:\Users\Standalone\Documents\datamaps\datamap_export.csv

works. But

datamaps export master Documents\datamaps\output\master.xlsx -d Documents\datamaps\datamap_export.csv

gets the error as above.

Yes this error was on Windows. However, given you couldn't reproduce did some further testing and got it to work with absolute rather than relative file paths. so ``` datamaps export master C:\Users\Standalone\Documents\datamaps\output\master.xlsx -d C:\Users\Standalone\Documents\datamaps\datamap_export.csv ``` works. But ``` datamaps export master Documents\datamaps\output\master.xlsx -d Documents\datamaps\datamap_export.csv ``` gets the error as above.

yulqen commented

2021-04-29 12:49:33 +00:00

(Migrated from github.com)

The second example you give (the relative path) wouldn't work unless your
working directory is C:\Users\Standalone. You could use echo %cd% in the command prompt to check that. Assuming that is the case, I'm not sure what's going on here and would have to do some testing in Windows. But advice for now is use the absolute path.

Don't forget your can write your commands into bash scripts if you're doing them
a lot! You don't have to keep typing 'em out...

On 29-04-2021, Will Grant wrote:

Yes this error was on Windows. However, given you couldn't reproduce did some further testing and got it to work with absolute rather than relative file paths. so datamaps export master C:\Users\Standalone\Documents\datamaps\output\master.xlsx -d C:\Users\Standalone\Documents\datamaps\datamap_export.csv works, but datamaps export master Documents\datamaps\output\master.xlsx -d Documents\datamaps\datamap_export.csv gets the error as above.

--
You are receiving this because you commented.
Reply to this email directly or view it on GitHub:
https://github.com/yulqen/datamaps/issues/19#issuecomment-829062680

--

Matthew Lemon
Email: @.***

The second example you give (the relative path) wouldn't work unless your working directory is C:\Users\Standalone. You could use `echo %cd%` in the command prompt to check that. Assuming that is the case, I'm not sure what's going on here and would have to do some testing in Windows. But advice for now is use the absolute path. Don't forget your can write your commands into bash scripts if you're doing them a lot! You don't have to keep typing 'em out... On 29-04-2021, Will Grant wrote: >Yes this error was on Windows. However, given you couldn't reproduce did some further testing and got it to work with absolute rather than relative file paths. so `datamaps export master C:\Users\Standalone\Documents\datamaps\output\master.xlsx -d C:\Users\Standalone\Documents\datamaps\datamap_export.csv` works, but `datamaps export master Documents\datamaps\output\master.xlsx -d Documents\datamaps\datamap_export.csv` gets the error as above. > >-- >You are receiving this because you commented. >Reply to this email directly or view it on GitHub: >https://github.com/yulqen/datamaps/issues/19#issuecomment-829062680 -- Matthew Lemon Email: ***@***.***

banillie commented

2021-04-29 14:15:04 +00:00

(Migrated from github.com)

Yeap working directory is C:\User\Standalone so weird.

yulqen commented

2021-04-29 15:11:59 +00:00

(Migrated from github.com)

Use absolute paths for now to be safe; leave the issue open, I'll look into
this.

Use absolute paths for now to be safe; leave the issue open, I'll look into this.

Rows
Columns

export master command -d flag file path error #19