FileMaker Pro Developer - External Data Filtering and XML Generation

**Project Overview:** We are looking for an experienced FileMaker Pro Solution Developer to create a custom FileMaker solution that will filter job data from an external data source and generate XML files following a specific XML format. This solution will help streamline our workflow by automating the process of creating XML files for our manufacturing system. **Key Responsibilities:** 1. **FileMaker Solution Development:** - Develop a custom FileMaker Pro solution that integrates with an external data source. - Design a user-friendly interface for data input and management. 2. **External Data Integration:** - Establish a connection to the external data source (e.g., a database, CSV file, or API) to retrieve job data. - Implement data retrieval and update processes to ensure the FileMaker database reflects the latest job information. 3. **XML Generation:** - Create XML files based on a specific XML format for each job entry in the FileMaker database. - Populate XML elements with relevant job data, including job name, material, dimensions, quantities, precision values, and other attributes (as defined in the XML format). 4. **Local Folder Storage:** - Configure the solution to save the generated XML files to a local folder on the FileMaker server or user's computer. 5. **Data Filtering and Sorting:** - Implement filters and sorting options within the FileMaker solution to easily locate and manage job data. 6. **Error Handling:** - Implement error handling and validation to ensure data accuracy and robustness. **Requirements:** - Proven experience in FileMaker Pro solution development. - Familiarity with XML file generation and parsing in FileMaker. - Strong understanding of data integration with external sources. - Proficiency in creating user-friendly FileMaker layouts and scripts. - Excellent problem-solving and debugging skills. - Attention to detail to ensure the generated XML files adhere to the XML format. **Deliverables:** - A fully functional FileMaker Pro solution that filters job data from an external source. - XML files generated according to the specific XML format. **Real Examples of the XML:** Here are real examples of the XML format based on the provided information: Example 1: ```xml <?xml version="1.0" encoding="UTF-8"?> <CustomXML CreatedBy="YourSystem" CreatedOn="2023-08-31T15:30:00"> <Jobs> <Job> <JobName>SO230728002</JobName> <MaterialName>COLORBOND Steel</MaterialName> <MaterialThickness>0.55</MaterialThickness> <Sheets> <Sheet> <Width PrecisionPlus="5" PrecisionMinus="5">105</Width> <Height PrecisionPlus="0" PrecisionMinus="0">2000</Height> <Quantity>1</Quantity> <KeepOrientation>false</KeepOrientation> <BarCode>2020100238458</BarCode> </Sheet> </Sheets> </Job> </Jobs> </CustomXML> ``` Example 2 (Multiple Sheets): ```xml <?xml version="1.0" encoding="UTF-8"?> <CustomXML CreatedBy="YourSystem" CreatedOn="2023-08-31T15:30:00"> <Jobs> <Job> <JobName>SO230728002</JobName> <MaterialName>COLORBOND Steel</MaterialName> <MaterialThickness>0.55</MaterialThickness> <Sheets> <Sheet> <Width PrecisionPlus="5" PrecisionMinus="5">105</Width> <Height PrecisionPlus="0" PrecisionMinus="0">2000</Height> <Quantity>1</Quantity> <KeepOrientation>false</KeepOrientation> <BarCode>2020100238458</BarCode> </Sheet> <!-- Add more <Sheet> elements for additional sheets --> </Sheets> </Job> </Jobs> </CustomXML> ``` **Timeline:** We are looking for a prompt delivery of the FileMaker solution. The project timeline can be discussed and agreed upon based on the developer's availability and estimated project complexity. **Budget:** Please provide your estimated budget for this project. **Application Process:** Interested candidates are requested to submit their proposals outlining their experience, approach to the project, and estimated timeline and budget. Additionally, please include any relevant examples of past FileMaker projects you have completed. Thank you for considering this project. We look forward to collaborating with a skilled FileMaker Pro Solution Developer to enhance our workflow efficiency.