Solved

Visual Fox Pro ???'s

Posted on 1998-10-13
1
219 Views
Last Modified: 2013-12-25
Each fall, hundredes of applications are recived from addmissions to ringling School of Art and Desing. These come via snail mail like they have for years, but increasingly students are choosing to apply over teh web. we have a nice on-line form which mimics the one in the catalog. However, we also haven't succeeded in making the information that comes in this form updatable into the databases that are currently used by the addmissions department. We need to find a way to create 'importable records' from the on-line form. What this requires is figuring out what form we can create a plain text document that will be importable into the visual fox pro that is currently used by the admissions department. make sense?
Question: Can import a plain text document with some fields named that will be read and correctly interpreted by visual fox pro??? If so, what if the specifacation of this syntax?
Thank you,
Chip Collier
0
Comment
Question by:crash020297
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 2

Accepted Solution

by:
Billy_Pilgrim earned 600 total points
ID: 1855703
Yes, you can.  Here is an example. A student enters some information, and you have a Foxpro table that looks like this with the name "Students":

Name            Country   GPA           PhoneNum
(character 30) (char 30) (numeric 5,3)  (character 20)

And the student enters the data, you save it to a text file called Student.TXT that looks like this:

"John Smith" "Germany" 3.123 "1234567890123"

In Foxpro:
USE Students
APPEND FROM Student.TXT TYPE DELIMITED WITH BLANK

That will put the data into the right fields for this student.

But, let's suppose that the "country" data piece is optional. ..

You need to leave a spacer for FoxPro so that it knows to skip that field, so your text file will look like this:

"John Smith" "" 3.123 "1234567890123"

So that FoxPro will know to skip the country field.  You don't include a line for the field names, for example:

"Name" "Country" "GPA" "PhoneNum"
"John Smith" "Germany" 3.123 "1234567890123"

when imported into FoxPro, you will get two records:

Name        Country  0      PhoneNum
John smith  Germany  3.123  1234567890123

( the "GPA" turned into a 0 because FoxPro can't assign a numeric value to the character string "GPA")

Let me know if you need more information.
0

Featured Post

Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Responsive Design or Mobile Sites? 4 37
Grunt script for Build Process 1 67
Add a loading gif while php runs server side 15 67
auto play video on web page 4 40
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Any business that wants to seriously grow needs to keep the needs and desires of an international audience of their websites in mind. Making a website friendly to international users isn’t prohibitively expensive and can provide an incredible return…
Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question