Write some Software

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

FILE CONVERSION SOFTWARE REQUIREMENTS

Basic system - requirements

Standalone software or script required to convert a list of serial numbers within a text file into an Excel xlsx file.

It will need to process multiple files at once (typical batch size can be around 1300 - 1800 files).

There will be two types of files, 350 & 1500.

 Where the 350 has 350 serial numbers.

 Where the 1500 has 1500 serial numbers.

Text file format:

ABC0001T

ABC0001*

ABC0002K

ABC0002)

ABC0003C

ABC0003$

Etc

Etc

One serial number is represented by two lines in the text file, one with a letter at the end and one with a special character at the end.

The main function of the software will be converting these into Excel files, which will need to be in the following format: -

Code 1 Code 2 Code 3 Code 4 Code 5 Read Read

1000001

1000002

1000003

 The Code 1 column will be a fixed sequential number from 1000001 to 1001500 for the 1500 files, and in reverse for the 350 files i.e. 1000350 to 1000001 .

 Code 2 will be the alpha characters from the serial number i.e. ABC

 Code 3 will be the numerical characters from the serial i.e. 0001

 Code 4 will be the last letter from the first line of each serial i.e. T

 Code 5 will be the last special character from the second line of each serial i.e. *

 The last two columns are the complete serials:

 Read (1) – first line serial i.e. ABC0001T

 Read (2) – second line serial number i.e. ABC0001*

Ideally, the output files will be generated in their own output folder which consists of the order number (inputted by the user) i.e. ORDER123456. The filename of the output Excel files should be the same as the input text filenames, but obviously with the different extension (*.txt vs *.xlsx). Note also that *.xls file types (older Excel versions) are also compatible.

Advanced system - requirements

As additional capability, the serial numbers are stored in a database / table. During the conversion operation (or prior), an additional check is carried out by the software in order to ensure there are no duplicate serial numbers contained within the text files being processed, compared to that of the previous numbers already converted.

The duplicate number check be only needed on the alpha and numerical numbers i.e. ABC0001

Excel VBA Java PHP Software Architecture VB.NET

Project ID: #14985303

About the project

58 proposals Remote project Active 6 years ago

Awarded to:

Ahmed818

Hello, sir i can do this script easily , i have done many data conversion jobs before can begin now waiting your answer Regards Relevant Skills and Experience Programming , VB.net , C#, Excel VBA Proposed Milest More

$250 USD in 2 days
(111 Reviews)
5.7

58 freelancers are bidding on average $495 for this job

rinsadsl

Hi there I partially understand the logic behind your XLSX generation program. If we can have a private chat, we can understand it fully. I am happy to work on this project. Thanks Rinsad Relevant Skills and Experie More

$263 USD in 3 days
(1187 Reviews)
9.2
webbookstudio

Hello, my name is Michael. I represent Ukrainian based IT-company Webbook Inc that provides services in the IT-sphere for international business. We were carefully reviewing the requirements of the job description, so More

$490 USD in 9 days
(350 Reviews)
8.8
tarekahmed

On time and On budget I can do all what you want .... I did 311 projects with a rate of 5/5 .... please check https://www.freelancer.com/u/tarekahmed.html Relevant Skills and Experience I have a Professional team for More

$555 USD in 10 days
(131 Reviews)
7.8
mascotindia123

Hey Friend, We are 14 person team of developer, designer and tester provide you excellent services. Relevant Skills and Experience Myself having has 10 years experience of web site development. Expert in Custom pr More

$500 USD in 10 days
(280 Reviews)
7.7
sphinxsolution

Proposed Milestones $1500 USD - we will discuss

$1500 USD in 30 days
(29 Reviews)
7.5
DigiWhizz

Hey, I am James, a PHP and full stack developer based in London. Your project falls within my skill set and would like to discuss further. Relevant Skills and Experience: Expert in Excel VBA, Java, PHP, Software Archit More

$555 USD in 9 days
(44 Reviews)
7.7
Shopify

Relevant Skills and Experience We also use to work on other CMS based on PHP like - Wordpress, Drupal, Joomla *Shopping cart/ eCommerce CMS - 1)WoocommerceD 2)Opencart 3)Shopify 4)Laravel 5)CodeIgnite 6)Symfony Pr More

$515 USD in 10 days
(27 Reviews)
7.0
specialist77

Hello, Based on the description I estimated one working day to develop and test the text to excel conversion program. I am available to discuss. Best Regards Relevant Skills and Experience Excel Integration, Excel f More

$330 USD in 3 days
(29 Reviews)
7.3
prashushinde9

Hello, We have accomplished 90% of the project which is similar of your requirement. All we need 10% customization as per your requirement set and specifications. Relevant Skills and Experience I expertise in: - RubyO More

$773 USD in 15 days
(54 Reviews)
7.1
raiakanksha49

Hello sir/ma'am.. I have gone through your project domain..and i want to complete your project. I have 5 years of experience and i can complete your project within your budget.. Thankyou!.. Relevant Skills and Experi More

$555 USD in 10 days
(59 Reviews)
6.5
cosmicwheels

Hi, your project sounds really exciting. I could build you a cross platform application that could convert your files into excel files. I worked on many excel generator projects in the past. Relevant Skills and Experi More

$750 USD in 12 days
(16 Reviews)
6.0
vedaantTech

Hello there, I have reviewed your job description as well and very confident to handle this project perfectly. Relevant Skills and Experience .net, javascript html Proposed Milestones $750 USD - 750

$750 USD in 10 days
(29 Reviews)
5.9
romanapanovich

Hi I can do both convertion in xlsx files and in database But I think we must do it webbased. But i can do also desktop version Wich one will be better for You? Do You own some server for these scope? Соответствующие More

$450 USD in 10 days
(30 Reviews)
5.9
dipakjadhav08

A proposal has not yet been provided

$660 USD in 2 days
(102 Reviews)
5.6
mhortis

I am a senior Full-Stack Java developer and I have coped with several projects, small and more complex. I can deliver your project in a reasonable time, after setting the exact requirements. Relevant Skills and Experi More

$600 USD in 10 days
(25 Reviews)
5.7
jperusan

I can make standalone application (GUI or command line only, it's up to you to decide) for this purpose. It will be only one executable (exe) file without need for anything else. Proposed Milestones $250 USD - applica More

$250 USD in 2 days
(53 Reviews)
5.6
ludiac

Hi, we have reviewed and understood your project requirements. Relevant Skills and Experience We have expertise in web development and we can share our portfolio of work with you in chat. Proposed Milestones $755 USD More

$755 USD in 10 days
(20 Reviews)
5.8
abbalove

Hey, when you need it completed on ? Rocky Stay tuned, I'm still working on this proposal.

$255 USD in 10 days
(43 Reviews)
5.1
zu02

Hi, the best way for your current project via Ms Access GUI with Excel automation, I can provide that. Relevant Skills and Experience Access, Excel, VBA, sql, ado Proposed Milestones $555 USD - default

$555 USD in 10 days
(19 Reviews)
5.3
tech1967

Hello, I am a Windows Application/Automation Coder. My name is Fuat, and I have done a similar project: reading from txt file and creating/writing to excel spreadsheet with AutoIT language. Relevant Skills and Experie More

$500 USD in 10 days
(16 Reviews)
5.0