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

[SOLVED] Error importing project expense

More
20 Aug 2025 11:47 - 20 Aug 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 Aug 2025 11:49 by jmmbb.

Please Log in or Create an account to join the conversation.

More
20 Aug 2025 14:29 - 20 Aug 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 Aug 2025 14:31 by jmmbb.

Please Log in or Create an account to join the conversation.

More
20 Aug 2025 15:05 - 20 Aug 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 Aug 2025 15:07 by jmmbb.

Please Log in or Create an account to join the conversation.

More
20 Aug 2025 15:08 - 20 Aug 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 Aug 2025 15:12 by jmmbb.

Please Log in or Create an account to join the conversation.

More
29 Aug 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 Log in 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 Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.304 seconds

Cookies settings

×

Functional Cookies

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

Please login to see yours activities!

Other cookies

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