Package - Variable Read from CSV+Email

More
2 years 5 months ago #23532 by admin
Please provide us with the file and a package. 

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
2 years 5 months ago #23533 by prashant
Attachments:

Please Log in or Create an account to join the conversation.

More
2 years 5 months ago #23534 by Peter.Jonson
Found a bug, a silly one

64 bit compiler assigns incorrect default value to  HeaderLines so the all the data is skipped (it should be zero)

Anyway can you try the latest version please.

Also the variables names within the file have no spaces but inside the Show message you do have spaces 

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
2 years 5 months ago #23535 by prashant
Hello,
This woks. Single CSV is being read now 

Question now , the format is supposed to be for loop to work or it won't matter?

<FirstName>, John
<LastName>, Peterson
<Email>, john@mail.com
<FirstName>, Peter
<LastName>, Parker
<Email>, peter@mail.com

OR

<FirstName>, John
<FirstName>, Peter
<LastName>, Peterson
<LastName>, Parker
<Email>, john@mail.com
<Email>, peter@mail.com




 

Please Log in or Create an account to join the conversation.

More
2 years 5 months ago #23536 by admin
You missing the point here

The lop action assign line value to a singe variable.

is if you file has 3 lines

Line 1
Line 2
Line 3

Loop reads the file one line at the time and assigns line value to a variable

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
2 years 5 months ago #23537 by prashant
I am totally confused.

1. Can you give me a package example of reading from CSV file along with loop to see variable/email? (as the original request)
Read CSV file containing multiple people name and email like below , how to send them emails
<FirstName>, John
<FirstName>, Peter
<LastName>, Peterson
<LastName>, Parker
<Email>, john@mail.com
<Email>, peter@mail.com


Loop reads the file one line at the time and assigns line value to a variable
Loop takes CSV file input,
Set variable takes CSV file (which is being read?)

Inputs are taken one at a time , how do It know which cluster to take for mail merge to happen <FirstName>, John <LastName> Peterson <Email>, john@mail.com


 

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save