string function not recognised

Hi all,

i am creating an appengine export to CSV file, and i am trying to use an if statement to generate a file flag.

at the end of my export script i am adding in a string element to check if the account code is a 3 or not (if its a C its a 3, if not then its a D.

the error message is that cord has not been 'defined'

Error Message:

The compiled result was empty.
Error: Line 151: Identifier cord has not been defined yet.

code snipit below

        //create (C) Credit or (D) Debit member
        if(StringLeft(saccounts,1) =="3")
        {
            string cord = "C";
        }
        else
        {
            string cord ="D";
        }

        //get the current date for the export
        string sdate = GetDateAsString(now);

        AppendToLocalFile("C:\Export\BudgetExport.CSV",saccounts + "," + SourcePeriod + "," + value + "," + value + ",0," + scurrency + "," + cord + "," + sl1department + "," + sl2roomsegment + "," + sl3mealperiod + "," + sl4eventsproject + ",ZZZ,ZZZ," + sl7local + "," + sl8property + "," + sl9feesdetails + ",ZZZ,"
                          + sbu + "_B_" + SourcePeriod + "," + sdate + "," +"ZBI01" + "," + sbu
                          + "
");
    }

Find more posts tagged with

Infor EPM Discussions

Comments

Nick Gladkov

change it to

string cord = "";

    if(StringLeft(saccounts,1) =="3")
        {
           cord = "C";
        }
        else
        {
           cord ="D";
        }

...

Nick Gladkov

However, if you are working with big data sets and big dimensions, I would not recommend checking accounts one by one. You can instead use alternative OLAP hierarchies, attribute driven hierarchies or selections, and relational staging area where you can have bulk operations.

John Robson

AppenndtoLocalFile can be slow for two reasons - aggressive virus checkers checking every file write and the process waiting for the append to happen.

In that event create StringList and append your rows to it then after the loop write the StringList to a local file. See code snippets below

StringList slCacheOut = CreateStringList()
//Within you loop
Append (slCacheOut, WDDPERIOD + "," + WDDFORECAST_PERIOD + "," + BPDANALYSIS_01 + "," + BPDANALYSIS_02 + "," + BPDANALYSIS_03 + "," + BPDANALYSIS_04 + "," + BPDANALYSIS_05 + "," + val * MultBy);
//After loop
AppendToLocalFile(OutputFile, StringJoin(slCacheOut,"
"));

Peter Chapman

Thanks Nick,

its for a budget export back to source systems (so by BU/version/ period )- it takes around 2 seconds to produce the file

Peter Chapman

Hi all,

I now have the export function working from an appengine button in application studio, however when i use from dashboards, i recieve the following error:

22:03:23 Application Engine process execution failed.
22:03:23 An error has occurred: Access to the path 'C:A60_B_Export.CSV' is denied.
22:03:23 Execution finished.
22:03:23 Executing the process took 3077 ms.

so executing over the web is giving a local file error - do you know if there is a way around this or can i give a prompt to create and save a file locally (it works fine on the server - but i imagine its local file security issues on each users PC.

Is there another way to save an export file though appengine either locally on the server or to save as a network file? (and if the user is not physically connected to the network ie over the internet?)

regards

peter

Legacy Contributor

Hi Peter,

is your web server on a different server from your application studio instance?

When accessing files on a local directory you need to make sure the web server has access to it at that exact file path. Alternatively use a network path.

Legacy Contributor

Also grant the relevant permissions for ‘ASWS’ to that directory

John Robson

Please try this:
Cache you intended output in a string (or maybe string list or similar). You must provide delineator characters like , or ; a Tab and end lines as below with
:

The in AE Before loop

RepositoryConnection RepCon = CreateRepositoryConnectionExisting(); //Connect to your repository

string outfile4 = ""; //Initialise variable for output

In loop add the new line to the file - 3 variants shown below

outfile4 = outfile4 + "Cycle: " + CycleID + " " + " Description: " + CycleDesc + "
"; //Tab delin.
or

outfile4 = outfile4 + "Cycle: " + CycleID + ";" + " Description: " + CycleDesc + "
"; // Semicolon as separator
or
outfile5 = outfile5 + "Cycle: " + CycleID + "," + " Description: " + CycleDesc + "
"; // comma delineated - best if no other commas in the output

Use the AE function below to create a Repository Attachment. The last parameter - content is what you write.

RepositoryCreateFile

Declaration

string RepositoryCreateFile(RepositoryConnection repositoryConnection, string attachmentName, string content)

Example where JR5.csv will be your file name. The file extension tells windows type and hence default program to open it.

RepositoryCreateFile(RepCon, "JR5.csv", outfile5);

In App Studio use the OpenAttachment action. The exact behavior on OpenAttachment is browser dependent but AFAIK most copy the file to your Downloads folder. Some then try and open it. It either case your file should be in your nominated download folder.

You can/should test for and delete any existing repository attachment files with the name you want to use.

You may yet the limit of the length of a string - which I don't know ...

i don't have a test tenant at the moment but think this might work

John

Peter Chapman

Thanks for the suggestion Ibrahim, adding ASWS permissions to the directory on the webserver resolved the issue.

now to fire off my sftp batch file

Copyright © 2025 Infor. All rights reserved.