DicE Posted February 14, 2003 Posted February 14, 2003 Hi, I have a serious problem with one perticular date. The product_date_avail to be more specific. I use the 20030203 snapshot, with QCv5.1 and the latest easypopulate. The problem is that the date when a product is going to be available is all wrong. It's correct in my excell sheet, in my tab delimited file. Then I upload it through easypopulate with following result: DateAvail was --6/3/2003--DateAdded was ---- | 0702200322 | /xbox |... Still no problem there. but when I go and look on my site, the date is: 20/03/2006 So as you can see, my dateformat is being changed to the US format YYYY/MM/DD (2006/03/20 and the "03" is just dropped) and the date is then reformated to be displayed conform my date formatting. (20/03/2006 <- customer is going to have to wait LONG TIME!!! :shock: I first thought this is due to the QC contribution because when I look at the product detail page in my admin section, I can see there that next to the field to enter the date available, there is a comment that dates must be in YYYY/MM/DD format. But now I see that the date is also in the wrong formatting in my database. Strange thing is that all the other dates like "product_data_added" and "product_date_mod" are entered correctly in the db. so why isn't this one put in correctly? :?: :shock: please help. It's been bugging me for days now and I can't make anymore sense of the php code that I've been going through! I'm not a programmer... :cry: Maarten _____.:::.________###__________|/______ :(o o): . (o o) (o o) ooO--(_)--Ooo-ooO--(_)--Ooo-ooO--(_)--Ooo-
DicE Posted February 14, 2003 Author Posted February 14, 2003 Really, what is the matter? :shock: I need some help here. This is the 3th post I made that just get's ignored by everybody... I thought this forum was here for the more challeging questions then (no offence intended) "how to add a language to osc" or "where is the install.php file?" ... for me this is for the questions that are not in the manual... apparently its not..???? :roll: someone should know the answer here, no? Need more info? Just let me know....! _____.:::.________###__________|/______ :(o o): . (o o) (o o) ooO--(_)--Ooo-ooO--(_)--Ooo-ooO--(_)--Ooo-
DicE Posted February 14, 2003 Author Posted February 14, 2003 oh yes ... incredible response... just love my popularity :wink: _____.:::.________###__________|/______ :(o o): . (o o) (o o) ooO--(_)--Ooo-ooO--(_)--Ooo-ooO--(_)--Ooo-
DicE Posted February 15, 2003 Author Posted February 15, 2003 HEEEEEEEEEEEEEEEEEEELP!!! really.... :cry: _____.:::.________###__________|/______ :(o o): . (o o) (o o) ooO--(_)--Ooo-ooO--(_)--Ooo-ooO--(_)--Ooo-
Guest Posted February 15, 2003 Posted February 15, 2003 What format is your date in excel sheet? it should look like 2003-02-11 to work corectly
wasson65 Posted February 15, 2003 Posted February 15, 2003 Really, what is the matter? :shock: I need some help here. This is the 3th post I made that just get's ignored by everybody... I thought this forum was here for the more challeging questions then (no offence intended) "how to add a language to osc" or "where is the install.php file?" ... for me this is for the questions that are not in the manual... apparently its not..???? :roll: someone should know the answer here, no? Need more info? Just let me know....! Hi, Tim here, the EasyPopulate author. First a couple words about date formatting and databases. DB's don't store your date the way you like to see it. They store it the same way no matter where in the world you are. It's generally up to the application code to convert the date information into a format that the user wants to see. The application code can ask the database to format it a particular way, and the query will return with the formatting already done. I'm sorry that you feel that you're being ignored, but I'll be honest: I have a wife, 4 kids, and my own consulting business + a mortgage. I don't camp out here, searching the forums every 5 minutes so I can give free support. I give what I can. I try to stand behind my product. Now, on to the interesting info about your problem: EP doesn't do any date formatting at all. It takes what the db gives, and puts it into the download. It takes what you give, and puts it into the database. It doesn't try to guess or think about any conversions. If you had done a download of sample data from your store, you'd have seen the date format that the database and EP are using. As far as this "not being in the manual"? You're right, it's not. I'm adding it right now. I hope this came across as just a very slight rant. Not a big one, just a little one. I'm sorry you had to wait 3 or 4 days for a definitive answer, but on the plus side, you did get the info straight from the developer, the docs did get updated so that others won't suffer the same fate, and the price was right. Just keep in mind that the folks here are doing this as a free service. OK, Tim's mini rant is over, you have the answer to your problem, and EasyPopulate is better now than it was a few minutes ago. See, the system works! Good luck with your store, and see you on the boards, Tim
DicE Posted February 16, 2003 Author Posted February 16, 2003 Hi Tim, thanks for the answer. Just for the record, I was not giving comments on you or anybody here (not intentionally anyway :oops: ) EP rules as far as I know. I just can't understand that all the dates that EP adds to the database get entered correctly, even the product_date_avail. Or so it seems when I look at the stream that is returned by EP when it has finished doing it's thing. But when looking at the database itself through PHPmyAdmin, it's all wrong. So somewhere along the line, something is altering my date... So the solution should be that I should have my date in YYYY-MM-DD format in my excell sheet? right? I could do that, but then again, I live in Belgium, and we put dates like DD-MM-YYYY. So my question was, how can I change "something" (EP? or some other code) so I can keep my BE format? Seeing I get my data like this from where I buy my products, that would ofcourse help... If it's not possible then I'll have to change it. no way around it :cry: But thanks for your help Tim! I appreciate your help a lot. You've always been there for us in the past and I know you'll always be there behind your contribs in the future. Keep it up!!!!!! Maarten _____.:::.________###__________|/______ :(o o): . (o o) (o o) ooO--(_)--Ooo-ooO--(_)--Ooo-ooO--(_)--Ooo-
Guest Posted February 16, 2003 Posted February 16, 2003 Where i live dates are also dd/mm/yyyy but that has nothing to do with easypopulate which i must say is excelent work done ...THANKS TIM! You must change date format in your language file to display it corectly on page. :)
DicE Posted February 16, 2003 Author Posted February 16, 2003 tomzzzy, I'm not saying that I have this problem due to EP. Don't get me wrong. I share your opinion, it is excelent work! wouldn't know what to do without it... I can see that EP imports my dates correctly as it reports back to me with : DateAvail was --6/3/2003--DateAdded was ---- | 0702200322 | /xbox |... that's a good date... I suppose it's just being interpreted by mysql as being 2006/03/20... I did check my date format in my language files. everything is alright. So you put your dates in the YYYY-MM-DD format in your excel sheet then? ok, I'll do that then. Thanks a lot for all the help!!!!!!!! Keep up the super trooper work on EP Tim! :lol: _____.:::.________###__________|/______ :(o o): . (o o) (o o) ooO--(_)--Ooo-ooO--(_)--Ooo-ooO--(_)--Ooo-
wasson65 Posted March 4, 2003 Posted March 4, 2003 tomzzzy, I'm not saying that I have this problem due to EP. Don't get me wrong. I share your opinion, it is excelent work! wouldn't know what to do without it... I can see that EP imports my dates correctly as it reports back to me with : DateAvail was --6/3/2003--DateAdded was ---- | 0702200322 | /xbox |... that's a good date... I suppose it's just being interpreted by mysql as being 2006/03/20... I did check my date format in my language files. everything is alright. So you put your dates in the YYYY-MM-DD format in your excel sheet then? ok, I'll do that then. Thanks a lot for all the help!!!!!!!! Keep up the super trooper work on EP Tim! :lol: Hi again, See, you guys keep coming up with cool features to add! I'm hoping to get a bit more time to spend on EP here in the next week or so, I've been totally stacked up. Of course, that's better than the alternative, so I'm not complaining in the least. I do agree that making EP handle a user-configurable date format would be a good thing, but I can't promise when that's going to happen. Now if you write the code, I'd be happy to include it! LOL!
DicE Posted March 5, 2003 Author Posted March 5, 2003 I would love to write the code for you Tim, if only I knew some php :? I already got the big PHP bible book, but I'm sorry to say that I havn't gotten any further then chapter 1 yet :roll: It would be a great feature though so if anyone else should feel like doing the good deed ... DicE _____.:::.________###__________|/______ :(o o): . (o o) (o o) ooO--(_)--Ooo-ooO--(_)--Ooo-ooO--(_)--Ooo-
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.