Sedang Disiapkan

Organising fles based on manufacturer or other variable

I have a large inventory of over 25,000 items each with an image. The images are in one large folder. There is an Excel/*.csv/*.txt sreadhseet that contains the inventory data, incuding image name & manufacturer's name.

I need some way of automatically sorting the images on a local hard drive into folders based on the manufacturer's name as provided in the Excel sheet.

For instance:

Item 1 Manufactured by FredCo, image name FredCo1.jpg. This requires a folder called "FredCo" to be created at the desired destination & the image [url removed, login to view] moved/copied into that folder on a local hard drive.

Item 2 Manufactured by BossCo, image name xyz987.jpg. This requires a folder called "BossCo" to be created at the desired destination & the image [url removed, login to view] moved/copied into that folder.

Item 3 Manufactured by FredCo, image name 123abco9n.jpg. This needs to be moved/copied into the existing folder called "FredCo".

Item 4 Manufactured by BossCo, image name drill72a.jpg. This requires the image [url removed, login to view] moved/copid into the BossCo folder..

etc etc.

The prefered methods are VBA or an Excel macro. It should be easily to run, create folders when needed so that files have somewhere to go & move/copy the files.

My guess is that the paths for the source files & destination for the sorted folders will be set at some stage either via a pop up entry window or a text entry in an Excel cell. However I'm open to other ways this may be done as long as the way it works is easily controled.

The absolute requirements are that the file sorter be able to read the source file, such as Excel, or *.txt, *.csv etc. It should be able to create folders based on the manufacturers names & move/copy files based on that name so that all images for a given maufacturer go into the same folder. Source paths for the spreadsheet, image locations & destination for the manufacturer folders should be user set. The choice between "move" & copy" should be available & required only once if necesary (ie as in being given a choice between "Yes, Move" & "Yes Move All" & the same for the "Copy file" option), so that I don't have to click "Yes" 25,000 times.

This is NOT something to move cell data around a spreadsheet, it needs to move the files on the hard drive.

There is no requirement to alter the images, their names or date stamp etc.

Kemahiran: Pengaturcaraan C, Excel, Troli Membeli-belah, Visual Basic, Destop Windows

Lihat lebih lanjut: txt 2 jpg, sorted data set, manufacturer requirements, local manufacturers, local manufacturer, go ie, sortere data efter dato med vba, vba open folder, vba create folder, excel vba or, excel vba long, create folder vba, Absolute, run sheet, need manufacturer, i need a manufacturer, excel based, c guess, alter some images -- 2, alter same images, alter files, Alter 1 image, vba excel copy, sorted, cell names

Tentang Majikan:
( 4 ulasan ) Brier, United States

ID Projek: #262184

Dianugerahkan kepada:

xxxjmt

With 9yrs of VBA experience, would be happy to do it for free for you as my first bid. I already have the working framework, just need to get more details to align with your requirements.

$30 USD dalam sehari
(7 Ulasan)
3.2

22 pekerja bebas membida secara purata $115 untuk pekerjaan ini

AtlanticSoft

Hi please check pmb for details

$200 USD dalam 10 hari
(50 Ulasan)
6.7
svet63

VBA developer since 1997. Can do. Regards, Svet.

$120 USD dalam 3 hari
(80 Ulasan)
6.8
adeelarshad

Hi, Plz check pm. Thanks

$150 USD dalam 2 hari
(42 Ulasan)
6.5
mingon

Hi, I can do it, check PM. Thank you.

$120 USD dalam 3 hari
(16 Ulasan)
5.7
badzia

Hi. See PMB. Thanks.

$100 USD dalam sehari
(12 Ulasan)
5.5
rajanlengde

I can do it, See PMB

$75 USD dalam sehari
(28 Ulasan)
5.1
VLADNOVA

Sir, see PM for details Vlad

$145 USD dalam 5 hari
(14 Ulasan)
5.0
SergeyPlus

Hello. Look PM please. Sergey S.

$65 USD dalam sehari
(16 Ulasan)
4.5
astk

Hi, I've done such a similar application lately. I'll send my experience via PM. Looking forward to work with you. Thanks, astk

$140 USD dalam 3 hari
(2 Ulasan)
3.4
sontosh

Ready to start right away.

$30 USD dalam 4 hari
(1 Ulasan)
1.8
dominichan

I can use VB to help you complete your need as you listed in project.

$30 USD dalam 2 hari
(2 Ulasan)
1.7
zjs0552

I can do this project for you.

$120 USD dalam 5 hari
(0 Ulasan)
4.1
minhas760

See PM for further details

$125 USD dalam 15 hari
(0 Ulasan)
0.0
abrahad

Please see PM

$200 USD dalam 14 hari
(0 Ulasan)
0.0
lalitprimus

WE CAN DO THE GIVEN PROJECT BUT AFTER HAVING A CLARIFICATION SESSION

$250 USD dalam 8 hari
(0 Ulasan)
0.0
mightypile

If I understand your requirements, I could do this in an Excel spreadsheet using VBA and finish in one day. My first concern is testing. I must assume that I would have access to a copy of the images so that I could t Lagi

$180 USD dalam 4 hari
(0 Ulasan)
0.0
betqil

I will be glad to undertake the project. you will be satisfied.

$50 USD dalam sehari
(0 Ulasan)
0.0
Abhisheak

I am having good experience in VB 6.0. this program require read the folder name and image path from xls sheet and create the folder form VB program. i am working in CMM level 5 company and laso working as a freelance Lagi

$110 USD dalam 3 hari
(0 Ulasan)
0.0
esses

I can do that using VB or Java

$200 USD dalam 15 hari
(0 Ulasan)
0.0
ravicoder

Can do the project easily and effectively.. Plus you will have more controls than you wish.. like everything organized.. good interface (showing what's happening and full details of actions being taken..).. I mean.. yo Lagi

$50 USD dalam sehari
(0 Ulasan)
0.0