TM1 Forum

I would like to write to a disk other than the one that the server is running on. Using TextOutput/ASCIIOutput functions I am unable to achieve it. Is there any functions or work around to write the file to a disk other than the server is running on?

Thanks in advance.

ryan wrote:I would like to write to a disk other than the one that the server is running on. Using TextOutput/ASCIIOutput functions I am unable to achieve it. Is there any functions or work around to write the file to a disk other than the server is running on?

Thanks in advance.

"I am unable to achieve it" does not give a lot of information about what you've done or how.

TM1 doesn't run on a disk, it runs in memory. As with any other computer system, the one whose memory it's running in will have access to one or more hard disk systems. There may be a single disk inside the server box. Or, there may be multiple hard disks in a single box. Or, there may be a RAID drive. Or, they may be disks on other servers on the same network, being accessible through mounted drive letters or UNC connections.

TM1 cares for none of this once it has loaded its data from disk and is running. As with any other application, TM1 can write data to any drive that the Windows login that TM1 is running under has access to, as long as that login has write access, and as long as you're specifying the location correctly.

If you can't write then the things that you look at are:
(a) What's the location that you're trying to write to?
(b) Can the server box that the TM1 server running on connect to that location?
(c) What's the Windows login that the TM1 server is running under?
(d) Does that login have write access to the remote location?
(e) Are you specifying the remote location correctly in your AsciiOutput statement?

Alan Kirk wrote:

ryan wrote:I would like to write to a disk other than the one that the server is running on. Using TextOutput/ASCIIOutput functions I am unable to achieve it. Is there any functions or work around to write the file to a disk other than the server is running on?

Thanks in advance.

"I am unable to achieve it" does not give a lot of information about what you've done or how.

TM1 doesn't run on a disk, it runs in memory. As with any other computer system, the one whose memory it's running in will have access to one or more hard disk systems. There may be a single disk inside the server box. Or, there may be multiple hard disks in a single box. Or, there may be a RAID drive. Or, they may be disks on other servers on the same network, being accessible through mounted drive letters or UNC connections.

TM1 cares for none of this once it has loaded its data from disk and is running. As with any other application, TM1 can write data to any drive that the Windows login that TM1 is running under has access to, as long as that login has write access, and as long as you're specifying the location correctly.

If you can't write then the things that you look at are:
(a) What's the location that you're trying to write to?
(b) Can the server box that the TM1 server running on connect to that location?
(c) What's the Windows login that the TM1 server is running under?
(d) Does that login have write access to the remote location?
(e) Are you specifying the remote location correctly in your AsciiOutput statement?

I am trying to write data to .csv file.

sFilePath = 'c:\tm1-testing.csv';
AsciiOutput( sFilePath, 'Hello World!' );

able to see tm1-testing.csv folder under c:\ for that server.

But when I want to write data to .csv file on the network drive:
sFilePath = '\\nt-dwdbprod\Excel Files\Finance\Lock and Value files\TM1Files\tm1-testing.csv';
AsciiOutput( sFilePath, 'Hello World!' );

Answers to the above listed questions:
(a) \\nt-dwdbprod\Excel Files\Finance\Lock and Value files\TM1Files\
(b) I am able to connect manually to the network folder from the server though.
(c) dwtest, this user even having full access to the above said folder.
(d) Yes, I have full access to the above said network folder.
(e) Yes

CXMD folder is on C:\

Hi Guys,

I'm experiencing the very same thing. My TM1 server is in machine Alpha. I'm running a process that exports data (using ASCIIOUTPUT) to machine Bravo.

It returns error. I'm not sure, but I know I've done it before and it worked.

Is it a limitation? or a set-up? or simply my misunderstanding?

Thanks.

bunchukokoy wrote:Hi Guys,

I'm experiencing the very same thing. My TM1 server is in machine Alpha. I'm running a process that exports data (using ASCIIOUTPUT) to machine Bravo.

It returns error. I'm not sure, but I know I've done it before and it worked.

Is it a limitation? or a set-up? or simply my misunderstanding?

Thanks.

It is not about your ability to write to the folder on machine Bravo. It is about the windows account that tm1sd.exe is running on on server Alpha. That account needs to have the appropriate authorization for machine Bravo simple as that.

I'm wondering. The account that tm1sd.exe is running on on server Alpha has Owner access in the TM1_Inputs folder. And it is Full Control.

This is the error message.

Error: Data procedure line (8): File "\\bravo\TM1_Inputs\TM1_FRRG_INPUTS.csv" not found.

bunchukokoy wrote:I'm wondering. The account that tm1sd.exe is running on on server Alpha has Owner access in the TM1_Inputs folder. And it is Full Control.

This is the error message.

Error: Data procedure line (8): File "\\bravo\TM1_Inputs\TM1_FRRG_INPUTS.csv" not found.

Is TM1_Inputs a share? Shouldn't the path be "\\bravo\TM1_Inputs$\TM1_FRRG_INPUTS.csv"?
If TM1_Inputs is not a share, shouldn't there be a drive reference in the path?
I assume this is a Windows machine - if not (but Linux/Unix) be aware of case sensitivity and forward instead of backslash.

My 2c, Michel

Hi. Thanks for the reply.

It is indeed simple.

Thanks anyway.