windows server 2008r2 scheduled task didn’t quite want to work

solution: use the start in folder…. grrrrr

About these ads

So the bizlink address was really annoying so I fixed it with a redirect

I can’t stand web services that have you go to really long URL’s

for example the bizlink addy is http://s-bizlink:8080/ipnet/msgsrv/WebApp?app=msgsrv&cmd=onStart

Sure you can make a bookmark but what if you are on some other random device?

So this is what you do to fix it

Open up C:\BizLink\app3.3.0\tomcat\webapps

create a folder called ROOT

create a file called index.html

add the linke

<meta http-equiv=”refresh” content=”0; url=http://yourserver:8080/ipnet/msgsrv/WebApp?app=msgsrv&cmd=onStart” />

save.

Now you can browse to http://yourserver:8080 tada magic

Bizlink and requesting FA’s

So I sent over a document but it would always say ack not requested

So I sent a note to tech support what gives. Well apparently you can use the rules engine to do various things with your FA generation

One quick way is to put a processing rules on the Originator of yourself. Call it FA Timeout

If the Transaction_IDCode is Equal To 947, then you can have an action of

FA Timeout,

Inside the timeout you can set either, Expected, Not Expected (it defaults to this), or Expected with not time limit. If you choose expected it wants a time limit and will send warnings to the trading partner.

I choose Expected with no time limit for now. And now my screen says Expected for the FA

Bizlink, creating new doc types for tracking metadata

So for what ever reason bizlink is set up with some of the more common doc types say 850’s and 810’s etc… to grab the useful metadata and index so you can search on it…. but it neglects to do this for all types… seriously, it would not be hard for them to do this correctly. Anyways when you contact them about it, they so kindly refer you to their professional service$ dept.

So, I am going to try and tease it out on my own.

The manual is at least kind enough to let you know that the xml files live in

C:\BizLink\app3.3.0\metadata

Clicking around the genst_GP looks as likely of a template as any for my 945, so I make a copy of it and rename it genst_945

I think the ST and SE should be boiler plate so I’m focusing more inside the ‘G01′

So instead of a G01 I want data from the W06

so

<Record Name=”G01″ Comment=”Beginning Segment for Invoice” MinOccur=”1″ MaxOccur=”1″ Optional=”M”>
<Element Name=”G0100″ Comment=”Segment Id” Optional=”M” Validator=”G01″ Saved=”SegmentName”/>

Becomes

<Record Name=”W06″ Comment=”Beginning Segment for warehouse transfer advice” MinOccur=”1″ MaxOccur=”1″ Optional=”M”>
<Element Name=”W0600″ Comment=”Segment Id” Optional=”M” Validator=”W06″ Saved=”SegmentName”/>

Now looking at this line

<Element Name=”W0601″ Comment=”Date” EdiCode=”373″ Optional=”M” VisableAttrs=”EdiCode”/>

I need to change the EDI code to a 514 that I have in my edi spec for the W06

so becomes

<Element Name=”W0601″ Comment=”Reporting Code” EdiCode=”514″ Optional=”M” VisableAttrs=”EdiCode”/>

and

<Element Name=”W0602″ Comment=”Invoice Number” EdiCode=”76″ Optional=”M” VisableAttrs=”EdiCode” Saved=”SigId2″/>

becomes

<Element Name=”W0602″ Comment=”Depositor Order Number” EdiCode=”285″ Optional=”M” VisableAttrs=”EdiCode” Saved=”SigId1″/>

(Changed it to SigId1 since that is the Document Number 1 I want to populate)

So I’m going to continue this editing and then bring in a 945 and see if it does anything useful for me. (I also created the 945 doc type on the Setup / Doc Types screen and pointed it to /genst_945.xml)

#Mapforce 2014, cool beans

So I have been rockin mapforce like its 2008. I finally got around to getting updated and on 2014. My favorite additions so far are the dynamic file paths. I used to have to edit the generated code but now I think I can do it all from within the mapforce studio! I used a simple wildcard path for the input path, and then used a get-folder + concat + ‘xml\’ + remove-folder and a replace-fileext and plugged it into the outbound file and wala there ya go!

Qlikview Tip – fix if you are getting blank lines from a stored procedure

I have been dealing with this same issue > SQL Svr 2008, and using temp tables.  Works fine over ODBC, but nothing is returned over OLEDB.  I was able to get around this by adding set nocount on to the proc, e.g.:

 BEGIN

 SET NOCOUNT ON

or you can use ODBC

From

 http://www.qlikcommunity.com/thread/4065

 

 

 

BizLink Install Part 2

Now we need some AS2 action. So I went to Parties (who doesn’t like parties??)

Since I already have an AS2 server I figured I would use it for testing against. So I grabbed its address and public cert, next I ran the AS2 Setup Quick Start Wizard that is on the welcome page.

This configured my local AS2 server I named it NFFCTEST and set the AS2 URL to reflect the ip of the system, I’m assuming I will set it to an external IP when I go into production.

It auto generated a cert for AS2 which was nice of it.

So now I needed to add an External Trading Partner

I gave it a name, typed in the AS2 Identifier and the AS2 URL. Originally I forgot to include the port (which made it not work of course)

I set a Customize Subject Header, and use EDI Message (I don’t know if this is correct, but it matches my other server settings)

I set the S/MIME Signed/Encrypted for the format type. For the Encryption Algo I set to DES3 168 (it defaults to AES 128) and signing algo to SHA1 160

I added the public cert that came from my other AS2 box.

I enabled Retry, 3 times, every 300 seconds.

I enabled Resend, 3 times, 1 every hour.

Then submit.

– Ok so that’s all fine and good. Now I need to get a file into this thing.

I went to Server, services. And then clicked add. Then added Directory Monitor Inbound. I created a folder and used an Include Mask of *.edi

I just specified the Originator / Recipient because I thought that was easiest!

I set the scan frequency for every 10 seconds, from 00:00 to 12:59 PM

Ok, now let’s drop a file in and see what happens.

If everything works you should see the file, and you should be able to click on it and get to this message tracking screen

bizlink3

 

 

 

 

 

 

 

 

 

 

Follow

Get every new post delivered to your Inbox.

Join 243 other followers