Author Topic: Time and date stamp Problem (Read 1508 times)

cstephens · « **on:** February 15, 2007, 10:53:02 am »

I am loading a series of emails into LM and sending them to myself to make sure I have the message codes set up correctly and its working very well, however there is a problem with the time_date code.

I imported my details into LM as a CSV file on the 02/13/07 but when I send a email it has the current date (example below)

On 02/15/07, you, or somebody using your PC,
at IP Address 203.56.244.169 ect.

Is there a way to fix this
Thanks
Craig

DW · « **Reply #1 on:** February 16, 2007, 12:35:55 am »

Hi Craig,

Unfortunately there is often a difference between the time zone of your web server and your own time zone which would result in what you are experiencing. In the "Formatted Date" message code you might use the "T" character to output the time zone.

Thinking ahead to future features there may be a way to detect the subscribers' time zone and display information to them in that zone. This, unfortunately, is not yet possible however.

Regards

cstephens · « **Reply #2 on:** February 16, 2007, 10:04:58 am »

Dean
Thanks for your reply, but I may not have explained my problem correctly, what I want to do is upload a csv file of leads which I have purchased.

The formatting for the csv file is as follows.

"First Name","Last Name","Email Address","ÏP Address","Date Time"
"Craig","Stephens","email@whatever.com","203.56.244.569","FEB 11 2007"

So when I test this all the codes work fine except the “Date Time”.

Because these people have filled out a form on a particular date like the date above I need to remind them in my message to them that this was when they filled out the form (example below)
------------------------------------------------------------------------
On !{CUSTOM_DateTime}, you, or somebody using your PC,
at IP Address !{CUSTOM_IP}, completed a
special biz-op form indicating that you would
like more information.
------------------------------------------------------------------------
So when I send the message the date I need to be in displayed is the date they completed the special biz-op form, NOT the current date.

I hope this makes sense
Craig

DW · « **Reply #3 on:** February 16, 2007, 05:33:38 pm »

Craig,

This makes sense now, however it is not incredibly easy to do as you wish.

Basically we need to process that date field with some custom script, or do a search and replace, and turn it into a format ListMail understands.

ListMail expects dates in YYYY-MM-DD format

Your leads are provided in "FEB 11 2007" format.

Okay. Open up your text file:

Search and replace "JAN " thru "DEC " with "2007-01-" thru "2007-12-"

Search and replace " 2007"" with """

That should do it.

Alternately a custom script could be created to do the above on a line-by-line basis, outputting the resulting CSV. Let me know if you want help with such a script.

Regards