XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Modules Support forums / 
  3. Module usage questions 
  4.  / Importing formated data in news module ?
Register
1
igorvuk
Importing formated data in news module ?

  • 2004/10/7 0:59

  • igorvuk

  • Just popping in

  • Posts: 8

  • Since: 2004/3/1 8


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 !!
2
igorvuk
Re: Importing formated data in news module ?

  • 2004/10/7 7:06

  • igorvuk

  • Just popping in

  • Posts: 8

  • Since: 2004/3/1 8


OK, I found the way, but i don't understand date format (input)..

[size=xx-small]
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
[/size]
3
rowdie
Re: Importing formated data in news module ?

  • 2004/10/7 9:57

  • rowdie

  • Just can't stay away

  • Posts: 846

  • Since: 2004/7/21


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
4
igorvuk
Re: Importing formated data in news module ?

  • 2004/10/8 6:52

  • igorvuk

  • Just popping in

  • Posts: 8

  • Since: 2004/3/1 8


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:

INSERT INTO xoops_stories VALUES (0,0,'ARENA No.56 PDF/s',1097151272,1097151272,0,'192.9.100.107',0,0,'','NIS',0,1,0,0,'admin',0,'R',0);

Quote:

#>mysql cms < prep_file

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

126 user(s) are online (68 user(s) are browsing Support Forums)

Members: 0

Guests: 126

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits