I need to transfer the data from a website into the database of another. I need to do this from two ways. 1) from an SQL file. 2) directly from the html pages. The site I am transferring data from is running the Phpfox social networking script. The data must be imported into the new site via an API. I need a script to be written for the API. The API is based on the Perl language. Below is a short description of what can be done with the API of the site I am importing into:
So we have a REST API (which users yaml over http). This REST api allows a user to do things like:
* create users
* create photos
* create videos
* tag users
* create groups
* make a user a part of a group
* (and more)
With the api you can do all this programatically. We have implemented an in house Perl implementation of the API which allows one to write Perl code to add things into our system.
So the interaction looks something like this
Perl API -> YAML -> REST -> Our system
But if you use the Perl API, all you have to do is write Perl code.
Here's some pseudo code that explains the logic you might implement in the users part of your script:
foreach row in my users table
SynctreeApi->createUser( :user_name => row.user_name, birth_date ...)