Search found 43 matches

by matt.baile
Fri Oct 05, 2018 8:54 pm
Forum: Flows
Topic: Archive Files Not In Folder - Possible?
Replies: 10
Views: 8896

Re: Archive Files Not In Folder - Possible?

Thanks! I did try to use the Execute command element using 7zip. My command is: C:/Program Files/7-Zip/7z.exe For arguments, I've tried the following: 7z a archive.zip * .\[Job.NestedName:Index="1"]\* 7z a archive.zip .\[Job.NestedName:Index="1"]\* I then thought I might need to ...
by matt.baile
Thu Oct 04, 2018 3:04 pm
Forum: Flows
Topic: Archive Files Not In Folder - Possible?
Replies: 10
Views: 8896

Archive Files Not In Folder - Possible?

I'm trying to zip three files together without putting them in a folder first. I was able to put the three files into a folder using the Assemble Job element and then use the Archive element to zip them, but the result is Zip>Folder>Files. What I need is just Zip>Files. Is there a way to do this wit...
by matt.baile
Tue Aug 14, 2018 8:31 pm
Forum: LEGACY scripting
Topic: Replace single XML node value
Replies: 5
Views: 7588

Re: Replace single XML node value

It could be a firewall issue. I'll ask IT to investigate. When I sign in to the app store, it doesn't recognize any server or any installations for some reason. The XML files going through this flow will have a few different structures, although the journal-id should always stay in the same place an...
by matt.baile
Tue Aug 14, 2018 5:18 pm
Forum: LEGACY scripting
Topic: Replace single XML node value
Replies: 5
Views: 7588

Re: Replace single XML node value

For some reason I keep getting a note saying that I need to sign into SWITCH in the "About" tab. I've done this, but still can't download a trial of the Make XML program. Any thoughts?

Is there a way just to keep the same XML file as is, but replace that one node and leave the rest as is?
by matt.baile
Tue Aug 14, 2018 4:34 pm
Forum: LEGACY scripting
Topic: Replace single XML node value
Replies: 5
Views: 7588

Replace single XML node value

We have a few different types of XML files coming through a workflow. There could be a mix of files coming through the flow, but we're not really concerned with what type of XML it is, they all have a <journal-id> with a few samples below of how this appears. <journal-id journal-id-type="publis...
by matt.baile
Thu Apr 26, 2018 3:56 pm
Forum: Flows
Topic: Writing XML value to Private Data in Script
Replies: 3
Views: 5574

Re: Writing XML value to Private Data in Script

I was missing a simple piece of the code: Metadata.Text

The code is now functioning perfectly:

Code: Select all

	var IssType = job.getVariableAsString( '[Metadata.Text:Path="/JobSheet/IssueJobSheet/IssueInfo/@IssueType",Dataset="Xml",Model="XML"]' );
by matt.baile
Tue Apr 24, 2018 5:11 pm
Forum: Flows
Topic: Writing XML value to Private Data in Script
Replies: 3
Views: 5574

Re: Writing XML value to Private Data in Script

Thanks for this. I receive the following error when trying to write this: Encountered unknown variable 'Path="/JobSheet/IssueJobSheet/IssueInfo/@IssueType"_Dataset="Xml"_Model="XML"' in 'SIX-XML_Text_r3' I'm actually reading the XML path in another workflow on another s...
by matt.baile
Tue Apr 24, 2018 4:46 pm
Forum: Flows
Topic: Writing XML value to Private Data in Script
Replies: 3
Views: 5574

Writing XML value to Private Data in Script

Hi guys, I need to set a Private Data variable based on the value contained in an XML file. I used the XML pickup and the value I want is IssueType (see below). I get an error when running this, so I'm not sure what's wrong. Keep in mind that both of the code snippets below are part of a larger scri...
by matt.baile
Mon Jan 08, 2018 5:52 pm
Forum: Flows
Topic: Report Language not Available in SWITCH 17.1 (PitStop Element)
Replies: 2
Views: 4191

Report Language not Available in SWITCH 17.1 (PitStop Element)

I just imported a flow into a SWITCH 17.1 install on a virtual server from an older physical box running SWITCH 11.5. I have a PitStop Server element asking for a Report Language, but when I try to select from Library, I have no options. On the older server, I have the option to select English, but ...
by matt.baile
Tue Dec 05, 2017 5:42 pm
Forum: Flows
Topic: Assign Private Data and/or Rename Job using Reference File???
Replies: 8
Views: 8285

Re: Assign Private Data and/or Rename Job using Reference File???

Thanks for all of the replies. When I posed on the forum, I also sent a support case in to enfocus and was made aware that we need the database module to read from an Excel file using the ODBC connector. Unfortunately, we do not have this module, so the XML may be the only way to go here. I do not h...
by matt.baile
Thu Nov 30, 2017 3:05 pm
Forum: Flows
Topic: Assign Private Data and/or Rename Job using Reference File???
Replies: 8
Views: 8285

Re: Assign Private Data and/or Rename Job using Reference File???

So I would put the XSLT transform in line with my job? I wouldn't be passing the Excel file each time, I was just looking to reference it when we received a file download from the FTP. I just added an XSLT transform element to the flow and it's asking for an XSLT stylesheet that I'm not familiar wit...
by matt.baile
Wed Nov 29, 2017 10:20 pm
Forum: Flows
Topic: Assign Private Data and/or Rename Job using Reference File???
Replies: 8
Views: 8285

Re: Assign Private Data and/or Rename Job using Reference File???

I've honestly never used either of those options so this is a good opportunity to do something new! Padawan - Do you have any examples of this or any reference material? Unfortunately, I didn't write the script to do the SQL lookup, but I can use it as a reference. I don't have any experience with t...
by matt.baile
Wed Nov 29, 2017 4:56 pm
Forum: Flows
Topic: Assign Private Data and/or Rename Job using Reference File???
Replies: 8
Views: 8285

Assign Private Data and/or Rename Job using Reference File???

I am creating a flow that downloads files from an FTP server, renames them, stores the original and renamed names as private data, calls a SQL database, and then archives files into a hierarchy derived from the file names and private data. I've done this before so I have most of the flow built, but ...