Automated ECN Submission - Pseudocode

-

 Automate redline

function(BU_####### string)


//Retrieve Redlines

open http://elstr.stadlerrail.ch/change#number=BU_#######

Navigate page and select attachment.pdf

Download attachment.pdf to /workfolder



//Fill out Change Management Form using url class <change details>

store class."alpha main-title" as string Title

store class."cd-assignment" as string Zuordnung

store class."cd-type" as string Typ

store "Technik" as string Abteilung

Open Antrag.docx from /systemfolder

Write variables as text

Save Antrag.docx as Antrag.pdf in /workfolder


//Update Antrag

Open AE_Antraege_CalTrain.xlsm

Row_count(sheet) as lngRow

Select Cell(lngRow+1,1)

Fill(Title,Zuordnung,Typ,Abteilung)

store lngRow+1 as int lfdno


//Combine into single PDF

EITHER

Open Adobe X Pro

function combine pdf

For each *.pdf in /workfolder

select .pdf

ok

combine

OR

Open Antrag.docx

insert pagebreak

insert object -> attachment.pdf

Save product as "L-4380 AE-Antrag" & lfdno & ".pdf" in /gescannte AE-Antraege

end function


 

Comments

Post a Comment

Popular posts from this blog

Bear Lake Observatory

-
Image
Objective The purpose of this project was to design and implement an improved system to open and close the USU Bear Lake Observatory (BLO) dome and provide alerts to the user on the status of the dome as well as the weather conditions at the dome. The previous system that was used was functional, but did not have exceptional functionality. The following problems arose during use of the previous observatory dome system: The previous system ran through a mac mini that was connected to a PLC. This means that when the Wi-Fi was down, the dome was inaccessible unless the dome user partially disassembled the dome.  Previously, the dome did not contain any sensors to detect rain or other weather conditions that could damage the telescope. The only way of knowing if it was raining at the dome was by checking the weather conditions and looking at the cameras at the dome. When the bump guard was triggered, power was cut from the dome and could only be reestablished when the bump guard was re...
Read more

Engineering Capacity Planning

-
Image
1       Introduction Stadler relies primarily on experience and intuition when making capacity decisions. Although this strategy has proved historically successful for the company, there isn’t a concise feedback loop to validate and improve the predictions. It is difficult to communicate expectations across the project phases with regard to predetermined budgets. Managers with limited understanding of the overall workflow are at risk of understaffing their departments at critical phases. This in turn leads to missed payment milestones, and management is pressured to add emergency personnel to make up for lost time. Although coined for a separate industry, Brooks’ Law takes shape, and that is “adding manpower to a late software project makes it later”. Brooks’ Law describes a scenario where total productivity declines due to resources being diverted to onboard potential contributors. Broadly speaking, strained capacity increases the total cost by means of d...
Read more