Posts

Showing posts from November, 2008

Boeing MBD FTP Download Script

Here is my Boeing MBD Hubspan FTP Download Script. (vbscript)
Instead of downloading files from Hubspan with FTP, decrypting with PGP, and then unzipping the tar.gz and zip files all by hand, this script will do it all for you.  I have it added to a Scheduled task on a Windows server that runs at 6am and Noon.
Make sure you note the instructions in the header.

I have added newer versions of my Hubspan scripts here:
https://www.dropbox.com/s/pdbnfow7qxwukq4/Hubspan-Scripts.zip?dl=0

'Author: Ed Hammond
'Date: Nov 1, 2008
'Purpose: Search pickup.log file for new jobs to download, download them, decrypt with GPG, unzip with PowerArchiver.
'Usage: This script will parse the Boeing SNET pickup.log file and output today's files in pickup-out.txt.
'Requirments: Install PowerArchiver (or modify script for winzip) and GNU GPG. Add the path to both programs to your PATH system variable.
'Requirments: Don't forget to import your PGP keys and get…

Infopath Boeing MBD Log Form

Image
Here is a snapshot of the log form I created from tracking Boeing MBD Data.
We use a website called MBDCentral.com to create our drawing from CATIA data, so the form includes information for tracking where our data is with them as well as Boeing.

In order to do what we are doing, you need to publish your infopath form to sharepoint and write the results to a SQL database.
We use SQL reporting services to generate status reports from the data.

Boeing MBD data administrator

Well, I'm now the Boeing MBD (Model Based Definition) data administrator for Skills Inc (in addition to being the Sr. System Admin).
I have been working for the last few months on our methods and I will be posting some useful information here to help others who need to take on this.
Background: MBD is Boeing's way of handing off drawing responsibilities to the suppliers to "save money". Yea. Right.

I have created a InfoPath form that we use to write our logs to a Microsoft SQL2005 database per the Boeing MBD requirements outlined in our DPD (Digital Product Definition) Quality Assurance Plan.

I also wrote a Vb script that will fetch our MBD CAD (CATIA) files from Boeing for us.
This is what it does:

1. The script connects to our Boeing SNET (tdi) account and pulls down via FTP the pickup.log file that shows all files that they have for us. This doesn't actually show the file name, so I just glean the beginning of the name from the log and use a wildcard for the rest wh…