OCM Import Files generation

[eferreyra]

Hi, there is some reference about the format and contents of the text files for import campaigns in an OCM ?

I do an export and i see the generated files, still have some serious doubts...

The export and import files are the same ? (.rsl vs .lst)
I know .rsl files because i generate one, but i have no idea about .lst files wich are the first option for importing in OCM

In relation to .rsl files:

Is the record_id field necessary or i can omit this and the records would be auto-numerated ?

I can test it, just showing examples of the doubts i have.

Thanks for any help.

Pachu

[cavagnaro]

Yes they are the same, extensions are only for you to know if you are looking a exported file or a file to  be imported.
If you see the list table on SQL or whatever DB Server you are using you will get a better idea on how to import the data.
Also if you check the fields on CME will be a good idea. So record_id is mandatory. you can modify your table to make it autogenerated but will not recommend it.

[eferreyra]

ok cav, but in my case if i let record_id= (empty)
when i import the records gets autonumerated record_id and in the sql server is an integer, not identity or any other autonum field.

Thanks for the tips

[cavagnaro]

As said, depends on your DBServer type