Find Jobs
Hire Freelancers

Filemaker Pro Script problem

£18-36 GBP / hour

Selesai
Disiarkan sekitar 10 tahun yang lalu

£18-36 GBP / hour

Trying to fix a script which will allow me to combine or merge two inventory files together to provide one consolidated Master file. Both files contain the same matching database fields. The files contain matching data entries containing different inventory values as well as unique data entries with inventory values. Where there are matches then the inventory values need to be shown individually together with a total field of the two values. As you can see we have pulled all this together using the master 'wholesale' file which pulls in data from the two individual stock files via an interim SKU Generator file which first identifies and deletes any duplicates. The only problem we have is that the stock values are not importing correctly - for example taking SKU 450367105 the individual values on the UK file are S-3 L-1 XL-3 and on DE XL-1 but the total combined stock on the _Wholesale file reads S-2 L-2 XL-2. We can't seem to fix this.
ID Projek: 5829181

Tentang projek

3 cadangan
Projek jarak jauh
Aktif 10 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
Dianugerahkan kepada:
Avatar Pengguna
Thank you for posting this project on Freelancer. And thanks for providing the files, so that I could check and test them. I can do the job in one hour, today, if my bid sounds good to you. Happy Easter! Alex Barattieri
£35 GBP dalam 1 hari
4.9 (18 ulasan)
5.9
5.9
3 pekerja bebas membida secara purata £32 GBP/jam untuk pekerjaan ini
Avatar Pengguna
Hi, There is an error when importing the DE data (the columns names don't match). And also when eliminating the duplicates, the script just eliminate the second entry, doesn't summarize the inventory and availability values. It could be fixed in a couple of hours of work. Feel free to ask further information. Kind regards, Mike
£40 GBP dalam 5 hari
5.0 (1 ulasan)
4.3
4.3

Tentang klien

Bendera UNITED KINGDOM
Chagford, United Kingdom
5.0
6
Kaedah pembayaran disahkan
Ahli sejak Nov 5, 2012

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.