Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Data Source import old data instead of new excel file

LCristina
Tera Expert

Hello community!

I have a Data Source to import information from Excel file with only one line to test, and the column names inside the file are: proposal; professional name; status; class entity and class number.

 

I have imported data before to the same table but I have used Brazilian Portuguese (I don't remember why to be honest), and seems like the last import had 210 records and column names in Portuguese: proposta; nome do profissional; estágio; classe e número da classe.

My issue is, when I try to import new data, the system loads the old data instead! 😭

I've tried so far without success:
- Delete the import table, transform map and data source. Create everything from scratch. The system brings the old fields and those old 210 records again.

- I've tried the old way to import data directly using the "Import" option on the table list on the column menu option. Nothing is imported and the Data Source it creates automatically has those old column names in Portuguese again.

- I've tried to delete old files from sys_attachment; old import sets and even edit the transform table web service. No success.

 

Please, can anyone help? I have to update more 2 thousand records and 5 columns in this table.

I appreciate the attention and help in advance!

0 REPLIES 0