1
scurvyd
File Format for importing links needed
  • 2004/1/31 6:49

  • scurvyd

  • Just popping in

  • Posts: 23

  • Since: 2004/1/28


I have created my categories and now I have many links to add.

I am familiar with how to run an SQL query on the Db, however I require the file formats and any possible special instructions if necessary.

I figure I am not the first to ask so is there a link to the docs on this I can read, please.

Thank you really enjoying Xoops.



2
scurvyd
Re: File Format for importing links needed
  • 2004/1/31 22:01

  • scurvyd

  • Just popping in

  • Posts: 23

  • Since: 2004/1/28


OK then no answers.

I have this SQL code


THis is to insert a catagory, easy enough.

INSERT INTO `xoops_mylinks_catVALUES (10'Communities''http://');


This is the SQL for inserting a link.

INSERT INTO `xoops_mylinks_linksVALUES (11'ScurvyDawg.com''http://www.scurvydawg.com/'''1110755331870'0.0000'00);


Now my question is, the date reads - 1075533187 - What is this number is it the date? is it ok if I import a whack of links with this the same on all of them??

Any caveats would be welcome before I do a mass import.

Thank you.

3
christian
Re: File Format for importing links needed
  • 2004/2/1 0:59

  • christian

  • Just can't stay away

  • Posts: 401

  • Since: 2002/2/24


For the date, you can test with
unix_timestamp('2004-02-01')

Here others samples with date

Best regards
(Sorry for my english)

4
Mithrandir
Re: File Format for importing links needed

Shouldn't matter if the timestamp is the same on all of them. It's just a timestamp for creation.

Login

Who's Online

256 user(s) are online (174 user(s) are browsing Support Forums)


Members: 0


Guests: 256


more...

Donat-O-Meter

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

Latest GitHub Commits