Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

[SOLVED] How import...
 
Notifications
Clear all

[SOLVED] How import with CRON ?

5 Posts
2 Users
0 Reactions
1,980 Views
(@bourle)
Posts: 26
Active Member
Topic starter
 
[#8601]

Hi all,

How can I import activity with the "cron function" ?
I don't know where i can find this information 🙁

Currently : 
When I try a drag and drop my file in the import directory, I have this error :    "Cron error : class 'Activité.csv' is unknown". (in ../import/logs/Activité.log.htm)
In "general log" I have this : 2022-11-13 23:42:17.165 ===== TRACE ===== File Name : D:/HorsSite/PQO/files/importActivité.csv
2022-11-13 23:42:17.166 ===== TRACE ===== Import ERROR : file Activité.csv imported with 1 errors [ Number of 'Activité.csv' imported : 0 ]
2022-11-13 23:42:27.458 ===== TRACE ===== Importation : File type CSV
My configuration : 
- ProjeQtOr v10.1.2
- Windows Serveur 2016
- IIS 10
- PHP 7.4
- MySQL 8.0.31

When I import my activity by the GUI, it's works.
Thx for your help.


 
Posted : 14 Nov 2022 2H57
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

'Cos your file must be called Activity.csv, not Activité.csv


 
Posted : 14 Nov 2022 10H52
(@bourle)
Posts: 26
Active Member
Topic starter
 

Snif :'(
it doesn't work too...
I also try with an export and rename it but it's also a failure.

I don't know what to do now.


 
Posted : 20 Nov 2022 0H33
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

What is the error logged ?
NB : in fact the format should be Activity_YYYYMMDDHHMNSS.csv where YYYYMMDDHHMNSS is a timestamp to ensure treatment os files in correct order.
NB : also be sure to delete old file called Activité.csv
 


 
Posted : 20 Nov 2022 19H20
(@bourle)
Posts: 26
Active Member
Topic starter
 

With timestamp is perfect !
Thank you


 
Posted : 21 Nov 2022 14H56
Share:

Scroll to Top