Hi,

I have started another string because no-one noticed that I had come back to you.Below is a copy of my original question:

The problem is that I have imported some Excel files in delimited text format using the Import ASCII facility. I have only 2/3 of the information I need in an OI table as although I treated all three excel files in the same way (as they were all part of the same timetable) I get this message on the third one which tells me there are 'no files to import'. This is a mystery.

I have the feilds set up in the corresponding part of Table Builder but I don't know what to do next. I need to be able to query the tables and put in hyperlinks when the results come up. At the moment

nothing happens at all. A further problem is the excel files are in czech. I have changed their feild headings in excel to english so they match those in Table Builder before importing them but this could possibly be causing a problem.

What I want to know now is, supposing I iron out the bugs when importing the data, what do I do next? What do I do after I have the feilds set up in table builder? How do I link them together and then what do I do to get some results from queries?

Thanks a lot,

Ben

Ben,

My response to your original note was …

]]All things being equal .. things should be working. But as we all know things are very seldom equal.

]]Have you tried importing the 3rd batch into a different table? Does that work?

Your reply to my post was

]]Supposing I get the information imported successfully, what do I do after I have the feilds set up in table builder? How do I link them together and then what do I do?

Now you are starting a new post of the original message.

Back to your original question. Did you ever try importing the 3rd batch into a separate file? What were the results.

As for your second question .. Once the data is in and you have built the dictionarys .. do what ever you want. There is no 'linking' of dictionary to data. That is all automatic. If you want to 'link' one table to another (as in relational) then use Symbolic/Calculated fields for that.

dsig@teleport.com onmouseover=window.status=imagine … ;return(true)"

David Tod Sigafoos ~ SigSolutions

Cell: 503-341-2983

dsig@teleport.com

Hi,

Still got problems with both points one and two.

1. When I try to import the files to a new table name I get the

message 'The (new table name)table is not availiable'. The data does not import.

2.So can I make a form which will query the data as it is? How do I do this? How would the data be display? Can I put dynamic hyperlinks into the data display and publish the whole thing on the net? How do I do this?

Ben.

Have you considered reading the manuals and then asking questions?

Ben,

I tried to suggest this to you before that you could establish a DDE link to your excel data and interface to the data in place. I realize you were talking about importing dictionary stuff into the Table Builder to create new OI files, so my comments might not have hit your point. And doing it with ASCII import is fine, as the messages from DSig have suggested. However, if your actual data is also in excel or other ODBC software then you would probably be better off using the Client/Server Connectivity features in OI. They are discussed in Chapter 5 of the Applications Development Manual.

As for creating a web page this is also straight forward. You can publish the forms in Form Design ( See File Options) Note that you also have to be concerned with events. For example see the QuickEvent Options in Quick Events. Also some form control types such as EditTables and GroupBoxes will not convert to HMTL and you have to build them yourself by another means in OI.

I do agree with Jane about researching this stuff first, but the manuals are lacking in many areas and if you are new, as I am, then it is difficult to pick up some concepts because of the terminology and learning curve. Once someone shows it to you then you got it. You might consider taking the Advanced OI class taught by WinWin. I think it would help you alot, particularly in the areas you have been asking about. If you can't get to the states for these classes then you consider hiring a consultant such as DSig or WinWin to help you (even if just on the phone) with your questions.

Good Luck

1. When I try to import the files to a new table name I get the message 'The (new table name)table is not availiable'. The data does not import.

You must first create the table and define the columns. Remember that OI requires a primary unique key per row, even if it is a sequential counter. I've just checked the "Getting Started" manual - something I haven't done in a long time, and it doesn't actually mention creating tables. Perhaps the "Guide to Applications Development"?

2.So can I make a form which will query the data as it is? How do I do this? How would the data be display? Can I put dynamic hyperlinks into the data display and publish the whole thing on the net? How do I do this?

Once the data is in and you have a dictionary established you can use the form designer to make a form which looks at the data. As there is a unique primary key, once the user types this in the form will populate. The skill lies in making it easdy for the user to find the unique primary key!

As for Web publishing, there is a good section on this in the manuals but your questions are a little too broad in scope to be adequately addressed in public fora. Essentially you're asking for an on-line training course!

Are you in any way connected with the Czech Coal Mining Industry with whom we're currently dealing?

Regards

amcauley@sprezzatura.com

Sprezzatura Group

World Leaders in all things RevSoft

Thanks everyone (even Jane) for your help.

I'm not part of the Czech Mining Corp. but I suffer from similar problems I would imagine they do, most manuals in Czech etc.

You have given me a few new alleys to work down.

Thanks,

Ben

Ben,

A further problem is the excel files are in czech. I have changed their feild headings in excel to english so they match those in Table Builder before importing them but this could possibly be causing a problem.

But what about the data themselves? Do they contain any of the delimiter characters? See http://czyborra.com/charsets/iso8859.html#ISO-8859-2 FA-FF. Delimiter characters could conceivably confuse the system. I'm not sure if they could be the cause of the 'no files to import' message, but you never know. Anyway you must get rid of them before you import data into OI.

- Oystein -

View this thread on the forum...