PROJEKT_BEWP Import Builder

Paste the full time export or a simple date list plus a task TSV. The page validates totals, can add future overflow days, previews allocation, and generates the full SQL import script with transaction, position/LFDNR offset logic and duplicate check.

Offline · SQL Server · PROJEKT_BEWP

Autosave · localStorage

1) Dates TSV

Accepted: full export TSV or simple Datum + Nicht_verrechnete_Zeit

2) Tasks TSV

Columns: ProjektNr + Text + Hours

Auto-add future dates when tasks exceed date total

Start date

Hours per added day

Weekdays only Overflow dates are included in generated SQL

PNR: ' 650' KST: ' 131'

Waiting for input.

Provided date total

0.00h

Generated extra

0.00h

Final date total

0.00h

Task total

0.00h

Difference

0.00h

Logical rows

Extra dates generated

Allocation Preview

Mirrors SQL allocation. Tasks may split at date boundaries.

Date	ProjektNr	Hours	Seconds	Text
No preview yet.

Generated Extra Dates

Only shown when task total exceeds provided date total and auto-add is enabled.

Date	Hours	Seconds
No extra dates.

Full Runnable SQL

Run in SSMS. It leaves transaction open after clean duplicate check.

Only VALUES blocks

For manual paste into the reusable SQL template.

Accepted dates: DD.MM.YYYY, YYYYMMDD, YYYY-MM-DD. Full time export input uses Datum and Nicht_verrechnete_Zeit; rows with zero hours are ignored. Decimal comma and decimal point are accepted. SQL strings are escaped automatically. Input and generated output are autosaved in this browser via localStorage.