Sql insert xml tableJobb

Hej Amr S., jag la märke till din profil och skulle vilja erbjuda dig mitt projekt. Vi kan diskutera detaljerna över chatten.

...Windows-tjänst. Connectorn ska presentera en ikon i Windows statusfält. Vid klick på ikonen öppnas ett fönster med konfigurationsalternativ: • API-nyckel (sträng, max 128 tecken) • URL (sträng, max 1024 tecken) • Sökväg till Visma Administration Gemensamma filer (bläddra-knapp) • Sökväg till Visma Administration Företag (bläddra-knapp) Konfigurationen lagras på lämpligt ställe på disken, förslagsvis XML. Kommandopollning Huvudsyftet för Connectorn är att ”polla” ett REST-API efter kommandon som ska utföras mot vald Visma Administration-databas. Varje kommando ska utföras i presenterad ordning. Innan nästa kommando utförs m...

Hej! Jag behöver hjälp med att bygga ihop ett formulär som kan exportera i XML. Detta är för att sedan tillhandahålla uppgifter om företagsändringar och ombildningar mot bolagsverket. Jag har precisa instruktioner för bolagsverket kring hur det kan byggas. tack! Ludvig

Till en nygrundade företag inom social entrepreneurship behövs det skaffas en SQL databas samt back-end mask till data query och entry, och en mindre front-end sökmask. Detailerad lista på databas-råder och egenskaper såväl som mockups på aller masker finns. Webspace med möjlighet till SQL databas finns. Detta är prototyp-stadien till en större projekt och rätt programmerare kan blir anlitad även till vidare arbeten med databasen, back- och front-end maskarna, samt senare utveckling av sökmask i app-form och enkelt web-shop kopplad till databasen.

Jag behöver en databas (SQL script) som håller reda på Medlemmar och dess Vänner, samt Kontakt/Meddelanden som skickas mellan dem: - Medlemmar (Namn, Mail, Lösen, Mobilnr., inloggningssätt (Facebook, Google, ösen)) - Medlemmars olika relationer till Vänner (mobilnr., mail, namn, adress) - Tabell över kontakter/meddelanden som tagits med Vänner (GUID skapas för varje gång). - Möjligheter för Vänner att logga in med hjälp av GUID för att se meddelanden - Meddelande skall kopplas mellan Medlem och Vänner. - Medlemmarna skall kunna ha en elektronisk plånbok

...förnuvarande en hemsida med webbutik via , men vill ändra detta till en mer komplett webbutik förslagsvis via woocommerce. våran hemsida nu är: Want help setting up an online webstore in woocommerce. containing around 200 articles with different auto parts. The help is enough with to start up and post some startup products, then via mail / telefon help me to continue and insert the remaining ones myself. Also want the webshop with stock, shipping, google shopping and facebook advertising, and the language should be Swedish. We currently have a website with online store via , but want to change this to a more complete online store, preferably via woocommerce. Our website is now: www.mercaskroten.se...

Project 1av 2(sql fler fields) skickar den andra projektet under dagen Har ändrat pattern1&pattern2 columnerna i databasen till kundnr&country, id till uid, verkar fungera. Sedan har jag ändrat field1&2 till flera columner i results.html. Så här ser columerna ut i databasen. id, kundnr, country, searchstring, tiff, checked, vat_number, company_name, company_adress, invoice_date, invoice_nr, valuta, summa_netto, summa_moms, varukod, varu_underkod, sprak_kod, beskrivning, fakturatyp, skattenummer

Mac PHP Har byggt en första version av en sajt som låter användare logga in och ange/ladda upp data. PHP/Mysql är använt idag. Skulle i dagsläget behöva primärt ett bollplank kring databasstruktur och koden principiellt men även hjälp med faktisk programmering för vidareutveckling av tjänsten. säkerhetsaspekter är också viktiga i nuläget

Söker back end utvecklare med erfarenhet från skräddaranpassade CMS hemsidor. Du bör vara kunnig inom PHP, Web 2.0, XHTML, SQL, Cross-browser optimering. Utvecklingen av hemsidan bör göras med stor anpassning. Då majoriteten av publiceringen görs av redaktörer måste backend vara anpassad för exempelvis skapande av artiklar. Du kan utgå från ett open-source alternativ och vidareutveckla den enligt våra specifikationer. Integrering mellan hemsidan och databas måste göras av dig. Analytics program erfordras. Interaktion görs möjligt med commenting, threads och forum. Erfarenhet från schemaläggning av aktiviteter bör du kunna göra. Caching även. Säke...

API Koppling mellan webbshop och kassasystem. Båda har öppen API. Kassasystemet heter eskassa och deras API skall kopplas till webbshopen.

Programmering av ett Iphone och Android telefonapplikation kopplat mot telefonväxel MS SQL och winows server. Funktion och design ingår. Erfarenhet av applikation som contact center, callcenter. Samtalsstryning och design. Lång erfarenhet och stor förståelse krävs.

Programmering av ett Iphone och Android telefonapplikation kopplat mot telefonväxel MS SQL och winows server. Funktion och design ingår. Erfarenhet av applikation som contact center, callcenter. Samtalsstryning och design. Lång erfarenhet och stor förståelse krävs.

ONLY SWEDISH FREELANCERS !! LANGUAGE ISSUE Vi behöver plocka ut Xml filer enligt skatteverkets modell. Datan och alla tabeller finns redan men det är endast XML exporteringen som saknas. detta skall sedan flyttas över i en APP till android. När ni åtar er att göra detta får ni tillgång till server login och en guidning av vad / vilka kopplingar som finns. Exemplena på denna sida skall följas i den mån det går. Om det saknas fält i databasen så skall dessa göras. Slutförandet av projektet blir när ni levererar koder som vi verifierar att den fungerar och att det går att importera dessa in i Appen. (som en annan utvecklare lägger

...olika jobbannonser riktade till olika målgrupper lagrade i en databas. Vissa av dessa jobb vill vi på ett enkelt sätt kunna publicera som facebook-annonser, riktade till just rätt målgrupp (kön/ålder/region). Antingen görs projektet genom att du skriver något i Java, som lägg till som en modul i vårt befintliga system, som publicerar utvald data till Facebook. Alternativt tillhandahåller vi en xml/json-fil som löpande uppdateras med aktuella annonser, som du med någon programvara ser till publiceras till Facebook. Vilken lösning som passar bäst kan diskuteras utifrån våra önskemål och din kompetens. Har du dessutom erfarenhet av Googles Adwords-API så kan det...

Vi får in Excel-filer som vi önskar konvertera till XML för att kunna läsa in dem maskinellt i en programvara. Filen vi får in är på formen som Excelfilen som är bifogad. Den kan ha olika antal rader och alla rader skall infogas i XML-filen på formen som finns i XML-filen som är bifogad. Vissa av fälten i Excelfilen är konstanta och skall läggas i ett huvud i XML-filen medan de variabla skall läggas som datarader i XML:en på det sätt som är angivet i exemplen. Det är inte en nackdel om det går att göra detta med XSLT. I detta läget behöver fel inte hanteras. Du kommer att bli tilldelad ett Bitbucket-repository som skall användas för detta...

Skulle behöva hjälp med att implementera Unibets API - json eller xml på sidan Wordpress

I'm looking for a freelancer who's great at web scraping to help with a project involving a specific website initially, with potential for more. I'll give you the specific data fields to extract. It'd be great if you: Are really good at web scraping and or Python. Know your way around MS SQL Server databases, not essential but definately an advantage. Understand how to extract data effectively. Understand the need for security and captcha integration if needed. Can work quickly since this project is a priority and needs to be done ASAP. Ultimately, I want to be able to manage the code with your ongoing help, so this could lead to a long-term partnership. I'll share the full details when needed. You will provide source code, documentation and deployment info...

I need to scrape data from a web...a website. I'm stuck with an error. I used improtxml to scrape data from a class in a website I know. However, the fact that this website has classes has a problem: . While on page 1 there will be that text data, but on many pages, that text data is not there and it is accidentally pushed up to insert the class data below into the previous class data. To make it easier to imagine, there will be 4 rows. I will need to get a fix for each row into the google sheet. However, there are pages where I insert the link and there will be no row 3 or row 2 and then row number 4 will be inserted into row number 3, making the data incorrect. I need improxml to automatically check the syntax, if it is correct, it will be filled in and if it is wrong,...

I need a modern, eye-catching and easily recognizable logo for my brand. Key Requirements: - The logo should have a modern design that aligns with current design trends. - It should be bright and bold, delivering a fresh and dynamic feel. - The main purpose of this logo is brand identification, so it needs to be memorable and easily associated wit...with the brand. Ideal Skills and Experience: - Proven experience in designing logos for brands, with a modern and bold style. - A strong portfolio showcasing similar, successful projects. - Good understanding of branding and the ability to create a logo that conveys the essence of a brand. I am open to various creative ideas, so feel free to bring your unique perspective and expertise to the table. Looking forward to seeing the grea...

PLEASE DO NOT SEND AI DESIGNS A 2D PLAN IS A MUST Seeking a talented interior designer to create a modern and stylish residential bedroom. Key...AI DESIGNS A 2D PLAN IS A MUST Seeking a talented interior designer to create a modern and stylish residential bedroom. Key Requirements: - Proficiency in residential interior design - Strong understanding of modern design principles - Experience in creating bedroom interiors The room will have the following 1. King size bed with 2 side tables 2. Large him/her walk-in closet 3. Desser table, for him/her 4. Tv unit – to be opposite to bed Please note 1. room height is 300cm, there is a concrete slab in the middle, the height from floor is 250cm 2. the room has 3 windows, any of these windows can be canceled to make a us...

I'm in need of a proficient developer to create a comprehensive computer (in a network) probe software compatible with Windows and Linux. The software should have the following key features: 1. find systems in a network and log details to a CSV file/db table. hostname, ip addresses , mac address etc along with hard disks ,os,version etc. 2. find applications installed in the computers Ideal Skills & Experience: - Prior experience in developing network monitoring and security auditing software. - Proficiency in programming languages suitable for cross-platform development. - Strong understanding of network protocols and security standards. - Experience with compliance monitoring tools and techniques would be an added advantage. Please include re...

Required a dot net developer. Speacialized in Microservices acrhitecture based solution. Dotnet Core, C#, SQL, Data transformation, API gateway, Auth based security.

I am seeking a full stack PHP developer to assist me with my project. I'm l...you are a skilled PHP developer with experience in full stack development and are passionate about producing high-quality applications, this project is for you. Your ability to work both independently and collaboratively will be key to our success. Ideal skills and experiences include: - Proficient in PHP and related frameworks - Strong knowledge of HTML, CSS, and JavaScript - Familiarity with SQL and database management - Experience in user authentication and payment processing - Understanding of project management and problem-solving - Excellent communication and time management skills I am looking to commence this project at the earliest convenience, so please get in touch if you're avail...

I am looking for a skilled UI/UX designer to create a visually appealing, user-friendly website design. We don’t need you to develop the website just the layout and the designs. Key requirements: - Create a modern, attractive design - Prior experience in designing websites - Ability to work independently and bring creative ideas to the table - Proficient in using design tools like Adobe XD, Sketch, Figma, etc. Here are the website references - - Looking forward to seeing your portfolio and discussing further.

I have written a Python code to extract a table from an HTML file. I need an expert in Python, Pandas and BeautifulSoup4 to review and make minor adjustments as necessary. The purpose of the table extraction is for data analysis. The HTML file has multiple tables with some nested elements, not overly complex. Key Requirements: - Need an expert in Python programming - Familiarity with Pandas and Beautiful Soup - Experience in data analysis The job mainly involves reviewing the existing code, fixing any issues that may hinder the data extraction, and ensuring that the extracted table is ready for analysis. Please note that no additional data preprocessing is required, just fixing the current code. --- name "iXBRL" , inside folder contain multiple html file...

...Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word document, including text fields, dropdowns, checkboxes, addable rows table, etc. - User-Friendly Interface: Design a clean, user-friendly interface. Skills Required: - Proficiency in HTML, CSS, JavaScript, and responsive web design - Experience with web form development and validation PHP Integration (optional): - Form Data Processing: Develop a PHP script to receive the form submission and convert the data into a multidimensional array. - Da...

I'm looking for a Kickstarter expert based in Bangkok who understands the ins and outs of successfully creating a captivating campaign to raise funds for a new technology product. Your role is crucial and will involve the following: - Designing an impactful Kickstarter page that perfectly encapsulates the vision and value of the product - Cr...campaign The ideal candidate must have deep knowledge and successful experience in Kickstarter campaigns, preferably within the technology sector. Strong skills in content creation, marketing strategy, and promotion are also necessary. Be ready to share examples of past work and successes. A keen understanding of the local market will be highly beneficial. Your ability to bring creative ideas to the table and problem-solving skills will...

I'm looking for a Kickstarter expert based in Bangkok who understands the ins and outs of successfully creating a captivating campaign to raise funds for a new technology product. Your role is crucial and will involve the following: - Designing an impactful Kickstarter page that perfectly encapsulates the vision and value of the product - Cr...campaign The ideal candidate must have deep knowledge and successful experience in Kickstarter campaigns, preferably within the technology sector. Strong skills in content creation, marketing strategy, and promotion are also necessary. Be ready to share examples of past work and successes. A keen understanding of the local market will be highly beneficial. Your ability to bring creative ideas to the table and problem-solving skills will...

...hence our AI works on it through big data and automation. The project is about algorithmic auto-investing trading on world wide's financial market. Fixed Rate Job Paid based on success delivery per country. $10/country. Make about 5-10 API/country for installing python, setting SQL for our applications and Google Sheet. For each country may need API for such as : 1. Historical Data 2. Financial Scrapped Source 3. Financial Summary Scrapped Source 4. Interest rate 5. Some More Required Skill & Experience : 1. Php & SQL 2. Familiar with python installing & setting up environments 3. Experienced in Linux Debian & LNMP server by SSH 4. You need to know on how to run python scripts on debian by ssh, and setup cron task on debian, and debugging etc Perso...

I'm looking for a professional who can help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple f...help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple format for my tables, in line with a minimalist style. Ideal Freelancer: - Proficient in Excel, with a deep understanding of formula creation. - Experienced in table formatting and design, with a flair for minimalism. - Able to deliver high-quality, error-free...

I need a wizard in Microsoft Word for a particular job. The task requires fixing issues related to page numbering and the table of contents in my document. Here's what you need to do: - The documents appear to have page numbering inconsistencies which require correction. - The table of contents needs to be arranged with numerical page numbers. It is worth noting that the document does not follow any specific style guide or template. So, a general understanding of Microsoft Word formatting rules is necessary. Ideal candidates should have: - Mastery in Microsoft Word - Experience in troubleshooting and fixing Word formatting issues - Understanding of different formatting styles (although the work does not require adherence to a specific style guide) This is a quick fix...

I have initiated the drafting of my business plan and investor deck, however, I am looking for a seasoned freelance professional to take my existing work to the next level. Pa...Particularly, I am in need of assistance in the creation of compelling visual branding elements. The suitable freelancer for this task should possess: - Proficiency in creating visually appealing branding elements - Impressive portfolio in graphic design with focus on branding - An understanding of business plans and investor decks - Ability to preserve my initial concept, yet bring fresh ideas to the table Your main responsibility will be to revamp the visual aspect of my business plan while maintaining the original essence. I am open to new ideas and novel thinking. I look forward to our potential coll...

Objective of the project The goal of the project is to develop an automated system that generates high-quality content related to beauty, cosmetics, skin and hair products, and makeup. This system must: Collect content from various sources (URL, RSS, XML) configurable by a Super User. Filter and process such content using artificial intelligence (AI) to improve it. Automatically publish enhanced content to a WordPress blog and various social networks. Provide an intuitive administration panel for managing system sources and configurations. Technologies and Tools Used Backend: Django Frontend: React Database: MySQL or PostgreSQL Monitoring: Prometheus and Grafana Containers and Orchestration: Docker and Kubernetes This project is already validated by AI tools to correct errors in ...

I need a full WordPress website for my bed and breakfast. 6 PAGES 1 - home page 2 - first apartment page 3 - second apartment page 4 - third apartment page 5 - booking form 6 - contact page Insert icon with link to Facebook page on the site Visitor statistics FURTHERMORE I need an excellent positioning of the B&B on Google My site might look something like this: I will provide all text and images for the site. I await your quote, don't be generic otherwise I will reject your offer. If you have already made similar sites I would like to see them. Thank you.

I am in need of a social media content creator who can help me boost my brand across Facebook, Instagram, TikTok and LinkedIn. You need to create 2 pieces of content using the below brand guidelines, the topic can be of your choice. I am looking for repeat work, and I will require a quotation from you based upon 10, 20, 30 pieces of social m...efficiently and deliver on time. Ideal Skills: - Proven experience in social media content creation and management. - Strong understanding of the different social platforms. - Ability to create appealing visual and written content. - Experience in brand awareness campaigns on Facebook and Instagram. If you're a creative social media professional who can bring fresh ideas and effective strategies to the table, I'm looking forward ...

I need a full WordPress website for my bed and breakfast. 6 PAGES 1 - home page 2 - first apartment page 3 - second apartment page 4 - third apartment page 5 - booking form 6 - contact page Insert icon with link to Facebook page on the site Visitor statistics FURTHERMORE I need an excellent positioning of the B&B on Google My site might look something like this: I will provide all text and images for the site. I await your quote, don't be generic otherwise I will reject your offer. If you have already made similar sites I would like to see them. Thank you.

I'm looking for a skilled photo editor who can remove the existing date from a picture and insert a new one, as well as incorporate a text or logo to the image. Key Requirements: - **Date Replacement**: You'll need to completely remove the old date from the picture and add a new one in its place. - **Text or Logo Placement**: The text or logo should be elegantly placed on the image, in a manner that doesn't overshadow the main subject. Ideal Freelancer: - Proficient in photo editing software like Adobe Photoshop or GIMP. - Experienced in working with image manipulation and text overlay. - Attention to detail to ensure a seamless blend of the new date and the existing image.

CAFE NAME: BIgmug Cafe Color black and white I'm looking for a creative logo design for my chain of cafes that can compete in the western market. Like Starbucks, Java House, Mugg & Bean I don't have any specific ideas for the logo yet, so I'm counting on your expertise to bring something unique to the table. Key Points: - The logo must convey a modern and innovative vibe, capturing the essence of my franchise cafe's vision. It should be memorable it’s extremely important it’s unique and memorable like starbucks - I'm specifically looking for a design in black and white or grayscale, so please ensure this is incorporated effectively.

...packet, four cups of water, and 1-4 pounds of cubed chuck roast, or meat of your choice, to a slow cooker or instant pot. Instant Pot - Set to Pressure Cook, on High, for two hours, then natural release for 15 minutes. Slow Cooker - Cook on low heat, covered, for 8 hours. Optional: Add the juice of 2 limes to the liquid mixture. Sear the beef before adding to mixture. Empty, wash, and dry the insert of the pressure cooker. Add 1/4 cup avocado oil to the pressure cooker and heat on the highest Sauté setting for 5 minutes. Add half the beef and sear until browned on a few sides, 8 to 10 minutes. Transfer to a plate. Repeat searing the remaining beef. " - Allergy Info - packed in a factory that handles nuts, peanuts and sesame....

...Ensure the site content is primarily in Arabic, with some pages in English. advice for students on studying abroad. any unnecessary content. a minimalist design. 5. Set up menus, categories, and subcategories. Content Upload: images and articles in Arabic. all content is well-organized and properly formatted. SEO and Analytics: up a Google XML sitemap. Google Analytics. the site for SEO. Performance Optimization: caching solutions to improve site performance. other performance optimizations (e.g., image compression, minifying CSS/JS). Security and Maintenance: and configure security plugins to protect the site. up regular backups. the WordPress core, themes, and plugins

exactly similar to this f-system

...PROVIDED): ----------------------------------------------------------------------------------------------------------------------------------------------------------------- I need to remove the Service Number Taxonomy that was added and create a new one called Booking Category. This will need look up the `11_bkntc_services` table in the database. (I use the Booknetic Plugin for Game Bookings) The table looks like this image, so you will have to use case insensitive SQL to find the `11_bkntc_services` WHERE name is PARTIALLY equal to the "Projects name" (2nd Image) as I have multiple actual games per "Project" The WP page in question is Https:// The "Book Now" button uses the code in the image below found in this file: wp-content/themes...

I am in need of a skilled iOS app designer to help develop a start-up program aimed at addressi...- Proficient in iOS platform app design - Prior experience in start-up or related app development - Solid understanding of user experience and interface design - Excellent problem-solving skills and creativity - Ability to work within deadlines and multi-task effectively. This project requires someone who can intuitively understand the needs of a start-up and bring creative solutions to the table. I look forward to hearing from you. I have searched the app store and have not found anything like this but it is very much needed. I will need to get a confidentiality agreement signed before anything starts. It should be fairly simple but I am not versed in app production. Thank you for ...

...to learn Salesforce and gain practical experience in this area. I am seeking a mentor or a client who is willing to guide me through a Salesforce project, providing me with the opportunity to learn and grow while contributing to their project's success. While I may have limited experience with Salesforce at the moment, I am dedicated, motivated, and quick to learn. Here's what I bring to the table: Extensive experience in Pick Basic programming and software development. Strong problem-solving skills and attention to detail. A proactive and enthusiastic attitude towards learning new technologies. The ability to adapt quickly and work effectively in a team environment. If you are willing to provide guidance and mentorship on a Salesforce project, I am eager to collabor...

Hi Mohamed A., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

...Implementation: - Set up a CI/CD pipeline using GitHub Actions for automated testing, building, and deployment of both frontend and backend applications. - Integrate the pipeline with our GCP infrastructure, including Compute Engine, Cloud SQL, and Cloud Storage. 2. Logging Setup: - Configure logging for all services: -- Frontend (Nginx, ): Log HTTP requests, errors, and application logs. -- Backend (Gunicorn, Django): Log application errors, access logs, and system logs. -- Celery and Beat: Log task execution and periodic tasks. -- Database (Cloud SQL): Log database queries and errors. -- Redis (Cloud Memorystore): Log Redis operations. - Collect and store logs centrally using GCP's Stackdriver Logging. - Set up log rotation and retention policies. 3. HTTPS Domain...

use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days you provide code to simulate input data (both code versions: python and sql)-> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78, 5, 23, 41. When 34 for 20%; 65 for 30%; 12 for 40%; 78 for 10%; 5 for 15%; 23 for 70%; 41 for 30% randoml...

I have a substantial Excel table and I am in need of a skilled data analyst to help with correlation analysis between Column 1 to 9 of my dataset, which contains more than 4200 rows and 9 columns. Need the source file of xls with formula too Key Responsibilities: - Perform accurate correlation analysis on specified columns - Generate line graphs to visualize the correlation Ideal Skills and Experience: - Proficiency in Excel and correlation analysis - Solid understanding and experience with line graph creation - Excellent problem-solving abilities - High attention to detail I'm looking for accurate and efficient work so I can understand the relationship between my data points and act accordingly. Your experience could be the key to enhancing my project. Looking forward to se...

We are looking for 5-10 years of .Net experienced developer who can also have experienced in React and .Net based web development. Long terms multiple projects development. Using Mainly Azure SQL server database with Visual Studio .Net Core API. Graph QL and EF. Worked on Azure Key Vault, Azure Logic app, Azure function is bonus.

use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days *****you provide code to simulate input data -> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states randomly 30 to 170 transactions per day for given product for usual price randomly 200 to 600 transactions per day for given product for promotion random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78,...