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

Prochaines Sessions

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

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

2 décembre 2025 (16h-17h30)

 
 

Planifiez avec ProjeQtOr

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

10 et 11 décembre 2025 (9h-12h30)

 
 

Administrez avec ProjeQtOr

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

16 et 17 décembre 2025 (9h-12h30)

 

 

 

Error importing project expense

More
25 Sep 2025 13:12 #7 by jmmbb
I get this error on log :

2025-09-25 12:59:26.224 ===== TRACE ===== [1] => Import line n° 4
2025-09-25 12:59:26.226 ..... SCRIPT .... [1] 80.241.9.27 UserMain::getVisibleProjects(limitToActiveProjects=1)
2025-09-25 12:59:26.229 ..... SCRIPT .... [1] 80.241.9.27 UserMain::getVisibleProjects(limitToActiveProjects=1)
2025-09-25 12:59:26.229 ..... SCRIPT .... [1] 80.241.9.27 securityGetAccessRightYesNo ( menuName=menuProjectExpense, accessType=create, obj=ProjectExpense #, user=User #1)
2025-09-25 12:59:26.230 ..... SCRIPT .... [1] 80.241.9.27 securityGetAccessRight(menuName=menuProjectExpense, accessType=create, obj=ProjectExpense #, user=User #1)
2025-09-25 12:59:26.230 ..... SCRIPT .... [1] 80.241.9.27 getAccessControlRights(obj=ProjectExpense #)
2025-09-25 12:59:26.230 ..... SCRIPT .... [1] 80.241.9.27 UserMain::getVisibleProjects(limitToActiveProjects=1)
2025-09-25 12:59:26.231 ***** ERROR ***** [V12.1.2] [1] Error on SqlElement to get 'availableTransferedAmount' for Class 'Budget' : field 'availableTransferedAmount' not found in Database on table budget

Please Connexion or Create an account to join the conversation.

More
25 Sep 2025 13:30 - 25 Sep 2025 13:32 #8 by jmmbb
I try on another instance (test) installed from scratch (V12.1.2).
I get the same error :
 

Note that expensePlannedDate and plannedAmount are recognized (it set the column with english name to avoid traduction error and they are correctly translated during import).

Not VAT ou exVAT find in field list...
 
Attachments:
Last edit: 25 Sep 2025 13:32 by jmmbb.

Please Connexion or Create an account to join the conversation.

More
25 Sep 2025 13:40 #9 by jmmbb
I use the full example for import (in my production instance, fields VAT and VAT amount are hidden by screen customization so they don't appear on list for import.

It work.

So perhaps it will be convenient to show even hidden fields in import example to avoid missing them.

Regards,

Please Connexion or Create an account to join the conversation.

More
04 Nov 2025 12:43 #10 by jmmbb
Hello,

i try another import and, even with every fields set and using english title, i get the same error :
 

For me, planned dat eand amount are both entered (even in planned amount and tax rate but with planned tax amount too).

Another idea ?
Attachments:

Please Connexion or Create an account to join the conversation.

More
05 Nov 2025 17:45 - 05 Nov 2025 17:53 #11 by jmmbb
Hello,

i try to use a new expense created just for export / import (see attachment).

I export the expense (only planned Amount, taxt rate and planned date for financial data).
I try to import from the generated .csv i get the error :
Invalid controls.
Real date and amount must both be entered

Status is "enregistré" so why to expect REAL amount and date ?

I think in will be because some fields are hidden in my instance (we don't use VAT cause every costs are VAT included).
In change customization to get every fields visible and do another export.
Same result (even with real amount set to 0).

I change in import file real amount and real date (see attachement) but i get the same error :
 

Regards,
Attachments:
Last edit: 05 Nov 2025 17:53 by jmmbb.

Please Connexion or Create an account to join the conversation.

More
05 Nov 2025 18:04 - 05 Nov 2025 18:50 #12 by jmmbb
Same issue with french translation :

 

The file used for import is attached.

Regards,
Attachments:
Last edit: 05 Nov 2025 18:50 by jmmbb.

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.070 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.