Script to extract and e-mail URL content

[caleb]

Has anyone been successful in implementing the following script?



IF so, could you link a URL or possibly copy a view-source here?



What I am looking for is this:



When I enable "Send transaction Data to URL" in my Edit Products tool and

append my e-mail address to the URL in the box a few screens over, I receive

a very long plain text e-mail with tons of attributes that looks like

this:



residence_country:

payer_business_name:

first_name: Jason

last_name: Fordham

payer_email: JasonFordham@msn.com

payer_phone:

payer_street:

payer_city:

payer_state:

payer_zip:

payer_country_code:



and on and on . . .



Note that since I'm selling a digital product (tickets) I do not need all of

that info. I just need a clean e-mail that gives me a few attributes and

their contents and deletes the empty fields.



example:



Name:

E-mail:

Number of Adult Tickets:

Number of Student Tickets:

Number of Senior Ticket:

Seating Selection:

Total Order:



Etc.



I'm sending this e-mail to my Box Office manager and she only needs the

relevant information to pull the tickets and hold them at will-call.



So . . .



If anyone has implemented a script at a URL--my server is apollohosting.com - I'm

assuming a Javascript will do) that will parse the URL parameters (I think

e-junkie uses GET for this) and then send out a couple or three e-mails to

my treasurer, me, and my Box Office Manager.



Thanks in advance if anyone can guide me in the right direction.

[E-junkie_Guru]

Although I don't have a specific script to offer, I can suggest some general advice you may find useful.



Our regular "Send Transaction Data to a URL" submissions work similar to a typical HTML form submission, where a user fills out a form and presses Submit to send their form data to a handler script's URL, which then wraps it up in an email to be sent to some address.



You might be able to find a generic form-handler script that allows you to specify which field names will be accepted, or at least in which order the fields would be ordered, so you could have the relevant fields appear first.

[caleb]

Yeah, it's the implementation that I am struggling with.



Here is a sample script that I set up and it DOES parse URL content and WRITES it to a page, but how would I get it to e-mail me?



Anyone able to help with a script sample?



http://www.romelittletheatre.com/geturl.htm



If you send a URL to that page, it will pull and parse the information and write it to a page.



Am I on the right track?



Thank!

[E-junkie_Guru]

The order-data submission for our Integration feature uses HTTP POST rather than GET, so there is no URL parsing to be done. More specifics are on our help page here:

http://www.e-junkie.com/ej/help.integration.htm



You would want basically a form-handler type of script where, instead of a user manually filling out a form and submitting that form, our server is automating the same transmission method to POST the order data to your handler script.

[caleb]

Ok, great, thanks Tyson.



And now I petition the e-junkie community . . .



Anyone have an example of a form-handler script that I can post to my server?



Or a push in the right direction.



Thanks so much,

Jason

[E-junkie_Guru]

Personally, I'm only familiar with the "nms-formmail" script available here:

http://nms-cgi.sourceforge.net/scripts.shtml



(This is a secure and modern replacement for the now-outdated formmail.pl script that was popular in the late '90s or so. It may not be the easiest for novices to set up, but it is robust, well-programmed and familiar for old Web hands like me. :^)

[ez_ecomm]

I'm setting up my first ecomm site - I'm using the older Formmail.pl script - which is stored in the cgi-bin. I'm confused about the URL page - Is it simply a blank page with a <FORM...POST...> tag that points to the script?



I also need to capture a DATE field that the user will select. How can I also retrieve this date? I'm trying to set this with PayPal Pro.



Any help will be appreciated.

[E-junkie_Guru]

First, you really should not use the old "formmail.pl" anymore, because it has a history of being insecure and susceptible to abuse by spammers. The nms-formmail script was designed as a direct drop-in replacement for formmail.pl, but one which is better-programmed and more secure; if you're already familiar with formmial.pl, you should find nms-formail quite familiar, but you'll wind up with a superior script. Even the original author of formmail.pl is recommending the nms replacements over his own, older scripts:

http://www.scriptarchive.com/nms.html



I'm not clear what you mean about the "URL page", unless you're asking about the Common Notification URL or Payment Variable Information URL for E-junkie's integration feature? If that's what you meant, then if your script is installed here:

http://www.example.com/cgi-bin/nms-formmail.cgi

...then that would also be the URL you specify for E-junkie integration.



If you want to provide a Date field or menu for your product's E-junkie purchase button, you could do that by enabling the "Variations which tell more..." setting for the product, then on the following screen you would name Option 1 something like "Date" and either provide a list of acceptable dates for Option 1 below that, or leave the list blank to show buyers a text field to fill in manually.

[ez_ecomm]

Thanks Tyson!

I will implement the nms-formmail as you suggest.



You have also answered my question about the Payment Variable Info URL.



The Date field is important to me as I'm selling Daily event tickets and I must know which Date the customer is paying for. I'm considering using a Calendar Script that will populate a date field by clicking a date on the pop-up calendar. Will this date be included in the Payment Variables by impementing the "Variations which tell more.." setting?



Thanks again!

[E-junkie_Guru]

Yes, configuring the "Variations which tell more..." setting will add a dropdown menu or text field to your product's Add to Cart button code.



Really, the values you supply for Variations are all arbitrary, so you could just set that up with sample dummy values to see how the button code HTML is structured, then you can write your calendaring script to output values dynamically within that structure.

[ez_ecomm]

Here's my problem - I have to refresh (F5 key) my browser a few times before the add-to-cart button actually does something. Occasionaly it will work the very first time I open the page. But often it will take upto 3-6 refreshes before adding items in the cart. I can't explain this! I'm not sure if I should put the link here for you to see what I'm talking about, but if you access the domain associated with my email you can get to the page via a link on the navigation panel (3rd from last).



Although I have a "Date" field via Variations... for each item, it only gives me a Date in the cart for the very first item? Something to do with the id="" parm??

[E-junkie_Guru]

I'm not sure exactly what could be happening, but I'd reckon it has something to do with your date-picker javascript conflicting with our cart javascript. Try moving these lines of our View Cart code lower in your page after your date-picker scripting, like just before your </head> tag or just before your </body> tag:



<script language="javascript" type="text/javascript">

<!--

function EJEJC_lc(th) { return false; }

// -->

</script>

<script src='http://www.e-junkie.com/ecom/box.js' type='text/javascript'></script>

[ez_ecomm]

I solced this problem and my transactions are going through. However, I get an automated email with this message:



"This is a notification that for the transaction 1ADXXX21XXX73YY, we were unable to notify your server as we were unable to connect to it."



Why am I getting this message?

[E-junkie_Guru]

That means that there was no response when our server tried to transmit order data to the URL which you had configured using our Custom/Third-party Integration features described here:

http://www.e-junkie.com/ej/help.integration.htm



If you were not intending to transmit order data to a script for additional custom post-checkout processing, you should remove any URL you might have added into your Payment Variable Information URL (in the settings of a specific product) or your Common Notification URL (in Admin > Account Preferences).

[travis]

I'm trying to figure out how to output customer data to the csv format that the US Postal Service requires for their automated postage payment & mailing label system. Basically, all I want to do is parse text.



I'm trying out sample code. I direct transaction data to http://budgetjustified.com/geturlTest.htm

which is supposed to call http://budgetjustified.com/cgibin/testParse.pl and output some text junk to a csv file. It seems as though nothing is getting output to the file, not even the text I hardcoded in testParse.pl .



Which makes me think something isn't being called. I tried placing testParse.pl in the cgi-bin directory, and tried it in the home directory. No results. Is there an example htm file that calls an example text parsing script that works with ejunkie?

[E-junkie_Guru]

Hm, well for one thing, using our Integration feature, you would typically direct transaction data to the URL of a script like http://budgetjustified.com/cgi-bin/YourScriptHere.pl which can receive HTTP POST submissions (similar to how a form-handler script works) and then do whatever you wish with the data, such as save it to a text file, reoutput it in a different format to yet another script or URL, etc.