Solved

Import Assets

  • 7 December 2022
  • 3 replies
  • 128 views
J
Badge

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

icon

Best answer by Kathryn Carter 13 December 2022, 14:47

View original

3 replies

Kathryn Carter
Userlevel 7
Badge +12

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

Kathryn Carter - Community Moderator
J
Badge

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?

Kathryn Carter
Userlevel 7
Badge +12

@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! 😄

Kathryn Carter - Community Moderator

Reply


Terms & ConditionsCookie settings
Incident IQ logo

Incident IQ is a service management platform built for K-12 school districts, featuring asset management, help ticketing, facilities maintenance solutions, and more.

Corporate Headquarters:
750 Glenwood Ave SE, Suite 320
Atlanta, GA 30316