Find Jobs
Hire Freelancers

Transfer info from old to new filemaker project

€30-250 EUR

Closed
Posted about 6 years ago

€30-250 EUR

Paid on delivery
I have a contact system for my repairs. Which has all the records(contact name,device,repair details) in one table. I made a new system now and i need to trasfer them in the new system(FM 2018). I made a script to trasfer them but i have a problem with this script. It dublicates the names of the customers and in same customer i will see 2 or 50 times in the contacts table. This problem is made because in the new system (FM2018) i have 3 tables. 1 table for contacts,1 for device and 1 for repair details. I need someone to make me a script which will check if the customer name is already in database so it dont dublicate it. Also the person that will make this i will suggest it for some projects more in the new FM2018. Because the files are personal info i will send them only to the programmer which make the script. My script: Freeze Window Go to Record/Request/Page [ First ] Loop Go to Layout [ original layout ] Set Variable [ $ΟΝΟΜΑ; Value:FM Lab Experts::[login to view URL] ] Set Variable [ $ΕΠΙΘΕΤΟ; Value:FM Lab Experts::[login to view URL] ] Set Variable [ $ΕΤΑΙΡΙΑ; Value:FM Lab Experts::tetairia ] Set Variable [ $MODEL; Value:FM Lab Experts::tmodel ] Set Variable [ $SN; Value:FM Lab Experts::tsn ] Go to Object [ Object Name: "p_portal" ] Set Field [ ΠΕΛΑΤΕΣ::ΟΝΟΜΑ; $ΟΝΟΜΑ ] Set Field [ ΠΕΛΑΤΕΣ::ΕΠΙΘΕΤΟ; $ΕΠΙΘΕΤΟ ] Go to Object [ Object Name: "s_portal" ] Set Field [ ΣΥΣΚΕΥΕΣ::ΕΤΑΙΡΙΑ; $ΕΤΑΙΡΙΑ ] Set Field [ ΣΥΣΚΕΥΕΣ::MODEL; $MODEL ] Set Field [ ΣΥΣΚΕΥΕΣ::SN; $SN ] Go to Layout [ original layout ] Go to Record/Request/Page [ Next; Exit after last ] End Loop
Project ID: 16252778

About the project

13 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
13 freelancers are bidding on average €143 EUR for this job
User Avatar
I am a FileMaker developer with 5 years experience and specializing in filemaker support and outsource services I can deliver you the best results when it comes to FileMaker Projects..
€155 EUR in 3 days
5.0 (39 reviews)
7.0
7.0
User Avatar
Hello I can help you with your Lab Experts Filemaker DB. I have over 28 years extensive experience with Filemaker Pro and have developed, deployed and maintained many instances from very large and complex down through to small more simple deployments. From your project description, it sounds like you are on the right track to separate the data into different tables. This will help with scalability for the future and help your solution run faster. I have done many similar projects of migrating data from older solution into newer, normalised structures, so I am very familiar with what is required. I would not recommend using scripting methods to move the data over to the new solution, as you have experienced, it is unreliable and prone to corrupted data. If you would like to send through some additional information on your project, including which version Filemaker you are running (or plan to) and perhaps copies of the old and new databases (cloned/sanitised if required), I can review it and provide a proposal with some stages to complete the project for you. Thank you Darren
€250 EUR in 5 days
4.9 (15 reviews)
6.1
6.1
User Avatar
Greeting, I have understood your Transfer info from old to new filemaker project task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Excel, FileMaker, MySQL, PHP, Software Architecture
€180 EUR in 3 days
4.8 (21 reviews)
5.5
5.5
User Avatar
A proposal has not yet been provided
€250 EUR in 3 days
4.9 (25 reviews)
4.3
4.3
User Avatar
A proposal has not yet been provided
€66 EUR in 4 days
5.0 (2 reviews)
4.1
4.1
User Avatar
Hi, I have checked your projects descriptions so I can do that. I have 7 years+ of experience with all IT related skills which is needed for your project. I have completed lot of projects with Software architecture, Excel, Script, Filemaker, MySQL, PHP which is related to your projects descriptions. My Skills: Software architecture, Excel, C, C++ Programming, Python, Java, JavaScript, MySQL, Asterisk PBX, Metatrader, Web security, Matlab & Mathematics, Machine learning, API, HTML, PHP, .Net, Engineering. Further details will be discuss over chat, waiting your response Thanks.
€50 EUR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have gone through your project details and I assure that I can do it as i got all the skills required for this project. I have already completed a lot of similar projects in the past so it is my pleasure to work on your project. High lights of expertise are:, C , C++ Programming,, Java, JavaScript, Python, PHP, MySQL, linux, Excel, File maker, HTML, website designing and Development, Web Scraping, Software Architecture and development. You may have a look at the Portfolio section of my profile to have a look at the quality of content I provide and get a feel of it! I assure good Quality within specified deadlines, at a reasonable Price. Waiting for your Valuable Response. Regards…
€30 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
€166 EUR in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
€155 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
We can go with import option and we can avoid scripts. for duplicate validation we can play with find mode which is easy way to merge/cancel the duplicates
€155 EUR in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GREECE
larissa, Greece
5.0
1
Payment method verified
Member since Sep 15, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.