This topic is locked

how to import a excel file and uploading to web

12/31/2007 1:32:05 AM
PHPRunner General questions
S
smiles author

Please provide some assistance to do the following.

  1. How to import a excel file to a project and build it. I have converted an excel file for test to php file or I can convert it to mysql.
  2. I loaded the excel converted file (now 903AD.php) to my web under /www/
  3. I created a mysql database 903AD from my cpanel to which now I can connect from phprunner, but past this point I can not import my excel database php file as it only recognizes the car_table or other tables that I created manually. Please clarify how I can get the 903AD.xls ot 903AD.php to the table page so that I can build it further.
  4. Is it possible to move the EDIT and INLINE EDIT and VIEW to the line above with the other Menus like ADD NEW etc. I feel that this will give the space that I need for a specific record which will have fair text in two columns. The checkbox can remain with each record so that each item can be selected for manipulation.
  5. I can not resize some columns prior to build in the preview page. is this disabled for trial version.
  6. How can the formulas be added to certain fields to do automatic simple calculation, like adding two fields together or adding a know value to a certain field.
    Thanks very much. I would appreciate your assistance on this.

C
CAP 1/9/2008

Hi,
You can transfer your data to MsAccess then connect it by PHPRunner.
CAP <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=24779&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' />

Please provide some assistance to do the following.


  1. How to import a excel file to a project and build it. I have converted an excel file for test to php file or I can convert it to mysql.
  2. I loaded the excel converted file (now 903AD.php) to my web under /www/
  3. I created a mysql database 903AD from my cpanel to which now I can connect from phprunner, but past this point I can not import my excel database php file as it only recognizes the car_table or other tables that I created manually. Please clarify how I can get the 903AD.xls ot 903AD.php to the table page so that I can build it further.
  4. Is it possible to move the EDIT and INLINE EDIT and VIEW to the line above with the other Menus like ADD NEW etc. I feel that this will give the space that I need for a specific record which will have fair text in two columns. The checkbox can remain with each record so that each item can be selected for manipulation.
  5. I can not resize some columns prior to build in the preview page. is this disabled for trial version.
  6. How can the formulas be added to certain fields to do automatic simple calculation, like adding two fields together or adding a know value to a certain field.
    Thanks very much. I would appreciate your assistance on this.

admin 4/7/2009

As a first step you need to create a MySQL database and import Excel file. This needs to be done outside of PHPRunner. There are may third party tools like Navicat or EMS MySQL Manager that can help you with his job.