DOCS: phpYellow Pro Edition

 

Database

This page describes database data migration.

Type of database: MySQL
Minimum version required: 3.23 or higher
Create table definitions: See the documentation that accompanied your software.

Data Migration

Overview

If you have a small amount of data to enter use the Quick Submit feature found in the administrative area. The form can be customized to suit your data entry needs. If you have a large amount of data to enter then you need data migration capability. You can do this yourself, or outsource to Globalissa or to others. Following is a description of how to migrate data from your source file to a target file for use in phpYellow.

Description

phpYellow is a database driven application and it requires that you match your source datafields with corresponding datafields in phpYellow, then to convert the resulting file into .csv or better, into .sql for direct import into phpYellow. You may utilize 3rd party SQL applications such as phpMyAdmin which lets you administer your MySQL database. Most host isps offer phpMyAdmin freely with your hosting account. Look for phpMyAdmin in your control panel.

Data Inserts

There should be data inserts into each of these tables for each record to migrate:

define("TABLECUSTOMER", "pypro710_contact");
define("TABLECATEGORY", "pypro710_listing");
define("TABLECOUPONS", "pypro710_coupons"); /* DO NOT CHANGE */
define("TABLEUSERNOTIFY", "TABLEUSERNOTIFY"); /* DO NOT CHANGE */

Relational integrity

This describes what relational data values to insert in each table:

• pypro710_contact.customerid is the primary key
• pypro710_listing.fkcustomerid is the same number as pypro710_contact.customerid
  This is used for a relational join of the contact and listing tables, for example in searches.
• TABLEUSERNOTIFY.fk_customerid should be the same number as pypro710_contact.customerid
• pypro710_coupons.ckey should be the same number as pypro710_listing.ckey

Example

See register_result.php for working code on those inserts.

Offer of data migration services

There isn't anything simple about data migration on a multiple table application. We offer data migration services. Send us a good quality source file. The better the source, the better the migration. Inquire for details.

Adding new data fields

We can add additional data fields on a custom mod basis. Time is roughly 1 hour per data field. Inquire for details.

 

    All content Copyright©2012 phpYellow.com. All rights reserved.