Bug 47329 – A tool which took the "old" record_uid and replace it with a new one

Bug 47329 - A tool which took the "old" record_uid and replace it with a new one


Summary:	A tool which took the "old" record_uid and replace it with a new one

Status:	RESOLVED WONTFIX

Product:	UCS@school
Classification:	Unclassified
Component:	Import scripts
Version:	UCS@school 4.3
Hardware:	Other Mac OS X 10.1

Importance:	P5 normal (vote)
Target Milestone:	---
Assigned To:	UCS@school maintainers
QA Contact:

URL:
Keywords:

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2018-07-09 22:12 CEST by Michel Smidt
Modified:	2023-06-23 13:15 CEST (History)
CC List:	3 users (show)

See Also:
What kind of report is it?:	Feature Request
What type of bug is this?:	---
Who will be affected by this bug?:	---
How will those affected feel about the bug?:	---
User Pain:
Enterprise Customer affected?:
School Customer affected?:	Yes
ISV affected?:
Waiting Support:
Flags outvoted (downgraded) after PO Review:
Ticket number:
Bug group (optional):
Max CVSS v3 score:

Attachments
migrate-recordUID (5.32 KB, text/x-python) 2018-08-22 11:29 CEST, Sönke Schwardt-Krummrich	Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Michel Smidt 2018-07-09 22:12:33 CEST

Unfortunately it is sufficient to bulk update the record_uids. Regularly the primary key from the datasource changed and than it would be very helpful to have a tool which took the "old" record_uid and replace it with a new one.
For example in a csv file with two columns (old & new).

Comment 1 Sönke Schwardt-Krummrich

2018-08-22 11:29:31 CEST

Created attachment 9634 [details]
migrate-recordUID

I attached a short script which does something similar. It reads a CSV file and searches for firstname, lastname and birthday and replaces the recordUID with a new one from the CSV file. A dry-run is already implemented. Also it writes a result CSV.

Comment 2 Michael Grandjean

2018-08-31 12:25:10 CEST

Just as an idea: To make this work for users which don't have a recordUID so far (imported via old import), the tool also needs to create the unique-usernames and set ucsschoolUsernameNextNumber appropriately

Comment 3 Jan-Luca Kiok

2023-06-23 13:15:52 CEST

This issue has been filed against UCS 4.3.

UCS 4.3 is out of maintenance and UCS components may have vastly changed in later releases. Thus, this issue is now being closed.

If this issue still occurs in newer UCS versions, please use "Clone this bug" or reopen this issue. In this case please provide detailed information on how this issue is affecting you.