Jump to content
Macro Express Forums

Metroscan


conniek
 Share

Recommended Posts

Metroscan is one of the most used programs that title companies use. It is a database of real property for different counties in the US. It tells ownerships, property characteristics, sales history etc etc. What I'm trying to do is export all the property owners from one county and export than as a dbf or text file. One drawback is that you can only export 5000 properties at a time. So I'm using macro express to export the properties without a human being watching to make sure when the export is done and go one to the next 5000.... i was able to get the # of records but now i'm stuck on this:

 

LET say I have 500,000 records with the criterias I entered -- how do I tell Macro Express to Divide the 500,000 by 5000 so I can get the # of files we will be exporting??

Link to comment
Share on other sites

Hello conniek!

 

Well, let's say that variable %N1% contains 500,000 then you would use the Variable Modify Integer command like so:

Variable Modify Integer: %N2% = %N1% / 5000

Is this what you are asking?

 

Also, I am curious; is this Metroscan software using Visual Foxpro databases? I ask because you designated .dbf as the database extension.

Link to comment
Share on other sites

:D Thanks for the help -- after writing the post i did figure out the variable modify. I'm not too sure what Metroscan is using as their language builder but dbf is one of the export type available. Metroscan also uses as a default the export type sdf which is really a txt

 

I did run across another obstacle yesterday though but i'll have to post it later

 

Connie K.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...