Author Topic: Equipment Import not placing fields correctly  (Read 9382 times)

SFD CERT

  • Full Member
  • ***
  • Posts: 107
    • View Profile
Equipment Import not placing fields correctly
« on: February 10, 2014, 02:49:06 PM »
I just did an equipment import and the fields were not placed correctly.   I have the following fields in my configuration:
* Equipment Categories: Animal Control, CERT Forms, Communications, EMR/CPR, Gear, HazMat, Logistics, Medical, Misc, Operations, Pager, PPE, Promotional Items, Survival, Toiletries, Tools, Trailer, Training, Uniforms (no spaces)
* Equipment Status: In Service, Out of Service, Repair-Svc-Inspection, Retired, Lost, Damaged, Expired (no spaces)
Equipment 'In Service Date' Field: In Service Date
Equipment 'Out Service Date' Field:
Equipment Field 1: ID Number
Equipment Field 2: Serial Number
Equipment Field 3: Location
Equipment Field 4: Vendor
Equipment Field 5: Inspection/Service Dt
Equipment Field 6: Count
Equipment Field 7: Assigned On
Equipment Field 8: Security Tag

Somehow I have location data in the Serial Number field...yet Serial Number never appeared as part of my import choices.

Can someone completely clear our Equipment table so I can start troubleshooting with smaller data sets (say 10 at a time)?

Radishworks

  • Hero Member
  • *****
  • Posts: 1318
    • View Profile
Re: Equipment Import not placing fields correctly
« Reply #1 on: February 10, 2014, 03:45:20 PM »
Quote
Can someone completely clear our Equipment table so I can start troubleshooting with smaller data sets (say 10 at a time)?
Your sys admin will need to send an email to support (at) radishworks.com with a clear request for us to clear your equipment. data.

SFD CERT

  • Full Member
  • ***
  • Posts: 107
    • View Profile
Re: Equipment Import not placing fields correctly
« Reply #2 on: February 10, 2014, 04:29:23 PM »
I'm the sys admin...who do I send the email to?

Radishworks

  • Hero Member
  • *****
  • Posts: 1318
    • View Profile
Re: Equipment Import not placing fields correctly
« Reply #3 on: February 10, 2014, 04:34:49 PM »
You will need to send the email to "support (at) radishworks.com".  Clearing of data, needs to come as a direct email request  :D.

SFD CERT

  • Full Member
  • ***
  • Posts: 107
    • View Profile
Re: Equipment Import not placing fields correctly
« Reply #4 on: February 10, 2014, 05:41:12 PM »
Email sent...thanks!

Radishworks

  • Hero Member
  • *****
  • Posts: 1318
    • View Profile
Re: Equipment Import not placing fields correctly
« Reply #5 on: February 10, 2014, 07:32:56 PM »
Email received and Equipment removed. 

I should have explained the request of the email, it may seem like an odd request.  We have a policy of only removing team's data via an email request from the admin, rather than just forum posts.  (security and privacy reasons  :D).

SFD CERT

  • Full Member
  • ***
  • Posts: 107
    • View Profile
Re: Equipment Import not placing fields correctly
« Reply #6 on: February 10, 2014, 09:10:35 PM »
Not a problem, it actually makes perfect sense.

So...my plan is to add in the fields I had before, then manually complete one record.  I'll "export" that record and use that file as a template to bring in a smaller set of records to see what fields are available for me to populate (today at least one field I had configured would not display as an available field to map), and see if I can find out where the rest of the data was going. 

Probably won't be until tomorrow though.  I'll keep you posted on how it goes.

SFD CERT

  • Full Member
  • ***
  • Posts: 107
    • View Profile
Re: Equipment Import not placing fields correctly
« Reply #7 on: February 11, 2014, 02:50:59 PM »
OK...reproduced the error.

Here's what I did:
I created 8 equipment fields -
"Asset Tag"
"Serial Number"
"Location"
"Vendor"
"Inspection/Service Dt"
"Count"
"Assigned On"
"Security Tag"



I then populated many of those fields and exported the .csv file.  I copied over values into that CSV file (pasting just values so I didn't alter the formatting), then saved the .csv file and tried to import the file.

The following fields did not show as available to map to during the import process - some are fields that were already in MM, others are some that I had added:
"Asset Tag"
"Serial Number"
"Vendor"
"Inspection/Service Dt"
"Count"
"Assigned On"
"Security Tag"
"Assigned Division"


Please advise.  Thanks!

Radishworks

  • Hero Member
  • *****
  • Posts: 1318
    • View Profile
Re: Equipment Import not placing fields correctly
« Reply #8 on: February 11, 2014, 03:14:02 PM »
Fixed.  The missing fields should be there now on the import field options.  Thanks for the report.

SFD CERT

  • Full Member
  • ***
  • Posts: 107
    • View Profile
Re: Equipment Import not placing fields correctly
« Reply #9 on: February 11, 2014, 03:44:45 PM »
You guys are wizards...WIZARDS I SAY!!  Thanks!! ;D