  Rank: Member Groups: Registered
Joined: 05/08/2021(UTC) Posts: 22 
|
Hi, I have some trouble understanding how to use importData() function. I get these type of errors:
- "file does not exist" if I try a relative path
- "input string is not in a correct format" if I try a absolute path
I am at loss, I don't understand what is not working  on win10 smath studio version 0.99 vuild 7921
|
|
|
|
|
|
 Rank: Advanced Member Groups: Registered
Joined: 23/07/2013(UTC) Posts: 1,075  Was thanked: 481 time(s) in 319 post(s)
|
DocumentDirectory() can be used for getting path of file. If there are texts in your document, they need to be in quotes. And arguments are depending on how they are written on file. If you could provide your csv file, it would be more helpful to find correct ones. Regards  Edited by user 26 January 2022 22:54:40(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 28/08/2014(UTC) Posts: 1,323  Was thanked: 800 time(s) in 506 post(s)
|
Hi. The attached shows that overlord's it's the best solution, but also that there are an issue somewhere, its cause is very hidden to me.  TEST.sm (306kb) downloaded 33 time(s). TEST.pdf (905kb) downloaded 50 time(s).Best regards Alvaro.
|
|
|
|
|
|
Rank: Member Groups: Registered
Joined: 05/08/2021(UTC) Posts: 22
|
Ah I almost got it! Some notes:
- I was confused by the function "DocumentDirectory()" since it is part of the Mathcad Toolbox plugin, which I didn't have in my installation (thanks to Razonar for the sm file)
- I still don't understand what is "Arguments Separator ("3: delimiter" )" meant for since the columns separator is defined in the 4th parameter; could functions being imported from the csv? (e.g. "...,foo(x;y),..." )
In the end the culprit was not the file path, which was ok, but the content of csv itself: the string where not enclosed in double quotes and there where also some whitespaces. The error message I got was unclear because it spoked about the "input string" being in the wrong format and I mistakenly thought it referred to the file's path passed to the function. After properly formatting the csv file, I was able to correctly import in my sheet. Thanks you Edit: damn emoji Edited by user 02 February 2022 14:22:59(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 28/08/2014(UTC) Posts: 1,323 Was thanked: 800 time(s) in 506 post(s)
|
Originally Posted by: kompre  Ah I almost got it!
Some notes: ...
I still don't understand what is "Arguments Separator ("3: delimiter" )" meant for since the columns separator is defined in the 4th parameter; could functions being imported from the csv? (e.g. "...,foo(x;y),..." )
From the "Interactive SMath Handbook" (In the SMath menu: Tools / Plugins / Interactive books): (string or 0) argument separator character in the file, relevant for symbolic expressions. 0: use default settingThis is the 'argument separator', which could be set at Tools / Options as period, colon or semicolon. In other words: useful if you want to import / export symbolic expressions with two or more arguments, like atan(y,x) or atan(y;x) Best regards. Alvaro. Edited by user 02 February 2022 19:10:31(UTC)
| Reason: Not specified
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
