prissypan Posted April 20, 2004 Share Posted April 20, 2004 Hi guys.. is it possible for the export function to export records individually and also ensure tht importing back of records is done as easily? I've tried exporting my records in CSV format and it looks pretty messy when i open it up using wordpad. When i try to import back into my application the fields got all mixed up. Any suggestions on how i can improve on the exporting? Thanks FileMaker Version: 6 Platform: Windows 95/98 Link to comment Share on other sites More sharing options...
cjaeger Posted April 20, 2004 Share Posted April 20, 2004 do a tab-delimited export &open with excel. that way you cannot mix up field delimiters. Link to comment Share on other sites More sharing options...
Reed Posted April 20, 2004 Share Posted April 20, 2004 Do you want to just export a single record? Just have that record be the only one in the found set when you export. Navigate to the Record Show All Records Omit Record Show Omitted Export You must specify both the export and import order. (They must be the same if importing into the same database.) You cannot specify field names when exporting to CSV.... if you use XML you can preserve field names in the exported text. Does this answer your question? Link to comment Share on other sites More sharing options...
prissypan Posted April 20, 2004 Author Share Posted April 20, 2004 thanks for your replies cjaeger n reed.. Reed, i tink i can work on the method you've mentioned but is there a simpler way, like for example if i have a list of found set, is it possible for me to program it in such a way whereby all the records in the list are saved as an individual CSV file with the fieldname as the file name? Link to comment Share on other sites More sharing options...
Reed Posted April 20, 2004 Share Posted April 20, 2004 You can write a looping script to export each file and rename it dynamically. The looping script part is easy. The dynamic renaming is a bit harder. I use a mac so it is relatively easy to use applescript to rename files using field values. I am guessing one could do the same with the send message script step in windows.... maybe someone else can help you write one. Otherwise you can download the demo of the Troi file plugin, or CNS saveit plugin or......etc. Link to comment Share on other sites More sharing options...
prissypan Posted April 21, 2004 Author Share Posted April 21, 2004 okie.. Btw any idea how i can prevent that loud prompt from occuring when i cancel my export script? Link to comment Share on other sites More sharing options...
Reed Posted April 21, 2004 Share Posted April 21, 2004 Maybe, using the set error capture [on] script step Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7310 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now