473,729 Members | 2,192 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

xml as an e-mail attachment job import/export/billing

Can anyone suggest the best and easiest platform for the following job,
possible freelancer and approximate budget for this:

"It must be a script that has as an input a long code from the "calling
scratch card" that

customers enters on our website. Script accepts the long code, validates
it with a

database, than offers a customer to create a login/pass to enter
customers personal area.
"Long code" consists of an open serial number that is printed on a
scratch card and closed

portion of a code under the scratch area.

2. In his personal area a customer enters his personal data and creates
a "subscripti on"

to some virtual service with several different service plans allowed.
Script accepts

customers input and creates very simple XML (actually a structured
summary of the

customers ID, number, date and the service plan choosen) with some 7-10
XML fields and

sends it via e-mail (attached to a message) to a service provider
address which is

connected to providers XML automation scripts.
3. Provider returns the result as a XML file attached to a message sent
to our e-mail

address, so the required script has to handle the incoming e-mail or
even be triggered by

an incoming mail (as for example the support tickets are triggered with
an incoming

e-mails from the customers in some perl/php support systems). Script
after being triggered

by incoming message from service provider should read the XML file and
import the data to

the database as well as send some message to the customer with the data
returned from the


Also the provider sends similiar XML files on a daily basis with the
information on an

extra charges (beyond the fixed monthly serviceplan fee), that should be
handled the same

way (script triggered by an incoming message to the particular address
should import the

data from XML file to the database).

4. Script must be able also to offer the following functionality to the

-To change the service plan from one to another (between 7 availible)
once in a month
-To terminate service
-To block service
-To prolong service by entering another "long code" from a "scratch
calling card"
-To check the history of the customer payments
-To notify customer about the close end of the billing period with an
e-mail message

requesting the customer to enter another "long code" from a scratch card
or some other

-To terminate/block user if no payment have been recorded for this user
in a database on a

daily basis.

All customer pages must be designed with the provided footer/header.

5. From the administrators end, the script should do the following:

- Generate a list of the "long code"s for scratch calling cards (this
module could be

taken from OSS project A2billing written on PHP:


- Give some simple interface to database (list of subscriptions, manual
edit of customers


- Allow admin to prolong the subcription manually (i.e. if the customer
have paid by bank

transfer or some other means)

- Allow to do a manual creation of the customer

- Allow to enter 3 kinds of prices for each out of 7 availible service
a) a providers price (i.e. - our costs)
b) a price for our resellers
c) a price for a final customers

- Some basic billing: total this month for us, for reseller(s), for

- Allow to create resellers accounts (login/password)

- Allow to block/unblock a single "long codes" for calling scratch cards
or in batch (the

whole blocks). This is to allow resellers to pay for the scratch calling
cards right

before the activation.
6. from the end of reseller the script have to offer the following
functionality only to

those customer that either were manually created by this reseller or
were registered with

a "long code" from a calling card sold to this reseller:

- Give some simple interface to database (list of subscriptions,
changing the status:


- Allow reseller to prolong the subcription manually (i.e. if the
customer have paid by

bank transfer or some other means to reseller)

- Allow to do a manual creation of the customer

- Some basic billing: total for reseller this month, total for all
customers this month.

Provider do provide a sandbox e-mail to test the application."
*** Sent via Developersdex http://www.developersdex.com ***
Mar 7 '06 #1
0 1435

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Paul Lamonby | last post by:
Hi, I am sending a file from the server as an email attachment. The file is being attached no problem and sending the email, but I get an error when I try to open it saying it is corrupt. Obviuosly, the file is fine on the server, so the attachment code I am using must be corrupting it, but I dont know what it is: // send email with attachment function emailAttachment($to, $subject, $message, $name, $email,
by: Damien | last post by:
Hi to all, I need to design an import/export system. Data comes from a filemaker pro DB in a big CSV file. Some alterations are made on the data as it is imported into my mysql table. Data is something like :id,text1html, text1raw,... . Problems : 1. Texts can contain html tags, including entities (" etc), so using only the ';' as separator does not work. 2. Some line are so long that is appears php breaks them down, so I lose
by: steve | last post by:
Hi, When I copy tables in a database from one server to another using enterprise manager, everything copies ok, except for field defaults. Has anyone seen this, and what is the solution? -- http://www.dbForumz.com/ This article was posted by author's request Articles individually checked for conformance to usenet standards Topic URL:...
by: Alok | last post by:
Hi, I recently upsized my access database to an ADP project with SQL backend. However when I did it the import/export specs were not ported to the new database. Also in the ADP files I am unable to create new import/export specs. The option is greyed out. I need to use the specs with the TransferText function. How can I get around this issue? Alok
by: Susan Bricker | last post by:
I would like to generate a report (I have the report working already) using MS/ACCESS 2000 and then have the ability to send the report as an email attachment to my colleagues. I have looked around in the MS/ACCESS Help facility and found that I can click on FILE (on the Menu Bar) and then click on SEND TO. This will generate, either, a 'Snapshot format' or 'Rich Text Format' file and send an email. Two problems: 1. Is it possible to...
by: Iavor Raytchev | last post by:
Hello, We a situation with a central database that contains the data that needs to be presented at N off-line terminals (N can be 5 000 can be 15 000). Each terminal presents unique data. The central database is used for data preparation. Then the data for each terminal is exported as separate SQL file. The terminals run the same application that is used to prepare the data - only in user mode. So what we do is - we export the full database...
by: phillip.s.powell | last post by:
We're looking at a GUI interface for our MySQL DB and I am interested in MySQL Administrator, however, one of our requirements is to be able to import/export databases. Is this possible or do I need to know else (e.g. Navicat)? Thanks Phil
by: maflatoun | last post by:
Hi, In SQL 2000 if I wanted to take a complete copy of another running sql database all did was create a new database locally and right-click it and select import and point to another database and click copy everything (stored procedures as well) and it did it for. I can't seem to find the same functionality in SQL 2005. You can copy tables and views but not the whole database. Is there another way of doing this? Our SQL database is...
by: Max2006 | last post by:
Hi, We are developing a SQL server based asp.net application. As part of requirement we should allow users import/export some relational data through web user interface. We are investigation which file format would be the most efficient format to import export relational data. So far we came up with two options: XML and Access MDB files and we prefer MDB files.
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.