Necesitamos leer un fichero CSV hasta el final. De este fichero sacaremos el campo clave para buscar en mysql y el dato para actualizar el registro. En mysql utilizaremos dos tablas. En la primera localizaremos el campo clave de la segunda, y en la segunda actualizaremos el registro con los datos obtenidos del fichero CSV. Necesitamos crear un log
Deseamos extraer de Amazon una sub-categoria de artículos PRIME (ej: hornos microondas) y poder verla en excel incluyendo estos campos: ASIN, nombre del producto, precio y enlace web de las fotos. Si puedes hacerlo indicame tus honorarios para conocer la respuesta. Gracias
La tienda esta funcionando y tiene los productos listados. Necesitamos un módulo para actualizar precios/descripciones desde un CSV 1- Importar manualmente el CSV del proveedor. 2- Cambiar los precios que hayan variado. Si un producto de la tienda tiene descuento, el descuento debe de quedar como está. 3- Si el producto en la tienda no tiene oferta
...una buena pagina, es importar correctamente archivos de productos .csv que me facilitan mis proveedores/mayoristas para que aparezcan perfectamente en mi tienda online. Tambien me interesa bastante volcar estos productos a una cuenta de Ebay, o bien directamente con los archivos .csv o volcados desde mi pagina web. Por favor necesito a un buen profesional
Sería importar categorías, subcategorías y productos en una tienda Prestashop (está vacía). Los archivos .csv (familias y productos) me los han enviado mi proveedor. No habría que hacer nada más puesto que la tienda está ya operativa. Sería dejarla cargada con los archivos que facilito. Gracias.
I ne...to sort out my excel spreadsheet into multiple CSV files there around 2500 lines in total to be organised. There are 6 months worth of transactions I need to organise for my business. I need you to organise them into GROSS & FEE spreadsheets and as a separate spreadsheet for each month. So there will be 12 spreadsheets in CSV format in total.
Wir betreiben ein Portal (noch in der Entwicklung) und wir suchen für eine Import-Funktion von Daten aus xls oder csv in die Datenbank unter Wordpress einen Programmierer. Es gibt einen Code, der jedoch eingeschränkt funktioniert und dieser muss verbessert oder neu geschrieben werden. Es sollen mehrere Zeilen mittels eines Imports in die Datenbank kopiert
...functions/purposes (Don't want big company apps) - Between 40-400 reviews - Does not have many clones & competitor apps As you find these apps, you will add them to a spreadsheet/.csv file. ----------------------- Please answer these questions: 1. Search the Apple or Google App Store & tell me 2 apps that are popular, but do not have other apps that
I have over 4,000 PDF files that are all in the same format. I have to get certain data from each PDF and put into a row in a csv file. The data is on the 2nd page, and always in the same position within the PDFs. I am looking for someone who can do this within 72 hours. I can provide the sample PDF to interested freelancers. Please indicate
* Data entry of 1500- 2000 receipts converted from JPEG to a CSV/excel format spread sheet. The spreadsheet has 4 data fields- "Date, Vendor, Amount, & Location. * Suitable candidate- 1. Must have fast, accurate, data entry experience. 2. familiarity with spreadsheet software. SEE related project file for an example of a receipt. Please reply with
...to be able to make an offer for the end-customer. This software would have two inputs: 1. Customer's request with the stated name of the item and its quantity (In a spreadsheet, CSV file, or some other format) 2. Supplier's price list (probably in the same format as 1.) - this cannot be fixed because copper prices vary on a monthly basis. Has to be
I have downloaded scv file from google forms. UNfortunately broken and need correction before useable. Tasks which i do manually but want to apply by script. (script and incorrect file in same folder; output in same folder) 1. REPLACE NEW DELIMITER CHARACTER THAT MIGHT BE IN TEXT: "§" by "+" 2. REPLACE delimiter character "," by "§" 3. R...
Goal: Generate the CSV file from Excel spreadsheet according to template (order and default values of the columns). Formulas are converted into the values. Milestones: 1. Generate CSV (with ‘;’ as separator) from current Excel data-sheet (formulas are converted into the values) - Verify if the rows have the same value in a certain field (aggregation
We have a source spreadsheet (see attached) that will need a backed database (MSSQL preferred as we already have licensing) with a web front-end for data entry, editing, and reporting/exporting as csv or xls for adding to an internal report. If there is a native Office365 app that this can be done with we would like to discuss. Table column description
...have many CSV files in a folder on my desktop. I want to create a giant CSV file out of it, which technically is a compilation of all data into a single spreadsheet. So, CSV1 will have 100 rows and CSV2 file has 200 rows. I want an Excel Macro, which will take CSV1.csv and CSV2.csv files (which are in the same folder), and creates another CSV file, whic...
Need someone to write a google apps script in google sheets to take contents from 2 different format email (6 emails per day) and put these into one spreadsheet per day in a consistent data format (matching columns and rows to header titles). We are familiar with placing the triggers in Sheets for a Script but need google script code to take contents
I have a spreadsheet CSV file with 132 domains that I need the Domain & Page Authority for as well as the estimated market value for each domain.
Using PHP parse a csv file and prepare to insert into a mysql database table with the same fields as outlined in the attached Excel spreadsheet tab 1. The CSV file will identical to tab 1 of the attached Excel file. In the attached Excel file I need a new row created where the field has a delimiter of ; the fields that contain this delimiter are qty
...of billing and to generate invoices. My suppliers send me invoices in PDF, CSV, excel and doc format. Presently I take data from these invoices manually and then paste it into my billing spreadsheets. I would like to automate this manual process so that an Excel spreadsheet is updated from taking the relevant data from pdf/excel files stored in different
Download CSV from external url using login credential (user and password) to save file in specific folder Budget: $2 per hour to start with this task and some other task related with project.
I have a spreadsheet of products, with their variables. Each variable option has a unique price. I need this data taken and entered into Opencart, be it via CSV upload or manual data. Please, PLEASE only reply if you know how to do this as I don't have the time, or patience for people who say then can do it, but they can't. Already had this issue 3
...properties for purchase - no ecommere transaction - stage 1 1B) Properties can be uploaded using CSV file (spreadsheet) - stage 1 FUNCTION 2 2A) List real estate properties for auction platform - ecommerce - stage 2 2B) Properties can be uploaded using CSV file - stage 2 2C) Possible integration with one of these auction platforms - Auction Zip, Proxibid
...is returned I will provide the following: - PHP file of current working iteration - Link to online version - Create table SQL script - CSV extract of dataset - Spreadsheet detailing each bug and task (spreadsheet will include previous bug history)...
Hi, I need to download a lot of articles from Factiva to an excel format (like shown in t...an excel format (like shown in the picture below). Is this something you could help with? [iniciar sesión para ver URL]
...threshold as well as rest and recovery rates and times to comply with California labor law. I have an existing excel spreadsheet, which is clunky, but works and I need a better ongoing workflow. The output will include a data batch grid (CSV) that can be imported to ADP as well as paystub detail reports that I will distribute to staff as pdfs. 30 - 45
Hello, 3 files need to be converted to VERIFIABLE and APPROVED XML sitemaps. CSV contains list of URL's x 3 files in total. Must be done within 1 hour.
trying to download item listing content from one online store into csv format. Would need item name, description, and image link
Hi, I want to automate data entry into my online database and for that purpose I need to have imacros configured. Around 10 fields need to be populated from excel to database automatically. I need to be done asap.
...my spreadsheet on models. It will tell me which new models were added (i.e. not in my spreadsheet) and which have been removed. Along with that for each model i need data (as sent in screenshot) for each model in csv format so i can easily add in my spreadsheet Obviously, on day one, it will extract each and every model as my current spreadsheet will
I need a bot making that will input data from a spreadsheet into Etsy and make listings. A video of the Etsy screen has been attached so you can see how it works. Below are the fields that need to be entered and where the data will come from. Photos URL's will be provided Title From sheet About this listing Default values Category From sheet -
Have an excel/csv file with about 3600 products. I am using a column from this spreadsheet (based on part #) which combines the two files giving me the part numbers description and price and other things. However, when I merge them in R, I get alot of duplicates for each Part # (as I have several vendors). I need to filter this by some method
...Inventory Listing Expert > Should be fully familiar using Amazon Seller Central Flat Files for making inventory live for selling. > Full content is provided as excel sheets/csv formats > More than 15,000 SKUs to be listed as per listing procedure, and format to ensure the products go live with the CORRECT optimisation features with Correct Amazon Browser
I would hire an expert WP TPL developer who could make a Template with Dynamic update of elements from an external Google Drive Spreadsheet, or uploaded CSV file. The site design is not complicated. The design and CSS should be appropriate to this: <a href="[iniciar sesión para ver URL]"></a> Please note this is a startup
...the following created: 1. In a private page, I need a file uploader where I can import a CSV file, then click ok. It then provides a confirmation if succesful or if it has failed. 2. In the [iniciar sesión para ver URL] I need code created to allow the page to import a CSV of users into Wordpress as a bulk import. 3. The new users once created need to be sent an
...from a combination from supplied information and market research. 5. Products will need to follow proper ecommerce catalog logic. 6. You will enter the products into a CSV/Excel spreadsheet (stage 1), we will load your work into the catalog master database, you will load the product picture with the right specifications in an Amazon S3 Folder for automatic
We are converting our alumni directory over to a digital excel spreadsheet for use in email and direct mail fundraising. We will provide a PDF file and need it converted to an Excel file in CSV format for loading it into our email and label lists. I will provide the 150 2 side sheets in PDF form or another if you know better. I'm including a sample
... the second is when I upload data to a table it no longer anchors with the table. so when I go to mysql workbench and I load a table, I then want to import data from a spreadsheet. however the import of data doesn't realize I importing to a specific table I go into workbench schemas pull up the table. the second issue has existed with the migration
Use Python3 libraries:- Regex, Pandas, CSV to write a python script to format the attached spreadsheet and import it into a Dataframe in Pandas. So the data in column D or J will be edited using RE to populate Columns, K, L, M, N. ie for instance. CatCode 1. Pack will be 10, Size will 20, Unit will be "s". CatCode 2. Row 63. Pack will be 5
Need a detail oriented individual to take an inventory of approximately 300 eCommerce products and enter them into a “Shopify friendly” spreadsheet (CSV) for import. All product info, variants and categories will be provided. The final product needs to be able to be seamlessly imported into Shopify upon completion.
I need a script to import every day a .csv file from URL into my Google Spreadsheet. The conditions is; every day, import it automatically at 09.00am (for instance) only the last 7 days. But in my sheet I keep all my historical data in a daily basis. So the script has to import the data starting in the correct field due the date range. Example URL
I am currently trying to set up a store to provide corporate clothing to industrial businesses. I have a csv data file which I received from a large distributor that has nearly 99k rows for products and related product info although each product has size and colour variations. I would like to import these products into my store and need help in regards
...Functionality: The Administrator user will provide data for upload in a .CSV file. The Administrator has all of the data in an Excel spreadsheet and will continue to manage it locally. The UGR algorithm is calculated in the spreadsheet as well. The Administrator will just export the spreadsheet to CSV and then upload it into the website’s database via a...
...TODAY...Hi, I have an excel spreadsheet with approximately 7,500 lines of data. I need it separated into different files with a maximum of 100 lines of data per file. The reason is the software I am uploading the data into can only take 100 lines per file. Therefore, we will end up with 75 separate spreadsheets (saved as .csv). First it needs to be sorted