| . |  Download PDF version of Mapping Instructions. Get Adobe PDF Reader Here.
What is mapping?
Mapping is the name given to a set of instructions used to tell Gold where the data collected from the web should be placed. This is also known as a protocol.
How do I get a mapping?
A mapping will need to be created to import data from GoldReg into the Gold System. To do this:
- Log into GoldReg
- Click on the Published link in My Meetings to go to Admin.
- Go to Data Management
- Click Gold Export Status
- Download your data from Pending Status to Download by clicking the Download Data link at the top of the page
- You will be directed to the Download Gold Files Page
- Left click the link for the time and date of the file you have just created
(.txt is your text data file of all of your registrants you just downloaded)
- Click the Create Mapping File button and follow instructions on page
You have created the mapping based on the data from this meeting. You will only need to do this once for this meeting. Note: Each meeting is unique and will require its own mapping. You will need to generate a new mapping for each GoldReg meeting you publish.
What to do with the mapping once it is created?
You will need to ‘run’ the mapping script in Microsoft SQL Server 7 in the Query Analyzer.
- Open Query Analyzer (Connect to Server if necessary)
- Choose your database from the dropdown box at the top right of the window labeled DB
- Load SQL Script by click the open folder on the left top and browse for your .sql file (You will see SQL statements in the programming pane)
- Click ‘Execute Query’ by clicking the green triangle
- You will see code such as this underneath the programming pane:
Database name 'tempdb' ignored, referencing object in tempdb.
(1 row(s) affected)
(1 row(s) affected)
- Once the Query has completed, you may close Query Analyzer
- You mapping is now installed in your Gold System Database.
There are two steps to importing a file into Gold.
- CSText2MB- a utility that dumps the entire contents of a text file into a single place called the mailbox.
- RegPplImp – utility to disperse individual records in the mailbox through out the database.
Importing data into Gold.
If you haven’t done so already, you will need to save the .txt file from the web to your desktop (or any other place that you can access it)
- Click on the icon for the CSText2MB (your first import utility for get records into the Mailbox, be sure you meeting is locked)
- Select your meeting
- Select your import ID. This is the mapping name you have just created.
- Choose your text file to import
- Select Vertical layout, # delimited
- Download text files
- Success message will tell you (X) records have been imported
Import from Mailbox into Database
- Click the icon for RegPplImp
- Select Registration Import
- Select your Import Protocol
- Import Records (be sure you Registration Defaults are setup)
Customizing mapping
You may realize that some mapping do not suit your needs. GoldReg give you the ability to create custom fields, however, these will be mapped into Registration Q&As only.
Example: You may want to collect shoe size on your registration form. There is not an option for shoe size in the regform setup. You may create a custom field called Shoe Size with a dropdown of sizes S, M, L, XL, etc. Shoe Size will now show up in Q&As. However, if you know Gold well enough, you will realize that Shoe Size is a field that shows up under the Personal Profile tab. How do you get it there?
You have a few options here. You may manually map your entire file using the mapping tool on the RegPplImp or you can remap any fields on the protocol created.
To re-map a field:
- In the bottom window, find the field you want to re-map
- Highlight the row of the field you want to change
- Press Del to delete
- Go to the top left window and find the field name you just deleted, double click it to send it to the gray display box under Text File Fields
- Go to the right top window and find the field in Gold you want this field to map to, double click it to send to the gray display box under Gold Fields
- Once both field are in the gray display box, click the green down arrow to include it back in the mapping
- Repeat for additional fields if necessary
- Click Close to end.
|