Data Conversion Assistance Needed

[Marc Lamaison]

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

id rating
212 8
213 7

So I figure I can just import them in dir_votes


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

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.


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?

[Sergey Ten]

Hello Marc Lamaison,

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

id rating
212 8
213 7

So I figure I can just import them in dir_votes


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?


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




For Clicks the old directory would just increment a number so the data looks like this

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.


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?

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

[Marc Lamaison]

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

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

Thanks a million,

Marc