2. PHPRunner General questions
  3. import data multiple formats
This topic is locked

import data multiple formats

 		11/18/2011 7:59:34 AM
PHPRunner General questions
author

Hi
I have a client that has about 10-15 reports all in .xls to upload weekly.

  1. Each report has a different collums, can I run a before event to say collum titled cars is to be imported in to mini
  2. Each report starts on a different collum some times with merged cells above, can I start on row 8 for report 7 but line 1 for report 3 (this one I guess i just have to say delete first x rows)
  3. Some reports have collums that are not needed, can I automatically ignor collums without an error (this one i guess I just have to say delete the collums not needed)
    Is their a easy way to do this? I know it all sounds crazy.
C
 		CK. 11/18/2011



Hi
I have a client that has about 10-15 reports all in .xls to upload weekly.

  1. Each report has a different collums, can I run a before event to say collum titled cars is to be imported in to mini
  2. Each report starts on a different collum some times with merged cells above, can I start on row 8 for report 7 but line 1 for report 3 (this one I guess i just have to say delete first x rows)
  3. Some reports have collums that are not needed, can I automatically ignor collums without an error (this one i guess I just have to say delete the collums not needed)
    Is their a easy way to do this? I know it all sounds crazy.


What I do is, import the file to a temporary table, do checking / filtering and copy necessary data to a new table and process whatever you want. (I use perl / linux to take care the .csv files but not .xls(x) file)