Freelancer

Upload Email List and Add to CMSms FEU Database  

Upload Email List and Add to CMSms FEU Database is project number 521182
posted at Freelancer.com. Click here to post your own project.


| More Free Trial For New Buyers
 

Status: Frozen
(Awaiting action from bidder)

Selected Providers: -

Budget: $250-750

Created: 10/05/2009 at 1:59 EDT

Bid Count: 6

Average Bid:
$ 763

10/15/2009 at 1:59 EDT

Project Creator: DigitalSocorro
Employer Rating: (No Feedback Yet)

Bid On This Project
 

Description

My environment is running CMS Made Simple and its Front End Users Made Simple extension.

I want to build a custom module that can be added to CMSms, that has three elements:

1. Admin interface to register new file types (see below Admin Interface)
2. Email List Transformation tool (see below Email Transformation)
3. FEU Loader that will add/modify data into the FEU database, based on the Email Transformation -- note this utility already exists, and you may simply tell me to use it rather than building your own :)

Right Freelancer has good knowledge of CMSms, Opening Email Messages from batch, detaching attachments, converting worksheets into CSV using OpenOffice or other freely available scripts/tools ...


1. Admin Interface
==================

The following form would be needed:

-----------------------------------------------------------------
Add Email Translation Rule
-----------------------------------------------------------------
Rule/Source Name: _______________________

Rule Type: (drop down) Match Sender
Match Sender & Subject
Match Sender & Subject & FileName
Match Sender & Partial Subject & Partial FileName

Ajax Fields:

Sender: _______________
Subject: _______________ (only displayed for #2 and #3)
Partial Subject: __________ (only displayed for #4)
File Name: ______________ (only displayed for #3)
Partial File Name: _________ (only displayed for #4)

-----------------------------------------------------------------
Translation Setup:
First Data Row : ___
First Name Column # : ___
Last Name Column # : ____
Email Column # : ____
.
. Note lots of fields
.
User Defined #1 Column # : ___
.
. Up to 10 User Def Fields
.
User Defined #10 Column # : ___
-----------------------------------------------------------------

These inputs will be added into a table, and later used by the Transformation Engine, depending on which rule, the rules to match how this email will be translated comes from matching (1) sender+partial subject+partial filename and if not found then (2) matching sender+subject+filename and if not found then (3) sender+subject and if not found then (4) matching sender only

The other setup fields are used once you open the attachment as translation rules (which row do I start reading from, which column contains the first name, which column contains the last name, etc)



2. Email Transformation
=======================

So, we're building a CRON job (or something) that is opening a mailbox and determining if there are any new email messages. If any are found, the attachment(s) need to be pulled from the email and transformed. If the attachment is an XLS or XLSX file, it needs to be converted to a CSV. If the XLS or XLSX file has multiple workbooks, only the last workbook needs to be converted.

My thoughts from a pseudo code perspective:

Open the Admin Database
Select * from Admin Database
Build an array (Sender, Subject, Filename, firstrec_position, fname_position, lname_position .(lots of fields)..email_position, user1_position, user2_position ..lots of fields.. user10_position, source_name)Close Admin Database

Open Output File
Open Report Writer
Open the mailbox

Do until new_messages = 0
Next Message
Set Sender = sender()
Trim "re:" and "fw:" etc from Subject
Set Subject = subject()

Do until attachments = 0
Extract attachment (if excel with multiple worksheets, open only last worksheet)
Search admin_array for match to sender and partial subject and partial filename
Else Search admin_array for match to sender and subject and filename
Else Search Admin_array for match to sender and subject
Else Search Admin_array for match to sender
Else Trigger Error Message "Sender=sender, subject=subject, filename=filename -- no array match"

For x=1 to firstrec
Read attachment row to ignore junk/header
End

Do until eof
Read attachment row
fname = csv column that matches Admin_array fname_position
lname = csv column that matches Admin_array lname_position
.
.
.
email = csv column that matches Admin_array email_position
user1 = csv column that matches Admin_array user1_position
.
.
.
user10 = csv column that matches Admin_array user10_position
if Admin_array lname_positon = 0 then assume we have to split fname into fname||blank||lname
Write Output File source_name, fname, lname, ... email, user1 ... user10
Write message to report writer
End
End
End

Close the mailbox
Close the output file
Close the report writer and send as email to admin
Exit

Messages Posted:0 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

1200

20 days

10-05-2009 07:44 EDT

Hi , We are interested , Please check PMB...

help

 

750

15 days

10-05-2009 09:05 EDT

Hello, We are a team of professionals with more than 2 years of experience and developed over more than 160 projects covering template designing, Creating templates, creating complete web-sites and also payment gateways. Please check PM for more details taking 2 minutes of your time and it will help you make a decision why to choose us. Thanks.

help

 

700

25 days

10-05-2009 08:24 EDT

(No Feedback Yet)

I am professional PHP Developer and having 4 Years Experience in Web Development I have Experties of Web Designing,flash,PHP and open sources(Joomla,Drupal,etc...), site Security I will complete it according to your requirements and given time if you give me a chance then I will prove it. Thank you very much.

help

 

500

30 days

10-07-2009 03:10 EDT

(No Feedback Yet)

Dear sir, I'm interest on your project. If I win the project I'll try to please you working actively with honesty.

help

 

700

21 days

10-07-2009 22:55 EDT

(No Feedback Yet)

I am professional PHP Developer and having 4 Years Experience in Web Development I have Experties of Web Designing,flash,PHP and open sources(Joomla,Drupal,etc...), site Security I will complete it according to your requirements and given time if you give me a chance then I will prove it. Thank you very much.

help

 

730

23 days

10-14-2009 06:36 EDT

(No Feedback Yet)

My Name is subbughousle.I have 3+ Years of Exp As an PHP Develpoer working In IBM at Bangalore.I have a team of professional web developers working for me in india.We develop quality product and give maximum stress on customer satisfaction.It would be nice working with you. In case if you want to see some of our work.

help


    Bid on this Project