vaststar.blogg.se

Mediunic email sign in free#

Please feel free to provide your suggestions. In the Destination address field, we need to use the variable $ I hope you like it.In the email step, we need to configure the below-mentioned properties.Rename it as per our naming convention, start, email and success respectively.

Drag ‘Start’, ‘Mail’, and ‘Success’ from the list of plugins in the design tab.

Here we will use this job file to send emails. Now, all these names should match with our input file fields. FirstName, EmailAddress Title and BlogPost.

In the Parameters tab, we need to add four parameters viz.

In the send_email job step, we need to check Execute every input row field in the Options tab.

We need to browse for our transformation files in the read_files and send_email step respectively.

Rename the steps as per our naming convention to ‘start’, ‘read_files’, ‘send_email’ and ‘success’.

In the Main.kjb file, we need drag ‘Start’, ‘Transformation’, ‘Job’ and a ‘Success’ step.

We need to perform the below steps to pass variables. However, we will be passing variables differently at the job level. If we end our transformation with ‘Copy rows to result’, then all our variables are accessible in our next transformations. Passing variables is a simple process in PDI.

This will require us to set-up the parent Main job file before we configure the SendEmail child job file. We need to pass variables to our child job for sending emails one-by-one. We can test this unit by running the transformation and previewing the output. We can also provide conditions in case required. Here, I wanted to show the capability of merging two files seamlessly using join rows step. That’s it, join rows step will perform its magic without changing even a single parameter.Similarly, in the read_latest_post step, browse for the file (D:\Work\SendEmail\Input\LatestPost.csv) in the File or directory field and File tab, in the Content tab, change Separator field to comma instead of semi-comma, and in Fields tab just click on Get Fields button.In the read_email_list step, browse for the file (D:\Work\SendEmail\Input\EmailList.csv) in the File or directory field and File tab, in the Content tab, change Separator field to comma instead of semi-comma, and in Fields tab just click on Get Fields button.Rename the same ‘read_email_list’ (text input 1), ‘read_latest_post’ (text input 1), ‘merge’ and ‘copy_result’ respectively.Drag two ‘Text file input’, one ‘Join rows (cartesian product)’ and ‘Copy rows to result’ plugins from the transformation design tab onto the canvas.Documentation is very essential in any programming language. Add a description to the transformation by right-clicking>‘New Note’.We need to perform the below-mentioned steps. We need to read the input file in this transformation. Open the transformation ReadFile.ktr on your Spoon (Desktop App). The idea is to read the entire mailing list and loop through each member and send an email with a custom message. We need to read two worksheet within a transformation. Project Folder Structure Step - 2 Read Files

Mediunic email sign in free#