Service to import and export

denisv

Is it possible to set up a process /service to import and export data without user intervetion (i.e. from the server once the operation panel is running).

I have a requirement for the following:

a) Export all records from a business object where the date value in an attribute is more recent then the last date that the export was performed (that last export data needs to be stored and updated after each export)

b) Import all records that are held in an external table or file into a business object

The data exchange involved is with an MS SQL Server.

aware_support2

Yes, this is done using scheduling rules. You will also need a couple of processes, one for the export and the other for the import. The exporting process would have the following 3 rules:

FIND MyObject WHERE MyObject.UpdatedOn > SystemSettings.MyObjectExportedOn
EXPORT MyObject TO 'c:/export/MyUpdatedObjects.csv'
SystemSettings.MyObjectExportedOn = CURRENT_DATE

You would also need to add attribute MyObjectExportedOn of type Date to object SystemSettings. The importing process would have the following single rule:

IMPORT MyObject FROM 'c:/import/MyImportedObjects.csv'

Finally you need to add two scheduling rules to start the exporting and importing processes respectively at the desired time of day.