Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 472

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 112

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 112

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 112

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 112

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 112

Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/jerdew5/orbworks.com/forum/includes/bbcode.php on line 112[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3368: Cannot modify header information - headers already sent by (output started at /includes/bbcode.php:472)[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3370: Cannot modify header information - headers already sent by (output started at /includes/bbcode.php:472)[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3371: Cannot modify header information - headers already sent by (output started at /includes/bbcode.php:472)[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3372: Cannot modify header information - headers already sent by (output started at /includes/bbcode.php:472)OrbWorks Community Forum • View topic - making a text file file into a database

OrbWorks Community Forum

This site is now in read-only mode. No new topics can be created, and no new users can register.

Thanks for all the good answers, Dewey. I have the simulator running now. It was very exciting! I got it to run one of my programs. It's not running perfectly but well enough for the moment.

For my application i want to turn a text file on my desktop into a database. I looked in the HTML docs and there doesn't seem to be any function for this. I saw functions for creating and building a database, but none for importing data. In my old days as a database programmer i would have just said 'APPEND FROM FILENAME FOR TYPE = TXT' but i don't see anythink like that anywhere in PocketC.

Thanks to Samps for the info on conversion. I must be doing something wrong tho. It says it can't access the destination file. Here's my command line:

orbpdb -csv -a -rA- -s8 see_you.csv my_data.pdb

Do you have to create the database beforehand? I didn't specify a database name, type or creator ID because it says not to if you're using the -a for append switch. Is this right? What am i doing wrong?

This time I actually pulled the old Orbpdb out of the drawer and tested it. Turns out I had the syntax slightly wrong in the above.

orbpdb -csv -c stAB s8 test.csv test.pdb

without a dash before the format string but WITH the addition of a creator ID. Those you get from Palm Developer Network or you make up any four-letter combination of upper and lowercase letters ad numbers just for your testing.

This creates a new palm database, now you can use the -a switch to append to data to it.

Sorry for creating confusion by not checking my facts earlier in the process.

It worked! A triumph! The only thing is on the Palm i get funny ASCII characters after each record. This is in using puts() to look at them. Also, the new line symbol won't work. Ack! Do you know what to do? Oh, well, some progress!

Yes, that's exactly it. My data is in a column and not a paragraph. Those pesky characters must be LF+CRs. I guess my file's not really Comma Separated Variables. Any ideas on some thing that will do a bona fide text file to pdb?

I'll try your suggestion for the new line operator. Is it correct to say it's an 'operator'? What do you call it? Symbol? It sure doesn't like it in quotes. Perhaps raw will go over better.

<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote">the new line operator. Is it correct to say it's an 'operator'? What do you call it? Symbol? It sure doesn't like it in quotes. Perhaps raw will go over better.<hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">

I usually refer to it as "the new-line character", it goes at the end of the string, within the quotation marks that encloses the string:

The new line character must be interacting with my CR+LFs. It works OK for plain text.

I've been fooling around with PDBConverterLE. It SAYS it's created a .pdb. It's on my hard drive. But it doesn't sync across! At least my program bombs and says there's a null string and i have to reset. When i go to the main menu, tap on time and tap info, it's not there either. The .pdbs i created with ORBPDB are there but not the ones i created with this fancy converter.

The difference between 'there' and 'not-there' .PDBs (and determinant to whether they can be sync'ed or not) might be in the presence (or absence) of a creator ID. Orbpdb checks that one is present, does PDBConverter?
Also, utilities like Z'Catalog might be able to tell, in greater detail, which .PBs are on the Palm, than the Launchers Info.

Hi trying to convert a pdb file to a csv file, the database has just 10 records each with 3 fields and each of the fields?¢‚Ç¨‚Ñ¢s is 30 characters long. I tired the following Orbpdb ?¢‚Ç¨‚Äúpdb ?¢‚Ç¨‚Äúr0- 3szs30 pwds.pdb pwds.csv and messed around with different combinations of the 3szs30 part of the command, but all I get in the csv file is the record number for the 10 records i.e. the first entry of the record. Anybody got any ideas where I?¢‚Ç¨‚Ñ¢m going wrong?:x