I have an app with 3500 records. I have an ascii file of 1000 records that I'd like to import. Both the app and the ascii file share a unique LE (policy number). I'd like to import the 1000 records and have them "go" where they should based on the shared policy number. Looking for a way to automate this...otherwise...yours truly will have the task of manually parsing through this!!
Any help appreciated...

I would like to update exisitng records with the text file but only for those records that share the same policy number...?

The app has about 700 LE's. 100 of these have just been added to the form to accomodate the data in the ascii file... The way it appears to me is that the data from the ascii file would be appended to the end of the existing form ...?

It is comma delimited...tx...

Here are a few lines from the import (ascii) file...(it ain't pretty!!)
"50C0003335",01,"06/04/2004","06/04/2005","MICHAEL BAY MARINE",98," "," ","CORPORATION","NON-APPLICABLE","8,9",1000000,175," ", ," ", ," "," ", ," ", , , ," ", , ," ", ," ", ," ", , ," ", , ," ", , ," ", , ," ", , ," ", , ," ", , ," ", ," ",175,"MD","IF ANY","1.0","1.0",74," "," "," "," ", ," "," "," "," ", ,74, ," "," ", , ," "," ", , ," "," ", ,0,10,"101", ," ", ," ", ," ","101","CA0001 03 06","CA9903 03 06","CA2117 12 93","CA2171 01 88","CA0170 10 01","CA0215 11 00","CA2113 04 01","CA2219 01 02","PA0216 11 00"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ", ," "," "
"50C0002167",04,"04/12/2006","04/12/2007","SAILCRAFT",20," "," ","CORPORATION","NAS-02167","1",1000000,1895," ", ," ", ," "," ", ," ", , , ," ", , ," ", ," ", ,"5",1000000,252," ", , ," ", , ,"7",1000,228," ", , ,"7",1000,818," ", , ," ", ," ",3193,"NC","IF ANY","1.0","1.0",74," "," "," "," ", ," "," "," "," ", ,74, ," "," ", , ," "," ", , ," "," ", ,0,10,"101", ," ", ," ", ," ","101","CA0001 03 06","CA9903 03 06","CA2117 12 93","CA2171 01 88","CA0126 03 01","CA2116 07 04"," "," "," "," "," "," "," "," "," "," "," "," ","2000 CHEVROLET","2003 CHEVROLET","2006 CHEVROLET SILVERADO"," "," "," "," "," "," "," "," "," "," ", ," "," "
"50C0004324",00,"05/30/2006","05/30/2007","BROAD CREEK MARINA LLC",10,"708 HARBOR ROAD","WANCHESE,NC 27981","CORPORATION","NAS-04324","8,9",1000000,175," ", ," ", ," "," ", ," ", , , ," ", , ," ", ," ", ," ", , ," ", , ," ", , ," ", , ," ", , ," ", , ," ", , ," ", ," ",175,"NORTH CAROLINA","IF ANY","1.0","1.0",74," "," "," "," ", ," "," "," "," ", ,74, ," "," ", , ," "," ", , ," "," ", , ,10,"101", ," ", ," ", ," ","101","CA0001 03 06","CA9903 07 97","CA2117 12 93","CA2171 01 88","CA9916 12 93","CA0126 03 01","CA2116 07 04"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ", ," "," "
"50C000737",10,"06/17/2006","06/17/2007","DAVID J WOOD",20," "," "," ","NAS-00737","1",1000000,1507,"2", ,"PEDESTRIAN", ," "," ", ," ", , , ," ", , ," ", ," ", ,"5",1000000,118," ", , ," ", , ,"7",250,111," ", , ,"7",500,422," ", , ," ", ," ",2158,"NJ","IF ANY","1.0","1.0",80," "," "," "," ", ," "," "," "," ", ,80, ," "," ", , ," "," ", , ," "," ", ,0,10,"111", ," ", ," ", ," ","111","CA0001 03 06","CA9903 03 06","CA2117 12 93","CA2171 01 88","CA0184 09 95","CA0188 03 99","CA2114 01 04","CA2230 11 04","CA2231 02 97"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ", ," "," "
"50C0002518",04,"12/10/2005","12/10/2006","GLASS MASTERS  BOATWORKS",20," "," ","CORPORATION","NAS-02518","8,9",300000,145," ", ," ", ," "," ", ," ", , , ," ", , ," ", ," ", ," ", , ," ", , ," ", , ," ", , ," ", , ," ", , ," ", , ," ", ," ",145,"MD","IF ANY","1.0","1.0",61," "," "," "," ", ," "," "," "," ", ,61, ," "," ", , ," "," ", , ," "," ", ,0,10,"84", ," ", ," ", ," ","84","CA0001 03 06","CA9903 03 06","CA2117 12 93","CA2171 01 88","CA0170 10 01","CA0215 11 00","CA2113 04 01","CA2219 01 02","PA0216 11 00"," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ", ," "," "

Thanks Hammer! I get a kick out of your description "Easy as pie!" you are talking to someone that burns toast...in a figurative manner of course... 
Again...many thanks...
Cliff

I really do thank you very much...this is such a help to me as I was facing the "opportunity" to manually parse this data twice...once for testing and then again for production...

Again...thank you!

Cliff

Hello Erika,

that is fantastically and brilliantly at the same time.
Thanks for these contribution.

Dr.. Belhareth

Cliff wrote on Feb 17^th, 2008 at 8:48pm:

I'm not sure what you're asking me to do, but if you want to email me (erika@hammerdata.com) or PM me we can can talk about it.

Let's start from the beginning. You should not be "importing" any data.

Yes or No. Did you add the line I gave you to the top of your text file?

OK. So far, so good.

What is the name of your main database?

Make a backup of policy.

Open xauto.
Retrieve all the records.
Mass update the records in xauto using the Mass Update I gave you.

Note that you cannot just paste it in and run it. You need to update it to match your database, form and element names. Your database is Policy, not Target. I only put in the first five as an example. You need to use more than the first five values and your element names are probably not Info1, etc. I can't tell you exactly what to type because I don't know which values from your text file go into which elements on your Policy form.

You also need to change the include path to one that is more likely to match yours.

#include "sbasic_include.sbas"

Hi Hammer:
Well...
Follows is the first few lines of the modified code you gave me:
#include "C:\Sesame2\sbasic_include.sbas"

var vRS as Int

     // Open a result set with the matching record in the target database
     vRS = @XResultSetSearch("policy.db", "Target", SEARCH_MODE_AND, SEARCH_SYNTAX_QA, "!Key=" + ASCII0000)
     If vRS > -1
     {
           // Make sure there is exactly one matching record
           If @XResultSetTotal(vRS) = 1
           {
                 // Update the values
                 XResultSetValue(vRS, "A1", ASCII0001)
                 XResultSetValue(vRS, "A2", ASCII0002)
                 XResultSetValue(vRS, "A3", ASCII0003)
                 XResultSetValue(vRS, "A4", ASCII0004)

All fields are completey synchronized (there are actually 95 of them).
I paste the code in the program editor in the ASCII0000 spec (the only one that shows in  the program editor other than GLOBAL CODE) and then click test.

When I do I receive an error that would probably be best sent as an image, if you click this link:

http://www.paracomm.net/Capture.JPG

You will see that the error is related to line 13 which is this line: (XResultSetValue(vRS, "A1", ASCII0001))

Dutifully, I have tried a number of things not the least of which was to fine comb the auto database files several times.

As always...any and all help is very much appreciated.

Thanks...

Cliff

Worked through the last...by adding quotes around the "ASCII0001...2...3...4" portions of the script.
Was able to run the script...
However...
Received numberous Error: Unable to open result set for + ASCII0000 errors but was able to export the data after the fact...
Exported data shows no change subsequent running the script...

workin' at it...

Cliff

Thanks...
Re: first few lines
#include "C:\Sesame2\sbasic_include.sbas"

var vRS as Int

     // Open a result set with the matching record in the target database
vRS = @XResultSetSearch("policy.db", "Target", SEARCH_MODE_AND, SEARCH_SYNTAX_QA, "!Key=" + ASCII0000)
If vRS > -1
{
           // Make sure there is exactly one matching record
If @XResultSetTotal(vRS) = 1
{
                 // Update the values
XResultSetValue(vRS, "A1", "ASCII0001")
XResultSetValue(vRS, "A2", "ASCII0002")

My primary database is policy...so I am taking it that "Target" should be the database name that I am running the script in? ie., xauto.db

As shown here I have ascii0001 associated with the element "a1" in the xauto database...
The very first LE in xauto is the policy number which I am assuming is the "key" by which we are syncing these two db's with and it would be ascii0000

Tx...cN

This line will not work as written. Your database is not named Target. The field in your database that matches is probably not named Key.
vRS = @XResultSetSearch("policy.db", "Target", SEARCH_MODE_AND, SEARCH_SYNTAX_QA, "!Key=" + ASCII0000)

To find the right names:
1. Open Policy.db in Designer. 
2. Open the Policy Form.
3. In the Property Viewer, from the View Setting For dropdown, select Database. The Database Name is what you want in place of "Target" as the second argument.
4. Click on the element on the form which has the matching key value.
5. In the Property Viewer, from the View Setting For dropdown, select Selected Elements. Click the Other tab. The Bound To is what you want in place of "!Key" in the last argument.

Fix that line and post it here. If it looks right, then I'll tell you what to do next.