Changelog¶

1.6.0 (2024-12-17)¶

Features¶

have new property IsActiveEntity status in export (#691) (fdefc5a)

Bug Fixes¶

show download template button in standalone mode when spreadsheetTemplateFile is used (51129c3)

1.5.2 (2024-12-12)¶

Bug Fixes¶

the resize icon of dialog caused chrome to crash (#686) (9729a98)

1.5.1 (2024-12-12)¶

Bug Fixes¶

column names did not parse if cell type is date (#677) (100771e)
resolve infinite loop in entity relationships navigation properties (#683) (1b29c8a)

1.5.0 (2024-12-06)¶

Features¶

add icon option to xml view button (#664) (5fa1c5c)
Deep Spreadsheet Export (#657) (7258af7)

Bug Fixes¶

in V4 Freestyle MetaModel was not found (#663) (7dee888)
label not found if no annotations available (#670) (3801d1a)

1.4.3 (2024-11-12)¶

Bug Fixes¶

label could be undefined and throws error(#649) (4b9fa59)

1.4.2 (2024-10-18)¶

Bug Fixes¶

preview did not show all columns (#638) (eca1534)

1.4.1 (2024-09-21)¶

Bug Fixes¶

add nl language to manifest (#633) (c9ea8ab)

1.4.0 (2024-09-18)¶

Features¶

new language dutch (LLM translated) (#631) (f4a7fae)

1.3.0 (2024-09-16)¶

Features¶

new parameter bindingCustom (#628) (935ea47)

Bug Fixes¶

in V4 context check if it is possible to execute with editFlow (#630) (c5701a9)

1.2.2 (2024-09-10)¶

Bug Fixes¶

update SheetJS dependency to 0.20.3 (#626) (58000d7)

1.2.1 (2024-09-05)¶

Bug Fixes¶

get odata version from binding instead of context (#618) (cf1f3a4)

1.2.0 (2024-08-14)¶

Features¶

new event preFileProcessing (#612) (966c3b1)

Bug Fixes¶

Edm.DateTimeOffset parsing with and without precision (#603) (6649d53)
force refresh only for v2 and when refresh failed (#596) (6f27348)

1.1.1 (2024-06-18)¶

Bug Fixes¶

dialog is blocking navigation in FE scenarios (#579) (5a0b05d)

1.1.0 (2024-06-13)¶

Features¶

new option excludeColumns (#575) (a639b02)
parse Edm.Time when excel data is text (#573) (cfaeace)

1.0.0 (2024-05-23)¶

⚠ BREAKING CHANGES¶

release 1.0.0

Features¶

new language portuguese by LLM translation (#553) (76d246c)
release 1.0.0 (345b82f)

Bug Fixes¶

dialog margin in sapUiSizeCozy mode (#562) (4104fb9)

0.34.1 (2024-05-08)¶

Bug Fixes¶

add seconds when parsing odata time (#549) (b5f69bc)

0.34.0 (2024-05-08)¶

⚠ BREAKING CHANGES¶

enable packaged deployment (#547) (6d3450b)

because of a bug, it is not possible to do a packaged central deployment of bug in the abap system.
The Bug was fixed as described in #490, but still relevant in older ABAP Systems.
To make things easier and make the packaged central deployment possible at all, it is necessary to add the version to the metadata name and make the resources path lowercase because abap system can´t handle camel case.

New metadata name¶

ui5-cc-spreadsheetimporter-v0-34-0

New lowercase resourceRoots path¶

Instead of thirdparty/customControl/spreadsheetImporter/v0_34_0 it is thirdparty/customcontrol/spreadsheetimporter/v0_34_0

0.33.4 (2024-04-19)¶

Bug Fixes¶

make fireEventAsync more stable (#534) (1ab4cd2)

0.33.3 (2024-04-18)¶

Bug Fixes¶

design improvements (#527) (af21d7b)
make sure payload in changeBeforeCreate is used (#528) (89f3292)
reset context on server error (#525) (d1dd033)

0.33.2 (2024-04-08)¶

Bug Fixes¶

special case for Edm.Byte for OData V2 (#519) (36b5f7c)
update SheetJS to 0.20.2 (#521) (29301d2)

0.33.1 (2024-02-29)¶

Bug Fixes¶

parse Edm.Byte and Edm.SByte (#506) (1b50aef)

0.33.0 (2024-02-23)¶

Features¶

possibility to overwrite i18n texts (#501) (4c08ed7)

0.32.0 (2024-02-15)¶

Features¶

add drag&drop to dialog to upload files (#496) (ea55361)

0.31.6 (2024-02-14)¶

Bug Fixes¶

turn off continue anyway on error dialog after upload button press (#494) (fb82978)

0.31.5 (2024-02-05)¶

Bug Fixes¶

make sure Edm.Date uses the correct date (#487) (934fe3b)

0.31.4 (2024-02-01)¶

Bug Fixes¶

show error in standalone mode after upload button press (#480) (9348694)

0.31.3 (2024-01-30)¶

Bug Fixes¶

preventDefault on event uploadButtonPress (#476) (4c6033e)

0.31.2 (2024-01-23)¶

Bug Fixes¶

update sheetjs to 0.20.1 (#463) (16a2722)

0.31.1 (2024-01-03)¶

Bug Fixes¶

string assignment using nullish coalescing operator (#450) (530fcbd)

0.31.0 (2024-01-02)¶

Features¶

add config for btp deployment with managed approuter (#419) (470b68f)
new checks for maxLength and duplicate columns (#447) (7d47e28)
new config to define columns in preview (#443) (b98db12)
new option `createActiveEntity´ to directly create active entities (#438) (a3449f7)

Bug Fixes¶

check if ComponentContainerData is available (#445) (c484e42)

0.30.0 (2023-12-21)¶

Features¶

enable spreadsheet importer for ui5 v2 (#440) (763c2c7)
new config to continue batch processing on errors (#441) (25dda51)
new config to send the spreadsheet row to the backend (#439) (44af189)
use events with async attached function s(#435) (2c95615)

0.29.1 (2023-12-16)¶

Bug Fixes¶

add missing row number in excel log file (#421) (6b05df3)
avoid error when annotation not found (#430) (a989e5f)
better error handling on backend errors (#426) (7541ab9)
sampleData only if defined (#428) (dfdacb1)
use sample data in standalone mode (#429) (3b9b165)

0.29.0 (2023-10-30)¶

Features¶

new config to provide own template file (#406) (591e284)
new config to skip columns check (#404) (6a14152)

Bug Fixes¶

add parsedData to CheckBeforeRead event (#407) (110933a)
hide generateTemplate in standalone (#409) (b9172db)

0.28.1 (2023-10-18)¶

Bug Fixes¶

add missing event requestCompleted to eventMethodMap (#389) (51f5c04)
add xlsm add upload type (#395) (0ce65d1)

0.28.0 (2023-10-12)¶

Features¶

new event requestCompleted (#386) (81baaac)

0.27.1 (2023-10-10)¶

Bug Fixes¶

preview (#382) (8eb8b28)

0.27.0 (2023-10-06)¶

Features¶

add sheet selector if multiple sheets in file (#376) (94de1b4)
error report can be downloaded as spreadsheet file (#378) (7fc727e)

Bug Fixes¶

i18n date parser attribute (#380) (b0e8279)

0.26.1 (2023-09-30)¶

Bug Fixes¶

event attachment of componentContainer (#372) (5f71366)

0.26.0 (2023-09-30)¶

⚠ BREAKING CHANGES¶

usage of UIComponent to return button (#370)

Features¶

usage of UIComponent to return button (#370) (6ef0f46)

0.25.4 (2023-09-28)¶

Bug Fixes¶

template generation in standalone mode (#368) (c0af0d9)

0.25.3 (2023-09-11)¶

Bug Fixes¶

check for odata type config parameter (#361) (86706cc)
use label in preview table (#359) (9a02b30)

0.25.2 (2023-09-06)¶

Bug Fixes¶

readAllSheets Parameter fixed (#354) (88475fb)

0.25.1 (2023-09-06)¶

Bug Fixes¶

close busy dialog on backend error (#348) (e1cc5e6)

0.25.0 (2023-09-06)¶

Features¶

add sheet name to payload (#346) (4af5b47)

Bug Fixes¶

add missing event parameter for uploadButtonPress event (#344) (93b7613)
make parameter optional (#341) (d52486d)

0.24.0 (2023-08-10)¶

Features¶

use odataType to create data for other entity (#334) (7330ebb)

0.23.1 (2023-08-03)¶

Bug Fixes¶

enable usage of controller extensions (#330) (f767a5c)

0.23.0 (2023-08-03)¶

Features¶

add progress indicator for large files (#327) (3bcfc26)
improve tablechooser (#326) (268a1a7)
new TableChooser if multiple tables in view (#325) (bfe5096)

Bug Fixes¶

rename tableChooser to tableSelector (#328) (50b21c3)

0.22.0 (2023-07-12)¶

Features¶

new option, add your own sampleData (#318) (24cef4f)
parse i18n texts from metadata (#319) (278447d)

Bug Fixes¶

continue on error did not work (#316) (5d1d55c)

0.21.2 (2023-07-03)¶

Bug Fixes¶

update ui5-tooling-transpile to use types in apps (#301) (7e0a35c)

0.21.1 (2023-06-30)¶

Bug Fixes¶

change texts when records are uploaded to app (#293) (13555fd)

0.21.0 (2023-06-28)¶

⚠ BREAKING CHANGES¶

The package was renamed from ui5-cc-excelupload to ui5-cc-spreadsheetimporter!

rename to spreadsheet importer (removing word excel) (#282)

Features¶

rename to spreadsheet importer (removing word excel) (#282) (e661c3e)

0.20.0 (2023-06-27)¶

Features¶

added sample data to template including formats and option to hide it (#275) (3766049)
export ts types and new ts sample app (#278) (46fbaee)
option to define available options for user (#264) (e6abe2d)

0.19.1 (2023-06-19)¶

Bug Fixes¶

improve error Message on table discovery (#270) (0215ba0)

0.19.0 (2023-06-10)¶

Features¶

add debugging option (#257) (61a5f3f)

0.18.1 (2023-06-09)¶

Bug Fixes¶

removed check for nullable fields (#255) (f4b569a)

0.18.0 (2023-06-02)¶

Features¶

add new option to show backend error message (#236) (f2a38dd)
show options menu for some configurations (#241) (8bfae76)

Bug Fixes¶

different format in float and integer for v4 (#240) (23b1b9a)
improve handling of backend errors (#213) (5d06db6)
send double as string value (#234) (799a3ef)
use busy indicator on opening options menu (#242) (0151700)

0.17.5 (2023-05-22)¶

Bug Fixes¶

add missing check on option "skip checks mandatory field" in v2 (#229) (6c7f53b)
skip sap properties (#228) (69bbe03)

0.17.4 (2023-05-22)¶

Bug Fixes¶

show raw value on parser error (#227) (50142bf)

0.17.3 (2023-05-20)¶

Bug Fixes¶

remove popup in FE scenario when uploading (#223) (f7d12b3)

0.17.2 (2023-05-20)¶

Bug Fixes¶

add missing Edm Types (Decimal, Integer) (#221) (7bda6d5)
rename option to skip all metadata mandatory field checks (#220) (a7ac5e4)

0.17.1 (2023-05-20)¶

Bug Fixes¶

messages are not a mandatory field (#217) (bc20e5c)
parsing booleans (#219) (82777f9)

0.17.0 (2023-05-18)¶

⚠ BREAKING CHANGES¶

change API to add messages to Error Dialog (#211)

Features¶

add option to hide the "preview data" button (#212) (65bcb5b)
add option to set decimal seperator (#199) (ba4a4f2)
add option to skip Fields with Nullable=false (#216) (28ded2d)
change API to add messages to Error Dialog (#211) (a06ec4e)
show faulty value in the error dialog (#197) (8e09745)
warning when numbers are formatted in file (#205) (701b31e)

0.16.4 (2023-05-09)¶

Bug Fixes¶

check on mandatory fields (#192) (05dbcc9)

0.16.3 (2023-05-09)¶

Bug Fixes¶

correct check for mandatory fields (#190) (83a7d6f)

0.16.2 (2023-05-09)¶

Bug Fixes¶

add check if no annotations are found (#188) (bd440bf)

0.16.1 (2023-05-08)¶

Bug Fixes¶

remove empty line (ae7bce8)

0.16.0 (2023-05-08)¶

Features¶

add continue on error button in error dialog (#182) (40d7d28)
add options menu for config (#183) (7533ba9)
revert removal of option fieldMatchType (#157), new default labelTypeBrackets (#173) (7a91c19)

Bug Fixes¶

i18n language codes (#179) (851a50c)
remove ids from options fragment (#184) (be2e947)

0.15.0 (2023-04-18)¶

⚠ BREAKING CHANGES¶

removal of option fieldMatchType (#157)

Features¶

check for mandatory fields annotation (#162) (6c99324)
removal of option fieldMatchType (#157) (4346e1b)

0.14.1 (2023-04-18)¶

Bug Fixes¶

error message shown twice on listreport (#152) (d0a3d12)
improve UX on upload dialog (#151) (4ca9e1f)

0.14.0 (2023-04-14)¶

Features¶

handle backend error (#110) (3abc24a)
preview of data uploaded to app and row counter (#148) (fb57789)

0.13.0 (2023-04-13)¶

Features¶

add event uploadButtonPress (#143) (23b918c)
new option to upload in standalone mode (#145) (ead496f)

0.12.3 (2023-04-11)¶

Bug Fixes¶

enablement for V4 FPM (#135) (1bf89ba)

0.12.2 (2023-04-10)¶

Bug Fixes¶

update correct versions in code (#124) (71f106e)

0.12.1 (2023-04-07)¶

Bug Fixes¶

remove unused imports (#119) (2eea092)

0.12.0 (2023-04-04)¶

Features¶

add Support for OpenUI5 (#97) (9f1ed6c)
including Sample App for OpenUI5 and wdi5 Tests
improve checks for all Edm Types (#105) (dc91ee2)
Documentation for the improved Error Handling can be found here
improved checks on the data formats and error handling (#103) (801cfcb)
Improvements for custom error handling. Documentation can be found here
new automatically translated languages added (#107) (477e899)
the english language was automatic translated to following languages: Chinese, French, Spanish, Italien, Hindi, Japanese

0.11.4 (2023-03-27)¶

Bug Fixes¶

namespace at manifest was not replaced correctly (#91) (f60c19b)

0.11.3 (2023-03-20)¶

Bug Fixes¶

use attribute tableId to get tableObject (#84) (0860373)

0.11.2 (2023-03-18)¶

Bug Fixes¶

missing check for active draft option (#81) (e15e2eb)

0.11.1 (2023-03-17)¶

Bug Fixes¶

use batchSize even when payload has less then 1000 lines (#77) (c0926d1)

0.11.0 (2023-03-17)¶

Features¶

new option batchSizes to slice batch calls to backend (#75) (8f7684f)

0.10.0 (2023-03-12)¶

⚠ BREAKING CHANGES¶

use namespace with underscores (#72)

0.9.1 (2023-03-02)¶

Bug Fixes¶

check for binding before open dialog (#62) (c1f545f)

0.9.0 (2023-02-18)¶

Features¶

check if all columns name in file match metadata (#57) (7c538a0)
support for UI5 Tooling V3 (#47) (d9f52e9)

Bug Fixes¶

Align Dialogs more with Fiori Guidelines (#54) (4f74eeb)
horizontal scrollbar in dialog on mobile view (#55) (3288a25)

0.8.1 (2023-02-10)¶

Bug Fixes¶

remove scrollbar from dialog (#45) (bb1b197)

0.8.0 (2023-02-10)¶

Features¶

setup for central deployment abap (#41) (54bc904)

0.7.0 (2023-02-03)¶

Breaking Changes

Changes involving in the manifest and custom code implementation.
See Documenation

Bug Fixes¶

component-preload.js and componentUsages in examples apps (#40) (33c6e88)
upload same file two times (#37), closes #36 (553e5a8)
using component-preload.js (#31) (4b223bb)

Features¶

add intial csv support (#33) (f7ec051)

0.6.0 (2023-01-14)¶

Bug Fixes¶

open dialog twice again (#20) (7a37483)

Features¶

Created compatibility and wdi5 tests for List Report and Object Page in Draft Mode for OData V2 (Versions 108,96,84,71) and OData V4 (Versions 108,96,84)
More info see Supported Versions

compatibility/wdi5 tests with v2 FE 96/84/71 (3f010d9)
support for v4 96/84 (#16) (109813f)
working in Draft List Report V2/V4 (#17) (cc07d38)
works in ListReport/ObjectPage V4/V2 and Freestyle V2(#10) (d9432d2)

0.5.0 (2023-01-04)¶

Features¶

init i18n (#8) (593b009)
multiversion support (#6) (68aa9ca)
works in ListReport/ObjectPage V4/V2, V4 FPM and Freestyle V2(#10) (d9432d2)
new option for draft Activation (#10) (d9432d2)

0.4.0 (2022-12-23)¶

Breaking Changes

Changes involving in the manifest and custom code implementation.
See Documenation

Features¶

multiversion support (#6) (68aa9ca)

0.3.4 (2022-12-09)¶

Bug Fixes¶

change console output statement to debug (cd19150)
Type "Edm.DateTime parsed in false format (8fb6541)

Features¶

add dedicated docs with mkdocs (#3) (77a6e06)

0.3.3 (2022-12-07)¶

Bug Fixes¶

check did not work with fieldMatchType:label (dde0bf9)

Features¶

convertion for date/time types before creation (65823aa)

0.3.2 (2022-12-07)¶

Features¶

new parsing type of column header (713e8a1)

0.3.1 (2022-12-06)¶

Bug Fixes¶

xlsx not in build (e3296c0)

0.3.0 (2022-12-06)¶

Breaking Changes¶

Move to reuse component, change in implementation

0.2.2 (2022-12-01)¶

Bug Fixes¶

change path, only dist folder for app build (300e2c5)

0.2.1 (2022-12-01)¶

Bug Fixes¶

remove wrong apostrophes from string (b1d31dc)

0.2.0 (2022-11-30)¶

Features¶

check for mandatory fields 0520ada
try get file name from v4 model fa9a349