|
|
> Content Management > Developers > Database IG Integration
Database IG Integration |  | | | IG List Overview Screen |
Using Invisible Gold Standard Upload and Download buttons for Groups and Lists.
When logged in to Invisible Gold one can download list or registration profile information in database format.
The export function sends the database to your web browser as a CSV file and will either automatically open excel or give further save options.
The "Import" Function adds additional entries to the existing data. It does not replace or remove any data. Remove or modify existing entries directly from within the IG interface.
EXAMPLE:
Making Routine Modifications. Let's say you have 1 entry to modify and 1 to remove and 10 new ones to add.
Step 1. Log into your Invisible Gold website and click on the Users or Lists Icon to get you to your selected Group or List.
Step 2. Check in front of the one entry you wish to delete click "Delete Selected Address"
Step 3. Click on an entry to modify (you will see the current info) then click "Edit Address". Each piece of information can now be changed, click "Save" when done.
Step 4. Click "Return to mailing list" to bring up the overview screen as to the list of entries. In the upper right hand corner you will see "Import". This brings up a Window where you can paste your 10 new entries (in comma delimited manner). Please observe the formatting details provided in the examples on that page. Double up the first row of data as IG (expecting field delimiters) ignores the first row. If you have made a formatting mistake, the entry will not show up in the Overview Screen. Correctly formatted entries from the 2nd line on will appear in Invisible Gold.
Step 5. Export the modified database out of Invisible Gold. Click Export and Select either "Save to File" or "Open With" (this is under your particular web browser's control) but either way will attempt to give you the opportunity to save the modified database or view it in Excel or any program capable of working or formatting Comma delimited text.
Step 6. Open the newly saved database and check the entries. If everything is OK this becomes your new latest version or working copy of your database until the next time you make edits.
Getting Familiar - Feel free to create new test groups or lists and thoroughly exercise the abilities within Invisible Gold to add, edit or delete entries and through "Import" and "Export" to get a hang for how it works. Once you realize how it works, it's easy to make future additions either directly in IG or importing several entries at one time.
HOW TO BEGIN: Start a database. Accurately fill out at least two profiles in IG or through the site's form response or registration and export that. If MS-Excel is installed on your system the default application for .csv (In this example Excel) will open up and format the data into cells. Then you can more easily edit entries and associated information. Use Notepad to open the saved CSV file (you'll see the commas) to copy new entries and paste into IG "Import" screen remembering the first entry has to be field delimiters or simply doubled up.
The knowledge level needed requires basic file handling skills in Notepad and Excel and an understanding of Windows Copy and Paste.
Format Note: If you are used to Excel, this program can save your data in comma delimited format.
Step 1: Have all your updated data saved in a new sheet
Step 2: Copy the new entries to upload to a new sheet and use "File/Save As" (under "Filename" is "Save as Type" and select CSV (Comma Delimited) *.csv format or 4th from bottom is (CSV) MS-DOS *.csv.
Step 3. Open this file in Notepad (you'll see the commas) and copy your entries and paste into IG "Import"
Step 4. Double up the first entry and click Import and if correctly formatted will see the data in IG.
Please feel free to contact us with how to best handle your data situation.
|
|
> Content Management > Developers > Database IG Integration
|
