i.e. if you have a bunch of .txt files and you wanted to keep them but also have a copy with .xml
go to dos promp
go to that folder of files
copy *.txt *.xml
There you go
Filed under: Applied IT | Leave a Comment »
i.e. if you have a bunch of .txt files and you wanted to keep them but also have a copy with .xml
go to dos promp
go to that folder of files
copy *.txt *.xml
There you go
Filed under: Applied IT | Leave a Comment »
select a.col1, b.col2
from db1.dbo.tab1 a, db2.dbo.tab2 b
where a.col1 = b.col2
All you sql wizards prob know this alread
Filed under: Applied IT | Leave a Comment »
dir “C:\FOLDER” /b/s |find /v /c “::”
Filed under: Applied IT | Leave a Comment »
FOR /F “tokens=*” %%i in (‘%~dp0sometool.exe’) do SET TOOLOUTPUT=%%i
Filed under: Applied IT | 1 Comment »
ST
ST01 Transaction Set Identifier Code i.e. 997 for a Functional Acknowledgment
ST02 Transaction Set Control Number
AK1
AK101 Functional Identifier Code i.e. if you are acknowledging a SI, send SI
AK102 Group Control Number i.e. the assigned number originated and maintained by the sender
AK2
AK201 Transaction set identifier code i.e. if you are FA an 858 send 858
AK202 Transaction set control number
And AK5 was most interesting to me
AK501 Transaction Set Acknowledgment Code
A Accepted
E Accepted But Errors Were Noted
R Rejected
AK501 Transaction Set Syntax Error Code
Code indicating error found based on the syntax editing of a transaction set
1 Transaction Set Not Supported
2 Transaction Set Trailer Missing
3 Transaction Set Control Number in Header and Trailer Do Not Match
4 Number of Included Segments Does Not Match Actual Count
5 One or More Segments in Error
6 Missing or Invalid Transaction Set Identifier
7 Missing or Invalid Transaction Set Control Number
And for the more in depth PDF download here http://sites.google.com/site/mellerbeck/Home/997_4010.pdf?attredirects=0&d=1
Filed under: Applied IT | Leave a Comment »
If you are running your computer as a joe schmoe user, and you have a mapped drive to a server, when you go to connect to an administrative share it will give you:
Multiple connections to a server or shared resource by the same user, using more than one user name, are not allowed.
In order to get around this try the below
From here
http://www.experts-exchange.com/Networking/Windows_Networking/Q_22912036.html
There’s a little workaround that allows you as many as two parallel connections with different credentials to the same machine:
For one connection, use the host name to connect to the share, for the other connection, use the IP address.
Filed under: Applied IT | Leave a Comment »
This might be interesting for some
We bought two PS6000’s 10/09
One came with a bum controller card which was replaced Quickly. Then 12/09 we lost a drive on the same PS6000. Then the PS6000’s have note had issues (as of Jan 27 2010)
We also bought a PS4000 at the same time
It lost its first drive on 12/12/09
then its second drive on 12/15/09
then its third drive on 1/26/10
This has been a little too frequent for my tastes….
No data has been lost and the failovers have worked flawlessly. It makes me wonder about that whole SATA versus SAS reliability thing though.
Filed under: Applied IT, equallogic | 3 Comments »
There are posts all over the place showing you how to get your iphone UUID. But I’m lazy and I can’t be bothered to connect my iphone to my computer and open up Itunes (what an abomination of a program anyways)
Anyways there is an app for that… its called hm UUID which gives your UUID and then lets you email it to someone.
Filed under: Applied IT | Leave a Comment »
.
Filed under: Note to self | 2 Comments »
So started the process of setting PowerTrack for our Freight Invoice Consolidation. Since I am always annoyed when I can’t find any data on subject on the Internet here is a quick overview of how PowerTrack works as well as their 858 doc specifications.
Well not sure if you can read that or not but basically you send an 858 to powertrack, and your shipper sends an invoice to powertrack. PowerTrack then matches your expected freight to what they invoiced and if they match then the pay on your behalf. Every month they then bill you a consolidated invoice. The shipper pays for this service with a 1% off of their bill.
Ahh, and here is the infamous 858 EDI doc specifications. http://sites.google.com/site/mellerbeck/Home/8584010PowerTrackProductStandard1-7-0.pdf?attredirects=0&d=1
So here is my desired workflow
Automate Order creation, I do this with an inbound 850 through TEE
Auto Ship the order, I do this through an Expect TCL script. (Setup the Customer to create an outbound advanced shipping order, through external interface)
Parse the outbound .EIF files and look for a match of the freight types that we are desiring, otherwise delete the .EIF.
— Check that the .EIF contains all of the needed lines (in case it is shipped by different plants) If not, put it on hold until the other line comes along and then combine them.
Convert the .EIF to XML using transform.jar
Convert the XML to x12 EDI either using bots transform engine or mapforce
Use mendelson AS2 to send the file.
Receive 997 through AS2 into BOTS. Match the Adage database (select on all sales orders that match the freight types) to the BOTS database and confirmed status.
Filed under: Uncategorized | Leave a Comment »