Data Conversion Assistance Needed

Discussion in 'Installation and Updates' started by Marc Lamaison, Jun 8, 2006.

  1. Marc Lamaison

    Marc Lamaison Paid Customer

    I have an old directory that contain values for Rating and Clicks and I want to convert it to work with eSyndiCat.

    For Rating the old directory just stored the average rating from 1 - 10

    Code:
    id      rating
    212    8
    213    7
    So I figure I can just import them in dir_votes

    Code:
    id_link   vote_value       ip_address     date
    212      8                    null               0000-00-00 00:00:00
    213      7                    null               0000-00-00 00:00:00
    
    - Will this work in eSyndiCat without the IP and date?


    For Clicks the old directory would just increment a number so the data looks like this
    Code:
    id_link       clicks
    212          612
    213          401
    
    It appears each click is stored in a single row in dir_links_clicks, so I guess I need to created 612 rows for id 212.

    Code:
    id      id_link     ip           date
    1      212        0.0.0.0    000-00-00
    2      212        0.0.0.0    000-00-00
    .
    612   212        0.0.0.0    000-00-00
    
    - Can this be done with a SQL statement for each link id I have? I have about 5,000 links and I estimate 1.2 million clicks.
    - Will it work within eSyndiCat without the IP and Date?
  2. Sergey Ten

    Sergey Ten <b>eSyndiCat Lead Developer</b>

    Hello Marc Lamaison,

    Yes, you are right. EscyndiCat will work without the IP and Date.

    If you want I could migrate your information of the Rating and Clicks.
  3. Marc Lamaison

    Marc Lamaison Paid Customer

    You Guys Rock!

    I'll take you up on that offer. I emailed you the dumps.

    Thanks a million,

    Marc

Share This Page