Jump to content

auto populate fields


Robert Moran
 Share

This topic is 4323 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a database that works without issue but I need to export content to an ancient legacy system. I need to completely populate a set of fields with placeholder info. (i.e.0, \0 null) that people can overwrite with relevant content to any given part of the field set before sending the export file to the dinosaur. All the fields must be populated to begin with but I don't know the best way to do this. Any help on this would be terrific.

Link to comment
Share on other sites

The system has to have all the fields populated as the legacy system I am addressing uses delimiters and the fields have to have content in them in order for the delimiter to properly separate the fields. From there, people will make changes to some of the fields as very rarely are all the fields filled with relevant data, hence, folks will overwrite some of the place holder data with relevant content prior to exporting the set to the dinosaur. The export part works without a problem, it's the auto population part that's the gotcha.

Thanks for responding

Best

Bob Moran

Link to comment
Share on other sites

Am I understanding correctly that you want to populate the fields in your Filemaker solution with some initial values - and only then will users enter the real values? I don't think that would be a good approach, on many counts. It would be much better to focus on the export part, and leave the solution to function normally. What is the exact output format required?

Link to comment
Share on other sites

It's just a tab.txt file with fields separated by a dilimiter like a "|". That's it. The export works when content is in the field like Fred|Jones| etc etc.,etc.,etc. If there is a way to put info into the export, that would be great as the db itself runs perfectly and needs no change on the logic side whatsoever.

Thanks again,

Bob Moran

Link to comment
Share on other sites

If there is a way to put info into the export, that would be great

Two ways, actually. The best option is to export as XML and use a custom XSLT stylesheet to transform the output. I believe there are examples on this forum that are very similar to this.

The other way is to define a calculation field that concatenates all fields (delimited by "|"). Then export this field only as tab-delimited (this assumes records are still return-delimited).

Link to comment
Share on other sites

This topic is 4323 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.