| Re: Importing formated data in news module ? |
| by igorvuk on 2004/10/8 6:52:10 This was very helpful, and it's works but i got errors on hevy load in database..(1 record per sec.).. is that normal? If I slow down input on 1 rec in 8 sec, everything is OK content of prep_fie: Quote:
Quote:
|
| Re: Importing formated data in news module ? |
| by rowdie on 2004/10/7 9:57:38 The format is unix time - number of seconds since 01/01/1970 GMT. You might want to try the mySql function UNIX_TIMESTAMP(date) to convert your dates. I haven't tried it but it looks like it might be what you need. information on function UNIX_TIMESTAMP(): can be found here. information on DATE and DATETIME strings: can be found here. Good luck, Rowd |
| Re: Importing formated data in news module ? |
| by igorvuk on 2004/10/7 7:06:37 OK, I found the way, but i don't understand date format (input).. storyid/uid/ title/ created/published/expired/ hostname/nohtml/nosmiley/hometext/bodytext/counter/topicid/ihome/notifypub/story_type/ topicdisplay/topicalign/comments 1/ 1/ ARE_01.pdf/1097103846/1097103846/0/127.0.0.1/ 0/ 0/ date time/0/ 1/ 0/ 0/ admin/ 0/ R/ 0 |
| Importing formated data in news module ? |
| by igorvuk on 2004/10/7 0:59:46 I have some idea, but I dont know it is possible.. I have huge database in FileMaker, and I can format output txt file in all kind of rules, but.. It is possible to "load" txt formated data in news module? Example of txt formated data: record;1;title;SOME TITLE1;topic;TOPIC1;description;SOME TXT1 record;2;title;SOME TITLE2;topic;TOPIC1;description;SOME TXT2 record;3;title;SOME TITLE3;topic;TOPIC1;description;SOME TXT3 to get 3(or more) Article in same topic !! |
Search
Recent Posts
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $15.00 |
| Due Date: | Jul 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $15.00 |
|
|