Fertiggestellt

VB.NET Excel data importer - Compatible with MacOS

We are currently building a marketplace for photographers to sell their art.

In time they will be able to upload their photos directly through the web portal, but for now we're looking to implement a batch import solution.

The goal of this project is to facilitate the import via an excel file.

There is a preliminary step for the import, and then five functional steps :

0) The excel file is placed in a new, empty folder

1) The user clicks on step n°1 button: it creates a 'photos' folder next to the excel file

2) The photographer copies/pastes his files in the generated photo folder

3) The photographer clicks on step n°3 button: the photo folder is scanned

4) The photographer fills in metadata

5) The photographer clicks on step n°5 button: a zip archive is created.

Step n°1: simple directory creation. That's it.

Step n°2: no code whatsoever, photo files are copied into the directory

Step n°3: the scanning process is the most important one. It's where most of the VB code resides. Its job is to:

- scan a specific folder looking for photo files,

- extract size and resolution metadata

- filter out the photos that don't qualify (low res, wrong ratio)

- generate a table in excel, listing all the photos

- generate thumbnails for each photo, and position them at the right place in the table

Step 4:

The photographer would then fill in some metadata : tags, categories...

Some columns to be filled should have data validation, based on the other data tabs of the excel file.

It's quite straightforward:

- DATA-Categories tab lists all the categories

- when the user fills in a category, it should belong to the list within DATA-Categories tab

=> please see provided excel file, the validation is already in place for all columns

Step 5:

The last part of the project is a button that when clicked, would create a zip archive containing:

- the entire photo folder

- the filled excel file

Attached is a template for this excel file, one empty (before scan), one generated (after scan), and one filled (after the photographer's metadata input).

PLEASE IGNORE the text displayed when clicking the buttons, those are obsolete instructions.

Fähigkeiten: Excel, Softwarearchitektur, VB.NET, Visual Basic

Mehr darüber vb net send data internet, vb net save data, vb net parse data file, vb.net vs vba, vb.net write to excel file, vb.net for excel, vb.net excel automation, convert vba to vb.net online, vb.net excel macro, vb.net create excel file, vb.net read data from excel, excel, visual basic, vb.net, vb net fill data adobe life cycle pdf, vb net excel pdf, vb net excel file, vb net excel export csv, vb net excel class, vb net copy data webpage

Über den Arbeitgeber:
( 0 Bewertungen ) Paris, France

Projekt-ID: #17185318

Vergeben an:

seaanddream

Hi, my name is Selim. I read your "VB.NET Excel data importer - Compatible with MacOS" project descriptions carefully before bidding. I checked the attached excel template & additional files as well... I got what you Mehr

€500 EUR in 5 Tagen
(263 Bewertungen)
7.7

11 Freelancer bieten im Durchschnitt €520 für diesen Job

schoudhary1553

Hello, I can help with you in your project Excel data importer. I have more than 5 years of experience in Excel, Software Architecture, VB.NET, Visual Basic. We have worked on several similar projects before! We ha Mehr

€750 EUR in 10 Tagen
(263 Bewertungen)
7.5
€588 EUR in 4 Tagen
(71 Bewertungen)
6.6
aanvikm

Hello Sir, I am an expert in .net and VBA programming and would like to work with you on this project. Thanks Aanvik

€588 EUR in 7 Tagen
(54 Bewertungen)
6.6
€500 EUR in 3 Tagen
(93 Bewertungen)
6.1
tiaratechies

Hello, we are a team of software developers with years of experience we can provide the solutions and give the exact output according to your requirement.

€750 EUR in 10 Tagen
(37 Bewertungen)
5.2
vaidyag

HI,, I have excellent experience in Excel and Access and other Microsoft related. I have written complex macros like creating a BoM for an ERP, creating P/L, Cashflow statements from a database. I have the code f Mehr

€376 EUR in 5 Tagen
(14 Bewertungen)
5.0
huypq5

if you want the tool can run on MacOS, I would like to use xamarin to build this app with c# language, it can deploy the tool in both window OS and MacOS. All feature will be implement with the fee in my bid, no extra Mehr

€333 EUR in 10 Tagen
(43 Bewertungen)
5.2
xinglong717

How are you i can help you. i am excel expert. also i am typing expert and my typing is very correct. if you give me your projeact, i will help you. and i will finish within short time.

€555 EUR in 10 Tagen
(16 Bewertungen)
4.5
akioUnity

Hello. I have rich experience in VB.NET Excel and Macro scripts. will build good script for your Excel file. thanks. akio

€333 EUR in 10 Tagen
(7 Bewertungen)
4.0
hsingla85

Available Immediately | MS Excel Expert | MBA | Assured accuracy and minimum turnaround time | VBA Champion You can look at my jobs history and have completed project like these successfully. Looking forward for Mehr

€444 EUR in 10 Tagen
(6 Bewertungen)
3.1