What’s the easiest way to get text into a server c:text file

Jaymer

I need to build a batch file, and then execute the batch file.
I need to generate multiple dynamic rowe in the batch file.
Do I have to use a document, and merge tags?
I was thinking I would build a BO with one attribute, and have rules to build the content, and create lines in that BO as I do my processing.
Then how do you export that as text?
Do I really need to build a file as described?
What if I have a LIRU attribute that contains all the lines in it all stuffed into one long field. How can I get that one line out to a text file?

BLOMASKY

I would think that Node would be a good solution. Easy to write to a file (you can have aware create and pass the dynamic text to node. I have not tried it, but I assume there is some module that can execute a batch file.

of course, I could be wrong.

Bruce

Jaymer

I can launch that batch file easy. (had a problem in another post, but just needed to set the current dir at the start of the batch file).
I just need to CREATE the batch file with many commands inside it.

BobK

I don't know anything about Node, so that might be a better solution then the following, but I am posting this anyway

Jaymer wrote
I was thinking I would build a BO with one attribute, and have rules to build the content, and create lines in that BO as I do my processing.

I assume that means you are able to build your batch file in an attribute of a BO.

Here is how to export it and excute it
note: I do something close to this, but not this exactly, so no guarantee it will work

Create the following batch file in your AwareIM bin folder and call it batch1.bat or what ever you want, I am not that controlling 😃

echo $1 > batch2.bat
call batch2

After building your batch file in AwareIM BatchBO.BatchAttribute
Run an AwareIM process with the following rule:

EXECUTE PROGRAM `C:\AwareIM\bin\batch1.bat `+BatchBO.BatchAttribute

I am thinking that the batch1.bat might consider each line of your built batch file as separate parameters, so you might have to put quotes around BatchBO.BatchAttribute
If you do need to put quotes around BatchBO.BatchAttribute, they might be included in the batch2.bat file and would need to be removed before calling batch2

You may also want to add

del batch2.bat

to the end of batch1.bat

Jaymer

Bob
I have all the GnuWin32 utils loaded.
Here's some sed stuff you might appreciate... or not. At the end of this, its stripped a webpage and turned it into an importable CSV.

sed s:\x22::g File1 | sed s:"\&nbsp;":"":g | sed s:"<td>":"":g  | sed s:"<\/td>":"":g | sed s!"License_id="!"\x22"! | sed s:"<tr valign=top><FONT FACE=Verdana,Arial,Helvetica size=2><A HREF = \/asp\/info.asp?tag=":"\x22":g > pg1b
sed s:"<BR><FONT FACE=Verdana,Arial,Helvetica size=2>License Expiration Date\: ":"\x22,\x22":g pg1b | sed s:"<\/A> - ":"\x22,\x22":g | sed s:" > ":"\x22,\x22":g | sed s:"<BR><BR><\/tr>":"\x22\x0a":g | sed s:">":"\x22,\x22":g | sed s!"		persons affiliated with license number: "!!g | sed s!"se_id="!"\x0a"!g  > pg1c
cat reps.header.txt > File2
tail -n +2 pg1c | grep -v -e "FONT" -e "Salesperson" -e ">Next"  >> File2

Anyway, that batch1/2 thing gave me an idea.
Cause I could do a cat from stdinput
EXECUTE PROGRAM "cat > batch.bat " + BO.field

I ultimately want to create this batchfile:

cd c:/Dfile/incoming
curl "http://www2.x1.com/ASP/info.asp?tag=72617" > 72617.0
curl "http://www2.x1.com/ASP/info.asp?NAV=1&function=sales&tag=72617" > 72617.1
curl "http://www2.x1.com/ASP/info.asp?NAV=2&function=sales&tag=72617" > 72617.2
curl "http://www2.x1.com/ASP/info.asp?NAV=3&function=sales&tag=72617" > 72617.3

EDIT: This will work as 1 line:

cd c:/Dfile/incoming && curl "http://www2.x1.com/ASP/info.asp?tag=72617" > 72617.0 && curl "http://www2.x1.com/ASP/info.asp?NAV=1&function=sales&tag=72617" > 72617.1 && curl "http://www2.x1.com/ASP/info.asp?NAV=2&function=sales&tag=72617" > 72617.2 && curl "http://www2.x1.com/ASP/info.asp?NAV=3&function=sales&tag=72617" > 72617.3

Jaymer

well, i've worked on this for over an hour.

can't get any of this to work:

EXECUTE PROGRAM echo 'AAA' > c:\files\incoming\echotest.txt
EXECUTE PROGRAM echo AAA > c:\files\incoming\echotest.txt
EXECUTE PROGRAM 'echo AAA > c:\files\incoming\echotest.txt'

EXECUTE PROGRAM cat AAA > c:\files\incoming\echotest.txt
EXECUTE PROGRAM 'C:\Program Files\GnuWin\bin\cat.exe AAA > c:\drefiles\incoming\echotest.txt'
EXECUTE PROGRAM 'C:\Program Files\GnuWin\bin\cat.exe AAA > c:\drefiles\incoming\echotest.txt'

nothing will create the file in the destination directory

tford

Jaymer,

I think EXPORT DOCUMENT action might help:

1) Create a BO called TxtStuff

2) Create a Doc of Txt type that uses all instances of TxtStuff .. call it TxtStuffBatFile

3) Process: EXPORT DOCUMENT TxtStuffBatFile TO FILE 'c:/destfolder/BatFIle.bat'

Jaymer

Tom
The EXPORT didn't work as anticipated.
Took a while to realize what was up.

Template file is only this: <<TxtFile.theData>>

EXPORT DOCUMENT TxtDoc TO FILE 'c:\DFiles\incoming\test.bat'
Execution Exception after resuming a process message Internal error. c:\DFiles\Incoming\test.bat\DOC_0.txt (The system cannot find the path specified)

I have 10 rows in the TxtFile BO.
Changed the command to: EXPORT DOCUMENT TxtDoc TO FILE 'c:\DFiles\incoming'
THEN it output 10 separate files, name DOC_0, DOC_1, etc.

It wont let me output all 10 to 1 file.

Tried this and it says LIST_LINE not supported in Text Files:
<<LIST_TABLE_START(TxtFile.theData)>><<LIST_TABLE_END()>>

Jaymer

Have multiple hours into this now.
Kind of crazy it’s so hard just to create a simple text file.
Bob, the curl command has to have its arguments with double quotes around it“, and that makes outputting that string tougher because it confuses DOS. I wasn’t trying exactly your way, so I’m gonna go back to that with the two batchfile approach.

BobK

Not a solution, but might be helpful

Jaymer wrote
EXECUTE PROGRAM 'C:\Program Files\GnuWin\bin\cat.exe AAA > c:\drefiles\incoming\echotest.txt'

In the above is AAA a file or are you trying to cat three A letters.
If 3 letters, does that even work from the command line? It did not work for me. In my testing cat only took a file name.

when using a file name
EXECUTE PROGRAM 'C:\mypath\cat.exe AFILE.txt > c:\drefiles\incoming\echotest.txt'
and
EXECUTE PROGRAM 'C:\mypath\cat.exe AFILE.txt
both output the contents of AFILE.txt to Aware's Server Output.
It does not look like the redirect symbol (>) is being recognized as a redirect symbol

FYI: AFILE.txt was in the AwareIM bin folder.

tford

Jaymer,

Will this approach work?
https://forum.awareim.com/d/10610

Jaymer

BobK wrote
In the above is AAA a file or are you trying to cat three A letters.
If 3 letters, does that even work from the command line? It did not work for me. In my testing cat only took a file name.

hi Bob
thx for trying

Yes, I've tried it both ways.
This IS helpful because I noticed a blank line in the Server Output window when this executes. Didn't occur to me that it was the result of the cat command.
... which, as you deduce, is because the redirect isnt working.

Jaymer

tford wrote
Jaymer,
Will this approach work?
https://forum.awareim.com/d/10610>

Will that approach work - no, not for what I want to do. I don't want to have a LIST attached to a parent as you do in your demo. I really don't even want to use a BO - I have a field calculated for what I need (the CURL statement) and I really just want to write it out to a file and move on.

THIS IS NOT FROM YOUR SAMPLE PROGRAM - This is an EXPORT, not EXPORT DOCUMENT.

Tom, yes, there is the just plain ol' export a BO to a file.
What a pain...
writes this to the file.

"curl ""http://www2.xxx.com/ASP/info.asp?License=9403"" > c:/DFiles/incoming/9403.0"

so now I have to remove leading and trailing "
plus xlate "" to "

not a biggie, just more steps

tford

so now I have to remove leading and trailing "

Where are those coming from? Not from the process I showed.