Working with the Excel tables.
22 USD Info * We Work with Prices (Torras)
Problems 2 pieces - we get the preys with a different layout of columns( it is solved ) and the "chip" problem is NOT solved
Chapes are different and take it 0 lines, 5 lines, for example, the name of the campaign logo, etc.
And then we go the necessary line Here is her task - to find the program itself.
This is done manually in the graphic window.
The program has already made us which looks at the name in the first line and then in each column there are "Name of columns" and will compare with the tags that we have set in the fault
It already works.
We need the program.
The task -
1) Find the line that is needed
2) Remove all unnecessary lines before the names of the headlines (photo, price, volume, etc.... )
- - -
Examples of work
*action - download the Ex file (price) in the folder - launch of the program
- the program takes the lines to fit the tags we assigned (the tags are already implemented)
When we find the line, we remove it and press “OK!”The program removes all lines above the line name.
–----–
Screenshot 1 example of Price - we see that our line that needs to start with 5 lines and all above needs to be removed
Screenshot 2 The program itself that selects the tables and after "OK!"They transfer places.
The left part - the tags we put
Central - We get the lines from the Excel file (if they are in the wrong order then they will be in the places)
The right side - Upper hand-down\ lift on the lines ( here we need automation ) + on the "GO " completion process ( here we need removal of all lines above the lines with names)
-
3 days22 USD
1101 63 0 2 3 days22 USD
Good day .
The exl is formed again, but in the right format?
In general, you need to see the code, but if you’re already looking for a headline to recognize the tags (and to move the columns), then I don’t have to do anything difficult, just remove all the lines to this line. and the
Go back, let us talk.
-
Понятное дело, что у вас своя кухня и вы варитесь в своем соку, но со стороны смотрю и ,извините, все таки возникает вопрос: "а зачем такой огород городить с с интерфейсами?". Ведь для распознавания и перестановки столбцов достаточно текстового файла с записанными построчно возможными эквивалентами столбцов вашего прайса. Надо будет, дополняйте сколько хотите.
К вам падает файл (в какие то папк(и/у). Пусть программа:
- смотрит постоянно эти папки и при появлении там файла открывает его,
- находит строку с заголовками столбцов ,
- переставляет их на нужные места,
- перемещает в папку выдачи куда надо, и/или включает софт дальнейшей обработке,
- аккуратненько записывает все это в журнал,
- "стоит, кричит, зовет господина и/или строчит кляузу в журнал ошибок" только в том случае если:
- файл не удалось открыть,
- не шмогла найти строку с заголовками столбцов ,
- попался не знакомый столбец.
Все. Оператор посмотрел журналы, Если все хорошо пошел на (обед). Иначе, принял меры и опять пошел.
-
Current freelance projects in the category Web Programming
Update of the one-page website for construction services
22 USD
Updating the existing one-page self-written website for construction services Task: -Redesign of the website -Adding service categories by creating a multi-landing page for 6 categories -Adding photos and descriptions of work to each category -Optimization of the website's… Web Programming ∙ 3 hours 22 minutes back ∙ 46 proposals |
Refinement of the Front-end e-commerce site on OpencartNeed to refine the front-end of an e-commerce site on OpenCart. Main tasks: fix visual bugs, ensure responsiveness for mobile devices, improve the display of product cards, categories, cart, and checkout page. Neat layout is expected, maintaining the current design, and correct… Content Management Systems, Web Programming ∙ 5 hours 11 minutes back ∙ 37 proposals |
Development of a lead collection form before program upload (MODX)
Website: bricscad-ukraine.com.uaCMS: MODXGoal: Create a lead collection mechanism before downloading software for 3 versions: Windows, MacOS, Linux from the site for further processing by the sales department. Web Programming ∙ 8 hours 40 minutes back ∙ 27 proposals |
Remove viruses from the site and update plugins (Wordpress)Need a WordPress specialist for technical refinement of the website Task: Clean the website https://www.mast-agency.com/ from viruses/malicious code, files; (there is a virus on the site that creates pages and redirects to someone else's store) Update plugins so that the… Content Management Systems, Web Programming ∙ 12 hours 12 minutes back ∙ 68 proposals |
Make sure that order emails from the store do not go to spam.Currently, there is a store on OpenCart, and order emails are landing in spam. We need to ensure they go to Inbox (ukr.net gmail) and check it. The hosting provider wrote: Poor email delivery may be related to a low sender reputation - IP or domain. In this case, we can advise… PHP, Web Programming ∙ 13 hours 16 minutes back ∙ 45 proposals |
Dnepr