This topic is locked

Recurring import

1/11/2024 11:44:33 AM
PHPRunner General questions
V
vnotarfrancesco author

Hi everyone,
I need to recurring import a csv file without user input.
It's possibile to save settings in PHPRunner import page, this one

img alt

so I can schedule a recurring import using just a url?

I'm using PHPRunner 10.9.1

Thanks,
Valerio

admin 1/11/2024

No, you cannot. Web applications do not work this way.

How would application get a CSV file if user do not upload it?

V
vnotarfrancesco author 1/12/2024

Thanks admin.
With Phprunner I'm building a web application that will shows data of a legacy desktop database application.
The old system can upload daily a csv file to a remote server.

So with Phprunner I need a way to import new and update records of this csv daily.

Valerio

fhumanes 1/12/2024

Hi Valerio,

@admin (Sergey) He has indicated what he can or may not do directly with Phprunner, but Phprunner is PHP (generated), so it can be added (integrate) almost any PHP code.

In this link I explain how automatic periodic tasks can be added to a phprunner application.

https://fhumanes.com/blog/guias-desarrollo/guia-73-planificador-de-tareas-batch/

In this other I explain how ZIP files can be treated for a system to integrate it into another (which both can be phprunner).

https://fhumanes.com/blog/guias-desarrollo/guia-54-utilizacion-de-ficheros-zip-para-transportar-contenidos/

It all depends on the ability you have to develop a bit in PHP.

Greetings,
fernando

V
vnotarfrancesco author 1/15/2024

Thanks Fernando, your post was very helpful.

Thanks to Sergey as well. :)

Valerio

admin 1/15/2024

You can also check this video that explains how to process CSV and Excel files manually.
https://www.youtube.com/watch?v=fEXsxpOfzLk

V
vnotarfrancesco author 1/15/2024

Thanks admin for the video.

Valerio

mbintex 1/17/2024

I would think that this is a classic scenario for automation providers like Make or Zapier.