Upload Data File

\n Upload your Excel, SQL, or Oracle data files to map them to the CDM ISDA model\n

\n\n

\n {/* Main Upload Area */}\n

\n {/* File Drop Zone */}\n

\n \n {selectedFile ? (\n

\n \n

{selectedFile.name}

\n {formatFileSize(selectedFile.size)} • {fileType.toUpperCase()}\n

\n setSelectedFile(null)}\n className=\"mp-button-secondary\"\n >\n Remove\n \n fileInputRef.current?.click()}\n className=\"mp-button-secondary\"\n >\n Choose Different\n \n

\n ) : (\n

\n \n

\n Drop your file here, or click to browse\n

\n Supports Excel (.xlsx, .xls, .csv), SQL (.sql), and Oracle formats\n

\n fileInputRef.current?.click()}\n className=\"mp-button-primary\"\n >\n Choose File\n \n

\n )}\n

\n\n \n

\n\n {/* File Type Selection */}\n {selectedFile && (\n

File Type

\n {(['excel', 'sql', 'oracle'] as const).map((type) => (\n \n setFileType(e.target.value as any)}\n className=\"sr-only\"\n />\n

\n {type === 'excel' && '📊'}\n {type === 'sql' && '🗄️'}\n {type === 'oracle' && '🔶'}\n

{type}

\n {supportedFormats?.[type]?.extensions?.join(', ')}\n

\n \n ))}\n

\n )}\n\n {/* Upload Progress */}\n {isUploading && (\n

\n Uploading and processing...\n {uploadProgress}%\n

\n \n

\n )}\n\n {/* Upload Button */}\n

\n \n {isUploading ? (\n

\n Processing...\n

\n ) : (\n 'Upload and Map Fields'\n )}\n \n

\n\n {/* Sidebar */}\n

\n {/* Mapping Preferences */}\n

Mapping Preferences

\n \n \n setMappingPreferences(prev => ({ ...prev, autoMap: e.target.checked }))\n }\n className=\"rounded border-gray-300 text-blue-600 focus:ring-blue-500\"\n />\n \n Auto-map fields\n Automatically suggest field mappings\n \n \n\n \n \n setMappingPreferences(prev => ({ ...prev, validateExternal: e.target.checked }))\n }\n className=\"rounded border-gray-300 text-blue-600 focus:ring-blue-500\"\n />\n \n External validation\n Validate against external data sources\n \n \n\n \n \n setMappingPreferences(prev => ({ ...prev, strictMode: e.target.checked }))\n }\n className=\"rounded border-gray-300 text-blue-600 focus:ring-blue-500\"\n />\n \n Strict mode\n Require all mandatory fields\n \n \n

\n\n {/* Supported Formats */}\n

Supported Formats

\n {supportedFormats && Object.entries(supportedFormats).map(([key, format]: [string, any]) => (\n

{format.name}

{format.description}

\n Extensions: {format.extensions?.join(', ')}\n

\n ))}\n

\n\n {/* Help */}\n

Need Help?

\n \n 📖 View Documentation\n \n \n 💬 Contact Support\n \n \n 📋 Sample Files\n \n

\n \n );\n};\n\nexport default FileUpload;","deleted","label",[171,172,154],"frontend","components","permalink","https://www.val.town/x/MRPRRSIDENT/CDMBenchmarking/code/frontend/components/FileUpload.tsx","extension","actionData","errors"]