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.
Hello,
I'm having an exception while trying to import work in projeqtor.
I've got several excel files in order to do so.They've got the same format (as requested by projeqtor) and i succeded import 5 excel files and i don't understand why this one is raising an exception.
here's the logs
2018-07-24 14:34:43.058 ** ERROR ** [V7.0.9] EXCEPTION **
2018-07-24 14:34:43.058 ** ERROR ** [V7.0.9] on file 'D:xampphtdocsprojeqtorexternalXLSXReaderXLSXReader.php' at line (152)
2018-07-24 14:34:43.058 ** ERROR ** [V7.0.9] cause = Sheet ID 1 does not exist in the Excel file
2018-07-24 14:34:43.059 ** ERROR ** [V7.0.9] => #0 D:xampphtdocsprojeqtorexternalXLSXReaderXLSXReader.php (135) -> getSheetNameById()
2018-07-24 14:34:43.059 ** ERROR ** [V7.0.9] => #1 D:xampphtdocsprojeqtormodelImportable.php (588) -> getSheet()
2018-07-24 14:34:43.060 ** ERROR ** [V7.0.9] => #2 D:xampphtdocsprojeqtormodelImportable.php (159) -> importXLSX()
2018-07-24 14:34:43.060 ** ERROR ***** [V7.0.9] => #3 D:xampphtdocsprojeqtortoolimport.php (112) -> import()
Hi,
I've had similar issues with Excel (not sure if it was with Projeqtor or other tools) : it can be an issue if the original 'Sheet1' from the Excel was deleted.
To workaround : create a brand new Excel file, and copy-paste all your data from the current file into the new one.
Hope it helps 🙂
it kinda work the importing tool said no error but when i check on the timesheet screen their is nothing for this resource
i checked in the data base and their is no value on field refId (all fields set to 0) and on idAssignement( all fields set to Null) while in my excel sheet i've got every field fill
Projeqtor desn't take these fields into concideration
i checked in the data base and their is no value on field refId (all fields set to 0) and on idAssignement( all fields set to Null) while in my excel sheet i've got every field fill
It is because you misspelled fields name
refId and not refID
idAssignment and not idAssignement
thanks for your help i tried both solutions and it work!
but know i'm facing (again) another issue. When i want to import another excel file containing work i've got this error
Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 4096 bytes) in D:xampphtdocsprojeqtorexternalXLSXReaderXLSXReader.php on line 214
Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 12288 bytes) in Unknown on line 0
I dont really understand this error because this particular file is not that bigger than my previous one. Like 5KB bigger
Problem solve
in my php.ini i change the memory_limit from 128 to 1024 and it work