I have a list of 3-6 thousand ISBN numbers in an excel file (or could use Access) as "ISBN,Sku1,Sku2,Sku3,title1,Title2, cost, price, weight". I have access to my distributor's inventory via FTP, formatted as comma delimited TXT. "ISBN,WHSE,QtyonHand,QtyonOrder,discountkey,listprice" There are no headers on TXT file. There may be up to 4 lines per isbn as there are 4 warehouses. TXT file may have 100k lines. I want to return my data, updated with the qtyonhand, by warehouse..."ISBN,Sku1,Sku2,Sku3,title1,Title2, cost, price, weight,discountkey,listprice,Whs1Qty,[login to view URL],Whse4Qty". I need the ability to add and delete to/from MY list.
Hello,
We can update your file using a php script that you can run when you want to update your list with information from your distributor.
The script will search for first ISBN number from your file in the data loaded from distributor csv and will and it will write all values to a new file with all information.
To remove a book it's enough to delete it from your file and the script will not search for that ISBN and will not load it into updated file.
To add you just have to add your information ("ISBN,Sku1,Sku2,Sku3,title1,Title2, cost, price, weight") and run the script, the value will be in the new file with data from distributor added.
Best Regards,
Constantin Plaiasu
$111 USD in 3 days
5.0 (2 reviews)
2.8
2.8
34 freelancers are bidding on average $139 USD for this job
Hi.. Expert Web Scraper & Data Minor here. I have done too many similar project in past. Having best scraping tools and experience i assure you 100% accurate and good quality work. I have too too scraping experience. Thanks
Hi,
I'm very interested helping you converting your text data, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating, please do not hesitate to check my portfolio, there is some samples of databases modeling and database assignments.
I've checked your requirement I can do this job in the deadline without a problem, because I've done many projects like this. Please send me all other details if you have about your project, so we can start asap. I'm available, and can start immediately. Looking forward to working with you. Thank you for your consideration. Regards
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
Hi,
I can help you on this. I have done the same job several times.
If you only want the new data in a text file, I can do it right now.
I'm not sure if you need to redo this again and then you need a script, but in this last case the bid should go a bit up as making the script takes a bit more of time.
Let me know if you need only the data or also the script.
Regards
Hello,
Interested by your project i would like to inform you that i am IT engineer , having more than 7 years in IT projects with 5 years in database development and data ETL using many tools and environments.
I am serious and professional ,i will engage myself to give you high quality of delivery.
Best Regards
Hi, Experienced dev here. I have read your project details and I'm interested in working on it. I need further detail on the data extraction process. Let me know when can we discuss ?
Hi, I can write you vba code which will read data from an excel file or text file, then customize the data and save it back to excel or text. If that is what you're essentially looking for let me know
Hello, I have been working with data extraction and manipulation for several years. I posses excellent written and verbal communication, as well as a great work ethic. I can complete this project for you with great efficiency. Would like the opportunity to help you out with your project.
I am currently emplyoed in a data management\data mining position.
Worked with Java technologies & .Net (C#)
With your help in better understanding your needs and after i will have a look on the files structure i am confident i can deliver a good result.
Good evening.
I am computer engineer, and I am able to do the task.
Need some details, more importantly if you want to work in a specific platform or it that's not important at all.
Thanks in advance.
Best regards,
João Afonso
I am a SQL and Data Expert, A Microsoft Trainer.
I would like to do this for you, frankly, to get my feet we using freelance.com.
I do this type of work every day, and will make sure you get everything you need ASAP.
Thanks,
Charlie Hyman
Hi,
I can provide you a software with user interface and abilities to add, edit, and delete records, from the database ( Access ). You can generate report either, CSV or TXT depending on how you want the report should be presented.
Kind regards,
ryugarai27