Problem with ASCIIOUTPUT

[lynnsong986]

Hello,

I keep getting process aborted error message (file A:\filename.csv not found)...sorry somehow I couldn't attach more screenshots...
Can someone please help?

DataSource is Cube View
Data Source Name: I chose a cube view named "Alectra-ES:SM_Depreciation->Download"

in Variables I have:
vTime
vProject
vtype
vMea
Value

in Parameters I set up pExportName as string with question "Enter File Name"

in prolog I have:
vCount = 1;
FilePath = 'A:\';

in Data I have:
If(vCount =1);
ASCIIOUTPUT(FilePath | pExportName | '.CSV', 'Period', 'Project', 'Type', 'Measure', 'Value');
vCount = 2;
EndIf;
ASCIIOUTPUT(FilePath | pExportName | '.CSV', vTime, vProject, vType, vMea, NumberToString(Value));


thanks so much!

[tomok]

I keep getting process aborted error message (file A:\filename.csv not found)...sorry somehow I couldn't attach more screenshots...
Can someone please help?

You're trying to write to a floppy disk on the server?????? A: is usually reserved for a floppy disk drive.

[lynnsong986]

I'm not sure how IT set it up but I had to put all of my CSV files on A: for TI to see them. This is the server drive. I actually tried to use a different path i.e. desk but the same error happened. Not sure how to fix this...

[lynnsong986]

sorry I meant that I used filepath like 'C:\Users\lynn.song\Desktop\' but got the same error.

[tomok]

The user ID that your TM1 Server service runs under has to have the necessary security privileges on the server to be able to create and edit files in order to use ASCIIOUTPUT. I'm not talking about TM1 security, I mean the Windows security for the actual server machine.

[lynnsong986]

Thanks tomok for your help, I may not have the privilege on the server machine but why I can't export to my own desktop either?

[lynnsong986]

would that be the same windows security reason? that means I need to go talk to IT department? thanks!

[tomok]

Thanks tomok for your help, I may not have the privilege on the server machine but why I can't export to my own desktop either?

You can't output to your own desktop because TI processes run on the server, not your local machine. Think about it......

[lynnsong986]

ok thanks so much!! I guess I need to talk to the TM1 guy who set up all securities instead, really appreciated it!!

[gtonkin]

If A: is a server folder/share, make sure that the account that is linked to the TM1 Service has access to it. TM1 will try and write with that account, not yours, unless you are linked on the service.

p.s. Tomok has mentioned this but just saying it a different way.

[lynnsong986]

Thanks for the clarification! I found it a bit confusing as I do have access to the drive, but sounds like it requires more than that. I reached out to the TM1 mastermind in my company.