my cron with automatic import from CSV files are out since migration in last version ...See attachment.
In manual import from application it is the same it doesn't work.
I try to change colum name to put in english instead of fr but same thing ...
Sincerely
Loic
Request recorded as Ticket #6322
Today i test cron with all name of colum with same name as table expense ... same trouble ... some column are not taken in account despite change text by integer value.I tested a lot of situation my problem appears mainly in expense table ... customer OK .. bill OK ... i don't understand.see new picture in attachment
I tested to import your files, and found no specific issue.
I think you have some issue with your indexes.
Try and rebuild/repair the indexes on your DB.
How should i do that ?
Try and rebuild/repair the indexes on your DB.
I change lot of thing on import file but all the time import failled for expense table ...
LR
You can Use phpMyAdmin (select the table to fix and at bottom, use option to reapir
or use SQL query
REPAIR TABLE `expense`;
I already try but i've got the answer :
"Ce type de table ne supporte pas les repair"
Try OPTIMIZE
"Table does not support optimize, doing recreate + ..."
Status :OK
OPTIMIZE seems to work but already have my trouble with import in expense table and cron bug.
Babynus,
I finaly make all import but explanation that we could export table and create a similar one to import is not so simple :
For exemple on table "expense" when i make CSV on project expense, projeqtor generate a file called "expense ...." but for import in CRON i should name it "projectexpense..." instead of personal expense wich is in the same table with file called expense ...
Where could i find all named of file for import ? or could it be possible to change extract of csv in projeqtor to have correspondance with import name ?
Thanks for your support.
LR