Skip to main content
Solved

Import records with username to RDM


Forum|alt.badge.img+4

Hello Ataccama community 😀

Has anyone previously used the USERNAME column type in the RDM Importer or RDM History Importer? I want to specify the [ Username ] on RDM, indicating who made changes to each record in an automated fashion.

However, I got an error telling me that unknown column 'username'; I tried using “USERNAME” instead of “username,” but still had no luck.

Could anyone familiar with this help me please?

Best answer by AKislyakov

To use RDM History Importer step you should first import current state using RDM Importer step and then attach relevant history using RDM History Importer. 
The RDM History Importer is rather unsafe step: it’s not incremental; it will not check your data; it will allow you to create inconsistent history.

The step should be handled with care, and I wouldn't use it if not absolutely necessary.

View original
Did this topic help you find an answer to your question?

5 replies

Forum|alt.badge.img+2
  • Ataccamer
  • 146 replies
  • March 27, 2023

I believe this column is read-only, so you can only use it in Read steps (RDM Extender Reader, RDM Reader). If the reference is maintained exclusively through imports, you can create a regular column to store the user.


Forum|alt.badge.img+4
  • Author
  • Data Pioneer L2
  • 28 replies
  • March 28, 2023

I see. Thank you, AKislyakov.

I have another question regarding the RDM History Importer; when importing data with this step, the data seems to go only to the HISTORY and ALL HISTORY view, even with some records having “Date to” as blank (so they are valid as of now). Do you know how to also have those records in PUBLISH and EDIT perspective?


Forum|alt.badge.img+2
  • Ataccamer
  • 146 replies
  • Answer
  • March 28, 2023

To use RDM History Importer step you should first import current state using RDM Importer step and then attach relevant history using RDM History Importer. 
The RDM History Importer is rather unsafe step: it’s not incremental; it will not check your data; it will allow you to create inconsistent history.

The step should be handled with care, and I wouldn't use it if not absolutely necessary.


Forum|alt.badge.img+4
  • Author
  • Data Pioneer L2
  • 28 replies
  • March 28, 2023

It works. Thank you, AKislyakov.


Forum|alt.badge.img+4
  • Author
  • Data Pioneer L2
  • 28 replies
  • March 28, 2023

Hello @AKislyakov, you mentioned earlier that the RDM History Importer step is not recommended as it can be considered unsafe. Could you please suggest an alternative method for importing data along with its history onto RDM? Thank you


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings