Multiple posts

[lkatz1]

We have a whole bunch of DBF files which we wanted to post into a master database is there any fast way without having to re-create a post operation for each individual dBase file ?
also, is there any way to look at the files while creating the post because they don't have the same field names?

[Tom Cone Jr]

Re: Multiple posts

David, I don't understand. Typically one does not "post" files into a "database". Are you talking about "appending" records to a "table"? "Posting" field values to a "table"? or something else?

[lkatz1]

Re: Multiple posts

Posting fields
example posting firstnames from 10 databases to 1 master database

[Tom Cone Jr]

Re: Multiple posts

database?

post?

Sorry to be so dense. Maybe an example would help.

A post is different from an append.

A table is different from a database.

An example will help us understand what you are trying to say.

[lkatz1]

Re: Multiple posts

here is the file we would like to have 10 files posted to the master sample upper file

[Tom Cone Jr]

Re: Multiple posts

Sorry, still don't understand. Maybe someone else can help. -- tom

[Stan Mathews]

Re: Multiple posts

David,

There is no expense involved in giving us a detailed explanation of what you want to do. You also need to consider Alpha terminology.

For Alpha a post operation takes information from one table and places it in records in another table for those records with some matching link value.

An append operation takes records from one table and adds them to another table. The append can add all records or just records where a value in a designated field doesn't exist in a matching field in the table being added to. It can also overwrite records in the table being added to.

You say you want to post records from ten tables to one master table but that doesn't make sense to us. How would you know whether a value posted on one operation wasn't overwritten by the next operation?

Wanting to append records from ten tables to one master table seems more likely. You cannot design one append operation and use it on ten differently named tables with differently named fields.

Have you considered renaming the fields in all ten tables to be the same? Is this a one time process or will it be repeated periodically?

[lkatz1]

Re: Multiple posts

looking at sample upper there is a post command with a name (last)which posts
replace the title and first names from the file F:\all new\Mon101203.Dbf we have 10 files similar to F:\all new\Mon101203.Dbf which we want to run the procedure without having to modify field by field by changing the 3 column in the expression group

[Stan Mathews]

Re: Multiple posts

we want to run the procedure without having to modify field by field by changing the 3 column in the expression group

No, you can't.

[lkatz1]

Re: Multiple posts

after renaming the fields in all ten tables to be the same name would there be a simple script to run one file after the other one post after the other without having to manually change the expression just by inputting only the *.dbf name

[Stan Mathews]

Re: Multiple posts

Running this script will ask you to locate the file to be posted from and then it will perform the post.

rslt = ui_get_file("Open Table to Post", "Table(*.DBF)", "","X")
tblnm = file.filename_parse(rslt,"n")

a_tbl = table.open("sample upper")
post.t_db = rslt
post.m_key = "left(Last,5)+left(Add,6)"
post.t_key = "left(Last,5)+left(Add,6)"
post.m_filter = "Title=\"\""
post.t_filter = ""
post.m_count = 2
post.m_field1 = "TITLE"
post.m_exp1 = "@"+tblnm+"->Title"
post.m_field2 = "FIRST"
post.m_exp2 = "@"+tblnm+"->First"
post.t_count = 0

a_tbl.post()
a_tbl.close()