2. PHPRunner General questions
  3. Import function in 4.2
This topic is locked

Import function in 4.2

 		2/29/2008 4:48:06 PM
PHPRunner General questions
author

Hi: the only thing I see about "import" is that it is added to the "Pages to Build" page. When I click the "read me first" linik, I get an error that the page is not available.
Where can I find the instructions for importing?
Thanks!!
J
 		Jane 3/3/2008

Mary,
to import records you need file (CSV or Excel) with following structure:

field1,field2,field3

value1_1,value2_1,value3_1

value1_2,value2_2,value3_2



First line of this file should be list of field names.
R
 		reanim 4/3/2008

can this handle inserts to multiple tables (e.g. in a master-detail fashion)
e.g.
if we have the following tables
Property (master)
and
Studio (detail)

B&B (detail)

Villa (detail)

Hotel (detail)

Hostel (detail)

...

etc
So in my application if I insert a Hotel I would insert the basic details in table Property and the details in the Hotel table. (we store different things for different kinds of properties that is why we have all these tables)
would hte import work for the above? maybe with some custom coding in the _import.php ?
J
 		Jane 4/3/2008

Hi,
to import data to more then one table edit generated ..._import.php file manually.

Unfortunately we don't have a ready to go solution for this.