This content has been marked as final. Show 3 replies
thanks for your feedback about the new feature, I will briefly give my comments below
-- can't load into a view, or into a table owned by another schema
the data upload feature allows you to create data load defnition on all tables under the schemas that you are having access to. in our future release access to the views also will be possible.
-- can't change the table name once a Data Load Definition is created
The concept of data load definition itself is linked to table. table lookups and transformations rules are all defined towards a table name, hence they would not be any need to change the table name only.
You will most probably need to add/edit or remove table lookups and transformations rules Or re-create the pages without re-creating the data load definition. and you can do all the above through shared component.
-- can't set any defaults for mapping fields to columns
Usually, the mapping is left to the user, so that he can make sure he is doing the right matches between his data and the table column names but the data upload feature helps in matching the table columns with the names of columns that appear on user data.
-- can't create a new Data Load Definition without rerunning the wizard
I just explained above, Yes you can re-create the wizard without going through all the steps. Just go to the shared components and choose your data definition, you should see a link on the right corner - Re-create Data Load Pages
-- page cache and collection are not cleared after the load is processed
In future release, I beleive we will give an option to the developer to choose if he would like to maintain his collections or not. The idea of keeping the collections was to give the developer much more control of the data in case, he would like to do more or extend the feature.
The data loading wizard is a really good idea and just what we need to reduce our workload. I would like to request a few more features which would enable us to fully use it within our business.
1) when i upload a csv not all the columns display in the Data / Table Mapping screen. i assume there is a limit on the number of columns you can upload. is there any way you can highlight that this limit is exceeded when we select the Data Load Table we want to use? what is this limit?
2) can we have more control over the transformation lookup. ideally i would be able to write plsql expressions to run against each field during the upload.
3) can we have the ability to create multiple transformation runs in one go (i had 20 columns which needed the same transformation rule)
4) can the table lookup look at views? my table lookup needs to be a combination to two tables (test and live)
I am using this feature for data load. it is not allowing to load more then 500 rows. My sheet got around 3000 rows, but the wizard only picks first 500 rows. How we can overcome this problem?