Import Table with all fields of Target table

[dshamatr]

Hello!

I have a question.

Is that possible to create Import Table with all fields of Target table?

For example, I have change_request table as target for my Import Table. Now, my table extends sys_import_set_row.

I inserting data into my Import Table using REST API. Previously we used change_request.do as endpoint to insert Change Requests directly.

Now we're moving to Import Tables and Transform Maps and we need to have possibility to use all fields that present in Change Request table by default.

Also, we want to avoid manual field creation.

Is there a way to create in my Import Table automatically all fields that present in the change_request table?

Or how it should be done properly?

Thanks.

/Dmitriy

[DrewW]

The only way off the top of my head I can think of to do this is to either create them all manually the first time and then create a business rule on sys_dictionary to keep up on it or write a script.   You are still going to have differences because the import table is always going to have a u_ in front of the column name.

Is there a reason you want to switch from how its being done now?

[dshamatr]

Certification reasons. We have both: scoped application and integration application.

[Atul Kumar2]

Hi Dmitriy,

Yeah, you can create a import table with all fields from target table.

Follow the below steps.

1. List the table record. by tablename.list

2. Add all column which you want from personalize list.

3. Right click on form header and export in csv or other format as per your wish.

4. Exported file will have all column, remove the earlier data and feed the data in it.

5. Create a import set table by loading the data into new import set table.

6. Map the all column present in import set table to target table.

Note- You will have to make a extra effort for the reference field etc.

Hope this helps.

Regards,

Atul Kumar

[lucaburgazzoli]

I've tried to follow the path but it does not work at least for me, on Helsinki once I've personalized the

list, I do not have the option to export them in csv :

The only option I have is to export a single record, but as xml ...