2. PHPRunner General questions
  3. [SOLVED]  Import one into many
This topic is locked
[SOLVED]

 Import one into many

 		10/10/2020 11:05:14 AM
PHPRunner General questions
B
 bob1234 author

Hi Forum
Is have a table which gets its date from the import of an excel sheet, what I would like to achieve if possible is for the import to populate 2 other tables which use the same data.
Is it possible to use one Import which would pass data to 3 different tables.
Thanks

Robert
jadachDevClub member 10/10/2020

I would be inclined to fire a stored procedure after data is imported.
B
 		bob1234 author 10/10/2020



I would be inclined to fire a stored procedure after data is imported.


Hi Jerry
Thanks for the reply, yes your correct I was looking at a MySQL stored procedure, but I don't have a lot of cpu or ram on this particular hosting and I think calling it would strangle things
Robert
Sergey Kornilov admin 10/10/2020

Robert,
if the stored procedure that inserts a couple of records into a couple of tables can break things on your server you need to run from that hosting the fastest you can.
I believe you are overthinking it. Just give it a try.
B
 		bob1234 author 10/10/2020



Robert,
if the stored procedure that inserts a couple of records into a couple of tables can break things on your server you need to run from that hosting the fastest you can.
I believe you are overthinking it. Just give it a try.


Hi Sergey
We're not talking about a couple of records, it's 100 plus columns and 5000 records at a time, if it was a couple of records I wouldn't have asked the question
Robert
HJB 10/11/2020

Yours... "import to populate 2 other tables which use the same data" refers ...
PHPRunner owns "Add custom view" of tabled content feature, say, if you import into ONE table, you

can use such feature to make 2 "new views" to get URL's you can bind into your project.
B
 		bob1234 author 10/11/2020



Yours... "import to populate 2 other tables which use the same data" refers ...
PHPRunner owns "Add custom view" of tabled content feature, say, if you import into ONE table, you

can use such feature to make 2 "new views" to get URL's you can bind into your project.



Hi walk2fly
Thanks for the reply, I am looking at this I had tried to work it with a custom view but one of the tables has a number of extra fields that need to be editable, but this is now the track I am taking and I think a bit of both MySQL and some table manipulation but phpr will get me where I need to be.

Jerry and Sergey are correct re stored procedure and that's the way I have went in the past with stuff like this but on this occasion the customer just doesn't have the hosting width and can't upgrade just at the moment and when it was tested it just pulled it to a stop.
Thanks everyone for the help it is appreciated and got me in the right direction.
Robert