Special BAQ constants

Kinetic ERP
1

Is there a BAQ constant that will give me the current server? I need to read it and set up a path to be used in a Kinetic function.

2

BAQs run in SQL Context, the server is all the same. You have 1 database

What business problem are you trying to solve? You could do something like this with a UBAQ using a GetList() post processing BPM but we’ll need more context.

1 Like
3

I am trying to transfer a file containing AP invoice data using a file-transfer widget and then reading the csv in my function so I can process them. In order to read the file, I have to provide a path. I understand that doing a transfer with the widget places the file in the working server directory. I am passing the chosen file name so I need to use the server path and append the file name. This is a tool I am trying to develop for our finance folks so they don’t have to enter each invoice individually.

4

SysAgent has the task agent server.

5

Why not use DMT?

6

Not everyone has DMT, as well as sometimes you need custom.

Somebody buy me DMT.

2 Likes
7

Why not buy DMT?

2 Likes
8

I was hoping you would buy it for me.

1 Like
9

Image of You can wish in one hand, and crap in the other...

2 Likes
10

You seriously don’t have DMT?

1 Like
11

ok I still don’t understand the BAQ constant bit. If you want to get server path etc in the function you can do that already in the function code.

3 Likes
12

Nope. We had it at go live.

I built one import dashboard and they dropped it, said we didn’t need it lol.

“Kevin can do it.”

ray donovan omg GIF by Sky

5 Likes
13

Don’t feel bad, we don’t use DMT either.

1 Like
14

I don’t, making dashboards taught me all this bs I share here.

5 Likes
15

I thought there might be something like CurrentUserID or something like “CurrentServer”. A shot in the dark.

1 Like
16

How do I get it in the function code? Is there an example somewhere?

17

I think there may be some misunderstanding here. Why do you need the server?

18

My file transfer widget copies (uploads) the file I choose with the file picker to somewhere. Then, in my function code, I need to access the file, read it, create invoices programmatically and add them to Epicor (kinetics). My finance people want to point to a file, click the magic button and the invoices are “in the system”. Then they wouldn’t have to do any work. Not their words but mine. Excuse my sarcasm.

1 Like
19

Yeah give me two shakes.

20 
  var sandboxFile = new FilePath(ServerFolder.UserData, "sample.csv");

  string sampleData = Sandbox.IO.File.ReadAllText(sandboxFile);
1 Like