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

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

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