Vbs query iis website numberemplois

Project Title: Fix SQL error Wordpress with Translatepress Specific Error: Unknown column 'plural_form' in 'field list' Error running insert_gettext_strings() Skills and Experience Required: - Strong understanding of SQL and database management - Experience with Wordpress and Translatepress - Ability to troubleshoot and fix database connection errors - Familiarity with syntax errors and query errors - Attention to detail and ability to identify and resolve specific errors - Past work demonstrating successful resolution of similar SQL errors - Excellent communication skills and ability to provide detailed project proposals Please include: - Examples of past work showcasing successful resolution of SQL errors in Wordpress websites - Relevant experience in workin...

I am looking for a skilled developer to build a Telegram bot using the Telegram Bot API. The bot will have the following requirements: Platform: Telegram Bot API Messaging Frequency: Hourly Tagging Members: The bot should be able to tag a minimum of 50 and a maximum of 200 members in each posting. Additional Features: - The bot should have the ability to post specific messages that I input into the software. - The bot should be able to pin the software to notify everyone. Ideal Skills and Experience: - Experience in building Telegram bots using the Telegram Bot API. - Proficiency in programming languages such as Python, JavaScript, or Node.js. - Knowledge of Telegram API and bot development. - Familiarity with handling messaging frequencies and tagging members in Telegram. - Strong...

I have an excel wo...Excel that calls a routine in the WOrd document. I have had to change this routine, but have introduced an error that I need help correcting. The problem that I have is that although the Excel macro appears to be running running correctly, when the WOrd macro starts it is using the wrong sheet to merge. I have noticed that when I do a manual mail merge from the Word document there are a large number of tables in the Excel file and the first one on the list is the table that the Word marco seems to be using (Cancelled courses). Program (LaunchCreateGoPack is the macro), Master is the sheet I am invoking the macro from) (CreateGoPack is the macro) I would like someone to troubleshoot and correct the macros so that they run correctly.

...am looking for a freelancer who can help me install SSL certificates on my websites and configure them properly. - The SSL certificate that I have is a Domain Validated (DV) certificate. - I currently have access to my server, so the freelancer should be able to work directly on the server. - The server that I am using is Microsoft IIS. - The ideal freelancer for this project should have experience in installing and configuring SSL certificates on Microsoft IIS servers. - Knowledge of SSL certificate types and their validation processes (DV, OV, EV) is also preferred. - Attention to detail and the ability to ensure proper configuration and functionality of the SSL certificates is essential. - The freelancer should be able to provide documentation or guidance on how to main...

I am looking for a skilled MS SQL 2012 developer who can help me with a query to get a concatenated string from multiple tables. The query involves multiple tables and the expected output is multiple row results. The deadline for completion is within 24 hours. Skills and experience required: - Strong proficiency in MS SQL 2012 - Expertise in writing complex queries involving multiple tables - Experience with concatenating strings in SQL - Ability to deliver high-quality results within tight deadlines

...walk-in traffic. The app should have the following features: - Walk-in sign-in: Customers should be able to easily sign in upon arrival, providing their name and phone number. - Data storage: The app should store the customer's information for future reference. - Mass messaging: I would like to be able to send mass messages to all the customers who have signed in, in order to encourage them to come back. The app should be compatible with both iOS and Android platforms, ensuring that it reaches a wide range of customers. The preferred method for customers to sign in would be through providing their name and phone number. This will allow for efficient communication with customers in the future. I am seeking an app developer who has experience in creating cross-plat...

...time for the query (5 minutes ago) DateTime startTime = (-5); // Create a ChangeQuery to filter changes based on time and change types ChangeQuery changeQuery = new ChangeQuery(); // IncludeAdd and IncludeUpdate = true; = true; = true; = true; // Include folder changes = true; = true; = true; = true; // Get the change collection for the site ChangeCollection siteChanges = (changeQuery); // Execute the query

Project Title: MySQL query help Specific Help Needed: Syntax error Deadline: Within 3 hours ASAP Complexity of MySQL query: Intermediate Skills and Experience Required: - Strong knowledge of MySQL syntax and query optimization - Experience in troubleshooting and resolving syntax errors - Ability to optimize query performance - Familiarity with intermediate-level MySQL queries - Attention to detail and ability to analyze complex queries

...above and have an intermediate level of proficiency in Quran memorization. We (Habib Ul Quraan), are based in Batley and are wanting your help please with our International Hifz Quraan competition that we are hosting Mid November. This is our website: QUESTION: Huffaz that are competing presses the spacebar button on a laptop which generates 3 random page numbers for a 15 line Quraan. The Huffaz should only see the page number on his screen. The judges should be able to see the full quraan page (from that page number) on their screen and the audience too - on the big screen that we will be setting up. Here is a link of an example from the Portugal competition that took place this year: We need something similar to the above example

I am looking for someone who can help me resolve specific issues I'm having with my Appsheet query. I need to retrieve user information, sales data, and inventory information. I'm specifically experiencing some bugs and issues with my query that need to be resolved as soon as possible. If you have the experience and skills to help, please apply for this job. I require urgent solutions as soon as possible.

Project descr...- User interface design should be intuitive and easy to use Preferred platform: - The system must be web-based Ideal Skills and Experience: - Strong knowledge and experience in advanced data analysis - Proficiency in web development technologies - Experience in designing user-friendly interfaces I need this to be done in PHP mysql I have my own database and I have an API already doing the query What I want is to create a username and password panel for normal customers and in this panel I want the administrator and the seller and the end customer the administrator can create sales users or end customers and the seller user can create end customer I will talk about the rest of the basic things to be done during the project The maximum amount I can pay will...

...it in some initial data. The GitHub repository is here - The YouTube tutorial is here - I would like to progress to the next stage of this project. I would like to: 1) Speed up the chat responses. The chat responses can take a LONG time. This is because it currently summarizes the articles every time a query is made. It will need refactoring to be production ready. I would like help to refactor the code. 2) Allow the bot to interact with my our own API when necessary. The developer should code a couple of demo API interactions that should be called only when the user asks for particular actions to be performed. The developer help these two points and be able to offer advice in how to better train

I am looking for a freelancer who can help me with the following tasks: - Writing queries on Access database - Performing integration with Oracle SQL Developer - Performing data integrity check Requirements: - Experience in writing queries on Access database - Knowledge of Oracle SQL Developer - Strong understanding of data integrity check The project is time-sensitive, and I need it to be completed within a week. All the necessary data and the database schema are already available. If you have the required skills and can meet the deadline, please submit your proposal.

I am looking for a larger number of audio files for an educational project. I specifically need call recording files of boyfriend and girlfriend calls recording. natural calls, some romantic , funny some non veg talking Freshers are most welcome to apply for this project. Need only girlfriend, boyfriend, husband and wife, call recording related to love, romance and role play. These are required for education purpose project and a large number of audio call recording files required. Skills and Experience: - no skill no experience required - freshers are most welcome If you read this carefully then write " I read carefully" on your bid . I will consider bids only written these headings in top of bid. Others without heading not considered. Please read...

I have coded data for a training study looking at the relationship between training factors and outcomes. this specific analysis needs to look at the relationship between number of curriculum items covered in training and its relationship to the training intervention being implemented into everyday practice. You will need to go through the data and create a score out of 11 (11 curriculum items covered) for each participant and see how the relationship goes linear regression between curriculum score and likelihood of integrating the training intro everyday practice . I have attached a word document explaining everything in sufficient detail

Sql Query Parse Join Columns. I need a way to parse sql queries and build a list of used in the join criteria. 1-Needs to be able to paste text (queries) in a textbox or load from a file. They can be many stacked in one file. 2-It needs to extract the join criteria from the queries. 3-It needs to format in a tab delimited file. +Tabe delimited. +Schema and table name written out (not alias) and combined. 4-If there are more than 1 criteria between 2 tables (meaning joining on more than 1 column), they both need to be listed and have a unique group number associated (that does not exist in the output file). 5-If the join is between a nested query (a derived table), that join does not need to be included. Only table to table. 6-The output file can not have duplicat...

I am looking to hire an experienced freelancer to use PowerShell and gain access to the Amazon Selling Partner API (SP-API). Specifically, I need to access the SP-API in order to make queries about my seller account stock, sales, and other relevant data. My preference is for the data to be presented as PowerShell objects so I can insert them into databases or use for analysis. The successful freelancer will be experienced in PowerShell scripting and automation. They will need to be comfortable connecting to APIs, using Amazon's STS and SP-API models via PowerShell, and securely storing access tokens, as well as experience manipulating data into the desired output format. Above all else, the freelancer should be dependable, trusting with Amazon account information, organized and able ...

Project Title: Investigate SSL TLS v1.2 client server handshake error Description: We are looking for an experienced professional to investigate and resolve the SSL TLS v1.2 client server handshake error that we are currently facing. The ideal candidate should have a strong understanding of SSL/TLS protocols and experience working with Apache, Nginx, or IIS servers. Please, submit a bid only if you are an expert in SSL TLS v1.2. Once the issue is resolved I release the money. The specific of this project is that there is no error message from the client side, it just rejects the Server Hello because it doesn't like something related to the Certificate or the Server Key. The details might not be available due to the commercial secret, this makes investigation a bit more complex...

Windows Server IIS Setup and LableMaker API deployment and fix of code refrance

Hey, I have two more small tasks for the same project if you're available? I was hoping to add a feature to the app where the user can choose between greater than, less than or equal to in the Production Budget and Worldwide Box Office columns. The query that they enter can then filter those values so that they can see if the data is above, below or equal to that query. I was also hoping you could add unit tests for the filter and sort features you implemented recently. Are you available?

For an affiliate-based website, specialized in cricket and sports betting, aiming at the Indian market, we are looking for an SEO specialist. The website had gone a re-branding process and has recently been re-launched, thus needs a full massive SEO work both on-page and off-page. The site is both in English and Hindi, with approximately 100 active pages (divided equally), thus chosen freelancer should be familiar with both languages. Each page needs to go full SEO review and have the meta-data and other tagging done to become Google friendly. Site is fully on Word-Press and is very structured. The chosen person or firm will work with us on defining the main keywords for each page/section and decide on which pages to put the emphasis on and which ones to promote. Building o...

...it in some initial data. The GitHub repository is here - The YouTube tutorial is here - I would like to progress to the next stage of this project. I would like to: 1) Speed up the chat responses. The chat responses can take a LONG time. This is because it currently summarizes the articles every time a query is made. It will need refactoring to be production ready. I would like help to refactor the code. 2) Allow the bot to interact with my our own API when necessary. The developer should code a couple of demo API interactions that should be called only when the user asks for particular actions to be performed. The developer help these two points and be able to offer advice in how to better train

I am looking for someone to extract specific text combinations from a multi page PDF document and output which page number each of these text combinations occur into an excel spreadsheet table. The specific text combinations I need to be extracted are lot numbers on a land title plan. I do have a specific format for the excel spreadsheet table that I will provide. The PDF document can vary from 2 to 500 pages and most commonly the plans are less than 50 pages long. I need someone who is detail-oriented and capable of accurately extracting this information and inputting it in the designated excel spreadsheet table.

...Programming: Languages: GLSL, C++ Frameworks: Vulkan, OpenGL Skills: 3D graphics rendering, shaders, Nvidia CUDA for GPU acceleration Cloud Computing: Platforms: AWS, Google Cloud, Azure Skills: Serverless architecture, database management, auto-scaling, containerization (Docker, Kubernetes) Database Management: Languages: SQL, NoSQL Systems: PostgreSQL, MongoDB, Redis Skills: Database design, caching, query optimization DevOps: Tools: Git, Jenkins, Travis CI Skills: Continuous integration, deployment pipelines, monitoring Nvidia Software Integration: Deep Learning SDK: Utilize Nvidia's deep learning SDK for training ML models that can control avatars or conduct conversations. CUDA Programming: Specialize in Nvidia's CUDA programming for GPU-accelerated tasks, criti...

I am looking for a freelancer to compile a number of webpages into a booklet for marketing purposes. The desired format of the booklet is both PDF and print. There are more than 20 webpages that need to be compiled. Skills and experience required for this project: - Strong proficiency in web development and design - Experience in creating and formatting PDF documents - Knowledge of print design and layout - Attention to detail and ability to organize and consolidate information - Strong communication skills to ensure the client's requirements are met

Programming: Languages: GLSL, C++ Frameworks: Vulkan, OpenGL Skills: 3D graphics rendering, shaders, Nvidia CUDA for GPU acceleration Cloud Computing: Platforms: AWS, Google Cloud, Azure Skills: Serverless architecture, database management, auto-scaling, containerization (Docker, Kubernetes) Database Management: Languages: SQL, NoSQL Systems: PostgreSQL, MongoDB, Redis Skills: Database design, caching, query optimization DevOps: Tools: Git, Jenkins, Travis CI Skills: Continuous integration, deployment pipelines, monitoring Nvidia Software Integration: Deep Learning SDK: Utilize Nvidia's deep learning SDK for training ML models that can control avatars or conduct conversations. CUDA Programming: Specialize in Nvidia's CUDA programming for GPU-accelerated tasks, critical...

We are looking to undertake a project on two Power BI Datasets. We need to reduce the memory and processing power by transferring Power BI Desktop Calculated columns to Power Query (M) or where necessary SQL. A review of the processes in place will also be undertaken so that upon completion we have more efficient Datasets. Skills and Experience Required: - Proficient in Power BI and DAX formulas - Strong understanding of M language - Experience working with datasets of moderate to large sizes - Ability to handle complex DAX formulas and convert them to M language efficiently - Knowledge of SQL is preferable - Attention to detail and ability to troubleshoot and debug any issues that may arise We are looking for someone with the right experience and skillset who has previously worke...

I have a legacy ASP classic custom built website and would like to integrate the Stripe payment gateway to the checkout. I don't wish to host the credit card form but would like to pass the minimum information required such as: - Order ID - Amount to pay - Customer name - Billing address I would then like Stripe to call back the website with the success or failure of the payment. The website is hosted via IIS on a Windows server and connects to SQL server database. For the final delivery I would like a standalone ASP classic test page which accepts test payments cards and returns successful and failed payments. Once I understand how it is working I can integrate it myself into the website but will need assistance in case there are issues.

...size (more than 10GB). Skills and experience required: - Strong expertise in SQL performance tuning and optimization techniques - Proficiency in working with SQL Server databases - In-depth knowledge of query execution plans and indexing strategies - Experience in analyzing and resolving high CPU usage issues in large databases -Trace deadlocks, root cause and implement solutions to stop them Responsibilities: - Identify and analyze the root cause of the high CPU/Memory usage problem - Optimize SQL queries and database structures to improve performance - Implement indexing strategies and query optimization techniques - Monitor and fine-tune the database for optimal performance If you have a proven track record in optimizing SQL Server databases and possess the necessar...

Veuillez vous inscrire ou vous connecter pour voir les détails.

JSP Project update I am looking for a JSP developer who can help me with adding new features to my project. I already have a specific...I already have a specific design in mind for the UI/UX improvements and function improvements. I need these updates and changes to be completed soon. Requirements: - Menu layout update ( max 3rd level submenu) - Search function enhancement - Jenkins deploy and test server environment setup Ideal skills and experience: - Strong proficiency in JSP development - Jenkins - Windows server, IIS and WAS - Experience with UI/UX design and implementation - Ability to work within tight deadlines - Preferred skill Need to understand Korean sentences. Skills required Java, JavaScript, Jenkins, JSP, Oracle ?250USD - 750USD ?GimenezTech from Almasso...

I am looking for a JSP developer who can help me with adding new features to my project. I already have a specific design in mind for the UI/UX improvements and function improvements. I need these updates and changes to be completed soon. ...I already have a specific design in mind for the UI/UX improvements and function improvements. I need these updates and changes to be completed soon. Requirements: - Menu layout update ( max 3rd level submenu) - Search function enhancement - Jenkins deploy and test server environment setup Ideal skills and experience: - Strong proficiency in JSP development - Jenkins - Windows server, IIS and WAS - Experience with UI/UX design and implementation - Ability to work within tight deadlines - Preferred skill Need to understand Korean ...

I have an aspx page written in C#-- I'm a VB.net person so I need a little help. My page redirects based upon the MemberID in the query string. All I want is If querystring is MemberID=117 go the Https:// It's just a couple of lines of code. Bellow is my entire code <script runat="server"> protected override void OnLoad(EventArgs e) { String currurl = ; String querystring = null ; int iqs = ('?'); if (iqs == -1) { ("HTTPS://", true); } // If query string variables exist, put them in // a string. else if (iqs >= 0) { // querystring = (iqs < - 1) ? (iqs + 1) :

I am using IIS 6.1-- URL Rewrite does not work, I need to put up an index HTML page on a website to redirect to another server The html page needs to see the query string and rewrite it to the new server If to If to If to I need this done ASAP

I am looking for someone to compose 3 PDF files for me. C...am looking for someone to compose 3 PDF files for me. Content: The files should primarily consist of images. Intended use: These files are for personal use. Ideal Skills and Experience: Hello, i will send you a few pictures and i just want you to put them in a file. Thank you. Example would be : https://www.freepik.com/premium-vector/hanukkah-dreidel-coins-coloring-page-kids_31582186.htm#query=hebrew%20alphbetcoloring&position=12&from_view=search&track=ais simple for kids coloring. - Proficiency in creating PDF files - Strong graphic design skills - Ability to curate and organize visually appealing images - Attention to detail to ensure high-quality output - Creativity in designing unique and vi...

I am in need of a real PHP MySQL expert who can assist me in setting up a query to replicate my database tables. The project requires the following: Size of the database: Small (under 1GB) - The expert should be experienced in handling small-sized databases efficiently. Type of data in the database: Business Data - The ideal candidate should have prior experience working with business-related data. Preferred method of replication: Master-Slave - The expert should have a strong understanding of Master-Slave replication and be able to set it up effectively. Skills and experience required: - Strong expertise in PHP and MySQL - Experience with replicating small-sized databases - Knowledge of handling business data in a database - Proficiency in setting up Master-Slave replication I...

...to configure a Microsoft Power Automate operation that does the follow: Operation 1: Logs into a website (if it's not already signed in) Clicks a button Filled out a booking form based on values stored in a MariaDB database Wait for the success message Update our database of successful post Operation 2: Login to the same website Exact data from that page and store it in in our database Operation 3: If data in our database changes: Login to the same site Open a specific URL (stored in the database) Click a couple of buttons and fill out the form. Click Submit. There are a couple of extra steps involved, error handling, checking, validation etc. We're developers, we can help with database query, or an API to format the data as JSON or what ever you need,...

Hi, I'm searching for an expert on database queries to help tune some SQL queries for a project. We're using HeidiSQL to manage our database and are currently experiencing some issues with the output of our queries. Specifically, we need help tweaking 1-3 of our SQL queries to achieve our desired output. If you have experience in tuning queries for a MySQL, Oracle, or MS SQL Server, we'd love to hear from you. We understand that the complexity of our project can vary, depending on the size and structure of the data, and the complexity of the queries, so please provide us with an estimate for the project if possible. Thank you for considering our project.

I am looking for a freelancer who can help me deploy on my existing IIS server. I am running Windows as my server operating system. Requirements: - Experience with deploying on IIS - Knowledge of Windows server operating system - Ability to work with existing IIS server Tasks: - Set up on my existing IIS server - Configure after deployment If you have experience with deployment on IIS and are familiar with Windows server operating system, please reach out to me.

SQL Tutor Neede...who can help me improve my SQL skills at a beginner level. Specifically, I am interested in learning about basic SQL queries. I need someone who speaks good English as well. Ideal Skills and Experience: - Strong understanding of SQL fundamentals - Ability to explain complex concepts in a clear and concise manner - Experience in teaching or tutoring SQL to beginners - Familiarity with basic SQL query syntax and functions Tutoring Requirements: - Availability for 1-3 hours of tutoring per week - Patience and a willingness to adapt teaching methods to my learning style - Availability for online tutoring sessions If you have the necessary skills and experience to help me improve my SQL skills at a beginner level, please reach out to discuss further details and ava...

I am looking for a freelancer who can help me get my correct phone number listed on Google My Business. Currently, the phone number listed is incorrect. Skills and experience required for this project: - Experience with Google My Business and knowledge of the platform's guidelines and requirements - Ability to access and manage Google My Business accounts - Attention to detail to ensure that the correct phone number is accurately listed - Good communication skills to coordinate with me and obtain the correct phone number Please note that I will provide the correct phone number later on.

Hi, I contacted Freelancer support and they did not know how to post a private project only for a specific freelancer. So this is the only way I could find. Let's see. I have functional Chrome extension that takes a screenshot of the current tab. It saves the image file to the downloads folder on the user's computer. I want to expand this and have the image up...post a private project only for a specific freelancer. So this is the only way I could find. Let's see. I have functional Chrome extension that takes a screenshot of the current tab. It saves the image file to the downloads folder on the user's computer. I want to expand this and have the image uploaded to web server and text from text fields be saved to a SQL database. Web server is Windows, IIS, dat...

I am looking for a professional PHP Laravel developer who can help optimize the speed of my website. The specific areas I want to improve are the overall website performance. Currently, the average loading time of my website is less than 2 seconds. It is important to note that all features and functions of the website should remain unaffected during the speed optimization process. Ideal Skills and Experience: - Strong proficiency in PHP and Laravel framework - Experience in website speed optimization techniques - Knowledge of caching mechanisms and server-side optimizations - Ability to identify and resolve performance bottlenecks - Familiarity with database optimization and query optimization - Understanding of front-end performance best practice...

...WooCommerce website to improve page load speed. Currently, the website takes 2-5 seconds to load, but I would like to achieve a load speed of less than 1 second. Skills and Experience: - Proven experience in optimizing WordPress websites for speed - Strong knowledge of WooCommerce and its optimization techniques - Expertise in working with caching plugins and optimizing server configurations - Familiarity with image optimization and compression techniques - Understanding of code optimization and minification - Knowledge of database optimization and query optimization - Experience in improving website performance and user experience - Familiarity with SEO best practices and how they relate to website speed optimization If you have the skills and expe...

...using sophisticated video analysis techniques, including computer vision and deep learning, to identify segments that align with the semantics of the user's query. Key contributions of the paper include the integration of state-of-the-art language models and video analysis techniques, enabling the system to understand the nuanced relationships between language and visual content. The proposed method addresses the challenge of bridging the gap between textual and visual data by employing a joint approach that effectively retrieves relevant video segments based on the user's query. Prediction results will demonstrate the effectiveness of the Query based Video Highlights system in accurately identifying and extracting moments and highlights from a wide range ...

I am looking for a skilled SQL developer to assist me with a query for updating the "MyContacts" table. I need to update specific columns in the table, specifically the "ContactInfo" columns. I have two tables and trying to Update first one by concatinating values from and but I need to concatinate only unique values. Skills and Experience: - Strong proficiency in SQL and SQL Server - Experience with writing complex queries and updates - Familiarity with concatenating strings in SQL Server - Attention to detail and ability to accurately update specific columns

Project Description: VYOS Network Traffic Graphing Per Autonomous System Number I am looking for a skilled freelancer who can help me with a project involving VYOS network traffic graphing per Autonomous System Number (ASN). The ideal candidate should have experience in network traffic analysis and graphing. Desired Output Format: - Interactive web-based graphs Frequency of Data Updates: - Real-time Software/Tool: - No specific software or tool in mind, but it must be open-source Additional Requirements: - The freelancer should have knowledge of VYOS and be able to extract traffic data per ASN. - Experience with data visualization and graphing libraries is a plus. If you are a self-motivated professional with expertise in network traffic analysis and graphing, and you a...

...(on local server, no cloud/GDrive/...) via browser - create and manage a gantt (it is a stand-alone function: If the user want to define/print a gantt because he's responsible of a task, he can defines task name, task description, start date, .... and he can use the gantt created, without use MS Project or other) Browsers in use are Firefox and Chrome. The new portal/application will work under IIS 10 (Windows). ----- Develop environment and test ----- If you need online free service for ASP pages, could you use - - ----- Process info ----- One Admin only (using his own admin console). User registration not needed: users will be invited and they receive user/pass to access. Users side, he can: - file upload (using

I'm looking for a UI/UX Designer for an underdevelopment app for both iOS and Android platforms. I have a rough idea of what I'm looking for in terms of design, but would need help with further developmen...would need help with further development. This app will be focused on education and elearning. As of now, I need around 12 screens to be designed. I'm looking for a talented UI/UX designer who can design the app as per my needs. The benefits of the app should be also taken into consideration, which may include improved user experience, creating a lasting impact, and drawing attention from a wide number of users. This person should also have the expertise to effectively provide testing and maintenance post-deployment. Finally, this person should be able to deliver w...

camera videos showing blank Cases are taking time to upload on server refresh issue on cases and booking pages Dummy data on many sections need to remove that selfie issues, its not storing in local and not transmitting to server query section to integrate api in it archive section need to integrate data add timestamp and lcoation for camera clicked images and videos and to add timestamp and location to gallery uploaded media add timestamp and location in selfie also