Closed

Apply text from cvs file onto image file : make the script

Hi!

I need to apply a serie of text entries from a csv text file onto an image, one entry after another on the same image and to save each image with a unique name.

I think that using "Image Magick" would be best suited, unless there is a php + gnu components that can to this.

DON'T APPLY IF

- you do not work within these specs.

- with a general type of offer, I will discard it right away.

- you think it will take you more than 2 hours.

- you can not set up a replicate a blank joomla 3.0.2 on the Wright framework on your servers to work on my project.

- you want to be pay otherwise than by the freelancer policies.

We will use Skype and Teamviewer to communicate. I will need you to modify theses css on other projects (15) as well eventually.

oops Please read as:

DON'T APPLY IF

- you do not work within these specs.
- with a general type of offer, I will discard it right away.
- you think it will take you more than 2 hours.
- - you want to be pay otherwise than by the freelancer policies.

We will use Skype and Teamviewer to communicate.

Question:
Do you have any requirements on:
typography, like font family and size
the quality of the text on the image
the location of the text on the image
any wrapping or overflow if the text is longer than image width?

Answer from Me:

Yes location is to be accounted for and wrap overflow as well

well I certainly do not mind a photoshop script. The csv file has 43000 records and I want to make twelve images per record. Is a photoshp script the best thing?

I want the image saved as a .png on a tranparent background (preferably)and the image to be max 115K.

I want to use one specific font per batch - but I worry about size because as per example some name could be as short as John and the next one be as long as Jean-François-de-la-Durantaye

Here is a link to a specific solution

http://stackoverflow.com/questions/700792/automate-photoshop-to-insert-text-from-file

import win32com.client
import xlrd
spreadsheet = xlrd.open_workbook("text_buttons.xls")
sheet = spreadsheet.sheet_by_index(0)

psApp = win32com.client.Dispatch("Photoshop.Application")
jpgSaveOptions = win32com.client.Dispatch("Photoshop.JPEGSaveOptions")
jpgSaveOptions.EmbedColorProfile = True
jpgSaveOptions.FormatOptions = 1
jpgSaveOptions.Matte = 1
jpgSaveOptions.Quality = 1

gifSaveOptions = win32com.client.Dispatch("Photoshop.GIFSaveOptions")



for rowIndex in range(sheet.nrows):
if(rowIndex > 0):
template = sheet.row(rowIndex)[0].value
targetFile = sheet.row(rowIndex)[1].value
targetFileFormat = sheet.row(rowIndex)[2].value
textTranslated = sheet.row(rowIndex)[3].value
psApp.Open(r"D:\Design\Produktion\%s" % template )
doc = psApp.Application.ActiveDocument

for layer in doc.Layers:
if (layer.Kind == 2):
layer.TextItem.Contents = textTranslated
if(targetFileFormat == "gif"):
doc.SaveAs(r"D:\Design\Produktion\de\%s" % targetFile, gifSaveOptions, True, 2)
if(targetFileFormat == "jpg"):
doc.SaveAs(r"D:\Design\Produktion\de\%s" % targetFile, jpgSaveOptions, True, 2)

can you do this?

Skills: ActionScript, Photoshop, Photoshop Coding

See more: the best work on freelancer, software projects freelancer, software freelancer projects, name text image, freelancer text, freelancer teamviewer, freelancer specs, freelancer serie, freelancer projects joomla, freelancer policies, freelancer make up, freelancer image to work, freelancer image to text, freelancer codding, cvs apply, csv freelancer, apply to cvs, apply to be a freelancer, apply as freelancer, apply as a freelancer, make up freelancer, the freelancer, Text from image, text freelancer, Image magick

About the Employer:
( 0 reviews ) Montreal, Canada

Project ID: #4202034

4 freelancers are bidding on average $189 for this job

triadb

Hi, please check PM

$111 USD in 0 days
(14 Reviews)
4.9
bappi400

Dear Client, I am expert in this kind of [url removed, login to view] my [url removed, login to view] will be find 100% accurate work from me.I am ready to take any kind of task what ever you [url removed, login to view] you give me a opportunity to work with you it,s will b More

$250 USD in 0 days
(20 Reviews)
1.5
NickyJones

Hello, sir. I'll create the image from the csv text as your requirements within time. Please give me details. Thanks.

$50 USD in 1 day
(0 Reviews)
0.0
lavizsolutions

Hi Please check PMB for detailed bid.. I am bidding on your project bcoz... - i m offering you no generic bid. - it can take 5-6 hours - i can set up a replicate a blank joomla 3.0.2 on the Wright framework More

$350 USD in 1 day
(0 Reviews)
0.0
nutanbhosale

Hi, Please refer to our Private Message. Ready to start. Thanks - Nutan

$45 USD in 1 day
(0 Reviews)
0.0