Question

Import Assets

  • 7 December 2022
  • 3 replies
  • 30 views

Hello,

I am using the Import Assets feature to update asset information. When I upload the spreadsheet one column is not uploading properly. It is reading it as  M/d/yyyy h:mm rather than the information that is in the column. 

I have had this happen several times so I am wondering what I can do to fix this problem. I have changed the format, re-uploaded, created complete new sheets to upload. Sometimes it fixes the problem and other times not. 

Do you have any suggestions?

Thanks,
Janell


3 replies

Userlevel 4
Badge +8

@Janell What information are you trying to bring into the system and under which column name is it? Could you provide a screenshot? 

Hi, it varies on the column. Typically if I reformat the column to Text then it works, but not all the time. I just create a spreadsheet. Do you want me to use a template?

Userlevel 4
Badge +8

@Janell YES! When you go to Assets / Import Assets, there is a template for you to include your information in to import. Here is a screenshot. 

I hope this helps! 😄

Reply