Thursday, September 27, 2012

"Automation" New Data Into Your System

Unless you have the Nifty 2000.00 dollar windows module that allows you to import directly from XLS Sheet.

You are going to have to do it this " Other " Way.

Open up "Network Access"
Type in FIL
Then Type in your Fil File name, Hopefully you already have a couple fil files configured
one for New ADD's and one to Up-Date Current Data

We've made a Default1 for new add's and Default2 for Up-dating existing data.






















Basically to make a long story short,  this is where you make a macro
select your Tab Delimited or Comma Delimited File and begin to load your
Fil File, 






















Before you create your macro, take your Excel sheet
and save as Comma Delimited or Tab delimited,
place that file on your desktop.

To create your Macro you select " Programmable Keys " from the options/ keys menu





















Here is an example of a macro we made for this load,
Select your TAB or COMMA Delimited Data file, 
Choose TAB or COMMA Delimited in Field Separator Selection.

After everything looks good here, hit " OK "
And then tap Ctrl+F1.  And watch the magic happen.
The macro will put the data in the proper field's and add
each record to the Fil File.

Next once the load is complete, You open up the Fil File in Eagle Browser for windows.
















If you like what you see then you Finalize, Updating your system with
this new data





No comments:

Post a Comment