View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Error importing project expense - ProjeQtOr

Prochaines Sessions

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

2 octobre 2025 (16h-17h30)

6 novembre 2025 (10h30-12h)

 
 

Planifiez avec ProjeQtOr

8 et 9 octobre 2025 (9h-12h30)

19 et 20 novembre 2025 (9h-12h30)

 
 

Administrez avec ProjeQtOr

15 et 16 octobre 2025 (9h-12h30)

26 et 27 novembre 2025 (9h-12h30)

 

 

 

[SOLVED] Error importing project expense

More
20 Aoû 2025 11:47 - 20 Aoû 2025 11:49 #1 by jmmbb
Hello,

i experience strange issue while importing project expense.
I do it several time in the past and it works but today, i can't find the bug...
ProjeQtOr's version is 12.1.2.

I use a csv file with 8 expenses (first problem become with a largest file but i reduce the number of line to track the bug).
 

File Attachment:

File Name: Importdpenses.zip
File Size:0 KB

Note : plannedFullAmount, expensePlannedDate, expenseRealDate and realFullAmount are in english to avoid translation's mystake but nothing change.
I use plannedFullAmount to 1 for expenses that are previously set and avoid error with amount = 0.
CP 2025 and aother are personalized flieds with financial value.
I use idProject because, when using project's name i get an error...

So, this is the log after import :
 

File Attachment:

File Name: projeqtor_...0820.log
File Size:1 KB


And this is the result :
 

So, fields are well recognized (name of fields are changed to there translation), but i get each time the same error, even with planned date and planned amount not void.

When i try to make it on my 292 expenses to import, i got a time out and log only show "invalid" for each line.

Any idea ?

Best regards,
 
Attachments:
Last edit: 20 Aoû 2025 11:49 by jmmbb.

Please Connexion or Create an account to join the conversation.

More
20 Aoû 2025 14:29 - 20 Aoû 2025 14:31 #2 by jmmbb
Doing a test with a fresh export structure : copied direct from import screen :
I copy the help line, paste it into excel, set some values according to reference (ie idProject, idStatus, ...) and try to import it, the result is the same :
 

Even if values are presents :
 
Attachments:
Last edit: 20 Aoû 2025 14:31 by jmmbb.

Please Connexion or Create an account to join the conversation.

More
20 Aoû 2025 15:05 - 20 Aoû 2025 15:07 #3 by jmmbb
Try to create an expense from ProjeQtOr then export to csv, change value (montant prévu) then try to import : same issue.

Even if i use "tout cocher) to be sure to export every values, can't import csv.
Last edit: 20 Aoû 2025 15:07 by jmmbb.

Please Connexion or Create an account to join the conversation.

More
20 Aoû 2025 15:08 - 20 Aoû 2025 15:12 #4 by jmmbb
Same issue trying in english (perhaps problem with translation ?), so message is in english but no import :) !
Need to set real date and amount : non sense with status "enregistré" !

And even with these value set, import doesn't work !
Last edit: 20 Aoû 2025 15:12 by jmmbb.

Please Connexion or Create an account to join the conversation.

More
29 Aoû 2025 14:08 #5 by babynus
Hi,
Issue is that Total Full Amount cannot be imported : it is calculated from ExVAT Amount + Vat Amount (and VAT Amount is calculated from VAT %)
So you need to enter ExVAT Amount and it will calculate Total Full Amount
 

Babynus
Administrator of ProjeQtOr web site
Attachments:

Please Connexion or Create an account to join the conversation.

More
25 Sep 2025 13:01 - 25 Sep 2025 13:09 #6 by jmmbb
hello,

exVAT Amount or VAT % are not in the fieldqs listed for import.
 

I put Value in plannedAmount and expensePlannedDate and get the same issue.I put my import file here (amount are example only).
 

File Attachment:

File Name: Prepa_budg...squs.txt
File Size:1 KB
Attachments:
Last edit: 25 Sep 2025 13:09 by jmmbb. Reason: adding file

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.280 seconds

Paramétrages de cookies

×

Cookies fonctionnels

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.