There shouldn't be a problem. On my windows 7 system, I opened MS Word, entered the word "Test" and saved it as a text file with the .txt option. I then opened a .fp7 file with FIleMaker 11 and selected Import Records | File from the File menu. I was able to select for "tab separated files, .tab or .txt". I could see my newly created text file and select it for import.
Hrm. This is a script doing the import. When the file name is .txt, it bombs. change the file extension to .tab, it works fine. Very odd.
I'll check more around, but if you think of anything else, please let me know.
What does "it bombs" mean exactly?
How did you set up your import records script step? What does the file reference for the step look like?
Hrm.. it gives the error "This file could not be translated using the selected file type"
The file reference, if I understand you, is manually selected during the import script.
I'm not sure I understand what you mean by 'set up import records script step'..
The actual import step has
'run with full access privileges'
specify import order -> Char set: Windows ANSI / Arrange by 'last order' / Import action 'Add new records' and when prompted for Import Options, I've tried both 'Perform auto-enter' and not.
If you can offer any more guidance, I'd be more than happy to provide whatever info you can use. Thanks much for taking this time to help me. I've been struggling with this for many hours.
Import records can be set up a number of different ways in a script. There are numerous options you might choose and a key one is how you specify what file to import from. The script could pause and open a dialog for you to select a file, it can use data in a field to find a file and import from that file or it can be "hard wired" to a specific file and location on your computer.
I think you need to post the relative portion of your script in order to show all the options that you have selected for your import records script step.
To post a script to the forum:
- You can upload a screen shot of your script by using the Upload an Image controls located just below Post A Answer.
- You can print a script to a PDF, open the PDF and then select and copy the script as text from the opened PDF to your clipboard for pasting here. (with this approach, you can get multiple script steps on the same line, please edit the pasted text by inserting some returns to separate those steps.)
- If You have FileMaker Advanced, you can generate a database design report and copy the script as text from there.
- If you paste a text form of the script, you can use the Script Pretty box in the Known Bugs List database to paste a version that is single spaced and indented for a more professional and easier to read format.