Messages

31

Feature Requests and Issues / Re: Equipment Import logic

« on: February 19, 2014, 11:05:28 AM »

You guys ROCK!  One other problem - don't know if you need a separate thread or not...

I was able to delete the old data (AWESOME that we don't have to bug you guys as we test now!!)...re-imported with the 'update' flag off (KILLER feature!)...then tried to start uploading pics for the gear.  It will upload the first photo, but when you move to another piece of equipment, it takes you through the steps of choosing the photo, but doesn't upload it if it's the same file name.  Sounds weird, but say we have 35 USAR helmets, we may want a generic photo of just a helmet in the database instead of separate photos for each one.

You end up having to change tabs (click on say Documents, then back to Equipment), then it lets you import...but just one photo, then it locks up again.

It's as if a flag isn't being cleared when you move between records on the Equipment screen.

32

Announcements / Re: New Time Keeping Options

« on: February 18, 2014, 04:18:38 PM »

Will turning off the mileage there still show the mileage on the check in screen?

33

Feature Requests and Issues / Equipment Import logic

« on: February 18, 2014, 11:19:34 AM »

We seem to be having an issue and we need a little more info on how MM works.

We have an equipment table of everything we have for our team (PPE, medical equipment, etc.).  Many of our line items don't have a serial number (medical equipment, etc.).

We have 5 trailers full of gear - much of it not serialized, with a small percentage that does have a serial number (generators, etc.).

After importing 2170 items, only 708 items were actually imported.

We need to know what the logic is for how MM decides an item is a 'duplicate' and how it determines if you are updating an existing line vs. adding a new line.

We THINK our issue is the "Name" field is only 30 characters (we are assuming the system is using that field to determine unique items).  If we were to try to add in say our trailer number to force the system to identify it as an independent item, we would be left with only 24 characters to describe the item (our trailer numbers are the 5 digit City Vehicle number).  That's not really practical for the items we have inside (such as "Adhesive Bandages, Sterile" - 26 characters).  We don't have enough room to make a name of "Adhesive Bandages, Sterile 10732" as it goes beyond the 30 character limit.

Sooo...we are not sure how to fix this issue to actually get the import to work.  Our old spreadsheets had an "ID Number" that acted like a unique ID...but to integrate that number with the name isn't really practical (a. it chews into the characters needed for the name and b. it is difficult to 'manually' manage).

Can someone provide some info on how the table and import works?

34

Feature Requests and Issues / Re: Equipment Screen

« on: February 12, 2014, 01:27:43 PM »

Once again, you guys win the internet!

35

Feature Requests and Issues / Equipment Screen

« on: February 11, 2014, 03:49:27 PM »

...is there something in my browser I can clear to get the buttons at the bottom right of the Equipment screen to lay out correctly?  It's like they are on top of each other or something...can't get to the 'check all' button without tabbing to it.

36

Feature Requests and Issues / Re: Equipment Import not placing fields correctly

« on: February 11, 2014, 03:44:45 PM »

You guys are wizards...WIZARDS I SAY!!  Thanks!!

37

Feature Requests and Issues / Re: Equipment Import not placing fields correctly

« 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!

38

Feature Requests and Issues / Re: Equipment Import not placing fields correctly

« 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.

39

Feature Requests and Issues / Re: Equipment Import not placing fields correctly

« on: February 10, 2014, 05:41:12 PM »

Email sent...thanks!

40

Feature Requests and Issues / Re: Equipment Import not placing fields correctly

« on: February 10, 2014, 04:29:23 PM »

I'm the sys admin...who do I send the email to?

41

Feature Requests and Issues / Specifications for Fields

« on: February 10, 2014, 02:52:28 PM »

Is there a document indicating what the max character length is for fields in MM?  I ran an import today of our equipment and fuond the Name field seems limited to 30 characters.

If not a document, could the field length (when not adjustable by the user) be listed on the Configuration page...say after the field that lets you rename the field?

42

Feature Requests and Issues / 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)?

43

General Mission Manager Discussion / Re: API?

« on: January 27, 2014, 11:49:34 PM »

I would imagine only administrators should have API access.  If that code gets out, all of your data could be at risk.  Only developers should have access to it.

Radishworks Admins...is this an accurate representation of what API access could do?

44

General Mission Manager Discussion / Re: Importing a CSV file

« on: January 14, 2014, 10:48:58 AM »

I don't believe you need either.  On the import step, it lets you decide what "destination" field you want the data to go in, and the current field name does not have to match.  The order doesn't seem to matter since you designate each field with a destination field (so say your CSV has FName, you choose "First Name" as the destination).

To make it easy on myself, I loaded a 'dummy' record and populated every field, then exported that in a CSV format.  That gave me the field names and orders of what MM has as data.  I then just tweaked the field names on my import file to match the exported file, and set the fields in the same order that MM had on the dummy file.  This made it much smoother to import since visually I had a 'one to one' match during the import process.

One tricky part are dates...they must be formatted in a specific way (yyyymmdd or yyyy-mm-dd if I remember correctly), so if you are using Excel to generate your CSV, you have to remember to fix the date format every time you save out to CSV.  Opening a CSV in Excel to review may switch that format around, so if you modify it, you have to again go back and fix the formatting.

45

Feature Requests and Issues / Re: Offline use with multiple laptops

« on: January 13, 2014, 11:29:02 AM »

Yea, that's where the functionality comes in handy - the ability to have multiple computers sync among themselves instead of with the main database.

Figure you'd have one laptop at Staging, managing teams, etc. ...another at Comms logging radio traffic...etc.  Comms wouldn't be able to log a transmission as being from Team 3 since it doesn't know Team 3 was created - only the laptop at Staging knows that.

I fully appreciate connecting to the internet at any opportunity - but we've had more than one experience where we literally had no cell coverage - through our own providers or others.  I know folks say "just get some altitude", but I'm not duct-taping my cell phone to the antenna mast to see if that works or not  

That leaves us limited to trying to run off of one machine, and that's pretty difficult to do with multiple functions.

We are trying to work around it - picking up some Linksys routers with DDWRT loaded to act as 'receivers' for a single login to a wifi network, but that won't address the primary problem of what to do when you have no connectivity and the need for more than one person working the event.

It's almost like a third mode...similar to 'offline' mode where it simply stores up info, but one where it can share that info it will have in cache with other machines.  Have one machine on a network be the cache site, and have the other browsers from machines on that same network 'sync' to that designated cache...then when you get back to having a signal, that cache machine can sync with the Radishworks server.