# SQLTag CSV Enumerations **URL:** \ **Category:** Module Development\ **Created:** [September 6, 2012, 12:54am UTC](https://forum.inductiveautomation.com/t/sqltag-csv-enumerations/5103 "2012-09-06T00:54:02Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![lisawas](https://avatars.discourse-cdn.com/v4/letter/l/4bbf92/32.png) [@lisawas](https://forum.inductiveautomation.com/u/lisawas)\ **Post date:** [September 6, 2012, 12:54am UTC](https://forum.inductiveautomation.com/t/sqltag-csv-enumerations/5103/1 "2012-09-06T00:54:02Z")
We’re working on generating a csv to import new tags into Ignition, based on spreadsheets from other facets of our facility. By and large, we have figured out what the Ignition CSV should look like, but I have a few remaining questions: What are the possible values for Eng Unit, AlertSendClear, AlertMessageMode, and HistoryMaxAgeMode? I skimmed through your documentation and the Ignition.Common .jar file, in hopes of determining the possible values for several tag attributes. I did manage to find definitions for most of the SQLTag enumerations. That said, while all of the above but Eng Unit seem to refer to integers, I got the impression that they were more like integer representations of boolean values. I apologize, as this is not a module programming question. It is more of a general programming question, as I’m writing a little program to generate a SQLTags.CSV for our facility. ---
**Author:** ![AlThePal](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/althepal/32/3603_2.png) [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Post date:** [September 6, 2012, 11:48am UTC](https://forum.inductiveautomation.com/t/sqltag-csv-enumerations/5103/2 "2012-09-06T11:48:24Z")
From the Ignition documentation: Eng Unit Manual reference: Project Design / SQLTags / Basic Tag Properties / Metadata Properties Definition: The engineering units of the value Possible values: ‘Deg C’, ‘mm’, ‘Bar’ etc. AlertSendClear Manual reference: Project Design / SQLTags / Basic Tag Properties / Alerting Properties Definition: Indicates that a message should be sent when the alert clears, in addition to when it becomes active. Possible values: 0 (=No), 1 (=Yes) AlertMessageMode Manual reference: Project Design / SQLTags / Basic Tag Properties / Alerting Properties Definition: How the message should be generated for the alert Possible values: 0 (=Auto-generated), 1 (=Custom) HistoryMaxAgeMode Manual reference: Project Design / SQLTags / Basic Tag Properties / History Properties Definition: The maximum amount of time that can pass before a new record is logged for the tag Possible values: 0 (=Unlimited), 1 (=value set in HistoryMaxAge used) Hope this helps - I worked out the possible values by editing the fields for a SQLTag and exporting it to a csv, then comparing what was in the file to what the options were on the screen. ---
**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Post date:** [September 6, 2012, 3:46pm UTC](https://forum.inductiveautomation.com/t/sqltag-csv-enumerations/5103/3 "2012-09-06T15:46:25Z")
The programmer’s guide in the 7.5.2 sdk has a new appendix with more info, though it doesn’t explicitly deal with CSV. However, in many cases enums are stored as integers, and it at least points you to the enums that define the possible values. Regards, ---
**Author:** ![lisawas](https://avatars.discourse-cdn.com/v4/letter/l/4bbf92/32.png) [@lisawas](https://forum.inductiveautomation.com/u/lisawas)\ **Post date:** [September 17, 2012, 3:55am UTC](https://forum.inductiveautomation.com/t/sqltag-csv-enumerations/5103/4 "2012-09-17T03:55:48Z")
Thank you very much. I worked out some of the other enumerations by looping through their values in Java, but I couldn’t find those.