Routines for csv_map.kb


MakeLocation

File Name

csv_map.kb

Syntax

MakeLocation(REF type: STRING, REF location_name: STRING)

Parameters

type - type of location (default or not)

location_name - location name

Returns

Nothing

Side Effects

None

Description

This procedure creates a location record.

Dialog Forms Called

None


MapFieldToClassAttrib

File Name

csv_map.kb

Syntax

MapFieldToClassAttrib(REF attributeList: LIST OF Attribute_DefRec, VAL attrib: STRING, VAL attrib_value: STRING, REF PList: LIST OF PhysAttribRec, REF IList: LIST OF IsaAttribRec): BOOLEAN

Parameters

attributeList - list of attribute records

attrib - attribute name

attrib_value - attribute value

PList - pm attribute list

IList - i attribute list

Returns

Boolean: success or failure

Side Effects

None

Description

This procedure takes the attribute list and splits it into a pm attribute list and an i attribute list, for use when mapping attribute values from CSV files to the database table columns.

Dialog Forms Called

None


MapFieldToInvContract

File Name

csv_map.kb

Syntax

MapFieldToInvContract(VAL attrib: STRING, VAL attrib_value: STRING, REF ContractList: LIST OF ContractRec, REF KList: LIST OF STRING, REF VList: LIST OF STRING, VAL flag: ValidFlagRec, REF inv: IS_InventoryRec ): BOOLEAN

Parameters

attrib - attribute name

attrib_value - attribute value

contractlist - list of contract records

KList - list of contract numbers

VList - list of contact values

flag - valid flag record for secure mode

inv - inventory record

Returns

Boolean: success or failure

Side Effects

None

Description

This procedure takes vendor and contract column assignments and maps the CSV data to the database table columns.

Dialog Forms Called

None


MapFieldToInventory

File Name

csv_map.kb

Syntax

MapFieldToInventory(VAL attrib: STRING, VAL attrib_value: STRING, REF Inv: IS_InventoryRec, REF PeopleList: LIST OF PeopleRec, REF ConnectionList: LIST OF ConnectionRec, VAL flag: ValidFlagRec): BOOLEAN

Parameters

attrib - attribute name

attrib_value - attribute value

inv - inventory record

PeopleList - people record list

ConnectionList - connection record list

flag - valid record for secure mode

Returns

Boolean: success or failure

Side Effects

None

Description

This procedure takes inventory column assignments and maps the CSV data to the database table columns for inventory, people, and connections.

Dialog Forms Called

None


MapFieldToValuation

File Name

csv_map.kb

Syntax

MapFieldToValuation(VAL attrib: STRING, VAL attrib_value: STRING, REF aVAl: ValuationRec): BOOLEAN

Parameters

attrib - attribute name

attrib_value - attribute value

aVal - valuation record

Returns

Boolean: success or failure

Side Effects

None

Description

This procedure takes valuation column assignments and maps the CSV data to the database table columns.

Dialog Forms Called

None