How to extract data from a Django QuerySet

Question

How to extract data from a Django QuerySet

Navigation

#1 by (0 votes)

0

I have a table with some information, the name of the employee, pis, date and time, the time field records the time of the record in the point clock, these records are all in the same column, for example: Employee 1, has four check in, check in, check in, check in, check in, check in, check in, check in, check in, check in, check in, check in, check in, check in, check in, check in, check in, check in, check in, field.

If anyone can logically help with this implementation, I'm grateful. It may even be also before importing the CSV file, because this data is imported to from a CSV but just the way it is. If I can do this even before import, it will resolve.

postgresql django csv

asked by anonymous 21.11.2016 / 21:24

1 answer

Filling in a div using each Jquery How to send information by local POST to external server?

score 0 · Answer 1

In importing the file you could do something like this:

Assuming your model has all the fields quoted above and the file has the following format: name, pee, schedule1, schedule2, schedule3, schedule4.

for line in file.readlines():
    data = line.split(',')
    funcionario = Funcionario(nome=data[0], pis=data[1], horario1=data[3] ...)
    funcionario.save()