#34322 - 12/17/10 03:14 AM
Re: barcode and numbers help
[Re: bowen]
|
OL Expert
Registered: 06/10/08
Posts: 207
Loc: Objectif Lune NL
|
Try "035020070292960600052503" including the quotes. You don't have to do add quotes to every row, only the first one.
PSM uses the MS Jet Text ISAM driver to interpret CSV files. This driver assigns a data type to each field by analyzing the values in all rows. If a field contains only digits it gets the 'Number' type. In that case leading zeroes are discarded. Adding quotes around one of the values forces the driver to see the field as 'Text'.
|
|
Top
|
|
|
|
|
#34331 - 12/17/10 09:05 AM
Re: barcode and numbers help
[Re: Sander vd Berg]
|
OL Newbie
Registered: 12/16/10
Posts: 28
|
thanks a lot.i've solved problem according your method.
by the way, do u know how to show its numbers below the barcode? i just found the express dialogue and wrote the express like CODE128([F3]). however,i can't find the way to setup details,such as style of barcode.
i am also a user of press, a software of printsoft. it provides the guide of barcode,include differnt kind of option to show barcode.
so what about the printshopmail? i'm very interested in main function and use of this software.
|
|
Top
|
|
|
|
|
#34347 - 12/17/10 01:19 PM
Re: barcode and numbers help
[Re: bowen]
|
OL Expert
Registered: 06/10/08
Posts: 207
Loc: Objectif Lune NL
|
If you're using a function like CODE128 you would need to apply a font that shows numbers below the barcode. Problem is, none of the Code128 fonts we supply seem to include those numbers. So I'm not sure how you could manage that, sorry..
Instead of using CODE128 you might want to consider using the Barcode plugin (click on the barcode button on the Tools toolbar). It should show numbers by default, and there's different kind of options you can set in the Properties panel.
|
|
Top
|
|
|
|
|
#34362 - 12/20/10 10:11 PM
Re: barcode and numbers help
[Re: Sander vd Berg]
|
OL Newbie
Registered: 12/16/10
Posts: 28
|
If you're using a function like CODE128 you would need to apply a font that shows numbers below the barcode. Problem is, none of the Code128 fonts we supply seem to include those numbers. So I'm not sure how you could manage that, sorry..
Instead of using CODE128 you might want to consider using the Barcode plugin (click on the barcode button on the Tools toolbar). It should show numbers by default, and there's different kind of options you can set in the Properties panel. cool!i'm done by ur way..haha...thanks a lot! there's another problem confuse me. i'd like to display something conditionally by using if expression. however ,i wrote different kind of expression according samples and help topics,nothing works. 1. IF([F18] <> 0,[F18],[F16]) this is programmed by online-help 2. IF(<<F18>> <> 0,<<F18>>,<<F16>>) this is programmed by samples download from websites can you tell me how to display field 18 or field 16 by conditions?
|
|
Top
|
|
|
|
|
#34363 - 12/21/10 03:27 AM
Re: barcode and numbers help
[Re: bowen]
|
OL Expert
Registered: 06/10/08
Posts: 207
Loc: Objectif Lune NL
|
[F18] is correct, but in an expression a field value is always a string. You'll need to convert it to a number before comparing it to a numeric value:
IF (VAL([F18]) <> 0, [F18], [F16])
When you're comparing a string to another string it's not necessary to convert. For example, to see if F18 is empty:
IF (TRIM([F18]) <> "", [F18], [F16])
|
|
Top
|
|
|
|
|
#34364 - 12/21/10 08:58 AM
Re: barcode and numbers help
[Re: Sander vd Berg]
|
OL Newbie
Registered: 12/16/10
Posts: 28
|
[F18] is correct, but in an expression a field value is always a string. You'll need to convert it to a number before comparing it to a numeric value:
IF (VAL([F18]) <> 0, [F18], [F16])
When you're comparing a string to another string it's not necessary to convert. For example, to see if F18 is empty:
IF (TRIM([F18]) <> "", [F18], [F16]) nice! i am very appreciated for your help. by the way, do u know whether it provides off-line help like chm format to download? it's not quite convenient to refere by internet.
|
|
Top
|
|
|
|
|
#34366 - 12/21/10 08:51 PM
Re: barcode and numbers help
[Re: Sander vd Berg]
|
OL Newbie
Registered: 12/16/10
Posts: 28
|
thanks a lot! by the way, how can i write several expressions in one variable? i mean,i created a varaible text like @F18@,and selected "edit expression". i'd like to write more than one if expression in varaible F18.but it showed end expression expected,i tried to use enter,but nothing worked. what should i do in the condition of several expressions?
|
|
Top
|
|
|
|
|
#34367 - 12/22/10 11:50 AM
Re: barcode and numbers help
[Re: bowen]
|
OL Expert
Registered: 06/10/08
Posts: 207
Loc: Objectif Lune NL
|
Each variable can have only one expression, but you can have multiple variables with different expressions in the same text box. For example, in a text box you could have @a@ on one line and @b@ on the next.
|
|
Top
|
|
|
|
|
#34368 - 12/22/10 08:00 PM
Re: barcode and numbers help
[Re: Sander vd Berg]
|
OL Newbie
Registered: 12/16/10
Posts: 28
|
Each variable can have only one expression, but you can have multiple variables with different expressions in the same text box. For example, in a text box you could have @a@ on one line and @b@ on the next. i tried to do by your way,but no way to realize my idear. for example, there are 3 filed name by F1,F2,F3,i'd like to output these fields row upon row,when they are not zero. if one of them are zero,not output and the next field move up to the position. therefore,if f1 is zero,just two line to output,if f1 and f3 are zero,just one lien to output. so,if i do it by your way,it would keep the blank line.
|
|
Top
|
|
|
|
|
#34369 - 12/23/10 12:14 AM
Re: barcode and numbers help
[Re: bowen]
|
Eric Lachance
Unregistered
|
Bowen,
It really depends precisely how your data is built, but here's a little pointer. If you placed a series of field names one after the other separated by a line return only (e.g. [F1] & "¶" & [F2] & "¶" & [F3] & "¶" & [F4] & etc...) , with no space or anything else, then you could check the "Remove Empty Lines" in the text object's properties and it would skip any field that is blank.
This will only work, however, if the field is completely empty (no spaces, or any character at all). It'll also only work if all your fields are on the same record (this wouldn't work with layout repetition, for example).
So if instead of creating rows you create separate columns with the expression like I wrote up there, it may be what you're looking for.
|
|
Top
|
|
|
|
|
#34372 - 12/23/10 08:17 PM
Re: barcode and numbers help
[Re: ]
|
OL Newbie
Registered: 12/16/10
Posts: 28
|
Bowen,
It really depends precisely how your data is built, but here's a little pointer. If you placed a series of field names one after the other separated by a line return only (e.g. [F1] & "¶" & [F2] & "¶" & [F3] & "¶" & [F4] & etc...) , with no space or anything else, then you could check the "Remove Empty Lines" in the text object's properties and it would skip any field that is blank.
This will only work, however, if the field is completely empty (no spaces, or any character at all). It'll also only work if all your fields are on the same record (this wouldn't work with layout repetition, for example).
So if instead of creating rows you create separate columns with the expression like I wrote up there, it may be what you're looking for. Hi,Eric As what u said,it just work on the condition that the field is empty. However,my field is 0 to indicate empty. So i've tried,no worked.
|
|
Top
|
|
|
|
|
#34373 - 12/25/10 01:36 AM
Re: barcode and numbers help
[Re: bowen]
|
Eric Lachance
Unregistered
|
Bowen,
Still possible but lightly longer and more annoying to type in:
IF([F1] > 0, [F1] & "¶", "") & IF([F2] > 0, [F2] & "¶", "") & IF([F3] > 0, [F3] & "¶", "") & IF([F4] > 0, [F4] & "¶", "")
|
|
Top
|
|
|
|
|
#34374 - 12/26/10 08:28 PM
Re: barcode and numbers help
[Re: ]
|
OL Newbie
Registered: 12/16/10
Posts: 28
|
Bowen,
Still possible but lightly longer and more annoying to type in:
IF([F1] > 0, [F1] & "¶", "") & IF([F2] > 0, [F2] & "¶", "") & IF([F3] > 0, [F3] & "¶", "") & IF([F4] > 0, [F4] & "¶", "")
cool! that's what i need,thx,eric  , it seems so important to use & to link more expressions!
|
|
Top
|
|
|
|
|
#34433 - 01/04/11 04:07 PM
Re: barcode and numbers help
[Re: Sander vd Berg]
|
OL Newbie
Registered: 12/29/10
Posts: 6
|
intelligent mail barcode, usps, HELP!! NO idea what i am doing. I have a mailer id from usps but when i try to edit the expression the barcode disapears. i found a youtube video for printshop mail and onecode but following the example generates errors in my setup.
don't know what my mistakes are don't even know if i am building the expression properly.
can someone please help with any guidance or suggestions?
thank you to all in advance.
|
|
Top
|
|
|
|
|
#34434 - 01/04/11 04:22 PM
Re: barcode and numbers help
[Re: jhicmc]
|
Marc-Andr
Unregistered
|
jhicmc,
The easiest way to use the IMB/OneCode Barcode is to use the Barcode Object in version 7.
You simply click on the Barcode Object and a barcode will appear on your page. Then if you look at the barcode properties change that to USPS OneCode. Then associate your Datafield with that barcode. Make sure you use only numbers and that you follow the guideline set by the USPS.
If you are still not able to make it work, I would suggest you open a service call.
Regards,
Marc
|
|
Top
|
|
|
|
|
#34435 - 01/04/11 04:43 PM
Re: barcode and numbers help
[Re: ]
|
OL Newbie
Registered: 12/29/10
Posts: 6
|
thanks Marc, i will try but i am just unclear on how to input my mailer id. I think i will open a service call.
thanks again.
|
|
Top
|
|
|
|
|
#34436 - 01/04/11 04:55 PM
Re: barcode and numbers help
[Re: jhicmc]
|
Marc-Andr
Unregistered
|
Once the barcode is placed, you can double click on the barcode. Then you will have the option to select the datafield(you created) that contains the information needed for the barcode.
regards,
Marc
|
|
Top
|
|
|
|
|
#34440 - 01/05/11 02:46 AM
Re: barcode and numbers help
[Re: ]
|
OL Expert
Registered: 06/10/08
Posts: 207
Loc: Objectif Lune NL
|
IMB/OneCode in the Barcode plug-in expects one long string that consists of all arguments concatenated together. The arguments are the same as the arguments for the ONECODE function in the expression editor, in the same order.
- Barcode ID (2 digits)
- Service Type ID (3 digits)
- Mailer ID (6 or 9 digits)
- Serial No (9 or 6 digits)
- Zipcode (0, 5, 9, or 11 digits)
The first digit of the Barcode ID should be in the range 0-9. Its second digit should be in the range 0-4.
Mailer ID and Serial No together should consist of 15 digits.
|
|
Top
|
|
|
|
|
|
Previous Topic
Index