bexis / Module_ResearchAreaManagement

A tool to manage research areas. You can define the shape of your main plots and draw subplots inside. You can plan the localization of field experiments. You can use maps for orientation in the field. As you will keep the history of the subplots, you will always be able to distribute prospective subplots. Module for Core @BEXIS2.

0 stars 0 forks source link

Test CSV import #9

Closed EleonoraPetzold closed 2 years ago

EleonoraPetzold commented 5 years ago

Link: http://be2020-dev.inf-bb.uni-jena.de:2010/pmm/MainAdmin/Index

Notes:

if you what to insert a new subplot or plot the ID must be blank
there will be an update of all rows in the file
[x] Test functionality
[x] check report after upload
[x] check data
[x] check history info

geofranzi commented 4 years ago

I have no test data to check.

aostrow commented 3 years ago

functionality:
- Status seems not to be considered, but it should. Systems set it automatically to 1, also if I enter 2.
report:
- Last column "status" seems to indicate if the upload happened or not. I did a test with a wrong coordinate and the status checkbox was not checked. Rename column, e.g. "Upload successful". Put column on the first place.
- Is it easy to provide a download (send mail?) of the report?
data:
- Uploaded data seems ok
- Date column for updated data is not changed. Shouldn't it reflect the date of the latest changes? On the other hand we have the date info in the history table.
history:
- Ok. It writes the new data also in the history table.

EleonoraPetzold commented 3 years ago

Date column for updated data is not changed. Shouldn't it reflect the date of the latest changes? On the other hand we have the date info in the history table.

In the pmm_geometryinformation table, they are no updates only inserts, or? So the insert date is up to date anyhow?

EleonoraPetzold commented 3 years ago

Is it easy to provide a download (send mail?) of the report?

Yes, an issue was created here #91

EleonoraPetzold commented 3 years ago

Date column for updated data is not changed. Shouldn't it reflect the date of the latest changes? On the other hand we have the date info in the history table.

In the pmm_geometryinformation table, they are no updates only inserts, or? So the insert date is up to date anyhow?

A bit confusing and I don't know where I should have seen this in the code BUT an update is an update also on the DB + entry in the history table.

aostrow commented 3 years ago

Archive (set status to 2) just makes this status change. Afterwards the status = 2 in the file is handled like an "set status to 2". No Updates/changes were done anymore. Just an archive reported again.

[x] is it ok like this? or should it do also changes/updates toghether with status changes
[x] should status = 2 always report an "archive"
[x] question: does it check if there are updates or does it just report an update for every line where it is no status change or insert?

aostrow commented 3 years ago

~~After I uploaded status=4 I can not upload anymore to this Plotid.~~ Status 4 is missing in report and nothing happens. It should be reported that a nothing happened for this line in the report. 00> issue here #93

aostrow commented 3 years ago

~~plotid column in plothistory table in db is 0 sometimes. Is this ok?~~ -> #92

aostrow commented 3 years ago

I set status = 2 and plot was archived. ==> done I set status = 1 again and in report an update was written but the geometry was still archived. ==>see issue #93

EleonoraPetzold commented 3 years ago

@aostrow

93, #91 is done please test it on dev:2010

EleonoraPetzold commented 2 years ago

test successful code published on prod server