JDE Tools — Date Converter & DS Importer

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ JDE Tools — Date Converter, DS Batch Import & Field ID Revealer ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ A Chrome extension built exclusively for Oracle JD Edwards EnterpriseOne (JDE) HTML5 client users — including business operators, ERP administrators, and JDE developers. If you work with JDE every day, you have almost certainly run into these three frustrations: First, JDE stores dates in its own CYYDDD format, completely different from the YYYYMMDD format used everywhere else. Knowing that "126120" means April 30, 2026 is not at all intuitive — yet you need to read, enter, and communicate these dates constantly. Second, when you need to enter dozens or hundreds of values into a Data Selection (DS) screen for a batch job, JDE gives you no choice but to type them in one by one. There is no bulk-entry mechanism built into the standard product. Third, when customizing JDE, building Orchestrations, or calling the AIS (Application Interface Services) API, you need to know the technical field ID (AIS ID or Alias) of each input field. Finding them requires digging through Chrome DevTools or a separate development tool. JDE Tools solves all three problems with a single lightweight extension. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Feature 1 — YYYYMMDD ↔ CYYDDD Date Converter ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ▌ Understanding the JDE Date Format JDE stores dates in a Julian format called CYYDDD: C → Century code: 0 = 1900s, 1 = 2000s YY → Two-digit year (2026 = 26) DDD → Day of year (January 1 = 001, December 31 = 365 or 366) Examples: 20260101 → 126001 (January 1, 2026, day 1 of the year) 20261231 → 126365 (December 31, 2026, day 365 of the year) 126120 → 20260430 (Century 1, year 26, day 120 = April 30, 2026) JDE users deal with this conversion dozens of times a day — entering dates into batch jobs, querying records, reading reports, and communicating results to colleagues. Every manual conversion wastes time and introduces the risk of error. This extension makes the conversion instantaneous and automatic. ▌ Popup Converter Click the toolbar icon to open the popup. Type any date and the format is detected automatically. 8-digit input → recognized as YYYYMMDD → displays CYYDDD result 6-digit input → recognized as CYYDDD → displays YYYYMMDD result The "Today" button converts today's date in a single click. The "Copy" button copies the result to your clipboard immediately. The C / YY / DDD components are explained individually so you can understand exactly what each digit means. The day of the week is shown alongside the converted date. Recent conversion history is saved automatically for quick reuse. The converter also handles slash and hyphen date formats: 26/04/30, 2026-04-30, 26.04.30, and similar patterns are all recognized and converted to CYYDDD automatically. ▌ Right-Click Context Menu Conversion Select any date number on any web page by dragging, then right-click. A "Convert Date: [selected text]" menu item appears. Click it and: ✔ A toast notification appears at the top-right of the screen, showing the conversion result for 3 seconds. ✔ The converted value is automatically copied to your clipboard. ✔ No popup needed — conversion is done instantly, right on the page. This works on any web page: JDE screens, emails, documents, spreadsheets, internal portals, and more. If the selected text cannot be converted, a clear error toast explains why. ▌ Toolbar Badge The Chrome toolbar icon displays today's CYYDDD date as a badge. Glance at the icon and you always know today's JDE date — no calculation needed. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Feature 2 — DS (Data Selection) Batch Import ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ ▌ The Problem with JDE Data Selection When running a JDE batch job (UBE — Universal Batch Engine), you frequently need to define the scope of data to be processed using the Data Selection (DS) screen. This screen lets you specify conditions such as: "Process only the following business units," or "Run for these specific address book numbers." The standard JDE workflow requires you to enter each value individually, one line at a time. For 10 values, that is manageable. For 50, 100, or 500 values, it can take half an hour of repetitive clicking and typing — a genuine productivity bottleneck for any JDE power user. ▌ How DS Batch Import Works ① Open the JDE Data Selection screen. (Click the "Data Selection" button on a batch job version prompt.) ② Right-click anywhere on the page and select "JDE DS Batch Import" from the context menu. ③ In the popup dialog, enter your values one per line, or click "Open CSV" to load them from a file. The tool auto-detects which column in the CSV contains your values. ④ Click "Start Import." Values are submitted to JDE one by one via the same server API that JDE uses internally. Progress is shown in real time: how many have been processed, how many were skipped, and the total. ⑤ When complete, verify the DS conditions in JDE and run your batch job. ▌ Key Capabilities • Handles hundreds of values in a single operation • Real-time progress display: processing / skipped / complete • If an error occurs partway through, "Re-import" resumes from the point of failure — no need to start over • Cancel at any time during the import • Direct CSV file loading from your desktop • Full multilingual UI (18 languages) ▌ Who Benefits Most Finance teams processing month-end journal entries for selected accounts. Logistics teams running batch jobs for specific order numbers. HR teams targeting a list of employee IDs for period-end processing. IT administrators re-running failed batch jobs with a curated subset. Anyone who has ever spent 20 minutes manually entering values into a JDE DS screen will immediately understand the value of this tool. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━…